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 ...
i am having this content h.X?‡©þZÆ©ä“0Ã......and its coming like this h.X?‡©þZÆ©ä“0Ã...... while reading through file reader snap and again while loading into the snowflake table these are missing ‡“
I am new to SnapLogic and currently learning how to use SnapLogic. At this moment, I am looking for some guidance how to create a pipeline that logs into a remote FTP server via SFTP and download a file to my share folder. I already created a SSH Acc...
