Designing and Running Pipelines

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

Can we get the name of scheduled tasks

Hello Everyone, I am getting all the schedule task details in manager Here is a screenshot that shows all the task names, so I need to capture these through API in Rest get snap, and even if possible I need all the details of the task. https://docs-...

SnapLogic - Integration Nation

Forum Posts

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

Can we get the name of scheduled tasks

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error