How to replace value in a json array usingJDBC lookup processor ?

asked 2020-09-30 07:20:27 -0500

Hi,

I have the following schema: { data: { travelInfo: [ { fromLocation: "Mumbai", toLocation: "delhi", travelDate: "2020-01-01" }, { fromLocation: "Delhi", toLocation: "Mumbai", travelDate: "2020-01-05" } ]
} }

Now I have Location table in my db and I want to replace all the location information with locationids.

How can I traverse the array and do a db lookup in streamset? I don't want to use javascript or jython processor.

Reply is appreciated. Thanks

edit retag flag offensive close merge delete

Comments

Can you update your question and add details around your pipeline? How are you loading the data--origin, data format, etc?

iamontheinet gravatar imageiamontheinet ( 2020-09-30 18:10:33 -0500 )edit