Skip to Main Content

APEX

PL/SQL function(s) for Mobile Verification using APEX_WEB_SERVICE

Mahmoud_RabieJul 6 2017 — edited Jul 10 2017

Hello Experts

Given:

- Nexmo SMS Service Provider used to verify mobile number. Based on documentation, just two simple steps are needed.

  1. Send the verify code to the number you want to verify:

curl -X POST  https://api.nexmo.com/verify/json \

-d api_key=MYAPIKEY \

-d api_secret=MYAPISECRET \

-d number=MYMOBILENUMBER \

-d brand="MYBRAND"

returns

{"request_id":"MYREQUESTID",

"status":"0"}

  1. Submit the Request ID generated by step 1 and the code received via SMS to complete the verification:

curl -X POST  https://api.nexmo.com/verify/check/json \

-d api_key=MYAPIKEY \

-d api_secret=MYAPISECRET \

-d request_id="REQUEST_ID" \

-d code=CODE

returns

{"request_id":"MYREQUESTID",

"status":"0",

"event_id":"anynumber",

"price":"0.10000000",

"currency":"EUR"}

Required:

Using APEX_WEB_SERVICE package, I need to write one or two PL/SQL Functions that take the mobile number and inputs and does these two POSTs and then return the result

I would appreciate any help

Regards

Mahmoud

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2017
Added on Jul 6 2017
2 comments
195 views