I have a input json file like below please see the dummy example below{ "totalCount": 2, "dataList": [ { "IFA": "IFA1", "voltage": "200", "power": "100", "equipid": "1234ABC", "SN": "SalesForce-1" }, { "IFA": "IFA2", "voltage": "200", "power": "100",...
Hi,I'm trying to add today's date in the file name when I load CSV file on S3 bucket.I know there is Date.now() , but this gives date with local tiem.What's the best way to add local DATE only (today's local date) (NOT THE TIME)?Thank you
About 5-7 months ago there was a webinar that walked through a Jira SalesForce integration. I tried to look through the webinar recordings and my email, but I cannot find that recording. Does anyone know where I can find that? Thanks!
Hi,I just found out, that when adding new expression library path , I can't set it as expression anymore. I can't find any info about this change in couple of last release notes, is this just a bug or some change planned?
Hello all,I'm trying to populate data in a Snowflake DB using the Snowflake insert snap.In my Snowflake table, I have defined some columns as "object", "array" and "timestamp", hoping that this would be a match for the corresponding data types in SL,...
Hi everyone, I am using the REST Get snap and it works beautifully for paginated data requests (using the Has Next boolean field and the Next URL field). I noticed that for some strange reason the REST Post counter-part snap doesn’t have this functio...
I need to convert an array to an object. this is my array:[ { "totalMatchingRows": 2, "pageCount": 1, "pageSize": 1000, "pageIndex": null, "rowsInPage": 2 }] I need to convert it to:{ "totalMatchingRows": 2, "pageCount": 1, "page...
We have a process today that does a SQL insert into a transactional database and returns the ID value for use in later steps. We have tried the SQL INSERT SNAP and ID is not returned. Also tried the SQL Server Execute Snap using and INSERT statemen...
