API

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

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

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?

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”  

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.

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!

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!

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?

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,                    

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

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!

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!

Is it possible to crate a card with more than one label? The bellow request works only for the first tag “309139499”  mutation {  createCard(input:{    pipe_id: 303361474    phase_id: 320602338    title: "title of card" label_ids: 309139499label_ids: 309139539  }){

I'm trying to use the api to fetch all cards from a specific pipe and read through a few of start_form_fields from each of those cards. But I have not found any way to retrieve start_form_fields...

Hello,Please, could someone tell me if the Pipefy API can extract moved event data from a card and get the current phase?Example:The user moved from Phase 1 to Phase 2;The user moved from  Phase 2 to Phase 3I need to have the life of the card and current phase, entrances and exits of the phases in an accumulative way.Example:The user moved from Phase 2 to Phase 3 at 21:00The user moved from Phase 3 to Phase 2(again); 21:30And so on ...

We have a field on an external system which is a drop-down, for example;UK Counties:AvonCarmarthenshireetcWe want to ensure that the same field on a Pipefy Card has the same drop-down value list whenever the Card enters the Phase which has the County field.Does the Pipefy API allow us to dynamically create the drop-down options for a “dropdown select” field. We can’t work that out from the API documentation, sorry!Thanks

Can someone clarify for sure whether the Field Update Webhook is triggered when a field on the Start Form is updated.We are using Pipefy APIs and are finding that the Field Update Webhook *is* triggered when a field is updated on a Phase Form but does not trigger when a field is updated on a Public Start Form.I’m getting conflicting information on this!Thanks

I've found that answer about retrieving phase field values: Unfortunately, it seems that StatementFields are not included in the in the normal fields list of a card. How can I retrieve the value of a StatementField?

Hey everyone! I’m trying to get all the late cards from a specific pipe. At the moment, i’m using this code here, that gives me all the cards from the pipe and then, on my editor, i filter the late ones:{allCards(pipeId: XXXXXXXX, first: 50)   {pageInfo {    hasNextPage    endCursor  }    edges {      node {        id        late        current_phase{          id}      }    }  }} Is there a way that i can get only the late cards? Like a request that only returns the late cards, an their respectives id and current phase?

Hi, I am trying to get Start Form values of a particular card(by id). I can get basic details of the card by using the following query { "query": "{card(id: 595234678) {title done id updated_at }}"}But it does not fetch the start form details (excluding the reason that i have not mentioned its field which i could not find)Can you please help me with a query which queries the start from details of the card as well please?@genietim I humbly request you to help me with this.

Process - Need to upload the signed document from Docusign to pipefy cardfield. For the above process, I am currently using make.com. The article that I am referring is: https://developers.pipefy.com/docs/how-to-upload-attachments-and-attach-to-a-card-record The URL that is being generated in the first stage is showing error “The request signature we calculated does not match the signature you provided. Check your key and signing method.”  Thanks in advance. Any help would be really appreciated!