Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    Guillaume Dauphin
    Answer API collection
    Topic posted February 14, 2019 by Guillaume DauphinBlue Ribbon: 750+ Points, tagged REST 
    68 Views, 2 Comments
    Title:
    Answer API collection
    Summary:
    Status of Answer : API Retrieve collection
    Content:

    Hello,

     

    I am trying to use the GET answer collection API :

    https://docs.oracle.com/en/cloud/saas/service/18d/cxsvc/op-services-rest-connect-v1.4-answers-get.html

    I am able include several Answer's fields into the response (language, summary, solution). However I cannot have the Status information.

    I tried the following syntax : fields:summary,question,language,statusWithType,solution

    Do you have any information please ?

    Guillaume

    Version:
    18D
    Code Snippet:

    Comment

     

    • Suresh Thirukoti

      I think there is a condition/clause "Queries on subfields, such as name.first, only work with individual resources and not with collections." but I am not sure whether StatusWithType is a collection as such.

      Alternatively I would suggest to go with ROQL option like this

      https://sitename.custhelp.com/services/rest/connect/v1.3/queryResults?query=select summary,statuswithtype.status.lookupname as STATUS, question, language.lookupname as LANG,  solution from Answer limit 5

      ~Suresh

      • Robert Surujbhan

        This is correct.  Sub-fields on a collection are not supported by the "fields" parameter, and statusWithType.status falls into this category.  Running ROQL tabular queries as Suresh suggested or executing a report via the API are the options!