Business | Canvas

Oracle Apex Google Firebase Chat Integration

Contact Us
oracle-apex-google-firebase-1.png

APEX web service for firebase messaging

Although Oracle offers enterprise grade chatbots that can easily be integrated to APEX, you can also call apex rest services to integrate with Google Firebase. Here's an example code that you can text in your PL/SQL code on insert or update triggers to send push notifications to your support 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://fcm.googleapis.com/fcm/send',
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"}')