REST API for GET_REQUESTS filterby All_Open

REST API for GET_REQUESTS filterby All_Open

The input data im using trying to get All_Open requests is this: 

INPUT_DATA=<Details> <parameter> <name>from</name> <value>0</value> </parameter> <parameter> <name>limit</name> <value>100</value> </parameter> <parameter> <name>filterby</name> <value>All_Open</value> </parameter></Details>

But I get this error. 

- < operation name =" GET_REQUESTS " >
- < result >
  < status > Failed </ status >
  < message > Technician/User does not have permissions to view this request filter </ message >
  </ result >
  </ operation >

*********************************************


The key im using is a full SDP admin.  9.1 Build 9107

Here is the entire URL: 

https://oursite.com/sdpapi/request/?TECHNICIAN_KEY=full_admin_technician_key&INPUT_DATA=<Details> <parameter> <name>from</name> <value>0</value> </parameter> <parameter> <name>limit</name> <value>100</value> </parameter> <parameter> <name>filterby</name> <value>All_Open</value> </parameter></Details>&OPERATION_NAME=GET_REQUESTS


************************************************


Are we able to filter the GET_REQUEST operation to only get OPEN REQUESTS? I'd rather not have to pull every single request, then iterate through that xml output just to grab the open ones. I found the All_Open filterby somewhere here in the forums... but i cannot remember where, looking now for reference. It looks like the capability is already there, the HTTP request was successful (200 OK), but its just having trouble with permissions, or some other issue, maybe cookie related?  




Get Requests

To get request, the URL should be given as:

http://<servername>:<port number>/sdpapi/request/

 

Assume the Request ID is 25,then the URL is given as:

http://localhost:8080/sdpapi/request/

 

Input:

<Details>

<parameter>

<name>from</name>

<value>0</value>

</parameter>

<parameter>

<name>limit</name>

<value>25</value>

</parameter>

<parameter>

<name>filterby</name>

<value>All_Requests</value>

</parameter>

</Details>

 



Note: Please note that the Input and Output XML formats have been changed. But for compatibility reasons, the Input operation will support both the formats.

 

Output:

 

<?xml version="1.0" encoding="UTF-8"?>

<operation name="GET_REQUEST">

<result>

<statuscode>200</statuscode>

<status>Success</status>

<message>Request replied Successfully</message>

</result>

<Details type="GET_REQUESTS">

<record URL="http://localhost:8080/sdpapi/request/<requestid>

<parameter>

<name>workorderid</name>

<value><requestid></value>

</parameter>

</parameter>

<name>requester</name>

<value>administrator</value>

</parameter>

<name>createdby</name>

<value>administrator</value>

</parameter>

</parameter>

<name>createdtime</name>

<value>12321434324324</value>

</parameter>

</parameter>

<name>duebytime</name>

<value>11234321412454</value>

</parameter>

</parameter>

<name>subject</name>

<value>subject</value>

</parameter>

</parameter>

<name>technician</name>

<value>administrator</value>

</parameter>

</parameter>

<name>priority</name>

<value>High</value>

</parameter>

</parameter>

<name>status</name>

<value>open</value>

</parameter>

</parameter>

<name>isoverdue</name>

<value>false</value>

</parameter>

</record>

<record URL="http://localhost:8080/sdpapi/request/<requestid>"

<parameter>

<name>workorderid</name>

<value><requestid></value>

<parameter>

<name>requester</name>

<value>administrator</value>

<parameter>

<parameter>

<name>createdby</name>

<value>administrator</value>

<parameter>

<parameter>

<name>createdtime</name>

<value>1232143323543</value>

<parameter>

<parameter>

<name>duebytime</name>

<value>1123432143534</value>

<parameter>

<parameter>

<name>subject</name>

<value>subject</value>

<parameter>

<parameter>

<name>technician</name>

<value>administrator</value>

<parameter>

<parameter>

<name>priority</name>

<value>High</value>

<parameter>

<parameter>

<name>status</name>

<value>open</value>

<parameter>

<parameter>

<name>isoverdue</name>

<value>false</value>

<parameter>

</record>

</Details>

</operation>


                  New to ADSelfService Plus?