Designing and Running Pipelines

Resolved! Limit results to 1 record on Salesforce Lookup Snap

We are using a Salesforce Lookup snap to return Account record Id’s based on a bunch of conditions. At the moment, if there are duplicate records in Salesforce, SnapLogic returns more than 1 id. We’d like to limit that to just 1, the first returned r...

Need help withTime format Conversion

Hi All, I am trying change a date format with expression. Input is a string value: “04/23/2021 12:00:00 AM” Output should be ‘yyyy-MM-dd HH:mm:ss’ format I am trying data parse the incoming date format but unable find proper format for input date. Da...

REST pagination works in validate but fails in executions

Hi, I’m having an issue running a pipeline with a REST GET with a next URL. When I run a validation, the SNAP works fine, and I even see multiple responses indicating the next URL seems to be returned. When I run an execution however, the SNAP abor...

Passing Array data into SOAP envelope

Can anyone suggest how I can pass an array of numbers into a SOAP envelope? I need to make a SOAP API call with a list of phone numbers, as in the below example: Using the Customize Envelope editor of SOAP Execute snap I have successfully configure...

Mysql account

I tried to create a mysql account using localhost. I get the following error, can you please help. Failed to validate account: Failed to retrieve a database connection. Cause: Communications link failure The last packet sent successfully to the serve...

Triggered task landing page

I am considering using a triggered task to provide unsubscribe functionality for an internal email system. The link would pass two parameters to the pipeline, username and subscribe = yes or no. I have a couple of questions; When the task has complet...

Ignoring double quotes

I am in a situation where after a CSV formatter my data is coming in double quotes. How can i ignore it?

Getting The Response Header and not Response Content from Jira Webhook

The header is a JSON file and content comes in a binary file as can be seen from the trigger task debug trace below: Tried using the pipeline below and I only get the response header also included below and can’t find a way to get the content:

SnapLogic - Integration Nation

Forum Posts

Resolved! Limit results to 1 record on Salesforce Lookup Snap

Need help withTime format Conversion

REST pagination works in validate but fails in executions

Passing Array data into SOAP envelope

Mysql account

Triggered task landing page

Ignoring double quotes

Getting The Response Header and not Response Content from Jira Webhook

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