Designing and Running Pipelines

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

Dynamic Values & the File Poller

Anyone managed to get this to work using dynamic values i.e. ‘MyFileName’ +data.now()+‘.txt’ plus does anyone know how to cause this to fail if the file never turns up? Currently it seems to finish with success no matter what.

How to edit a name of a project space

I can’t seem to edit the name of a project space once it’s created. Is this functionality not available to admins or am I overlooking it?

SnapLogic - Integration Nation

Forum Posts

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

Dynamic Values & the File Poller

How to edit a name of a project space

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?

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