Skip to main content

API

Pipefy API

  • 179 Topics
  • 576 Replies
179 Topics
Gabriel Candido
Gabriel CandidoExplorer
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? )

6472
Lucas Democh
daniel-rodrigues-toolzz
daniel-rodrigues-toolzzInspiring
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” ?

1623
marcosmelo
Christian Nunes
Christian NunesExplorer
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                }            }        }    }

2225
Lais Laudari
P
pferrariogExplorer
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?

972
Lais Laudari
antonio-nykael
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.

1874
Lais Laudari
marcosmelo
marcosmeloLegend
asked in API
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?

1265
marcosmelo
Lais Laudari
Lais Laudari
published in API
How to get the sent and received emails of a card via 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    }  }}

652
Ezequiel Souza
Lais Laudari
Lais Laudari
published in API
How do I update the record status field via 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    }  }}

2890
Lais Laudari
caio-osilva
caio-osilvaExplorer
asked in API
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"          }  

5639
Ingrid Hille
Pipefy Staff
alejandroparra
alejandroparraNew Member
asked in API
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”  

1952
alejandroparra
felipe-leite-matrixenergia
felipe-leite-matrixenergiaExplorer
asked in API
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':

2341
lucas-lacerda-pipefy
Pipefy Staff
renan-araujo-creditas
renan-araujo-creditasExplorer
asked in API
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?

1457
marcosmelo
caio-pagliarani
caio-pagliaraniNew Member
asked in API
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.

2861
lucas-lacerda-pipefy
Pipefy Staff
yeiser-mirabal
yeiser-mirabalExplorer
asked in API
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!

2904
genietim
yeiser-mirabal
yeiser-mirabalExplorer
asked in API
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!

