SnapLogic - Integration Nation

tarena

The Salesforce REST API can update up to 200 records be POST call. The Salesforce Update snap documentation says that it's implemented to only update 1 record at a time in REST mode. The Bulk API is asynchronous, even in serial mode. What is the best...

tarena

This pipeline is executed by a [Scheduled Task > Pipeline > HTTP Client > Triggered Task] regularly. This pipeline hasn't changed structure in months. Occasionally I will get an error that the Triggered Task failed with the error: Reason: HTTP Code: ...

tarena · 12-06-2024

I'm using the following expression to parse date fields in an object. It works correctly. However, when I replace key.contains('date') with another string to compare, the expression returns null for the object.$attributes.mapValues((value,key) => key...

tarena · 03-28-2023

JSON Path Test_2023_03_28.slp (6.4 KB) GOAL: Set up a mapper to write input document structure to new structure, deleting some paths, and renaming others. ERROR: “Failure: Unable to write to JSON-Path: $.ACHData.employeeId, Reason: Expecting object f...

tarena · 03-16-2023

I’m trying to understand the documentation for the Array function toObject. It uses [‘zero’, ‘one’, ‘two’].toObject((x, index) => index, x => x.contains(‘two’)) as an example, which returns {“0”: false, “1”: false, “2”: true}. What does the (x, index...

tarena

After some more experimentation, the Salesforce Poller snap keeps the pipeline open for the entire duration of the update and return individual successes and failure for each record. This is close enough to synchronous for my use cases.

tarena

Thank you. This was pretty close to the problem. If there is an error in a function called in mapValues, a null object is returned as the result of map values. My original error was from adding an or condition that would include keys which couldn't b...

tarena · 05-25-2023

The Diff snap evaluates based on the exact values in each column of the incoming records. If a record exists in the Original and New inputs, but has a different data type in a field, then it will be evaluated as a Modification. For example, if a valu...

tarena · 05-25-2023

The functionality to execute the macros is in the Excel program, not the workbook where the macros are stored. SnapLogic doesn’t have an engine to extract, compile, and execute the VBA code within the workbook.

tarena · 03-28-2023

I figured this one out. You can’t add paths to null objects. Since ACHData is null for the second record, it’s impossible to add ACHData.employeeId. If I reverse the order of the rows in the mapper then the result is that ACHData is null for the reco...

SnapLogic - Integration Nation

User Statistics

Re: Salesforce Update REST API Throughput

Salesforce Update REST API Throughput

Intermittent Task Failure BAD_REQUEST: POST to pip...

Re: mapValues returns null when adding certain con...

mapValues returns null when adding certain conditi...

User Activity

Salesforce Update REST API Throughput

Intermittent Task Failure BAD_REQUEST: POST to pipeline that does not have an unlinked input view

mapValues returns null when adding certain condition

Failure: Unable to write to JSON-Path

Arrow Function Parameters

Re: Salesforce Update REST API Throughput

Re: mapValues returns null when adding certain condition

Re: DIFF SNAP issue

Re: Integrating Snaplogic with VBA

Re: Failure: Unable to write to JSON-Path