4 Replies Latest reply on Mar 19, 2019 10:06 PM by Robert Sibek

    POST Json data with nested object to DB Table using ORDS

    Robert Sibek

      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.