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

Data reconciliation solutions?

One of my company's use cases for SnapLogic today is replication of data from Salesforce into internal Kafka topics for use throughout the enterprise.There have been various instances of internal consumers of the Kafka data reporting missing records....

feenst by New Contributor II
  • 30 Views
  • 0 replies
  • 0 kudos

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 II
  • 837 Views
  • 4 replies
  • 1 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 II
  • 1033 Views
  • 4 replies
  • 1 kudos

Resolved! 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
  • 765 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
  • 866 Views
  • 1 replies
  • 0 kudos