Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    Farhad Pagdiwala
    Oracle Service SOAP APIAnswered
    Topic posted March 16, 2017 by Farhad Pagdiwala 
    673 Views, 17 Comments
    Title:
    Oracle Service SOAP API
    Content:

    Hello:

        We're integrating our Oracle EBS with Oracle Service Cloud using Cast Iron integration tool.

        The Service Cloud SOAP has several APIs such as Create, Update, QueryObjects etc.

        I would like to know how to pass the number values to these APIs.

        For e.g.  I'm trying to update a custom object Orgs based on the account number which is uploaded along with customer name to this object.

                     I'm using QueryObjects() to first query the data. When I look at the body of this api it has the following elements in the body:

         1. Query    - I believe, we can pass ROQL query to this element with binding parameter. How can we do it?

         2. id

         3. LookupName

         4. CreatedTime

         5. UpdatedTIme.

         Questions:

           1. How can I pass the bind variable to the Query element?     

           2. What values have to be passed to id and LookupName?

              Can I pass account number to the id? If not then, pls. guide as to how can this be achieved?

        Note: I've uploaded the screenshot in case you would like to see how it looks in Cast Iron.

    Version:
    Service Cloud

    Best Comment

    Allan Schrum

    A vaguery of the permission model between QueryCSV and QueryObjects. It should not allow that query but does at the moment. I've an incident filed to fix that issue. Soon you will not be able to use QueryCSV unless you have permissions as well. The same should be true for AnalyticsReport where the custom object is exposed to analytics.

    Regards,

    -Allan

    Comment

    • Allan Schrum

      A vaguery of the permission model between QueryCSV and QueryObjects. It should not allow that query but does at the moment. I've an incident filed to fix that issue. Soon you will not be able to use QueryCSV unless you have permissions as well. The same should be true for AnalyticsReport where the custom object is exposed to analytics.

      Regards,

      -Allan

    • Farhad Pagdiwala

      Thank you Allan. That resolved my issue with QueryObjects operation call.

      Best Regards,

      Farhad.