Forum Stats

  • 3,769,313 Users
  • 2,252,947 Discussions
  • 7,874,985 Comments

Discussions

POST Json data with nested object to DB Table using ORDS

Robert Sibek
Robert Sibek Member Posts: 35 Red Ribbon

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.

Robert SibekthatJeffSmith-Oracle

Best Answer

Answers