Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    Romark George Armor Palaganas
    Pass Oracle report to SalesforceAnswered
    Topic posted October 30, 2018 by Romark George Armor PalaganasRed Ribbon: 250+ Points, tagged REST, SOAP 
    98 Views, 11 Comments
    Title:
    Pass Oracle report to Salesforce
    Summary:
    Pass Oracle report output to Salesforce
    Content:

    Hi,

    I'm new in OSC CRM, just wanted to ask if what is the first step on getting this task done. 

    Client would like to get the output of a report from OSC CRM going to Salesforce. 

     

    Thank you,

    rome

    Version:
    18c

    Best Comment

    Sebastiaan Draaisma

    You have to make it into a POST request. The report will then be generated on the OSvC and then you get a result that looks more like a report

    Comment

     

    • Sebastiaan Draaisma

      This can be done through REST API where a url retrieves the information gathered by the report.
      An example would be https://<SITE>.custhelp.com/services/rest/connect/latest/analyticsReports/100313

      In this case report id 100313 is being retrieved and presented in JSON format

      See: https://docs.oracle.com/en/cloud/saas/service/18c/cxsvc/api-analyticsreports.html

      • Romark George Armor Palaganas

        Thank you for your response. I tried to do that and it returned a json-like result that has links. Was expecting that the output would be the same as when we viewed the report in console or something like report that is in json form. 

    • Vlad

      Aside from what Sebastiaan mentioned, depending on your requirement, you may consider using the SOAP API, which returns the data in XML form. You may also run a Cron job which can run a Connect PHP script that executes a report on the Oracle Service Cloud server, outputs the data in CSV form and then uploads it to your FTP server. Aside from the 3 public APIs (REST, SOAP and PHP), you can use standard product functionality and schedule reports to be executed at a specific time and send the data in CSV form via Email.

      See the public APIs documentation for more information. If you are interested in developing a custom Cron job solution that schedules the export activity through Oracle Service Cloud, please reach out to your sales account manager to discuss purchasing a consulting engagement.

    • Sebastiaan Draaisma

      Good question... I have never worked with Postman so I can't say but you would think it should work.
      Do you get a specific error?

      If it's a web based application you might have to include the language header (if the interface language and browser language don't match)
      For example xmlhttp.setRequestHeader("Accept-Language", "sv-SE");

      If you get a cors error you will need to ad your domain in the OSvC cors settings PAPI_CORS_DOMAIN_LIST

      • Romark George Armor Palaganas

        Yeah, the error is 

          "type": "https://custhelp.com/services/rest/connect/exceptions/OSC-CREST-00028",
            "title": "You are forbidden to access this site",
            "status": 403,
            "detail": "Not Allowed: No permission granted to Create AnalyticsReport.",
            "instance": "https://custhelp.com/services/rest/connect/v1.3/analyticsReports/100209",
            "o:errorCode": "OSC-CREST-00028"

         

        Anyway, it's working in soap so I guess I missed a setting config in postman. Thank you again!

    • Sebastiaan Draaisma

      Try analyticsReportResults

      https://custhelp.com/services/rest/connect/v1.3/analyticsReportResults/100209",