This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
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...
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...
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...
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...
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" ...
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"...
