Skip to Main Content
  • Questions

  • How to call json api's from external application/system and insert data in oracle database tables

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Thabo.

Asked: October 19, 2023 - 7:26 am UTC

Last updated: November 03, 2023 - 4:46 pm UTC

Version: 19c

Viewed 1000+ times

You Asked

We have an application which connects with other system using an API. So they are providing us with an API which we need to call and insert its data in our oracle database. I don't know how to go about it.

and Chris said...

If you want to call (REST) APIs from PL/SQL then I recommend installing Oracle APEX in the database first (if it isn't already).

You can then use APEX to read data from APIs. Here's an example tutorial:

https://apexapps.oracle.com/pls/apex/dbpm/r/livelabs/run-workshop?p210_wid=942

Or you can call APEX_WEB_SERVICE directly from PL/SQL:

https://oracle-base.com/articles/misc/apex_web_service-consuming-soap-and-rest-web-services

Whichever route you go down, you'll need to ensure that the network allows the app/database to reach the API and you're using the right authentication method. You'll need to work with the other system's provider or read their documentation to figure this out.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, November 03, 2023 - 12:47 pm UTC

Hello Chris,

Thanks for the links you provided. Let me go through them
Chris Saxon
November 03, 2023 - 4:46 pm UTC

You're welcome
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.