cancel
Showing results for 
Search instead for 
Did you mean: 

Grab each object from array and insert whole JSON object as a string (VARCHAR) in DB

ashis1upreti
New Contributor II

Hello, can someone please help with this? I was to extract each of the { "securityAlt":[...], "security":[...]} section out of the main array, and store each record on oracle table under a field. So for this below example, I want to insert the 12 objects from the main array in my ORACLE table.

ashis1upreti_2-1708715128706.png

 

 

 

2 REPLIES 2

Aleksandar_A
Contributor III

Hello @ashis1upreti,

Could you please provide additional details regarding the input and the desired output? That would help us better understand the context and requirements.

An example input and example expected output data would be a great starting point!

ashis1upreti
New Contributor II

@Aleksandar_A thanks for taking time to read the question and reaching out. I however was able to figure it out by using a mapper. 

ashis1upreti_0-1709062434311.png

 

Thanks anyways. have a good day!