Designing and Running Pipelines

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

Filter on Epoch Time

In the flattened data set, $lastUpdatedAt is an Epoch time value (i.e. 1665404233565) A Filter snap is being used to filter out flattened records updated prior to yesterday. There are 64 records in the dataset that meet that condition. When the filte...

Excel Parser not producing empty document view

Hello Community, I have a problem where my excel parser snap is not producing an output document view when I’m parsing a file with only headers present and no actual data (this is a valid business scenario we have to deal with). I have the same pipel...

Inserting Multiple object records Salesforce

Hi, Is it possible to insert multiple object records in a single pipeline. E.g. Insert Account first and then insert contacts and associate those contacts with the account using an external id field. Thanks!

Salesforce oauth account creation

How to setup salesforce oauth account and generate access token and refresh token in snaplogic.

Data post through BULK API

Hi, I need to load data in my target application using BULK API. Which snap I have to use in this case? Please help!

Salesforce to Redshift

Hello Community, We are planning to implement a solution loading data from SFDC to Redshift, I searched for a pattern and found the following blog post helps very much. Unfortunately, we searched in the patterns but didn’t find the relevant one. We a...

SnapLogic - Integration Nation

Forum Posts

Binary attachment upload for PUT API call

Filter/Ignore not null values

Filter on Epoch Time

Excel Parser not producing empty document view

Inserting Multiple object records Salesforce

Salesforce oauth account creation

Data post through BULK API

Salesforce to Redshift

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error