Designing and Running Pipelines

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

Resolved! Route based on grand child value

Hi there, I have this structure json. I need to route the json based on attachment in below json, if exist or not input json [ { "data": { "po-number": "4501918519_2", "order-lines": [ { "id": { "@type"...

Remove multiple columns from writing into a file

i’m looking for an approach where i can remove multiple columns from writing into a file. The catch here is I don’t want to hardcode the column names (at source column) and passing null (in target column). I want to identify the unwanted column based...

File Writer not creating new directory

Usinf FileWriter snap I am trying to create a new direcorty ‘202303’ and write a file to that location but it is throwing erro however I am able to write a file to the existing directory(If i create a new folder named ‘202302’ manually then it is...

SnapLogic - Integration Nation

Forum Posts

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

Resolved! Route based on grand child value

Remove multiple columns from writing into a file

File Writer not creating new directory

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

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data