Designing and Running Pipelines

Get a list of scheduled tasks (name and scheduling details)

Hi All, I’m looking for a Snap or API that will return a list of scheduled tasks with the task name and its scheduled time. I tried SnapLogic List snap which returns the task name but not the scheduled time. Is there any API I can use for this? Ultim...

Ignore mapping if empty

hi there, how can I ignore the mapping if I am not getting any values? example in the below screenshot for the record, there’s no attachment so mapping should not happen. for this example since no attachement its failing in the downstream snaps. Tha...

Number is equal ""(empty string)?

Hi there, Can someone explain to me why the following expression generates true as a result: I have the following pipeline: In JSON Generator I have: { "field": null } AutoPrep config: Data type is set to a number; if null, 0 (zero) will be the ...

Resolved! Compare data between 2 different systems before an update

Hi Team, My pipeline has a source system as Snowflake and target system as Salesforce There are 2 fields that needs to be updated in Salesforce but these should be updated ONLY if the data has changed in snowflake. I was going ahead with the field in...

Edit account using API?

I need a way to edit an account programatically using API. In our case, the end-user uses our application to enter the credentials for a data source (e.g. google drive, SFTP etc). I would then like to edit the corresponding account in Snaplogic with ...

How to add a property name to my incoming Array

How to I add a property name to my incoming array: Looks this way: [{ “fileName”: “Invoice.pdf”, “filePath”: “\\Server01\FileFolder\12575\773016951\6b83566e-0908-42f9-9bbe-9adefb296633” }, { “fileName”: “Invoice2.pdf”, “filePath”: “\\Server01\FileFo...

Resolved! How to use "contains" function in router? I am getting error of expression failure

Hi guys, I am trying to use router with diff data scenarios, where I have to give conditions like: 1) ($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘DI_AVT_DH_PERSON_TYPE_ODS’,‘DI_AVT_DH_PERSON_CITIZENSHIP_ODS’,‘DI_AVT_DH_PERSON_LANGUAGE_ODS’)) If ...

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

SnapLogic - Integration Nation

Forum Posts

Get a list of scheduled tasks (name and scheduling details)

Ignore mapping if empty

Number is equal ""(empty string)?

Resolved! Compare data between 2 different systems before an update

Edit account using API?

How to add a property name to my incoming Array

Resolved! How to use "contains" function in router? I am getting error of expression failure

Expression in mapper

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data

Parsing XML using a Python script returns an encod...

multiple array objects

String replace method where pattern is dynamic