Data Integration
Discuss data integration use cases and solutions from ETL, ELT, reverse ETL, and AutoSync.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

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

Don by New Contributor
  • 29 Views
  • 1 replies
  • 0 kudos

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

LeeDuffy by New Contributor
  • 238 Views
  • 4 replies
  • 1 kudos

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

Vamsik by New Contributor II
  • 449 Views
  • 1 replies
  • 0 kudos

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

lake by New Contributor
  • 423 Views
  • 1 replies
  • 0 kudos

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

lake by New Contributor
  • 588 Views
  • 3 replies
  • 0 kudos

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

lake by New Contributor
  • 425 Views
  • 1 replies
  • 0 kudos

Real time Integration Google Sheet to Snowflake

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

Capture d’écran 2024-08-06 à 18.12.47.png Capture d’écran 2024-08-06 à 18.13.32.png
salinee by New Contributor
  • 407 Views
  • 0 replies
  • 0 kudos