I have the below JSON output from a Union (below is just a subset of the results), which combines the output of 2 SOAP calls into the 2 arrays.I'm trying to merge NCTimeTypes array with CHTimeTypes array to create a single array "TimeTypes" that cont...
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...
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...
Hello all,I need to convert an array of ID values into a JSON payload, and I cannot find any array function that can iterate the values of the list to generate what I need.My array of IDs looks like this: ["r4ige6rwgvnr", "4nkmdoijydfj9", "6ashbd99w3...
| User | Count |
|---|---|
| 317 | |
| 172 | |
| 158 | |
| 120 | |
| 114 |
