How to get data from REST API to Oracle DB

Question

I need a way to read/get data from a REST API to insert it into a table in Oracle DB. I've been searching for it but I've only found the opposite case.

I'm using PL/SQL Developer & Postman Do i need another software ?

Thanks.

Is the data in a JSON format? I would suggest starting with the UTL_HTTP package. — Acroyear
– Acroyear, Commented Dec 11, 2019 at 22:53

thatjeffsmith · Accepted Answer · 2019-12-11 22:53:16Z

3

One way to go is with Oracle REST Data Services (ORDS).

It's a mid-tier Java application (or servlet with Tomcat/WebLogic) that takes HTTP(S) requests and marshalls that to the Oracle Database.

It handles GETs, PUTs, POSTs, & DELETEs so you can definitely use it to INSERT one or more rows to a TABLE. And it can do that via a SQL statement, or an existing PLSQL API.

I talk more about this here.

Here's a REST Service that let's you POST a new record to a TABLE, including a BLOB (file).

This technology is included with your Oracle Database license at no additional cost.

answered Dec 11, 2019 at 22:53

thatjeffsmith

22.7k6 gold badges44 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Acroyear · Accepted Answer · 2019-12-12 15:45:49Z

3

If you want to use UTL_HTTP, you can do something as simple as an INSERT ... SELECT ...

INSERT INTO my_table(response_data)
  SELECT utl_http.request('http://service.url.com')
  FROM   dual;

answered Dec 12, 2019 at 15:45

Acroyear

1,4614 gold badges25 silver badges40 bronze badges

Collectives™ on Stack Overflow

How to get data from REST API to Oracle DB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related