I am trying to get some response from this URL using rest API
https://api2.clarizen.com/V2.0/services/data/timesheetQuery
raw json code
{"typeName":"TimeSheet",
"fields":[ "Reportedby.name","Reportedby.username","Reportedby.displayname","CreatedOn","CreatedBy.name","Project.name","WorkItem.name","ReportedDate","Duration.unit","Duration.length","State.name","LastUpdatedBy.name","LastUpdatedOn"],
"paging": {
"limit": 1000
}
}
when I try above one I am getting successfully response but when i add two (ReportedBy.EmployeeID, ReportedBy.PrimaryGroup.Name) key names in "fields" it sends an error response
{
"errorCode": "InvalidField",
"message": "Entity 'User' does not contain the field 'employeeid'",
"referenceId": "b3y3xVpLkgNGbvdHhONtl"
}
but same thing am able to do in excel add in
I need all employees office id or employee id number and reported by primary group name
Please sign in to leave a comment.
Hi Arayan,
I suppose EmpoyeeId & PrimaryGroup are custom fields. With the API you need to use the field's API name (the one that starts with C_, check the field definition on the Configure page in Clarizen).
Hope this helps,
Ophir
Doesn't seem like there's an answer Aryan, so I will try and ask our dev team here about this.