Data Integration

Resolved! Cloning Data Stream: Copy Snap vs Router Snap for Efficiency and Performance

Hi Team,In my pipeline, I need to clone the incoming data stream for further transformation. I have two options: either to use the Copy Snap or the Router Snap with both conditions set to true. Which option is more suitable for cloning large volumes ...

JSON path and case insensitive search

I'm having issues trying to find all instances that match a particular email address using JSONPath. The example below is just an array of email objects, but the real data is an array or personnell profiles that I need to search by an email address ...

Resolved! Simple JSON nesting issue

Hi All,I would like some advice/better solution to my query!I am preparing some data to send in a table via email, the data structure is as below [{ "statusCode": 202, "statusText": "Accepted", "payload_file_name": "s3:///bucket/api-payload/archive/...

Issue with MYSQL Update on Duplicate condition

Hi Team,I am working on integration to push data to MYSQL , When we are using the Update on Duplicate condition i see the below error for some of the recordsYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server ...

Resolved! An element in an array is present in another array or not

I would like to know how to check whether an element in one array is present in another array or not?I have tried arr1.every(item => arr2.includes(item)) in mapper snap. It complaints about list type does not have a method named every. I used sl.ensu...

Resolved! My response always shows < for all the values inside XML instead of < after the xml formattersnap

I am passing the below input to XML formatter from mapper snap as string to XML formatter snap.Before XML formatter snap:"openEngine":"<items>\n<item \n</item>\n</items>" After XML Formatter snap:<?xml version='1.0' encoding='UTF-8'?><openEngine><...

Resolved! Array of Objects manipulation

Hi team,I would like to iterate thru an array of objects and verify if the objects has same num, code and date with different boxNumbers, then I should add the boxNumbers together and make that as a single object. If those three didn't match I should...

Resolved! Array of objects manipulation

Hi team,I would like to iterate thru an array of objects and verify if the objects has same num, code and date with different boxNumbers, then I should add the boxNumbers together and make that as a single object. If those three didn't match I should...

SnapLogic - Integration Nation

Forum Posts

Resolved! Cloning Data Stream: Copy Snap vs Router Snap for Efficiency and Performance