Integrations and APIs for Service

Get Involved. Join the Conversation.

Posts

  • David Wright
    REST API - analyticsReportResults return nested JSON format95.0
    Topic posted July 18, 2017 by David WrightBlue Ribbon: 750+ Points, tagged REST 
    Title:
    REST API - analyticsReportResults return nested JSON format
    Content:

    Does anyone know if it is possible to change the format / nesting of the JSON as returned by the analyticsReportResults function of the REST api?

    Ideally we want something like:

    {
    "Report1":
    [
    "Column1":"value",
    "Column2":"value"

    "Subreport1":[
    "Column3":"value",
    "Column4":"value"
    ]
    }

    ]
    }

    If not possible using the Analytics report function would there be any other way to achieve it using the REST API?

    Thanks, David

  • Mike Waldron
    REST queryResults Resource/Endpoint Not WorkingAnswered155.0
    Topic posted July 25, 2016 by Mike WaldronGold Medal: 3,500+ Points, tagged REST 
    Title:
    REST queryResults Resource/Endpoint Not Working
    Content:

    I'm trying to run a ROQL tabular query with the REST queryResults resource/endpoint. According to the documentation, I should be able to do this, but...ain't workin', even when I copy-and-paste the example directly out of the documentation.

    One peculiarity I've noticed is if I hit

    https://mysite.example.com/services/rest/connect/v1.3/queryResults/
    ?query=select id,subject from incidents where id<=10;
    

    (query from the documentation) there's an extraneous space in between the last slash and the question mark...which may be an artifact of the line break. If I leave it, I get a 200 OK...but no results. If I take it out, I get a 400 Bad Request. Neither result is useful.

    I'm trying to do this on Feb '16. Is there a bug in this REST resource, is something missing from the documentation, or is some other thing going on? Anyone dealt with/resolved this before?

    mjw

     

     

     

  • Nancy Strickland
    REST API introductory videos5.0
    Topic posted April 9, 2016 by Nancy StricklandGreen Ribbon: 100+ Points, tagged REST 
    Title:
    REST API introductory videos
    Content:

    For those who're new to the REST API in Service Cloud, links to short (2-5 minute) introductory videos and code examples are posted here:

    http://docs.oracle.com/cloud/latest/servicecs_gs/servicecs_videos.htm

    (Scroll down toward the bottom of the page.)

  • Janusz Jasinski
    OSC-CREST-00013 - Unrecognised resource25.0
    Topic posted July 17, 2019 by Janusz JasinskiSilver Crown: 22,500+ Points, tagged Connect PHP, REST 
    Title:
    OSC-CREST-00013 - Unrecognised resource
    Content:

    Hi,

    Please see code below - so I'm trying to upload Base64 data as an attachment to an incident.

    However I get this error:

    {
        "type": "https://mydomain.custhelp.com/services/rest/connect/exceptions/OSC-CREST-00013",
        "title": "Unrecognised resource",
        "status": 404,
        "detail": "Resource with id 705951 not found",
        "instance": "https://mydomain.custhelp.com/services/rest/connect/v1.3/incidents/705951/fileAttachments",
        "o:errorCode": "OSC-CREST-00013"
    }

    This incident exists though - I can confirm this by going to the link the error says does not exist. This code sits in the model.

    Am I doing anything obviously wrong?

    Code Snippet:
  • Padma Prabha Varadarajan
    Hash Functions usage15.0
    Topic posted November 11, 2019 by Padma Prabha VaradarajanRed Ribbon: 250+ Points, tagged Connect PHP, Custom Process Models - CPMs, REST 
    Title:
    Hash Functions usage
    Summary:
    Alternate workaround for Hash function
    Content:

    Hi Team, 

    We are in need of using Hash Functions for one of our business requirement that needs to be implemented in Oracle Service Cloud. We have been notified that the Hash Functions are disabled for the php versions available in our application. In this case, please suggest us on the ways that we have to follow to implement the similar functionality as in Hash Functions. 

    Thanks

    Version:
    18C
  • Vijay Krishna
    Chat REST ServiceAnswered25.0
    Topic posted October 16, 2019 by Vijay KrishnaBlue Ribbon: 750+ Points, tagged REST 
    Title:
    Chat REST Service
    Summary:
    Issue with establish session - Chat REST API
    Content:

    Hi,

    I'm trying to invoke Chat REST services for a custom integration. But I am getting an error while calling establish session REST API. Please find the details below. .

    API: https://xxxxx.custhelp.com/services/rest/crossChannelServices/latest/establishSessions

    Body

    {
     "sessionInformation": {
     "emailAddress" : "vijay.krishna@speridian.com", 
     "firstName" : "Vijay",
     "lastName": "Krishna", 
     "question" : "Test Chat",
     "auxiliaryData" : {
    "BROWSER" : "Mobile Safari 11.0", 
    "OPERATING_SYSTEM" : "iPhone OS", 
    "USER_AGENT" : "Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.0 Mobile/15E148 Safari/604.1"

      }
     }
     
    Response
    {
    "type": "https://xxxxx.custhelp.com/services/rest/crossChannelServices/exceptions/OSC-CREST-00006",
    "title": "An attempt to write a resource failed",
    "status": 400,
    "detail": "A problem setting a property was encountered: not an object; EstablishSession.SessionInformation",
    "instance": "https://xxxxx.custhelp.com/services/rest/crossChannelServices/latest/establishSessions",
    "o:errorCode": "OSC-CREST-00006"
    }

     

     Please suggest if any parameter is missing.

    Thanks,

    Vijay Krishna

    Version:
    19B
  • Sristy Arya
    Unable to download File Attachment using CURL5.0
    Topic posted September 29, 2019 by Sristy AryaBronze Trophy: 5,000+ Points, tagged Connect PHP, REST 
    Title:
    Unable to download File Attachment using CURL
    Content:

    Hi Everyone,

     

    I am stuck in downloading a file attachment from portal using CURL. I am able to get the response but unable to download the attachment. Anyone knows about this or has done this before can help.

     

    PFA the code .

     

    Thanks

    Code Snippet:
  • Camilo Peña
    ¿How to? API RN OSvC connected to DialogFlow5.0
    Topic posted June 17, 2019 by Camilo Peña, tagged REST 
    Title:
    ¿How to? API RN OSvC connected to DialogFlow
    Summary:
    Hi, I need to retrieve or create an incident with the fullfillment option in dialogflow, obtaining an answer from the API REST of OSvC
    Content:

    The Main idea is to connect the RN API REST to DialogFlow, and with a fullfillment option, retrieve info of an incident or maybe create one. 

    If you could help me, would be great.

     

    Thanks. 

    Version:
    1.3
  • Sreedhar Loorthu
    How to use CURLFile() with File Attachment of...15.0
    Topic posted June 10, 2019 by Sreedhar Loorthu, tagged Connect PHP, Custom Process Models - CPMs, REST 
    Title:
    How to use CURLFile() with File Attachment of Incident
    Summary:
    Fetch File Attachment from Incident and Pass it to CURLFile() function using PHP
    Content:
    As part of Integration, I need to pass an image file to REST API. 
    It was recommended to use CURLFile('') function for assigning file.
    So, I need to get the file from a particular Incident's FileAttachment and assign it in JSON using PHP.
    Find the bleow sample code for CURLOPT_POSTFIELDS.
     
    CURLOPT_POSTFIELDS:
     
    array('file'=> new CURLFILE('imagefile.jpg'),
      'method' => 'method_name',
      'api_key' => 'XXXXXXXAPIKEYXXXXXXX',
      'body' => '{
    "to":"to_number",
    "type": "image", 
    "image" : {
    "caption" : "Image File"
    },
    }',
    'from' => 'from_number',
    'format' => 'json')
     
     
    How to get the file from Incident and pass it to CURLFILE('') function?
  • Sathya Rajendran
    REST API: OSC-CREST-00008Answered65.0
    Topic posted May 6, 2019 by Sathya RajendranGold Medal: 3,500+ Points, tagged REST 
    Title:
    REST API: OSC-CREST-00008
    Content:

    Hello All,

    When create contact using rest api i am getting below error. And it throw error after refresh only in live it is working perfectly. Any idea why it is?

    {
        "type": "https://mysite-int--tst2.custhelp.com/services/rest/connect/exceptions/OSC-CREST-00008",
        "title": "An internal error has occurred",
        "status": 500,
        "detail": "Cannot save/update: Contact(ID=0): \nDB API Error\n",
        "instance": "Unexpected internal problem: %s",
        "o:errorCode": "OSC-CREST-00008"
    }

Filter by Date

< < December 2019 > >
S M T W T F S
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31        

Filter by Type