Designing and Running Pipelines

Expression in mapper

how to write below expression in snaplogic least( IIF(ISNULL(LINEAR_PREMR_DATE),to_Date(‘01/01/4000’,‘mm/dd/yyyy’),LINEAR_PREMR_DATE), IIF(ISNULL(GO_PREMR_DATE),to_Date(‘01/01/4000’,‘mm/dd/yyyy’),GO_PREMR_DATE), IIF(ISNULL(VOD_PREMR_DATE),to_Date(‘01...

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.

SnapLogic - Integration Nation

Forum Posts

Expression in mapper

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

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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