Skip to main content

- - Knowledge base
Products Updates
Ideas
Events

[NOVO] Curso Pipefy AI

3 months ago

Home
Community overview
Pipefy Developers
API

API

Pipefy API

164 Topics
555 Replies

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

164 Topics

altairrosaNew Member

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!

Lucas DemochPipefy Legend

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

alvin-thamNew Member

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?

raimundo.santosNew Member

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

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

allefy-costaNew Member

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?

joao-baitatecNew Member

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?

daniel-rodrigues-toolzzNew Member

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?

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

antonio-nykaelBrainy

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.

Gabriel CandidoNew Participant

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

daniel-rodrigues-toolzzNew Member

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

Christian NunesRegular Participant

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

pferrariogNew Member

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?

antonio-nykaelBrainy

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.

marcosmeloPipefy Legend

Erro API Pipefy x Make

Olá, pessoalEstou tentando conectar o make ao pipefy, mas recebo essa mensagem de erro no Make ao inserir a API KEYwrite EPROTO 139810707130304:error:14094410:SSL routines:ssl3_read_bytes:sslv3 alert handshake failure:../deps/openssl/openssl/ssl/record/rec_layer_s3.c:1565:SSL alert number 40Alguem ja passou por esse erro?

published in API

How to get the sent and received emails of a card via APIF.A.Q.

To get all the emails sent and received from a card, just run the following query:query{ card(id: XXXXX) { title comments { id author_name created_at text } inbox_emails { from fromName subject to cc bcc body sent_via_automation state } }}

published in API

How do I update the record status field via API?F.A.Q.

To update the status of a record via API, just follow the steps below.👉🏼First you need to know the Status ID. The following query will give you this information:{ table(id: "XXXXXXXXXX") { statuses { name id } }} 👉🏼Next, you will use the Status ID obtained to update the field of a record by executing the following mutation:mutation { updateTableRecord(input: {statusId: XXXXX, id: XXXXXXXX}) { table_record { title status { name } } }}⚠To find out the record's ID, simply access the database and when you open the record identify the final number that appears in the browser's address bar. Or via API by running the query below:{ table_records(table_id: "XXXXXXXXX") { edges { cursor node { id title } } pageInfo { endCursor hasNextPage hasPreviousPage startCursor } }}

caio-osilvaNew Member

Consultar registros externos do card

Boa tarde pessoal!Estou com a necessidade de consultar os dados de um card que são originados de uma tabela, onde na criação do card os dados dessa tabela são vinculados.No caso é o cadastro de contatos em que eu preciso pegar o email dessa contato, para ajudar no entendimento tenho o print de como é o card abaixo, onde eu preciso pegar o email campo pessoa no canal, mas se eu consulto o card via GraphQL só tenho o retorno: "field": { "help": "", "description": "", "id": "pessoa_no_canal", "index_name": "field_3_connector", "label": "Pessoa no canal", "type": "connector" }

alejandroparraNew Member

updateCardField dont work

Hi, im trying tu create a card relation mutation {createCardRelation(input: {parentId : 8050[my card parent id],childId : 6552[mi card child id],sourceType : "PipeRelation",sourceId : "some[i donr not what put here!]"}) {clientMutationId}}If i setup the sourceId as my organization id then i get “"Validation failed: Source Source PipeRelation is not connected to repo”

felipe-leite-matrixenergiaRegular Participant

Eu consigo atualizar mais de um campo em só uma requisição GrathQL?

Atualmente estou utilizando a seguinte estrutura para atualizar um card, porem como são muitas requisições em tão pouco tempo estou tendo problemas com o tempo de resposta da api, existiria algum modo de juntar todas elas? payloads = [ {'field_id': 'tipo_de_pessoa', 'value': info_cliente['Tipo Pessoa']}, {'field_id': 'cpf', 'value': info_cliente['CPF Representante']}, {'field_id': 'cnpj', 'value': info_cliente['CNPJ']}, {'field_id': 'nome_da_empresa', 'value': info_cliente['Nome']}, {'field_id': 'nome_do_contato', 'value': info_cliente['Nome']}, {'field_id': '1_n_telefone_do_contato', 'value': info_cliente['Telefone']}, {'field_id': 'e_mail_do_contato', 'value': info_cliente['Email']}, {'field_id': 'valor_da_fatura_r', 'value': info_cliente['Valor Conta']}, {'field_id': 'm_dia_de_consumo_kwh', 'value': info_cliente['Consumo Medio']}, {'field_id': 'soma_do_consumo_kwh', 'value':

renan-araujo-creditasRegular Participant

Como criar uma Query para retornar os dados "FirstTime Enter" e "LastTime Exit" de um card em uma fase

Gostaria de construir uma API que retornasse para mim o "LastTime Exit” e o "FirtTime Enter” de um card em uma fase ID XAlguém tem a ideia de uma query?

caio-pagliaraniNew Participant

Update title of a card

I’m trying to update a title of a card without changing the field linked to that. for example. in this pipe, the title field is the “ applicant's name “. but later in the process, we want to change the title to the applicant’s company name, instead of the applicant's name , and i cannot simply delete the applicant's name and put the company name that i want, because i would lose that information The mutation that i am using is:“mutation{ updateFieldsValues(input: { clientMutationId: "test" nodeId:"card id", values:[{ fieldId: "title" value: "New title" }] }) { clientMutationId }}”the return is:“{ "data": { "updateFieldsValues": { "clientMutationId": "teste" } }}”But the card remain with the origin title, without chance.

yeiser-mirabalRegular Participant

Querying Cards from the Last Year Sorted by Update Date via API

Hey there!, I am reaching out to inquire about fetching data using the Pipefy API. Specifically, I'd like to retrieve all cards from the last year and have them sorted by their update date.Is there a specific GraphQL query that would allow me to accomplish this? I'm looking for a way to obtain this dataset for analysis and reporting purposes.Any guidance or example queries you could provide would be greatly appreciated!

yeiser-mirabalRegular Participant

Tracking Assignee History for Each Phase in a Process

Hello Pipefy Community,In my workflow, it's essential that every phase has an assigned user. I'm looking to retrieve the history of assignees for each phase a card has passed through.I've tried using the following GraphQL query:{ cards(pipe_id: "CARD_ID") { nodes { phases_history { phase { name cards { nodes { assignees { email } } } } } } }} However, this only gives me the history of phases without the respective assignees. How can I modify this query or use another approach to retrieve the assignee history for each phase?Thank you for your assistance!

1
2
3
4
5
6
7

Page 3 / 7

Community Experts Leaderboard

Powered by Gainsight

Terms & Conditions Cookie settings

Sign Up Now!

Already have an account? Login

Login with your Pipefy credentials

or

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

Login with your Pipefy credentials

or

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.

OK

This file cannot be downloaded

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

OK

Eficiência impulsionada pela IA

Company

Careers

Success stories

Ethics and Compliance

Products

HR Service Delivery

Custom Workflows

Platform

Pricing

Business Solutions

Process Management

Service Management

ITSM

Help & Support

Pipefy Community

Resources

Blog

Guides and E-books

Events and Webinars

Process Improvement 101