Designing and Running Pipelines

Resolved! Cumulative sum of a value in an array

Hi Everyone, I need help on an expression solution. The “sum” should be the sum of the value(s) of “key2” from previous records till the current record within the array. I’m trying to make it using the “reduce” function. Input: [ { "key1": "val...

Resolved! Group by fields with specific group size

Hello All, Is there a way we can use group by fields limited to a group size? Group by fields snap doesn’t let us specify a group size, so if we try to create groups based on a field, whether the occurrence of the field is 5 times or 500 times, outpu...

Resolved! Merge objects into first element of the group

Hello All, I have stumbled upon a scenario where we need to map all the elements within an array to the first element of the object or if we have to simplify the use case based on a certain field we have to merge all the elements together. The exampl...

How to convert XML arry file to CSV

Hi all, I am getting xml file in array format which i want to conavert to the CSV formate. lease gud me here for same; my sml formalt is like : Name ROll Number CLass 0000000000 `

Dynamic Table Loads

Trying to do ETL to move source data to target db. I don’t want to create a pipeline for every single table. There are hundreds of tables. To start I want it to do this simply and assume a truncate and reload of all the tables. I will worry about ...

Excel Parser - reading dd/mm/yyyy format

I am reading a list of Dates in excel. Excel region settings are Australian (so dd/mm/yyyy). Excel file sample is: Using the excel parser the output is all converted to American format (mm/dd/yyyy): SnapLogic clearly knows it is dealing with Dates....

How to get execution details of a pipeline using REST GET

I am trying to get the execution details of a pipeline using the REST GET snap. As I can see from the documentation it is done with calling the API: https://elastic.snaplogic.com/api/1/rest/public/runtime/<organization>/<ruuid>?level=detail in the ...

CORS Setting in Cloudplex

I have created triggered task in cloudplex which is tested & working from postman but the same is not working from javascript. Just want to know if any one done any setup for Cross Origin Request Sharing (CORS) in snaplogic cloudplex

SnapLogic - Integration Nation

Forum Posts

Resolved! Cumulative sum of a value in an array

Resolved! Group by fields with specific group size

Resolved! Merge objects into first element of the group

How to convert XML arry file to CSV

Dynamic Table Loads

Excel Parser - reading dd/mm/yyyy format

How to get execution details of a pipeline using REST GET

CORS Setting in Cloudplex

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...