Product Category Discussions
Discuss app and data integration, API Management, and AI/ML.
91 PostsActivity in Discussions
Merging 2 arrays into single array
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...
Converting Snowflake Lookup results into an array
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...
Resolved! Cannot add expression library file path as expression
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?
Mapping object, array and timestamp datatypes between SL and Snowflake
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,...
No Pagination Support on REST Post Snap?
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...
Convert an Array to an Object
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...
Flatten JSON files into CSV files
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...
Resolved! SQL Insert / SQL Server Execute Snaps
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...
Featured Posts
