Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    Mohammed Shanab
    Integration Push Data from Oracle Service Cloud
    Topic posted November 9, 2018 by Mohammed Shanab, tagged Connect PHP, Custom Process Models - CPMs, REST, SOAP 
    116 Views, 2 Comments
    Title:
    Integration Push Data from Oracle Service Cloud
    Summary:
    How to call an API or push data into a queue on trigger of a data change
    Content:

    Hi,

    We would like to know if we could make an API call or push a message to a JMS queue on trigger of a data change so that we could propagate the change to other applications in the enterprise. We have a middleware which can expose an API or JMS stack. 

    The current implementation is a pull model where a poller regularly polls Oracle Service Cloud for a change via a watermark custom field which populated on a change. 

    Thanks

    Shanab

    Comment

     

    • Vlad

      I would suggest implementing an asynchronous custom process (CPM) that runs on create/update/destroy event for the object in question and through PHP code does a Curl call to your exposed API.

      Answer Link: The Process Designer / Custom Process Models (CPM) functionality
      Answer Link: Anatomy of a CPM (Custom Process)
      Answer Link: CPM/Process Designer Best Practices
      Answer Link: Two second guideline for synchronous CPMs
      Answer Link: Use of cURL in custom process
      Answer Link: Technical Documentation and Sample Code

      Another approach would be to use the Event Notification Service in the SOAP API. For more information on that see the SOAP API documentation in the last answer linked above.

    • Isaiah Inuwa

      Hello Shanab,

      I did some work on implementing the Event Notification listener. There are some hiccups that I ran into that may be useful for you if you decide to go that route. See this post for more information: https://cloudcustomerconnect.oracle.com/posts/b452f097a1

      Our implementation has one Spring webapp service receiving all notifications from Service Cloud, pushing them into a RabbitMQ/AMQP exchange. After that, any interested consumers can create a queue for any relevant data. That removes the need for implementing the OSvC Event Notification Listener multiple times. I'm sure you could do something similar with JMS if you wanted to. I haven't posted our latest code to the forum, but I'll try to if I have some extra time.

       

      Isaiah Inuwa