Integrations and APIs for Service

Get Involved. Join the Conversation.


    Dong Wang
    The filter in RunAnalyticsReport api doesn't work as...
    Topic posted March 6, 2019 by Dong WangRed Ribbon: 250+ Points, tagged SOAP 
    59 Views, 1 Comment
    The filter in RunAnalyticsReport api doesn't work as expected
    I'm using soap ui to execute the operation RunAnalyticsReport, and it doesn't work as expected.

    Dear All,

    I'm retrieving data from report via API RunAnalyticsReport. I copied the standard report "Answers - Complex Expression Search Default" (whose report id 176) and changed nothing. I use the new report id to run the method RunAnalyticsReport. The request xml is as below,

    <?xml version='1.0' encoding='UTF-8'?>
    <soapenv:Envelope xmlns:soapenv="">
            <ns7:ClientInfoHeader xmlns:ns7="" soapenv:mustUnderstand="0">
                <ns7:AppID>Run report sample</ns7:AppID>
                <wsse:Security xmlns:wsse="" mustUnderstand="1">
                        <wsse:Password Type="">***</wsse:Password>
        <ns7:RunAnalyticsReport xmlns:ns7="">
            <ns7:AnalyticsReport xmlns:ns4="" xmlns:xsi="" xsi:type="ns4:AnalyticsReport">
                <ID xmlns="" id="100194" />
                <ns4:Filters xsi:type="ns4:AnalyticsReportFilter">
    <ID xmlns="" id="10" />
    </ns4:Operator >

    I got the operator from GetValuesForNamedID, and the 'IN LIST' operation id is 10. 137 is the category's id, who are associated with more than 1 answers in system.

    But I didn't get any result, see as below,

    <soapenv:Envelope xmlns:soapenv="">
          <n0:RunAnalyticsReportResponse xmlns:n0="" xmlns:xsi="">
                      <n0:Name>xx_Answer-Complex Expression</n0:Name>
                      <n0:Columns>Summary,New or Updated,Description,Date Updated,Summary,Answer ID,Weight,Computed Score</n0:Columns>

    But when I changed the operator to some other negative operation, such as <>, not like, not in list, there will be records.

    Please help check the issue.


    Thanks a lot in advance.



    • Robert Surujbhan

      Dong, in the Service Category hierarchy, which level is category ID 137 on?  Is it a node on Level 1, 2, 3, 4, 5, or 6 of the tree?

      Let's say category ID 137 is located on level 2 (so it has one parent).  For your <Values> element in the soap/xml, you will need to send 2.137 instead of just 137.


      If it is at the top as a level 1 category node, then you would use:


      This is the expected format and it should work fine using the IN LIST operator (ID 10) just as you were doing.  Give it a try?