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...
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!
Hi All,I recently turned on an integration that only runs for about a month in the spring and in the fall when I'm pushing some data from a training system into our ERP and noticed it started failing. After looking through the logs, it looks like it'...
Hello,I have an array of objects that i need to simply add a key to. However, im not a able to find a way of doing this. attached are screen shots of the input and desired output. Any advise is much appreciated.Input:[{fromCurrency:{code: "CUC",name:...
I would like to create a pipeline which downloads excel file from this webpage https://www.eia.gov/electricity/data/eia861m/#salesrevenue every month. I am currently using web scraping and python to download the excel file. Can we do webscraping or i...
