APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exteral API with JSON value and Post the json value into Oracle Table

M.broFeb 20 2024

Hi All,

I am using Oracle Apex 20.1 and DB 12c

I am new to the API. I am consuming external API to some JSON Value or “no data found” - error message. I configured using “REST Data Source” - GET Method.

I want to insert the value in the Oracle table (POST Method).

Example: https://jsonplaceholder.typicode.com/todos/ this URL is getting some fake JSON value. I want to insert the value in the Oracle table.

what is the difference between REST Enabled SQL Vs. REST Data Sources?

Thanks & Regards,

M.bro.

This post has been answered by Carsten Czarski-Oracle on Feb 21 2024

Jump to Answer

Added on Feb 20 2024

#apex, #api, #get, #json, #oracletable, #post, #restful

3 comments

547 views

1 mention