Designing and Running Pipelines

Get input file name from CSV parser

Hi, I have a set of CSV files that I read from using a CSV Parser. Is there a way the CSV Parser can also output the name of the file. I have already thought of putting the CSVParser in a child pipeline and feed the name of the pipeline as a paramete...

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

SnapLogic - Integration Nation

Forum Posts

Get input file name from CSV parser

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

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