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

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

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling