Resource Load through API

I'm trying to automate getting the resource load report through the API. I'm using V2 of the API.

I saw this post https://success.clarizen.com/hc/en-us/community/posts/203993808-v6-Download-pre-built-Resource-Load-report-via-API?input_string=Resource%20Load%20through%20API

but it seems to only be available for V1 of the API?

Could anyone point me in the right direction?

Audun Rundberg February 05, 2016 07:31 Answered

Please sign in to leave a comment.

7 comments
Date Votes

The REST docs for this API: https://api.clarizen.com/V2.0/services/data/ResourceManagementQuery

The SOAP docs: https://api.clarizen.com/v2.0/docs/index.aspx and select "ResourceManagementQuery" from the index

Eyal Post February 05, 2016 08:28 0 votes

Thanks, the documentation looks like this is exactly what I need.

However, this returns a not found error:

curl -H "Authorization: Session yadi-yadi-yadi" https://api2.clarizen.com/V2.0/services/data/resourceManagementQuery

I get this error:

{
"errorCode": "FileNotFound",
"message": "File not found: data/resourceManagementQuery.",
"referenceId": "gFRgYJ6OBaoN7iRijBrAm"
}

Audun Rundberg February 05, 2016 10:29 0 votes

Try with POST

Eyal Post February 05, 2016 10:43 0 votes

:-)

Thanks!

Audun Rundberg February 05, 2016 11:02 0 votes

OK, so now I get a 500 Internal server error instead.

From the docs, it looks like no parameters are required. If that's not correct, do you know what parameters I need to set?

Audun Rundberg February 05, 2016 11:09 0 votes

Got it working after looking at this https://success.clarizen.com/hc/en-us/community/posts/205373507-Get-custom-fields-using-ResourceManagementQuery

Audun Rundberg February 05, 2016 12:39 0 votes

Posting my work to anyone who comes looking. :-)

This gets the resource load for a single user (with the ID yadi-yadi-yadi) in hours for a period of four weeks (controlled by the dates in the timeFilter)

POST to https://api2.clarizen.com/V2.0/services/data/resourceManagementQuery

JSON:

{
   "resourceEntitiesIds":[
      "/User/yadi-yadi-yadi"
   ],
   "definition":{
      "setting":{
         "fields":[
            {
               "typeName":"User",
               "fieldNames":[
                  "Email"
               ]
            }
         ],
         "sortingType":"Alfabet",
         "workOrRemainingEffort":"Work",
         "loadOrAvailability":"Load",
         "hoursView":true,
         "reportingPeriod":"Weekly"
      },
      "globalFilters":{
         "timeFilter":{
            "from":"2016-02-01T00:00:00",
            "to":"2016-02-28T00:00:00"
         },
         "wantedStates":[
            "Active",
            "Draft"
         ]
      }
   }
}

Audun Rundberg February 05, 2016 12:55 1 vote

Resource Load through API

7 comments Date Votes

7 comments
Date Votes