Designing and Running Pipelines

Ignore the null in array

hi there, I have to map an array object as in the screenshot below. I have 2 records in that array. one is coming in as null and the other has value as in the below screenshot. how can I ignore the one that’s null and map the one with value? as it ...

API returns 500 only when POST is from Snaplogic

Hi, i’m having a problem while making a POST request to Pivotal Tracker API. i make the exact same request from Postman and it works. But when i request from Snaplogic it returns 500. I really don’t know what might be wrong with Snaplogic, i suppose ...

Creating Junction object record in Salesforce

I have a csv file which has Account, Contact and Account Contact Relationship data. Account is parent to Contact and Relationship, Contact is parent to Relationship. In my pipeline I need to first insert Account, then Contact and related the Contact ...

Timestamp conversion from UTC to EST

Hi, I am getting error while converting Datetime value from UTC to EST, suggest the expression for below UTC date value. 2021-10-25 04:00:00

Resolved! Mapper behaviour

Hello Team, I am facing a strange situation where I am trying to map a value to a variable but it is getting over-written with another value that I haven’t mapped it . Please find the below steps. Here is the mapper, where “” value and X are getting...

Baching of data

Hello Community, I want to batch the data into some number of records which is coming from snowflake and then load into SAP system. How can I achieve this.

Binary attachment upload for PUT API call

Hi All, I am trying to make PUT call to upload an attachment file in binary format after pulling it from a source SFTP. Below is the postman snippet containing headers of the API followed by the snippet of the attachment: My pipeline does not perfo...

Filter/Ignore not null values

Hello, I am trying to build a pipeline where a series of format operations must be applied to a CSV file. For some columns, I want to delete/remove or simply ignore empty rows from the file. I tried doing this with a mapper/filter but with no success...

SnapLogic - Integration Nation

Forum Posts

Ignore the null in array

API returns 500 only when POST is from Snaplogic

Creating Junction object record in Salesforce

Timestamp conversion from UTC to EST

Resolved! Mapper behaviour

Baching of data

Binary attachment upload for PUT API call

Filter/Ignore not null values

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