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.