2354
yeiser-mirabal
juliana-opis
juliana-opisNew Member
asked in API
Contagem de chamadas API

  Bom dia! Criei um código que faz chamadas na API do pipefy e busca todos os cards de um determinado pipe.No total eu tenho um pouco mais de 1000 cards nesse pipe, pela lógica, sendo 50 registros por página, seriam aproximadamente 20 chamadas na API. Acredito que as chamadas não estão sendo contabilizadas corretamente, já que no último mês nosso consumo passou de 100k. No dia 01/09 o consumo estava em 2k, sendo que não havia feito nenhuma chamada. Existe alguma maneira de contabilizar as chamadas por aqui? Quero saber porque esse consumo está tão alto.Segue trecho do código que faz as chamadas: def get_all_cards(pipe_id, page_size): all_cards = [] after = None has_next_page = True while has_next_page: query = ''' query GetCards($pipeId: ID!, $pageSize: Int!, $after: String) { cards(pipe_id: $pipeId, first: $pageSize, after: $after) { edges { node { id fields { date_value date

2841
Lais Laudari
ramongb
ramongbInspiring
asked in API
GraphQL: How to clear a connection field value

Hi there! Im trying to get a card and clear the value of a field using GraphQL. The field is not string or number, it is a pipe connector. I’m not trying to delete the relation field, just clearing it out. I’m trying the following:mutation { updateFieldsValues(input: {nodeId: "{cardId}", values: {fieldId: "{name}", value: [] }}) { clientMutationId } } I have tryed usin “” or [“”] in the value but I got always an error sayin is an invalid input.Have anyone did this before?

2855
Ezequiel Souza
Daniel Angelini Serviços
Daniel Angelini ServiçosExplorer
asked in API
Criação de card via api com conexão de database

Olá.Estou tentando criar um card em um pipe, via API, sendo que o form inicial só tem um campo que é uma conexão com um database. A idéia é criar um card para cada linha do database, conforme uma determinada condição.No postman estou usando a seguinte mutation query:mutation {  createCard(input: {    pipe_id: 303443432,    title: "teste api",    fields_attributes:      {field_id: "estagi_rio", field_value: {          table_records:{              edges:{                  node:{                      id: "746422898",                        title: "Julia Cazarim"                        }                  }              }          }      },    }  ) {    card {      title    }  }} O payload que retorna é: "data": {        "createCard": null    },    "errors": [        {            "message": "Invalid input: estagi_rio ([{\"table_records\"=>{\"edges\"=>{\"node\"=>{\"id\"=>\"746422898\", \"title\"=>\"Julia Cazarim\"}}}}])",            "locations": [                {             

2981
Daniel Angelini Serviços
Daniel Angelini Serviços
Daniel Angelini ServiçosExplorer
asked in API
Delete multiple cards by GraphQL mutation

Hey there, anyone knows how to delete multiple cards, by their Id, with graphQL mutation? I tried this:mutation {  deleteCard(input: {id: [751517290,751517292,751517294,751517296,751517297,751517299,751517300,751517305,751517318,751517343,751517344,751517345,751517346,751517347,751517348,751517349,751517352,751517353,751517355,751517356,751517358,751517360,751517361,751517363,751517364,751517366,751517367,751517368]}) {    success  }}and received this:{    "errors": [        {            "message": "Argument 'id' on InputObject 'DeleteCardInput' has an invalid value ([751517290, 751517292, 751517294, 751517296, 751517297, 751517299, 751517300, 751517305, 751517318, 751517343, 751517344, 751517345, 751517346, 751517347, 751517348, 751517349, 751517352, 751517353, 751517355, 751517356, 751517358, 751517360, 751517361, 751517363, 751517364, 751517366, 751517367, 751517368]). Expected type 'ID!'.",            "locations": [                {                    "line": 3,                    

2221
genietim
P
pferrariogExplorer
asked in API
Error while creating card via API

I’m trying to create a card via API in a pipe that has many required fields in the form. I already tried a lot of things, mapped all the ids and the formats i should build the payload. Even with the connector’s fields, that i’m using the record id to send the value that i want. But, i still get an error and i can’t figure out what it says to me or what should i change. My query looks like:mutation MyQuery {  createCard(    input: {pipe_id: "12345678", fields_attributes: [                 {field_id: “xxxxx”, field_value: “yyyy”},                  {field_id: “xxxxx”, field_value: “yyyy”}              ]           }        )   {    clientMutationId  }}  And the error: {  "data": {    "createCard": null  },  "errors": [    {      "message": "Something went wrong",      "locations": [        {          "line": 2,          "column": 3        }      ],      "path": [        "createCard"      ]    }  ]}  Pls, i need help on this

2722
P
Paulo Rodrigues
Paulo RodriguesExplorer
asked in API
Is the docs about api usage limits updated?

Hi, or I’m missing something or the docs about api usage limits are outdated, let me explain.I’m on the starter (free) plan while evaluating the usage of Pipefy for my business and the integration (api) part of this is crucial for us.On the free tier I already did much more than 20 api call in a month as mention on this doc as a limit.https://help.pipefy.com/en/articles/5580799-how-to-use-pipefy-s-api#h_a506831afcIs this right?As on the below link there is no way to check programmatically how is my monthly usage (this is bad, very bad)Any Pipefy master could clarify this for me?Thank you!

2171
Leonardo Lucena
Pipefy Staff
Juliana Spinardi
Pipefy Staff
Juliana SpinardiPipefy Staff
published in API
New GraphQL update: Retrieve Card attachments
New GraphQL update: Retrieve Card attachments

We added support to retrieve card attachments -- we will return both attachments attached through the card and by the fields of type attachment. We added a new type called Attachment and we also added the attachments attribute inside the Card type.Sample query: Changelogadded: Attachment type added: attachments  attribute inside the Card type

6326
genietim
Paulo Rodrigues
Paulo RodriguesExplorer
asked in API
Send e-mail as reply using API

Hello!Can I send an email via API as a reply to the previously received e-mail?For example, I´d receive and email from client@exemple.com with the subject "Need your help" and tried to reply using the api as follow: mutation { createInboxEmail( input: { repo_id: [pipe_id] card_id: [card_id] subject: "Re: Need your help", from: "pipe[pipe_id]+[card_id]@mail.pipefy.com" to: "[address I'd received the email from]", html: "<b>just a reply test</b>", } ) { inbox_email { id, state } }} But at least on my Gmail I receive the answer in a new thread not as a reply on the previous one.Any idea? Thanks!

2723
genietim
vitor221
vitor221Inspiring
asked in API
Criar card conectado via API

Atualmente no pipefy possuimos a possibilidade de criar um card conectado por meio de um campo de conexão com outro pipe e via automação, minha dúvida é: seria possível criar um card conectado (card filho) via API?

2871
Lais Laudari
sistemas-orbita
sistemas-orbitaExplorer
asked in API
Limitação da api

Estou com uma dúvida, é possível fazer paginação ao puxar os pipes pela api ?

2371
Leandro Almeida
Pipefy Staff

Community Experts Leaderboard

Terms & ConditionsCookie settings