Designing and Running Pipelines

Resolved! Trim last lines in csv file

Team, I have a log file in csv format. But the log file contains status information in first 5 lines and last 3 lines. I can skip the first 5 lines using Skip lines* property in csv parser. But I could not remove the last 3 lines. And I am getting er...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Trim last lines in csv file

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

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

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