{"id":22715,"date":"2025-04-17T13:41:10","date_gmt":"2025-04-17T13:41:10","guid":{"rendered":"https:\/\/clockify.me\/help\/?p=22715"},"modified":"2025-05-09T13:36:19","modified_gmt":"2025-05-09T13:36:19","slug":"how-to-make-a-list-of-projects-with-assigned-people-via-api","status":"publish","type":"post","link":"https:\/\/clockify.me\/help\/troubleshooting\/how-to-make-a-list-of-projects-with-assigned-people-via-api","title":{"rendered":"How to make a list of projects with assigned people via API?"},"content":{"rendered":"\n<p>If you want to create a list of projects with the people assigned to them, do the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Tools<\/strong>:<br>\n<ul class=\"wp-block-list\">\n<li>You will need Postman (or another API tool) for making API calls<\/li>\n\n\n\n<li class=\"translation-block\">Convert JSON responses into CSV format for easier handling in Excel (e.g. use <a href=\"https:\/\/konklone.io\/json\/\">konklone<\/a>, or some other conversion tool)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>API calls<\/strong>:<br>\n<ul class=\"wp-block-list\">\n<li>Use the following two endpoints:\n<ul class=\"wp-block-list\">\n<li><code>GET \/v1\/users<\/code> \u2013 To get user information<\/li>\n\n\n\n<li><code>GET \/v1\/projects<\/code> \u2013 To get project information<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"translation-block\">Be mindful of the <strong>page size<\/strong> and <strong>page number<\/strong> when fetching project data to ensure you retrieve all projects<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Convert data to CSV<\/strong>:<br>\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">In <strong>Postman<\/strong>, export the responses to JSON<\/li>\n\n\n\n<li class=\"translation-block\">Use <strong>konklone.io<\/strong> to convert each JSON response to a CSV file<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Combine data in Excel<\/strong>:<br>\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">Open the two CSV files in <strong>Excel<\/strong><\/li>\n\n\n\n<li class=\"translation-block\">Use <strong>Excel\u2019s conditional formatting<\/strong> to match the user IDs in the project CSV with the corresponding user names (or emails) from the user CSV<\/li>\n\n\n\n<li>You may need to adjust cell sizes to view all data or separate the user IDs into multiple cells<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"translation-block\">As a result,<strong> <\/strong>you\u2019ll have a CSV file listing <strong>projects<\/strong> in one column and the assigned <strong>user names<\/strong> in another column.<\/p>\n","protected":false},"excerpt":{"rendered":"If you want to create a list of projects with the people assigned to them, do th&#8230;","protected":false},"author":25,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_helpful_status":1,"_searchwp_excluded":"","footnotes":""},"categories":[75],"tags":[],"class_list":["post-22715","post","type-post","status-publish","format-standard","hentry","category-api-response"],"acf":[],"featured_image_src":null,"author_info":{"display_name":"tamara radijevac","author_link":"https:\/\/clockify.me\/help\/author\/tamara-radijevac"},"_links":{"self":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/22715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/comments?post=22715"}],"version-history":[{"count":10,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/22715\/revisions"}],"predecessor-version":[{"id":23055,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/22715\/revisions\/23055"}],"wp:attachment":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/media?parent=22715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/categories?post=22715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/tags?post=22715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}