Business | Canvas

Oracle ATP & APEX - Chatbot, Messenger plugin integration

Contact Us

APEX Chat Plugin

Integrating email and chat with Oracle APEX running on ATP enables you to create powerful and complete applications. You can write simple REST API calls to interact with Oracle Digital Assistant to easily add chatbot functionality to your APEX application. You have to enable a web channel to use your Oracle cloud Digital Assistant in your APEX application. Here's an example code that you can add to your PL/SQL code on insert or update triggers to send push notifications to teams mobile devices and meet your SLA's.
apex_web_service.g_request_headers(1).name := 'Content-Type';
apex_web_service.g_request_headers(1).value := 'application/json';
apex_web_service.g_request_headers(2).name := 'authorization';
apex_web_service.g_request_headers(2).value := 'key=your key goes here';
l_clob := apex_web_service.make_rest_request(
p_url => 'https://your-digital-assistant-web-channel-goes-here',
p_http_method => 'POST',
p_parm_name => apex_util.string_to_table('notification:to:data'),
p_parm_value => apex_util.string_to_table('{"title": "Patriots vs Rams","text": "5 to 1"}:"your key":{"message":"New Ticket has been assigned to you"}')