API

Pipefy API

  • 133 Topics
  • 461 Replies

133 Topics

antonio-nykael
antonio-nykaelBrainy
asked in API

Como fazer upload de arquivo para um card via API (make)?

Olá,Como fazer, via integração (make), pra criar um card e anexar arquivos nesse card? Estou tentando várias formas, mas ainda sem sucesso. 

14
antonio-nykael
16 days ago
joao-castagnoli
joao-castagnoliNew Member
asked in API

Exclusão de usuários remove os dados

Notei que quando um usuário é excluído todos os registros que temos em nome dele são perdidos. Quando faço um relatório no pipefy o campo fica como desconhecido e perdemos o histórico de quem realizou tais tarefas, especialmente quando puxamos os dados para um banco de dados externo.

4
marcosmelo
22 days ago
beatriz-koller
beatriz-kollerNew Member
asked in API

Como puxar TODOS os dados de um card

Estou precisando de TODOS os dados de TODOS os cards de um Pipe específico. Não consegui encontrar na documentação um atalho para isso que não selecionando todos os campos no simulador de Query (o que está gerando um código enorme). Existe alguma forma de fazer isso de uma maneira mais simples?

3
Lais Laudari
Community Manager
30 days ago
fonseca
fonsecaNew Member
asked in API

How Can I Get All Cards From Phase

Hi guys! Can you help me?I’m trying to get all cards from a phase in a pipe using GraphQL API. But, I’m can not.Can someone give a example how to get all cards from a phase?I read other topic in the pipefy community about this question, but, it’s not functional the solution suggested to get all cards from a phase.Tks!

4
Lais Laudari
Community Manager
1 month ago
altairrosa
altairrosaNew Member
asked in API

How can I download a file from a pipe thru API or make

Hello!Can somebody help me?I’m using MAKE and need to download a file from a card.Can somebody help me with an GraphQL command os some idea?Thank you!

4
altairrosa
1 month ago
Lucas Democh
Lucas DemochPipefy Legend
asked in API

Number of Columns via API

 Is there any limitation on returning columns via the API?I didn't find anything about it in the API documentation, but when querying a table with many columns (+100), some columns are not appearing in the query.https://api-docs.pipefy.com/reference/queries/table_records/#table_records

5
Lucas Democh
1 month ago
Lais Laudari
Community Manager
Lais LaudariCommunity Manager
published in API

API Reference > PipesF.A.Q.

