Designing and Running Pipelines

PostgreSQL - Bulk Load with schema provided

Hello - I am trying to provide a schema for the PostgreSQL - Bulk Load snap to use. I’m getting an error that “Expecting a schema document with a map of column names to their descriptions”. I have a query that returns the column names and their data ...

Resolved! Money formatting

I am multiplying a salary field by 100. Any salary with a decimal point is still showing the decimal afterwards even tho in the mapper snap, it looks correct. Here is my code in mapper snap: ($RATE_1*100). It is showing correctly in mapper snap but w...

Ultra endpoints - Response is not returned to the caller

Hello, We started to experience very strange behavior with ultra tasks. Ultra tasks are up and running, but some of the endpoints are not returning the response back, even in dashboard we can see that the requests are processes successfully. Any thou...

CSV with header, detail, and trailer records on S3

I need to create a pipe delimited text file. The file needs to have a single header type record row with two columns, infinite number of detail record rows, and a single trailer type record row with three columns. 00|File Type Description 01|Data1|Da...

How do we do Reverse ETL in Workday Prism

Hi Team, We have Workday Prism Analytics Bulk Load snap to upload data. How can we perform Reverse ETL in Workday prism ? As we don’t have Workday Prism Bulk Analytics bulk read snap in SnapLogic.

Resolved! JSON snap not working as expected

JSON splitter last week was working correctly. Pipeline was not edited, JSON format did not change, and yet Pipeline is crashing indicating error that JSON splitter is expecting list not an object. Before 17th of Feb it was working perfectly fine. wa...

Resolved! Rest Get output is in filename.json.gz format need to convert to csv

Hello All, I have file called “filename.json.gz” which is obtained using REST GET Snap and I need to convert it to a CSV format file. I need this transformation to be done in one pipeline. Any help would be greatly appreciated. Thanks!!

Resolved! Parent-child pipeline execute

Hello all, I’m trying to understand one functionality for “pipeline execute”. Let say we need to have multiple executions in the child process and the pool size is 1. My question is does pipeline execute is scanning the project environment before ini...

SnapLogic - Integration Nation

Forum Posts

PostgreSQL - Bulk Load with schema provided

Resolved! Money formatting

Ultra endpoints - Response is not returned to the caller

CSV with header, detail, and trailer records on S3

How do we do Reverse ETL in Workday Prism

Resolved! JSON snap not working as expected

Resolved! Rest Get output is in filename.json.gz format need to convert to csv

Resolved! Parent-child pipeline execute

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...