Designing and Running Pipelines

Resolved! Change array to object and extract certain characters from it

Hi, I am trying to change the array to an object and after that only get the value between the () Example: Input [ { “Systems” : [“Ardoq (431)”, “SnapLogic (780)”] } { “Systems” : [“SnapLogic (780)”] } ] Expected output: [ { “Systems” : “431”, “Syste...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Change array to object and extract certain characters from it

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

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

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