Designing and Running Pipelines

How to Sort an Array Based on Key/Column name

Hi , I have an array which i want to sort it by the keys/column. { array1:[ { " Width":“4” " Length":“5 " " Item Desc”:"Black ", " Item ":"Pen " }, { "Width":"5" " Length":"7 " " Item Desc":"Blue ", " Item ":"Pen " , } ] } Output:- { ...

Group by N is not working in child pipeline

Hi , I have a requirement to combine the 4 JSON document into 1 document using the group by N snap. But group by N snap is not working as expected. Below are screen shot of pipeline.

How to Covert date in the JSON data

Hello, I am trying to work with the date (timestamp to be precise) and getting into trouble. My requirement is below. I have a stage table where the data is stored as JSON in a Variant Column and the data looks like below in that column. { “message_b...

Anyone got SOAP execute for Salesforce working?

I am getting error: Failure: An exception occurred while executing the SOAP request, Reason: Could not send the SOAP request, Resolution: Verify that the template is correct, the substituted values are valid and the provided envelope matches the name...

How To Rename Array key or Column

Hi , I have an array and I want to change the key/column names of it. { “Items”:{ “Item”:[ { “Item”:'“Pen”, “Desc”:“Black” }, { “Item”:"Pen ", “Desc”:“Blue” } ] } i want to rename the Item as WM_Item and Desc as WM_Desc

CSV Validate Header writing documents to output

A bit of help appreciated. I am trying to accomplish this with my pipeline: Use File Reader and CSV parser to read a CSV file.With the CSV Parser, validate the file and make sure the required headers exist.If the headers exist, do further processing ...

Resolved! How to access a field in Child Pipe Line

Hi, when I am trying to access Col Desc field in child pipe line getting the below error sample JSON { “Style”:“Pen”, “Col Desc”: “Black” } “failure”: “Validation errors:\nproperty_map.settings.transformations.value.mappingTable.value[4].expression....

File writer in Sequence Snap

Hi Good Day, I was trying to use sequence snap in child pipeline so to split the days sequentially which is passed from parent pipeline . To make it understandable , we have a field called Total_Days and start_date from the parent pipeline . For exam...

SnapLogic - Integration Nation

Forum Posts

How to Sort an Array Based on Key/Column name

Group by N is not working in child pipeline

How to Covert date in the JSON data

Anyone got SOAP execute for Salesforce working?

How To Rename Array key or Column

CSV Validate Header writing documents to output

Resolved! How to access a field in Child Pipe Line

File writer in Sequence 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...