Designing and Running Pipelines

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

Workday : Content-Location data from Multi-File reader

I am looking for a way to preserve ‘Content-Location’ data specifically ‘filename’ coming out of a Multi-File reader snap which has a Fixed-Parser snap next to it. Also, if someone can help me know of a way to use a splitter to process each of the fi...

Cron scheduled task executed with 8 minutes delay

Hi SL gurus, Scheduled a cron task for 1AM like this. Got executed 1:08AM. Any suggestions? PS. “A Scheduled Task can take up to 10 minutes past the scheduled time to execute. If it misses that window, the task does not execute.” - is this an april’s...

SnapLogic - Integration Nation

Forum Posts

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

Workday : Content-Location data from Multi-File reader

Cron scheduled task executed with 8 minutes delay

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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?