Post

3 followers Follow
0
Avatar

How to get ReportedBy.EmployeeID and ReportedBy.PrimaryGroup.name from Rest API

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

 

Aryan Singh Answered

Please sign in to leave a comment.

2 comments

0
Avatar

Doesn't seem like there's an answer Aryan, so I will try and ask our dev team here about this.

Guy 0 votes
Comment actions Permalink
1
Avatar

Hi Arayan,

I suppose EmpoyeeIdPrimaryGroup 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

Ophir Kenig 1 vote
Comment actions Permalink