Designing and Running Pipelines

Discuss how to use the SnapLogic platform.

Forum Posts

Sorted by:

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

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

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