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...
I have to transform documents that look like the following: [{ “Id”: 999, “field1”: “value1”, “field2”: “value2”, “field3”: “value3” } ] Into output like this. [{ “Id”: 999, “entity”: { “path”: “field1”, “op”: “replace”, “value”: “value1” } }, { “Id”...
Hello Experts,for Dynamics 365 For Sales Search snaps give result incorrect result .i applied greaterThan criteria for filter condition. still it work like "greaterThanEqual to " why i'm getting data for '2023-12-18T08:15:18Z' as i have selected gr...
Hello, We are calling an API that uses epoch date parameters. Is there a way to convert/parse UTC timestamps to epoch? I want to set a parameter startDate = Date.now() and in the GET POST query parameter, I want to call the startDate but parse it int...
An epoch date is either the number of seconds or milliseconds since 1 January 1970 00:00:00 UTC. UNIX and other applications use seconds, while JavaScript uses milliseconds. SnapLogic uses JavaScript as its scripting language, so the epoch date is i...
