JSON

[Jeevan Sompuram]

We have need to join REST JSON API with Relational Tables. Right now we do lot of coding to call REST API and convert nested JSON data from REST API into Tabular format and then join with relational tables.

Can we make things simpler like we have in Oracle DB for Oracle.

 

See the below link:

 

https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6287

these are the steps:

Call REST API using OAUTH2

Publish that Data Source and then use somehting like this :

 

SELECT json_value(po_document, '$.Requestor' RETURNING VARCHAR2(32)),

json_query(po_document, '$.ShippingInstructions.Phone'

RETURNING VARCHAR2(100))

FROM j_purchaseorder

WHERE json_exists(po_document, '$.ShippingInstructions.Address.zipCode')

AND json_value(po_document, '$.AllowPartialShipment' RETURNING NUMBER(1))

= 1;-Jeevan.