Designing and Running Pipelines

Fetching platform error failures using public API

Hi, I am trying to fetch the below errors using the snaplogic public APIs which are logged in the jcc_error.json file. Unable to get poolProxyHeartbeat failedUnable to push pipeline runtimes toStopping runaway suggest I was able to fetch the “Unable ...

Eval method behaving strangely

Hello. This is very strange but we have a pipeline that has pipeline parameters / arguments. 1 for month and the other year: This works fine when the months is 7 or less (july). once you put the param = 08 for august and year 2020 this strange error...

Redshift Unload Directly to Parquet

Hi, Has anyone figured out a way to Unload data directly to parquet format from Redshift? The Redshift Unload snap does not have parquet format as an option (just delimited and fixed width files). I have tried to circumvent this by using a Redshift E...

Video: Extract Load Transform (ELT), August 2020

In this video, learn how you can push workloads to your favorite cloud data warehouse with the new ELT feature in the SnapLogic Intelligent Integration Platform.

Resolved! Remove json object conditionally

I have the following document with question responses. When the response is “-”, I would like to remove the question and answer text. Is there a way to do this in a mapper or conditional step? Before: [{ “Questions”: [ { “answerText”: “John”, “Que...

Resolved! Using the parsed Float value in string

I have double value coming from the source as a string. Source value: “NTGEW” : “3.400” I am using parseFloat() function to convert the string into double value. parseFloat($NTGEW) ===> 3.4 The parseFloat function is working as expected when it is th...

Extraction of binary objects (BLOB) like images and pdf from Oracle table

Does Oracle Select Snap fetch the BLOB data from a table as actual document/image? I would like to fetch those docs from database and store them in FTP location. Here, I’m looking for specific example of pipeline. I’ve not seen any special mention...

SoapExecute Workday Read Get Course Sections fails with error message 'Course_Section_Reference is required' when it actually exists in the request

I am attempting to get a web service response from workday, but hitting an error which does not make sense to me error: Course_Section_Reference’ is required, on internal element 'Course Section Request References There is no ‘Course Section Request...

SnapLogic - Integration Nation

Forum Posts

Fetching platform error failures using public API

Eval method behaving strangely

Redshift Unload Directly to Parquet

Video: Extract Load Transform (ELT), August 2020

Resolved! Remove json object conditionally

Resolved! Using the parsed Float value in string

Extraction of binary objects (BLOB) like images and pdf from Oracle table

SoapExecute Workday Read Get Course Sections fails with error message 'Course_Section_Reference is required' when it actually exists in the request

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...