Forum Discussion

rajneesh4u's avatar
rajneesh4u
Visitor
4 years ago
Solved

I need to discuss regarding RESTful API for accessing oracle database tables.

Hello All,

I need to discuss regarding RESTful API for accessing oracle database tables.
API was created using Oracle Rest Data Services (rest data enable at SQL developer).
I am getting error : 401 unauthorized while doing query through post man as below:

GET http://localhost:8080/ords/autodemo2/metadata-catalog/

However below is working fine (code 200 OK):
http://localhost:8080/ords/autodemo2/open-api-catalog/

Not sure why metadata query is facing authorization issue while swagger(open API) one is giving response without issue at postman.

I tried for other schema alias autodemo and here both are giving proper response:
http://localhost:8080/ords/autodemo/metadata-catalog/
http://localhost:8080/ords/autodemo/open-api-catalog/

 

Thanks,
Rajneesh

  • Hi Rajneesh,

     

    The issue seems to be either with Postman or with Oracle Rest Data Services and not with Swagger open-source tools. You should open a ticket with Portman and/or Oracle for support.

1 Reply

  • HKosova's avatar
    HKosova
    SmartBear Alumni (Retired)

    Hi Rajneesh,

     

    The issue seems to be either with Postman or with Oracle Rest Data Services and not with Swagger open-source tools. You should open a ticket with Portman and/or Oracle for support.