Designing and Running Pipelines

Resolved! Running Rest API in a loop where Page count is fixed variable

Step -1 Rest API to get the collection info looks like https://stage-data.xyz.com/v1/xyz-api/collections/models/info?page_size=100Output:{ "total_count": 5099, "page_count": 51, "page_size": 100}Step -2Rest API to get the model looks likehtt...

Get path of xml elements (tag) and their values and attributes

Hello there,I have a requirement to insert in the database the path, attributes and values of each element(tag) of an xml file but I don't see how to do it with snaplogic. I did a python script using lxml library but I don't understand how to use thi...

Difference between 2 dates

Hi,I have 2 dates, which are of localdatetime.Date1 - 2023-08-13T14:17:00.000Date2 - 2023-08-23T05:00:00.000I am using the below expression find the difference between them, and i am getting value as 9.6131944444 expecting the value to be 10. Timesta...

How to give multiple key columns in join?

I have multiple tables and I need to join them all with different key columns by using the join snap, but it is resulting in the following error:-Failure: Right join path not found for input2, Reason: Right join path required, Resolution: Please addr...

JSON output nested in array

Good evening,I have an array of elements that I'd like to output as JSON: [{...},{...},{...}]In order to nest this array under a JSON property, I utilize the "Group by N" snap, which results in my data looking like this: { "randomKey": [{...},{.....

Azure Cosmos DB

I saw a post from a few years ago asking the same question with no replies, but I figure I'd create a new thread to see if anything has changed.I'm trying to figure out an easy way of connecting Snaplogic to an Azure Cosmos DB account. A quick Google...

Resolved! Convert Mulsoft dataweave code to SnapLogic

Hello, I have the following MuleSoft code im trying to convert into SnapLogic. I have tried everything i can think of and im not getting anywhere. Also, posted below is a sample output from stored procedure and the expected output i need. Thank you f...

Take upstream file as an input for parquet reader snap

Hi I am getting a zip file from a rest request. Contents of this zip file are parquet files. Is there a possible way to unzip and read these parquet files without having to write to a temporary file?

SnapLogic - Integration Nation

Forum Posts

Resolved! Running Rest API in a loop where Page count is fixed variable

Get path of xml elements (tag) and their values and attributes

Difference between 2 dates

How to give multiple key columns in join?

JSON output nested in array

Azure Cosmos DB

Resolved! Convert Mulsoft dataweave code to SnapLogic

Take upstream file as an input for parquet reader snap

What account should be used for API with query par...

How to dynamically update an account?

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...