Designing and Running Pipelines

Resolved! Pad field with zero

How can i take a sql result field where I am counting the number of people in the file for a trailer and left pad with zeroes? I have tried a bunch of the expressions shown in several of the answers here but nothing is working. I get

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Pad field with zero

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

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

What account should be used for API with query par...

How to dynamically update an account?

Execute each child pipeline multiple times

Routing files from S3