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

Cannot read more than 2,147,483,647 into a byte array

Hello, I am facing issue while reading a huge file (more than 2 GB) in size. I want to read the file and zip the file.I tried in 2 ways and in both i am getting the error. Method 1: After file reader snap, I am using a Binary to Document (Encode or D...

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

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

Cannot read more than 2,147,483,647 into a byte array

newID() not working against starrez

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings