Home/ Questions/Q 1610
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-10-01T20:30:46+00:00

How to accept JSON arrays of objects on ORDS

  • 1
  • 1

Hi all,

I am working on REST APIs to integrate with an external frontend. The task is to accept a collection of JSON arrays.

The problem is I understand how to accept objects but I don’t understand how to accept arrays using the ORDS platform.   An example can be: 

 {     "users": [   

 {  "name": "adam", },                          

  {  "name": "susan", }    

] }
json arrayoracleords
Share
Leave an answer

Leave an answer

Browse

4 Answers

  1. You can accept JSON array inputs via type object using PL/SQL in Oracle ORDS. Below is an example:

    Create a table to store the data:

    CREATE TABLE APP_USERS (
NAME VARCHAR2(30),
USERTYPE VARCHAR2(10));

    Create a DB package with TYPE declaration:

    CREATE OR REPLACE PACKAGE accept_json AS
    TYPE vc_arr IS
        TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
    PROCEDURE ins_user (
        u_name IN vc_arr
    );
 
END accept_json;
 
/
 
CREATE OR REPLACE PACKAGE BODY accept_json AS
 
    PROCEDURE ins_user (
        u_name IN vc_arr
    ) AS
    BEGIN
        FOR i IN 1..u_name.COUNT LOOP 
         INSERT INTO app_users (
            name,
            usertype
         ) VALUES (
            u_name(i),
            'ENDUSER'
          );
 
        END LOOP;
 
        COMMIT;
    END ins_user;
 
END accept_json;

    Now enable the above DB package for ORDS:

    BEGIN
    ORDS.ENABLE_OBJECT(p_enabled => TRUE,
                       p_schema => 'YOURSCHEMA',
                       p_object => 'ACCEPT_JSON',
                       p_object_type => 'PACKAGE',
                       p_object_alias => 'ACCEPT_JSON',
                       p_auto_rest_auth => FALSE);
    COMMIT;
END;

    Calling the package:

    curl --request POST \
  --url http://localhost:8080/ords/hr/accept_json/INS_USER \
  --header 'content-type: application/json' \
  --data '{
	"u_name" : [ "adam", "susan"]
}'

    Please try and let me know if any issues.