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

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error