Pipefy for Developers

In a scenario where a Card in "Pipe A" is connected to a Card in "Pipe B" (ie Pipe A has the connect field), is there an API query which, for a Card on Pipe B, will give all of the Cards which are connected to that Pipe B Card? Thanks for any help

I’m trying to figure out whether it’s possible to formulate a GraphQL query to retrieve more than 50 itemsHere’s a sample query which is returning a page of 50 items, when in fact I want all cards query MyQuery {  cards(pipe_id: "305537187") {    nodes {      id      current_phase {        name      }      fields {        value        native_value        field {          id          label          internal_id          index_name          index        }      }    }  }}

Hey guys, I’m trying to use the following query to get all cards by paginating my info with the following line of code but I’m getting a Response 400 as a response, if I remove the “after: endCursor” part it works perfect for my first 50 cards - any suggestions? payload = "{\"query\":\"{ allCards(pipeId: 304500848, after: \"WyI4LjAiLCIzMzEuMCIsMTAxMTE3MjI1N10\") { edges { node { id title fields { name report_value updated_at value } } } pageInfo { endCursor } } }\"}" 

Is there any way to change the Move Card Settings using the API?  

How can I set a parent relation to a specific card?

Hi everyone,I’m currently working on a Python script to automate report exports from Pipefy. I’m using the exportPipeReport and pipeReportExport GraphQL queries to export reports, retrieve download URLs, and save the files locally. However, I’ve encountered an issue where the download URLs sometimes work and sometimes don’t. Specifically, when they don’t work, I receive a 404 error. The odd part is that if I take the same URL and try it in a browser, it sometimes works but often fails.Here’s the code I’m currently using:import requestsimport osimport time# Data for the reportsreports = { "MASIVOS VH": {"pipe_id": 303931430, "report_id": 300754311, "name": "ventas_vh_reporte.xlsx"}, "RENOVACIONES": {"pipe_id": 304179178, "report_id": 300757125, "name": "renovacion_es_reporte.xlsx"}, "CANAL INDIRECTO": {"pipe_id": 304130823, "report_id": 300756746, "name": "canal_indirecto_reporte.xlsx"}}# Folder where files will be savedSAVE_FOLDER = r"C:\Users\MateoEcheverría\OneDrive - ChevyS

Hi team,I’m trying to create a script in python with a rather heavy request… I need to get all the history for the cards that are in 2 specific phases and export all that info to an excel file, I’m not exactly proficient in what coding is, but I’ve been trying to code using chatgpt and with trial and error I got to produce the following code:import requestsimport pandas as pdfrom datetime import datetimepipe_id = "MyPipeId"API_TOKEN = "MyAPIToken"HEADERS = { "Authorization": f"Bearer {API_TOKEN}", "Content-Type": "application/json"}# Define the phase IDs for the phases of interestphase_ids = ["This_is_ID_1", "This_is_ID_2"] def fetch_cards_for_phase(phase_id): all_cards = [] has_next_page = True after_cursor = None while has_next_page: # Construct the query with pagination support query = f""" {{ phase(id: "{phase_id}") {{ cards(first: 30, after: "{after_cursor}") {{ edges {{ node {{

We’re having some trouble trying to attach multiple files to a field in Pipefy using the API. The first file uploads just fine, but when we try to add a second one, we get an "Invalid data" error. It seems like the field isn’t set up to handle more than one file, or maybe the format we’re sending is wrong. Also, instead of accepting multiple files, the field ends up replacing the previous one.We are seeking guidance on how to properly configure a field in Pipefy to accept multiple files via API. If the field is supposed to accept multiple attachments, it would be helpful to clarify the correct data format for submission. Additionally, we would like to know if there are any limitations or restrictions on attachment fields in Pipefy that could be causing these errors.

When I retrieve a query from a specific card, it doesn’t return this field: and I can’t seem to find where it is stored and connected to the card.How would I get this value? 

I look for a way to list the connections between a Pipe and a table.It is easy to query for card/record connections but I find no way to have this information  from the pipe/table.For instance, I have this pipe “pipe 1” with a start form with a field “Customer Name” connected to the table “Customer”.query{  pipe(id:304611228){    start_form_fields{      id      type            connectedRepo{        __typename      }    }  }}In this response I know it is a connector field connected with a PublicTable and I look for a way to know the tableName and Table Field name.the response is as follow.{  "data": {    "pipe": {      "start_form_fields": [        {          "id": "customer_name",          "type": "connector",          "connectedRepo": {            "__typename": "PublicTable"          }        }      ]    }  }}

I’m looking for a way to query all the cards and their comments (with created date and authors) of a pipe. If possible, in Python.Is there any way to do it?

DROPDOWN FIELD MUTATION OPTIONS UPDATE Hello! I need to update the options of dropdown field using Graphql, but so far I was not able to create a mutation to do so. Anyone can help?

Hello!About Make.com integration.There are some special fields like CNPJ (BR Tax Number) and Phone Number that are not loaded in Make.com.How can I fill in these fields without changing the field type?

Hello,Could you please assist me understanding why I am getting a 400 Bad Request response when trying to use createCard using graphql?Ex: $client = new \GuzzleHttp\Client();$response = $client->request('POST', 'https://api.pipefy.com/graphql', [ 'body' => '{"query":"mutation { createCard( input: { pipe_id: '.$pipe_id.', phase_id: '.$phase_id.', title: "LOREM IPSUM", fields_attributes: [ { field_id: "title", field_value: "LOREM IPSUM1" }, { field_id: "email", field_value: "my-email@email.com" } ] }) { clientMutationId card { id title } } } ', 'headers' => $headers,]);Thanks!

Hey everyone,I'm currently working on a project using Pipefy and I need some guidance on how to retrieve conditional information associated with a field using the Pipefy API. Specifically, I'm looking to understand how to:Retrieve conditional rules or expressions set for a particular field. Determine if a field has any conditions attached to it programmatically. Access details such as when these conditions trigger or how they affect field behavior.I've explored the Pipefy API documentation but couldn’t find a direct method to query this information. If anyone has experience or insights into how this can be achieved, I would greatly appreciate your advice or pointers.Thank you in advance for your help!

Like every business, we need to be able to track conversions from our Website.For instance, we have a Pipefy Customer Enquiry Form embedded on a page on our Google Sites website and we want to track these conversions.We have extensive experience building integrations using make.com and have built extensive integrations between Pipefy and our systems using make.com and the Pipefy APIs.However, we haven’t built any integrations involving Analytics and Pipefy.Has anyone achieved this?Just need help understanding how to put this integration together, principles and concepts.Thanks for any help.

I’m creating a CRM Pipe and it is so important to have the lead source. I was thinking to get the information from URL parameters, since all my campaigns URL has parameters.Anyone know how to solve this problem? The HTTP automation can help with that?

I want to know how can I create a sequencial Card ID using the http request, for exameple when I create a card start with 1, the next card start with ID 2 and so go on.

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!

 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

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? 

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