[higgledy]

I have a requirement to get all cases of all users. i.e. all cases in the database for every user. I see that the standard REST API only returns cases of the logged in user. How do I get around this limitation?

[amosbatto]

You can use:
http://{domain}/api/1.0/{workspace}/extrarest/cases/user/{user_uid}
in my extraRest plugin.
See:
viewtopic.php?f=44&t=730200&p=813110

To get the latest version of extraRest, download it from here:
https://github.com/amosbatto/pmcommunity

[higgledy]

Thanks Amos, but I want all cases for all users no matter the case status or assignee. This http://{domain}/api/1.0/{workspace}/extrarest/cases/user/{user_uid} takes a usr_uid which implies it will return only cases assigned to that user.

[amosbatto]

In the same plugin, you can use:
POST http://{domain}/api/1.0/{workspace}/extrarest/sql

POST parameters:
sql: SQL SELECT statement to execute

Example:

Code: Select all

$postVars = array( 
   sql  =  "SELECT * FROM APPLICATION"; // add your search criteria
);
$url = "/api/1.0/workflow/extrarest/case/sql";
$oRet = pmRestRequest("POST", $url, $aVars, $oToken->access_token);