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...
Json: "name": "Company Name","addressLine1": "10 North Street","addressLine2": null,"city": "Washington","state": "DC","postalCode": "12345","country": "USA"Expected XML:<VocabularyElement id="urn:epc:id:sgln:77777.111111.0"> <attribute id="urn:epc...
I have a pipeline that runs as a taks and in the end outputs a XML file, like the following example. But I need to get the XML file without the <content> tags. Any help how to achieve that?The XML output is:<content> <soapenv:Envelope xmlns:StUF=...
Hello all,I'm using the Snowflake Lookup snap to query a table that contains the details of projects already processed, and get the values of the "project ID" column. The values are unique project IDs that I need to store somehow (I'm thinking an arr...
