Designing and Running Pipelines

Join snap not working

Ok, so you all helped me get past my issue with adding a GUID, and I appreciate it! But now I’m having a problem with my join snap not working. A pic is worth a thousand words so here it is: The thing that is confusing is for the mapper just befor...

How to handle NULL

Hi, I have the below expression but sometimes it can be NULL instead of ‘S’. Could you please suggest how to handle the NULL in the below expression? $input0.final_document.Pipeline_Status==‘S’ && $input1.final_document.Pipeline_Status==‘S’ && $input...

Resolved! How to handle CSV file with header only

Hi, I have CSV files coming through some third parties and sometimes it comes to empty i.e. only with headers and no data. Can you suggest how I can handle such files?

Resolved! Count of files in a directory

Hi, I want to find out the count of files in a directory, could you please suggest how to achieve it?

How to generate a unique id in snaplogic

Hi Team, Can you please let me know how to generate a unique ld like the below one in snaplogic. 1553020781234-4901709987102371234-03202019DFF456F123 Thanks in Advance!

Resolved! Eliminating duplicated records based on the Last Updated Date

Continuing the discussion from Fetch data whose date is less than 10hrs from the existing date!: Hi Team, The discussion was going on a different thread but it would have made more sense to open a new topic thus this one (thanks @koryknick for your s...

newID() not working against starrez

I’m having an issue, but it’s being masked by the fact I’m doing a REST POST against the starrez system (residential housing). I’m just trying to do a simple SELECT [field1], [field2], newID()… Whenever I add the newID() as myGUID back in, my POST...

Unable to Read File Error

Hi, When I am running a pipeline from the parent, it errors out with the below reason but when I run the same child pipeline explicitly, it completes successfully. Could you suggest what’s causing this issue? Reason:Snap errors: {ruuid=78013f7a-5905-...

SnapLogic - Integration Nation

Forum Posts

Join snap not working

How to handle NULL

Resolved! How to handle CSV file with header only

Resolved! Count of files in a directory

How to generate a unique id in snaplogic

Resolved! Eliminating duplicated records based on the Last Updated Date

newID() not working against starrez

Unable to Read File Error

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

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