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"...
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...
I would like to execute this unix command in snaplogic to convert the csv file so could you please help me to get this done awk -F'"' -v OFS='' '{ for (i=2; i<=NF; i+=2) gsub(",", "", $i) } 1' input.csv > output.csv
Sharing a part of my whole pipeline flow is:Router snap --> oracle_execute snap (fetches data from oracle db via slect statement) --> mapper --> csv formatter --> file writerThe mapper input view is of the format:[ { "key1": "Key1", "key2":...
I have a Simple But Difficult Problem to solve, where I have "target_column_name" as the pipeline parameter and incoming data has a value column that should be mapped to this "target_column_name" which is the "department".it can change to any name (n...
I need to make a Post Rest API call using OAuth 2.0 with client_id and client_secret and then pass the token to a Get Rest API snap to make the api call Client Authentication ‘Send as Basic Auth Header’. How can I do this using the Rest Snaps?
HI team,I have doubt related to gate snap.currently we are using gate snap to transfer all the documents to parent pipeline . But we have restriction to not to use gate snap. How can we merge all documents into single document and send the output to ...
