Designing and Running Pipelines

PostgreSQL Bulk Upload

When the INSERT query getting fired from Snaplogic, the PRIMARY_KEY is going as null which is causing issue to insert the data in the destination PostgreSQL database.The primary key column is auto-increment but since from the query we are passing it ...

Transform list of objects into single object with key value pairs.

Trying to use snaplogic expressions to read input view of below form from union snap:[ { "a": " value1" }, { "b": "value2" }]into http client snap such that I can fetch value as: value1 for a and value2 for b. What can be done to achieve thi...

Pass null when object is not found or data is not found in mapper

I have list of ifa numbers and I will do lookup to salesforce and get the account id mappings to it and form the below structure using mappings if the account is found. "customerMappings": {"0280944234": "0011H000034uSFAQA2"},if the Account is not fo...

reading fixed width cobol file in snaplogic using python script

hi Team,i am currently using this copybook layout in datastage and reading the content in the file.now i am trying to read this content using snaplogic script snap using python script.but i am not getting the expected output as datastage process.so c...

Resolved! Send multiple files from file writer snap to http client snap for a POST rest api call.

Send multiple files from multiple file writer snaps to http client snap for a POST rest api call using multipart/form-data.The files generated by file writer snaps have timestamp in their names which will vary for each run. These files are being writ...

Resolved! Nest the document under another document

I have the data in below format{"assetguid" : "12345","sfdcid" : "02i79000003OFcKAAW","status" : "SUCCESS","updatedTime" : "2024-04-04T09:25:43.771Z"}I need to convert it to this format with out group by snap. is it possible?[{"sfdcAssetResponseSdo" ...

Rest GET/HTTP Client trying to increment page number but after second iteration it's appending.

First response"headers":{"Server":"opentest""Date": "Thu, 02 May 2024 03:54:38 GMT""Content-Type":"application/json""Transfer-Encoding":"chunked""Vary":"Accept-Encoding""X-Current-Page":"0""X-Page-Count":"9""X-Page-Size":"2000""X-Total-Count":"17139"...

Resolved! optional field on mapper

Hello teamI am getting error "Cannot invoke a method on a null value, snap" due to optional field being absent. In some JSON the "primary_mkt_ind" field is coming as value "NULL" so I have the below check. But in some JSON that I am consuming, that f...

SnapLogic - Integration Nation

Forum Posts

PostgreSQL Bulk Upload

Transform list of objects into single object with key value pairs.

Pass null when object is not found or data is not found in mapper

reading fixed width cobol file in snaplogic using python script

Resolved! Send multiple files from file writer snap to http client snap for a POST rest api call.

Resolved! Nest the document under another document

Rest GET/HTTP Client trying to increment page number but after second iteration it's appending.

Resolved! optional field on mapper

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

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