This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
Created by @schelluri The pipeline pattern flattens a JSON file, which has multiple objects, and turns it into a CSV file. Configuration Sources: JSON Generator Targets: CSV file Snaps used: JSON Generator, JSON Formatter, JSON Parser, Script, CSV...
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...