Designing and Running Pipelines

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

Users created by pipeline but not showing in snaplogic UI

I have created a pipeline to add users in snaplogic.After executing the pipeline using triggered task, i am getting the response that user is created successfully and verified the same using “fetch data using email” rest api.but in ui i am not findin...

How to use database link in an Oracle Select or Insert snap?

Is there a way to specify a database link in an Oracle Select and Oracle Insert snap? For example, I have a select statement with a DB link that I can run in an Oracle Execute snap (or in SQL Developer) like this: select * from schema.table@db.mycomp...

Expression to keep leading zero in a number

I am using Mapper snap to map an integer column from database to CSV file. How do you write expression for this field “MyNum” to keep the leading zero in the csv file? like 04567 Thanks

SnapLogic - Integration Nation

Forum Posts

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

Users created by pipeline but not showing in snaplogic UI

How to use database link in an Oracle Select or Insert snap?

Expression to keep leading zero in a number

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data

Parsing XML using a Python script returns an encod...

multiple array objects