{"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\/pt\/troubleshooting\/how-to-make-a-list-of-projects-with-assigned-people-via-api","title":{"rendered":"Como criar uma lista de projetos com pessoas atribu\u00eddas via API?"},"content":{"rendered":"<p>Se voc\u00ea quiser criar uma lista de projetos com as pessoas atribu\u00eddas a eles, fa\u00e7a o seguinte:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Ferramentas<\/strong>:<br>\n<ul class=\"wp-block-list\">\n<li>Voc\u00ea precisar\u00e1 do Postman (ou outra ferramenta de API) para fazer chamadas de API.<\/li>\n\n\n\n<li class=\"translation-block\">Converta as respostas JSON para o formato CSV para facilitar o processamento no Excel (por exemplo, use o <a href=\"https:\/\/konklone.io\/json\/\">konklone<\/a>, ou alguma outra ferramenta de convers\u00e3o).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Chamadas de API<\/strong>:<br>\n<ul class=\"wp-block-list\">\n<li>Use os dois endpoints a seguir:\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\">Esteja atento ao <strong>tamanho<\/strong> da p\u00e1gina e ao <strong>n\u00famero<\/strong> da p\u00e1gina ao buscar dados do projeto para garantir que voc\u00ea recupere todos os projetos<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Converta os dados para CSV<\/strong>:<br>\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">No <strong>Postman<\/strong> exporte as respostas para 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 os dados no Excel<\/strong>:<br>\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">Use o <strong>konklone.io <\/strong>para converter cada resposta JSON em um arquivo CSV<\/li>\n\n\n\n<li class=\"translation-block\">Use a <strong>formata\u00e7\u00e3o condicional do Excel<\/strong> para fazer a correspond\u00eancia dos IDs de usu\u00e1rio no CSV do projeto com os nomes de usu\u00e1rio (ou e-mails) correspondentes no CSV do usu\u00e1rio.<\/li>\n\n\n\n<li>Pode ser necess\u00e1rio ajustar o tamanho das c\u00e9lulas para visualizar todos os dados ou separar os IDs dos usu\u00e1rios em v\u00e1rias c\u00e9lulas.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"translation-block\">Como resultado, voc\u00ea ter\u00e1 um arquivo CSV listando os <strong>projetos<\/strong> em uma coluna e os <\/strong>nomes de usu\u00e1rios <\/strong>atribu\u00eddos em outra.<\/p>","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\/pt\/author\/tamara-radijevac"},"_links":{"self":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts\/22715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/comments?post=22715"}],"version-history":[{"count":10,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts\/22715\/revisions"}],"predecessor-version":[{"id":23055,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/posts\/22715\/revisions\/23055"}],"wp:attachment":[{"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/media?parent=22715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/categories?post=22715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clockify.me\/help\/pt\/wp-json\/wp\/v2\/tags?post=22715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}