Designing and Running Pipelines

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

Salesforce Update (not Upsert) by External ID

I’m trying to do a SF update based on External ID … however, the snaps available right now make it look like that’s not possible. I have: Salesforce Update: update based on IdSalesforce Upsert: update or insert based on external id. Can someone advi...

SnapLogic - Integration Nation

Forum Posts

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

Salesforce Update (not Upsert) by External ID

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

String replace method where pattern is dynamic