Do you need help with your API queries and/or mutation?Here are a few that might help you!😉🔎Queries📍LIST PIPES{pipes(ids: [ID1, ID2]) { id name phases {  name  cards (first: x) {    edges {    node {     id     title     }    }   }  } }} 📍SHOW PIPE{ pipe(id: 123456) {  id  name  start_form_fields {   label   id } labels {  name  id} phases {  name  fields {  label  id }  cards(first: X) {   edges {   node {   id   title    }    }   }  } }} 📍SHOW ALL FIELDS FROM PIPE{  pipe(id: XXXXX) {    start_form_fields {      id      internal_id      label      type      options    }    phases {      fields {        label        internal_id        type        options      }    }  }}🛠Mutations📍CREATE PIPEmutation { createPipe( input: { organization_id: XXXX name: "XXXX" labels: [ {name: "Label 01", color: "#FF0042"} ] members: [ {user_id: 00000, role_name: "admin"} {user_id: 00001, role_name: "member"} ] phases: [ {name: "First Step"} {name: "Finished", done: true} ] start_form_fields: [ {typ

1246
Karine Cristina
Pipefy Staff
1 month ago
alvin-tham
alvin-thamNew Member
asked in API

Querying for recent emails sent/received in cards

I am looking to search for all emails recently sent to or from a card.The inbox_emails query can be used to display the details of an email, but doesn’t allow me to search for an email.The closest thing I could find was to use the allCards query and filter by the “updated_at” field, but this pertains to the card itself and receiving an email doesn’t update this field. { allCards( pipeId: 111 filter: {field: "updated_at", operator: gte, value: "2024-02-01T00:00:00Z"} ) { edges { node { inbox_emails { id subject } } } }} Is there a query or field that would allow me to find recently sent or received emails? 

2
alvin-tham
1 month ago
franciele-vicente
franciele-vicenteNew Member
asked in API

Criar card conectado via API

Bom dia!  Atualmente temos a possibilidade de criar um card via API, em qualquer fase do processo, desde que esteja configurado para que crie cards na fase. Para criação de card utilizamos: mutation { createCard(input: { pipe_id: 123, title: "New card", fields_attributes:[ {field_id: "field_1", field_value: "Value 1"}, {field_id: "field_2", field_value: "Value 2"} ]} ) { card { title } } } Quando entro no graphiQL e tento iniciar a mutation para criar card relacionado, encontro “createCardRelation”, mas não sei como continuar para de fato criar o card conectado.  Podem me ajudar, por favor? 

5
marcosmelo
1 month ago
raimundo.santos
raimundo.santosNew Member
asked in API

Listing field conditions actions via API

HI, there!I'm trying to get a complex list of conditions for a pipe via GraphQL, but exploring it in https://developers.pipefy.com/graphql it does not give me  the list of actions (hide or show a field).How can I list these actions via API?The interface does not give a good overview of the implemented logic there…Thank you,Raimundo Santos

2
raimundo.santos
2 months ago
Thais Nascimento
Pipefy Staff
Thais NascimentoProduct Education Team
published in API

How to obtain the ID of a parent card from a linked child card

Hey, everyone! How are you? I have a question for you today: Do you know how to obtain the ID of a parent card from a linked child card? 🤔It's easier than you might think!👉Find the ID of the child card.👉Then, make queries using our API to discover the ID of the parent card. 📚Check out the step-by-step on how to obtain the ID of a parent card from a linked child card

432
marcosmelo
2 months ago
allefy-costa
allefy-costaNew Member
asked in API

Phases - consult cards by phase

I'm learning graphQL and currently I need to query all the cards in a phase, however, I'm having great difficulty, can anyone instruct me with a query?

5
Lais Laudari
Community Manager
2 months ago
joao-baitatec
joao-baitatecNew Member
asked in API

API - Creating a connection between databases on different cards via API

Hi guys, what's up?I have a question about API's.I have a Pipefy that has a form where you can fill in various items from a given database. I've developed an API, along with Pipefy's available APIs, which would be as follows:Whenever a card reaches a certain stage, it will create in another Pipefy 1 new card for each database that was registered in the previous Pipe, but in this case I only put the database information on the new card, and in this case I would like to create a connection and go the entire database item and not just a few fields.Can you help me with this? 

1
Lucas Democh
2 months ago
daniel-rodrigues-toolzz
daniel-rodrigues-toolzzNew Member
asked in API

Get wich member moved the card

Using the Graphql API, is it possible to get the information of who was the person that made the most recent card move?

2
Lais Laudari
Community Manager
3 months ago
loise-franco
Pipefy Staff
loise-francoPipefy Staff
published in API

🔦 New API Reports available!

Hello, Pipefy Community, We have great news: now, you can integrate Pipefy with your reports tool, such as PowerBI or DataStudio, through API! Here’s how: With Reports, you can filter data from your processes in real time, organize them into columns and export them as a spreadsheet to analyze the information you want. If your team needs to export reports frequently and within a certain period of time, you can automate that process! Configure an API Scheduler routine to automate report extraction using a mutation. The report will be exported in the time period you set in your scheduler. To extract the report, two calls are needed, the first is a mutation that will obtain an ID in the response to be used in the extraction, and the second is a query, which will use the response obtained in the first to obtain the download URL of the report. The initial call, as follows, must inform the ID of the Pipe where the report is saved and the ID of the report already formatted with all the columns

121212
Lais Laudari
Community Manager
3 months ago
Lais Laudari
Community Manager
Lais LaudariCommunity Manager
published in API

How to bulk invite pipe members via APIF.A.Q.

First you will need the ID of the pipe you want to add members. Then just run the following mutation: mutation { n1: inviteMembers(input: {pipe_id: pipe ID, emails: { email: "email@email.com", role_name: "permission level"}}){ clientMutationId n2: inviteMembers(input: {pipe_id: pipe ID, emails: { email: "email@email.com", role_name: "permission level"}}){ clientMutationId n3: inviteMembers(input: {pipe_id: pipe ID, emails: { email: "email@email.com", role_name: "permission level"}}){ clientMutationId }} ⚠For the permission level use:- admin for pipe admin;- member for pipe member;- read_and_comment for restricted view;- my_cards_only for read only and- creator for start form only. 

191
marcosmelo
3 months ago
Jay2241
Jay2241
asked in API

API query limit

Hello,I've begun some PHP integrations to extract statistics from Pipefy, using this query: $query = <<<GRAPHQL    {        pipe(id: xxxxxxxxx) {             phases {                name                cards(first: 100) {                     edges {                        node {                            id                            fields {                                name                                value                            }                            assignees {                                name                            }                        }                    }                }            }        }    }    GRAPHQL; The data is being displayed in a vertical menu format, and it's working wonderfully. However, there's one issue: a specific phase only shows a maximum of 30 records. I understand this is due to an API pagination limitation, but I need a workaround. For instance, if we have 100 cards in one phase, how can I retrieve all of them?  How do

6
Jay2241
3 months ago
Lais Laudari
Community Manager
Lais LaudariCommunity Manager
published in API

API PaginationF.A.Q.

API queries to dense databases could potentially return millions, if not billions, of results. Pagination thus helps to limit the number of results. It’s a process used to divide a large dataset into smaller chunks (pages).⚠ Pipefy API endpoint supports pagination with a limit of 50 cards/records per pipe or 30 cards per phase.👉🏼Here are two examples of how to use pagination:🔹Example 1 > query allCards {    allCards(pipeId: xxxx, first: 50) {    pageInfo {      hasNextPage      endCursor    }    edges {      node {        id      }    }  }}You will set the pageInfo attribute and it will return the "endcursor", with the endcursor you can see the other cards within that phase, putting it as an argument in the "after" command. And  hasNextPage will show you if there are more pages. You can then use the ID returned by the endCursor to get to the next page: {allCards(pipeId:XXXXX, first:50, after:"WyIyLjI1IiwiMTg1LjAiLDI2ODc1OTNd"){pageInfo {hasNextPageendCursor}edges {node {id}}}}🔹E

2453
leonardo-mendonca
4 months ago
Lais Laudari
Community Manager
Lais LaudariCommunity Manager
published in API

API Reference > CardsF.A.Q.

Do you need help with your API queries and/or mutation?Here are a few that might help you!😉🔎Queries 📍LIST CARDS{ cards(pipe_id: XXXX, first: 10, search: {title: "XXXXX"}) { edges { node { id title assignees { id } comments { text } comments_count current_phase { name } done due_date fields { name value } labels { name } phases_history { phase { name } firstTimeIn lastTimeOut } url } } }}⚠This query has a limit of 50 cards/records per page, so it is necessary to use pagination, you can find this information here.  📍SHOW CARD{ card(id: XXXX) { title assignees { id } comments { text } comments_count current_phase { name } done due_date fields { name value } labels { name } phases_history { phase { name } firstTimeIn lastTimeOut } url }} 🛠Mutations 📍CREATE CARDmutation{ createCard( input: { pipe_id: XXXX fields_attributes: [ {field_id: "assignee", field_value:[00000, 00001]} {field_id: "checklist_vertical", field_value: ["a", "b"]} {field_id: "checklist_horizontal", field_value: ["b"

2036
genietim
4 months ago
antonio-nykael
antonio-nykaelBrainy
asked in API

Problema de integração entre Pipefy e Make

Olá,Pessoal, estou passando por algumas dificuldades, que começaram a ocorrer a cerda de 2h atrás. Tentei achar uma solução, mas sigo sem sucesso.Recebi vários emails de erro das automações do make.  Tem alguns módulos do pipefy que não estão funcionando, dentro o (Get a Card Info). Mesmo crianco um Cenário novo, colocando somente 1 módulo, e insrindo o ID de um card, ele retorna com esse erro:​​​​​Alguém já passou por isso? Alguma ideia de como resolver?Alguns webhook também estão com erro, como Watch Done Cards.

36
Lais Laudari
Community Manager
4 months ago
Gabriel Candido
Gabriel CandidoNew Member
asked in API

Integrate specific Pipefy reports data into Power BI

Hello,I would like to know if there's a way to integrate specific Pipefy report data into Power BI using M language of Power Query.In the API reference, there are options for Report Query and Export Report. However, the Report Query only returns the report properties (ID, name, field names), and the Export Query generates a URL to download the report ( Would I still need to continue to upload it manually? )

2
Lucas Democh
4 months ago
daniel-rodrigues-toolzz
daniel-rodrigues-toolzzNew Member
asked in API

Listar cards etiquetados com uma label específica

Atualmente é possível listar cards etiquetados com uma label específica?Consigo usar a seguinte request para listar todos os cards cujo campo_X  (exemplo: um campo do tipo short text) possui o valor_Y:query MyQuery { findCards(pipeId: "302926544", search: {fieldId: "campo_X", fieldValue: "valor_Y"}) { edges { node { id } } } } Existe alguma request semelhante que utilize o campo “labels” ?

3
marcosmelo
4 months ago
Lais Laudari
Community Manager
Lais LaudariCommunity Manager
published in API

API Reference > DatabaseF.A.Q.

Do you need help with your API queries and/or mutation?Here are a few that might help you!😉 🔎Queries📍 GET TABLE RECORDS WITH PAGINATION - TABLE ID{  table_records(first: 10, table_id: "XXXXXXX") {    edges {      cursor      node {        id        title        url      }    }    pageInfo {      endCursor      hasNextPage      hasPreviousPage      startCursor    }  }}📍 GET TABLE RECORDS  -  TABLE RECORD ID{  table_record(id: XXX) {    assignees {      id      name    }    created_at    created_by {      id      name    }    due_date    finished_at    id    labels {      id      name    }    parent_relations {      name      source_type    }    record_fields {      array_value      date_value      datetime_value      filled_at      float_value      name      required      updated_at      value    }    summary {      title      value    }    table {      id    }    title    updated_at    url  }}📍 FIND TABLE RECORDS  -  FIELD ID | FIELD VALUE{  findRecords(tableId:"xxxx", first: 50,

1102
Ezequiel Souza
4 months ago
Christian Nunes
Christian NunesRegular Participant
asked in API

Apollo Database Graphql Search

Hello, I’m look for a solution similar to the query findCard bellow, but to get IDs from records in apollo databases. Is there a way to get the ID passing as parameters like fields and fields values?     query GetCardIdByFieldValue($pipeId: ID!, $fieldId: String!, $fieldValue: String!) {        findCards(            pipeId: $pipeId            search: {                fieldId: $fieldId,                fieldValue: $fieldValue            }        ) {            edges {                node {                    id                }            }        }    }

5
Lais Laudari
Community Manager
4 months ago
P
pferrariogRegular Participant
asked in API

What done means in a table record?

I’m trying to clean a database with only active records from a third-party source. I’m concerned about what deleting records could make to old cards in pipes.So, i’m searching a way to set a record as “inactive” and found here TableRecord - Pipefy GraphQL API, an option “done” but i don’t know what this do to the record.Someone can explain, please?

2
Lais Laudari
Community Manager
4 months ago

Community Experts Leaderboard

Terms & ConditionsCookie settings