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 ...
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/...
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 ...
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...
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><...
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...
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...
Hello everyone,I've been asking to update a Snowflake table in real time every time there's a modification made on a specific worksheet in a Google workbook.I'm not sure how to proceed, I believe it's by using a Google Sheet Subscribe snap and Trigge...
