{"id":9494,"date":"2024-10-09T08:51:32","date_gmt":"2024-10-09T11:51:32","guid":{"rendered":"https:\/\/iclips.com.br\/help\/?p=9494"},"modified":"2026-03-18T11:02:55","modified_gmt":"2026-03-18T14:02:55","slug":"api-como-realizar-a-conexao","status":"publish","type":"post","link":"https:\/\/iclips.com.br\/help\/api-como-realizar-a-conexao\/","title":{"rendered":"[API] Como realizar a conex\u00e3o entre iClips e Power BI"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Aqui, voc\u00ea vai saber mais sobre:<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/iclips.com.br\/help\/api-como-realizar-a-conexao\/#Video_tutorial\" >V\u00eddeo tutorial<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/iclips.com.br\/help\/api-como-realizar-a-conexao\/#Material_de_apoio_em_PDF\" >Material de apoio em PDF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/iclips.com.br\/help\/api-como-realizar-a-conexao\/#Qual_o_significado_de_cada_coluna_na_planilha\" >Qual o significado de cada coluna na planilha?<\/a><\/li><\/ul><\/nav><\/div>\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Video_tutorial\"><\/span>V\u00eddeo tutorial<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>O v\u00eddeo abaixo mostra como realizar a integra\u00e7\u00e3o da API de projetos de iClips com o Power BI:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe loading=\"lazy\" title=\"Integrando API iClips e Power BI\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/0noFlHsJCLE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<\/div><\/figure>\n\n\n\n<div style=\"height:47px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Material_de_apoio_em_PDF\"><\/span>Material de apoio em PDF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Recomendamos tamb\u00e9m consultar nosso material de apoio em PDF com as instru\u00e7\u00f5es de integra\u00e7\u00e3o tanto com o Power BI quanto com o Excel:<\/p>\n\n\n\n<div data-wp-interactive=\"core\/file\" class=\"wp-block-file\"><object data-wp-bind--hidden=\"!state.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/10\/PT-Content-Data-API-no-PowerBI_Excel.pptx.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Incorporado de PT - Content Data API no PowerBI_Excel.pptx.\"><\/object><a id=\"wp-block-file--media-0b99c870-79c1-48ee-b974-d8abfcbd15ce\" href=\"https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/10\/PT-Content-Data-API-no-PowerBI_Excel.pptx.pdf\">PT &#8211; Content Data API no PowerBI_Excel.pptx<\/a><a href=\"https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/10\/PT-Content-Data-API-no-PowerBI_Excel.pptx.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-0b99c870-79c1-48ee-b974-d8abfcbd15ce\">Baixar<\/a><\/div>\n\n\n\n<div style=\"height:41px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Qual_o_significado_de_cada_coluna_na_planilha\"><\/span>Qual o significado de cada coluna na planilha?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Ao importar os dados da API de Projetos iClips cada coluna tem um nome. Para facilitar a interpreta\u00e7\u00e3o dos dados, vamos colocar os nomes abaixo e seus significados:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>data.jobId<\/strong>&nbsp;\u2013 Identifica\u00e7\u00e3o\/N\u00famero do projeto<\/li>\n\n\n\n<li><strong>data.projectName<\/strong>&nbsp;\u2013 Nome do projeto<\/li>\n\n\n\n<li><strong>data.pieceId<\/strong>&nbsp;\u2013 Identifica\u00e7\u00e3o da pe\u00e7a<\/li>\n\n\n\n<li><strong>data.pieceName<\/strong>&nbsp;\u2013 Nome da atividade<\/li>\n\n\n\n<li><strong>data.taskPiece<\/strong>&nbsp;\u2013 T\u00edtulo da atividade<\/li>\n\n\n\n<li><strong>data.clientName<\/strong>&nbsp;\u2013 Nome do cliente<\/li>\n\n\n\n<li><strong>data.clientCnpj<\/strong>&nbsp;\u2013 CNPJ do cliente<\/li>\n\n\n\n<li><strong>data.clientId<\/strong>&nbsp;\u2013 Identifica\u00e7\u00e3o do cliente<\/li>\n\n\n\n<li><strong>data.responsible<\/strong>&nbsp;\u2013 Atendimento do projeto<\/li>\n\n\n\n<li><strong>data.responsibleCpf<\/strong>&nbsp;\u2013 CPF do atendimento<\/li>\n\n\n\n<li><strong>data.responsibleId<\/strong>&nbsp;\u2013 Identifica\u00e7\u00e3o do atendimento<\/li>\n\n\n\n<li><strong>data.assistant<\/strong>&nbsp;\u2013 Auxiliar do projeto<\/li>\n\n\n\n<li><strong>data.assistantCpf<\/strong>&nbsp;\u2013 CPF do auxiliar<\/li>\n\n\n\n<li><strong>data.assistantId<\/strong>&nbsp;\u2013 Identifica\u00e7\u00e3o do auxiliar<\/li>\n\n\n\n<li><strong>data.jobPecaId<\/strong>&nbsp;\u2013 Identifica\u00e7\u00e3o da pe\u00e7a dentro do projeto<\/li>\n\n\n\n<li><strong>data.clientGroupName<\/strong>&nbsp;\u2013 Esse cliente faz parte de um grupo de clientes? Se sim, qual?<\/li>\n\n\n\n<li><strong>data.projectApprovalDate<\/strong>&nbsp;\u2013 Data de Apresenta\u00e7\u00e3o ao cliente<\/li>\n\n\n\n<li><strong>data.workflowId<\/strong>&nbsp;\u2013 Identifica\u00e7\u00e3o do modelo de workflow<\/li>\n\n\n\n<li><strong>data.projectConclusionEstimateDate<\/strong>&nbsp;\u2013 Data de Conclus\u00e3o prevista<\/li>\n\n\n\n<li><strong>data.projectEntryDate<\/strong>&nbsp;\u2013 Data de abertura do projeto<\/li>\n\n\n\n<li><strong>data.projectStatusChangeDate<\/strong>&nbsp;\u2013 Data de mudan\u00e7a de status do projeto<\/li>\n\n\n\n<li><strong>data.workflow<\/strong>&nbsp;\u2013 Nome da etapa do workflow<\/li>\n\n\n\n<li><strong>data.plannedInitialDate<\/strong>&nbsp;\u2013 Data de in\u00edcio (se for tarefa)<\/li>\n\n\n\n<li><strong>data.plannedEndDate<\/strong>&nbsp;\u2013 Data fim (se for tarefa)<\/li>\n\n\n\n<li><strong>data.playStartDate<\/strong>&nbsp;\u2013 Data em que o usu\u00e1rio deu play na atividade<\/li>\n\n\n\n<li><strong>data.playEndDate<\/strong>&nbsp;\u2013 Data em que o usu\u00e1rio concluiu a atividade<\/li>\n\n\n\n<li><strong>data.slaTime<\/strong>&nbsp;\u2013 Tempo gasto na atividade<\/li>\n\n\n\n<li><strong>data.estimatedTime<\/strong>&nbsp;\u2013 Tempo estimado<\/li>\n\n\n\n<li><strong>data.executionResponsible<\/strong>&nbsp;\u2013 Respons\u00e1vel pela atividade<\/li>\n\n\n\n<li><strong>data.executionResponsibleCpf<\/strong>&nbsp;\u2013 CPF do respons\u00e1vel<\/li>\n\n\n\n<li><strong>data.executionResponsibleId<\/strong>&nbsp;\u2013 Identifica\u00e7\u00e3o do respons\u00e1vel<\/li>\n\n\n\n<li><strong>data.status<\/strong>&nbsp;\u2013 Status do projeto<\/li>\n\n\n\n<li><strong>data.statusPiece<\/strong>&nbsp;\u2013 Status da etapa do workflow<\/li>\n\n\n\n<li><strong>data.taskPiece<\/strong>&nbsp;\u2013 T\u00edtulo da atividade<\/li>\n\n\n\n<li><strong>data.projectFinishedDate<\/strong>&nbsp;\u2013 Data em que o projeto foi finalizado<\/li>\n\n\n\n<li><strong>data.employeeHourlyCost<\/strong>&nbsp;\u2013 Valor\/hora do colaborador<\/li>\n\n\n\n<li><strong>data.DataInicioPecaWorkflow<\/strong>&nbsp;\u2013 Data in\u00edcio da etapa do workflow<\/li>\n\n\n\n<li><strong>data.DataFimPecaWorkflow<\/strong>&nbsp;\u2013 Data fim da etapa do workflow<\/li>\n\n\n\n<li><strong>data.JobPecaStatus<\/strong>&nbsp;\u2013 Status da pe\u00e7a ou etapa atual do workflow em que ela est\u00e1<\/li>\n\n\n\n<li><strong>data.NomeDepartamento<\/strong>&nbsp;\u2013 Departamento do respons\u00e1vel<\/li>\n\n\n\n<li><strong>data.Refacao<\/strong>&nbsp;\u2013 Data em que houve pedido de refa\u00e7\u00e3o<\/li>\n\n\n\n<li><strong>meta.limit<\/strong>&nbsp;\u2013 N\u00famero m\u00e1ximo de linhas que foi definido na URL de pesquisa<\/li>\n\n\n\n<li><strong>meta.page<\/strong>&nbsp;\u2013 N\u00famero da p\u00e1gina consultada<\/li>\n<\/ol>\n\n\n\n<p>Lembrando que todos os itens em iClips possuem um n\u00famero de identifica\u00e7\u00e3o, mesmo que \u00e0s vezes n\u00e3o o vejamos de forma t\u00e3o clara como o n\u00famero do projeto, por exemplo.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V\u00eddeo tutorial O v\u00eddeo abaixo mostra como realizar a integra\u00e7\u00e3o da API de projetos de iClips com o Power BI: Material de apoio em PDF Recomendamos tamb\u00e9m consultar nosso material de apoio em PDF com as instru\u00e7\u00f5es de integra\u00e7\u00e3o tanto com o Power BI quanto com o Excel: Qual o significado de cada coluna na [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[35],"tags":[],"class_list":["post-9494","post","type-post","status-publish","format-standard","hentry","category-api-de-projetos"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Lais Mesquita","author_link":"https:\/\/iclips.com.br\/help\/author\/lais-mesquita\/"},"uagb_comment_info":0,"uagb_excerpt":"V\u00eddeo tutorial O v\u00eddeo abaixo mostra como realizar a integra\u00e7\u00e3o da API de projetos de iClips com o Power BI: Material de apoio em PDF Recomendamos tamb\u00e9m consultar nosso material de apoio em PDF com as instru\u00e7\u00f5es de integra\u00e7\u00e3o tanto com o Power BI quanto com o Excel: Qual o significado de cada coluna na&hellip;","_links":{"self":[{"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/posts\/9494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/comments?post=9494"}],"version-history":[{"count":6,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/posts\/9494\/revisions"}],"predecessor-version":[{"id":11599,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/posts\/9494\/revisions\/11599"}],"wp:attachment":[{"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/media?parent=9494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/categories?post=9494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/tags?post=9494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}