Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Removing [] from JSON array

Hey Everyone, I’m currently receiving data from an API and inserting the data into a MySQL database. Here’s an example of one of the columns that are coming over: [“5bb1614c4fd80200018e33c4”,“5ca500003aaf6000014dbc98”,“5b5f558add2f28000151e88d”] Is t...

Matt by New Contributor
  • 2121 Views
  • 3 replies
  • 0 kudos

Resolved! Splitting Json value

My requirement is whenever I pass a filename, the relevant node_id should be displayed for example: when the file name " 82755-6-012019-55.pdf" is passed node id 1021953 should be filter out.