Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

POST Json data with nested object to DB Table using ORDS

Robert SibekMar 16 2019 — edited Mar 20 2019

Hello,

I am currently developing Apex application and need to use ORDS endpoints for data callback.

When I tried to post without nested object, everything was working perfectly. But recently, API provider made some changes and now some information are presented as nested Object.

This is the Json sample configured in the provider's backend.

{

  "device" : "37AB2C",

  "time" : "1552749097",

  "data" : "0d01da0c1600",

  "signal" : "Average",

  "location" : {"lat":49.21706417063655,"lng":16.627916371512473,"radius":9228,"source":2,"status":1},

  "seqnumber": 1714

}

This is the table, to which I am insterting data:

CREATE TABLE "SENSOR_DATA"

   (

"DEVICE" VARCHAR2(8 BYTE) NOT NULL ENABLE,

"TIME" NUMBER(*,0),

"SIGNAL" VARCHAR2(12 BYTE),

"DATA" VARCHAR2(24 BYTE),

"LOCATION" VARCHAR2(20 BYTE),

"SEQNUMBER" VARCHAR2(20 BYTE)

   )

Thank you for any suggestion.

This post has been answered by thatJeffSmith-Oracle on Mar 18 2019
Jump to Answer
Comments
Post Details
Added on Mar 16 2019
4 comments
1,550 views