Search
  • Bheem

Whatsapp Integration with Oracle Apex

Step 1 : Get your API credential's from https://app.chat-api.com/login


Step 2: Scan the QR code.


Step 3: Compile PLSQL Procedure.

Replace URL & Token in URL section.



CREATE OR REPLACE PROCEDURE send_order_confirmation_watsapp (
    p_mob       IN   VARCHAR2,
    p_message   IN   VARCHAR2
) IS

    l_response   CLOB;
    l_p_body     CLOB := '{"phone" : "'
                     || p_mob
                     || '","body" : "'
                     || p_message
                     || '"}';
    lv_status    VARCHAR2(100);
    l_url        VARCHAR2(2000) := 'https://eu85.chat-api.com/instance15/sendMessage?token=v7dnj26becvg';
BEGIN
    apex_web_service.g_request_headers(1).name := 'Content-Type';
    apex_web_service.g_request_headers(1).value := 'application/json';
    l_response := apex_web_service.make_rest_request(p_url => l_url, p_http_method => 'POST', p_body => l_p_body);
/* Parsing Webservice Response as JSON */

    apex_json.parse(l_response);
    apex_application.g_print_success_message := l_response;
END;


Step 4: Call Procedure according to your requirement.

404 views0 comments

Recent Posts

See All

How to create network ACL in oracle database.

when you are calling third party API in oracle using UTL_HTTP then you will face Network access denied by ACL error if ACL is not created. To create ACLfirst login with sys account then run below code