- - Knowledge base
Products Updates
Ideas
Events

[NOVO] Curso Pipefy AI

14 days ago

Home
Community overview
Pipefy Developers
API

API

Pipefy API

155 Topics
534 Replies

When you subscribe we will email you when there is a new topic in this category

155 Topics

Recently active

Most replies Most views Newest first

produtos7New Member

asked in API

Query para vincular card

Bom dia, gostaria de saber qual a query correta a se usar, para o seguinte cenarioQuando um card é criado no pipe A, eu tenho uma automaçao que cria um Card no Pipe B, com isso tenho os ID do card no PIPE A e no PIPE B, ai eu quero saber qual a query que se usa para vincular o card do PIPE B, no PIPE A, detalhe q eu quero q esse card fique sendo exebido ali no pipefy perto das labels, irei deixar um print do local esse print é do PIPE A. ai eu quero fazer com que o card q foi criado no PIPE B, seja exibido aqui, eu queria fazer isso sem ter q criar um novo campo de conexao no pipe A, pq acredito q esse campo ja seria de conexao

4 months ago

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.

6 months ago

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.

6 months ago

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!

7 months ago

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!

7 months ago

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

7 months ago

Lais Laudari

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

2586

7 months ago

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?

7 months ago

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

8 months ago

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

1032

8 months ago

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?

8 months ago

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?

8 months ago

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?

8 months ago

Lais Laudari

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.

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

9 months ago

Lais Laudari

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

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"

4096

10 months ago

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.

10 months ago

Gabriel CandidoNew Participant

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? )

10 months ago

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” ?

10 months ago

Lais Laudari

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,

2232

10 months ago

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 } } } }

10 months ago

pferrariogNew Member

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?

10 months ago

antonio-nykaelBrainy

asked in API

Limite em uma query com filtro

Olá, Estou fazendo uma automação e eu preciso, que me retorne todos os cards de um pipe, que foram atualizados nos últimos X tempo.Eu achei uma query que me atende muito bem:query allCardUpdatedYesterday { allCards(first: 20, pipeId: 123,filter: { field: "updated_at", operator: gt, value: "2018-08-01T23:50:11-03:00"}) { edges { node { id title } } } }Porém, descobri que ela tem um limite. Ela retorna um máximo de 50 resultados. Mas se nesse meio tempo, entre uma execução e outra, se mais que 50 cards furam atualizados, alguns serão perdidos no processo. Eu sei que o módulo LIST CARDS, não tem esse limite. Pelo menos, ja fiz com mais de 2000 resultados. Há alguma forma de remover esse limite? Agradeço quem souber. Obrigado.

11 months ago

Lais Laudari

published in API

How to get pipe and cards attachments via APIF.A.Q.

You can download the attached files in a pipe!😃 To get the links to the card attachments from a pipe via API, these are the queries you will need: ◾Attachments to cards on the pipe{ cards(pipe_id:XXX){ pageInfo{ hasNextPage endCursor } edges{ node{ id title attachments{ url } } } }}◾Card attachments{ card(id:XXXX) { attachments { createdAt path url } }}

3321

11 months ago

Page 2 / 7

Community Experts Leaderboard

Terms & Conditions Cookie settings

Sign Up Now!

Already have an account? Login

Username *

Company's email *

Phone Number

Department *

Are you already a Pipefy user?

(Private)

Only you and moderators can see this information

Yes Not yet

Job Title *

Company *

Company Size *

Country *

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Join us in the Pipefy Community! 🚀

No account yet? Create an account

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.