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...
I am trying to process a excel file using Excel parser and on the mapper we want to pull the previous not null value for a field if the value of the field is null for which have tried the below expressions but snaplogic is giving error .option 1 :$Va...
We are trying to create a pipeline to transfer files from an SFTP location to S3 bucketI looked at this page: S3 File Writer - SnapLogic Documentation - Confluence (atlassian.net) But I didn't see anything about the data in transit.
I have an array of the following form:I want to convert this array of objects into a single object that has the same fields along with Debit_Amount and Credit_Amount fields summed up.Any help is appreciated!
| User | Count |
|---|---|
| 320 | |
| 192 | |
| 172 | |
| 145 | |
| 115 |
