I'm trying to connect to a remote REST API using sqlDeveloper. I don't need ORDS, since I suspect I'm making a call to a remote REST API to get back JSON data, parse it and then load into a DB table. I do not need the DB receiving the data to provide REST API's , I just need to call a REST API to get data into a table.
Problem is in sqlDeveloper when using "REST Development" and attempting to connect to server, it tries to connect but fails authorization (401) even though I know user/passwd is good. Turns out its making a POST call to remote API server, when I would have wanted a GET call , plus it fails 401 even after I enter correct user/passwd in popup window . Suggesting for connecting correctly ?