This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
Data Integration
Discuss data integration use cases and solutions from ETL, ELT, reverse ETL, and AutoSync.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Start a conversation

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
  • 639 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
  • 814 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
  • 678 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
  • 711 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
  • 1001 Views
  • 3 replies
  • 0 kudos
SnapLogic Trust Site
Visit Trust.SnapLogic.com for real-time visibility into system performance and availability.
SnapLogic Documentation
Visit our documentation for detailed information on functionality and features.
  • New site
  • Original documentation site
    • Labels