Skip to Main Content
Forums

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!

Call API from plsql and get value from JSON response

GeekintoNov 4 2016 — edited Nov 7 2016

Hi,

Please support,

/*

Apex Version: 5.0.3

Data Base: 11.2g

OS: Windows 10

*/

My API is: https://api.nexmo.com/verify/json?api_key=450eafe&api_secret=e7f5f0197e054c&number=2010024470&brand=NexmoVerifyTest

Capture.PNG

It's Verify API service.

Ref API: https://docs.nexmo.com/verify/api-reference/api-reference

Quick info..
This API When call it from HEAD method will be sending verify code to Number (in my example: 201009924470) and get Response or retrieve JSON code into API.txt file.. please look to prev PIC.

Now i want, Please

  1. How to call this API from plsql function.
  2. How to parse or get json values from same plsql function.

Thank you..

@"Mahmoud_Rabie"

@"Kiran Pawar"
This post has been answered by Pavel_p on Nov 5 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 3 2016
Added on Nov 4 2016
#11g, #apex, #apex-discussions, #api, #plsql
4 comments
3,587 views