Lets say i have a string:"FF;0545454;value1;test;01;99;;;value2;866"how can i tell snaplogic in mapper, if third value is (value1) and value in fifth column is 01, change second value to 888 so the result will be:"FF;888;value1;test;01;99;;;value2;86...
Hi, Currently when I use Oracle select/Oracle execute snaps to query data from Snaplogic, it will return multiple documents as output from those snaps(one row per doc). Is there a way i can merge them together into one json array or one doc? Thanks
I am trying to create an account in Google AD for which there are mandatory fields such as given name, surname, email and password. For the password, I would like to auto generate random passwords of 8 characters of which 2 are uppercase, 1 number an...
Hello,I have a pipeline were im running a stored procedure in SQL to insert and update records. On update, If no records are found, the stored procedure snap doesn't display anything in the result set output view.I also tried the SQL - execute snap a...
I have 2 date values, have to find the difference between both of them. Weekends to be excluded.I am using the below expression to derive the value.parseInt((Date.parse($Date2.toString())-Date.parse($Date1.toString()))/(1000*60*60*24)*0.71)This logic...
My Input looks like this. [{"error": "","stacktrace": "","reason": "","resolution": "","status_code": "","statusCode": 404,"snap_details": {"label": "","instance_id": "","class_id": "","build_tag": ""},"External_id__c": ""}]I have to send the output ...
Hello,I am trying to upload a file to a REST POST multipart/form-data web service without having to initially create the file onto the SLDB.The web service works fine when payload.xml has already been created onto the SLDB.The web service wants a mul...
Hello, I need to insert the string " 30/01/2024 00:00 'DD/MM/YYYY HH24:MI' " into Snowflake Timestamp_NTZ(9) column as " 2024-01-30 00:00:00.000 'yyyy-MM-dd HH:mm:ss.SSS' ". I tried the following with no success. Any help would be appreciated.1. Date...
