Designing and Running Pipelines

How to write each document to a file rather than all documents to a single file

I am reading multiple messages using JMS consumer into one big binary file then using a binary to document snap I am breaking it into multiple documents. How can I write each document to a separate file with timestamp rather than writing all the docu...

Create new object at end of array

I have a flat file shown here: “firstName”: “Gregor” “lastName”: “Samsa” “mainAddress”: “123 Main St” “mainCity”: “Boston” “mainState”: “MA” “mainZip”: “02131” “mailingAddress”: “456 Mailing Ave” “mailingCity”: “Somerville” “mailingState”: “MA” “mail...

Failing a pipeline that contains data in error view

Hi all, Is it possible to have a SnapLogic pipeline fail when one of the error views in the pipeline contains data, while still returning the output from the error views. In the example above, the pipeline contains multiple branches… and the SF Look...

Common Error Handler

Hi, As requested in another thread, here is our common error handler which we’re trying to use across all projects. Feel free to share your own and any ideas! Here is the screenshot (pipeline definition is attached below): Key features: We have mult...

hasOwnProperty() and fields containing special characters

Given the object: { "Errors" : { "$.Field_1" : "Too many characters.", "Field_2" : "Too few characters." } } The following expressions yield different results: $Errors.hasOwnProperty('$.Field_1') ==> ...

Salesforce: deleting a record based on external ID

Hi, I took a quick look at the documentation for the salesforce delete snap and it appears that deleting a record looked up based on External ID is not supported. Can someone confirm if my understanding is correct? If so, please advise what steps I...

Find Array index from object value in the array object getindex?

I have a json file with an array designed like below. I don’t have control over the number of or order of address entries. I have tried $.Address.findIndex(x => x == ‘Home’) and $.Address ? (value.AddrType = Home) among other expression language sta...

Parsing XML created using XML Generator: a simpler way

I’m trying to test a pipeline that receives incoming payload as XML and processes it using some static XML specified in the XML Generator SNAP. My problem is, I would like the XML Generator generated XML to be converted to JSON… Right now it looks ...

SnapLogic - Integration Nation

Forum Posts

How to write each document to a file rather than all documents to a single file

Create new object at end of array

Failing a pipeline that contains data in error view

Common Error Handler

hasOwnProperty() and fields containing special characters

Salesforce: deleting a record based on external ID

Find Array index from object value in the array object getindex?

Parsing XML created using XML Generator: a simpler way

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

Converting a string to JSON doesn't work

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