How to get all users that have worked on a project

Developers & API
1

As the title suggests, I am trying to find a smart and efficient way to get all users that have worked on a given project.
I could retrieve all time entries for all users but it would take a lot of time…
Any help would be appreciated!

2

Hi Rob,

If you know how to use API you can use the following endpoint to obtain information about project membership. Make sure to add your API key and content type-application/JSON in the headers
GET https://api.clockify.me/api/v1/workspaces/{workspaceId}/projects

Once you fetch information in the JSON format you can convert them to a CSV file by using online converters such as JSON to CSV Converter

Cheers,

3

Hello Nicola,
I solved by try and error with the following call:
https://reports.api.clockify.me/v1/workspaces/{{workspaceId}}/reports/summary

and JSON body:

{
“dateRangeStart”: “2023-01-01T00:00:00.000Z”,
“dateRangeEnd”: “2023-12-31T23:59:59.000Z”,
“summaryFilter”: {“groups”: [“USER”]},
“exportType”: “JSON”,
“projects”: {
“ids”: [“xxxxxxxxxxxxxxxxx”]
}
}

Thanks all the same!

1 Like