Question

Retrieve data from JSON response

  • 20 July 2020
  • 1 reply
  • 362 views

Userlevel 2
Badge +6

Hi,

We are getting a set of result from a API call in JSON response.

How can I get the value and map with FSM field?

Currently I am using subtring function to achieve.But when the tag repeats, it creates a problem.

Any quick help regarding this.


1 reply

Userlevel 7
Badge +18

Oracle Database can process JSON natively. You may need a full license of the Oracle Database software, since creating your own tables is usually not something you can do with an ASFU license.

Attached is some SQL showing how this might work.

The column constraint is not merely a constraint but also a flag that changes the logical behavior of the subsequent SELECT query. This is why this won’t work on a native CLOB you might find in the existing application.

Reply