API

I don’t think it’s possible to directly get a pipe report via API, since I haven’t find anything related in the docs. Anyway, I’d be happy if I’m wrong on that.However, I can directly pull tables  - from the “database” feature - via API. So a workaround on pulling reports would be to connect the pipe to a table and then pull this table using the API. To be more precise on what I mean to connect pipe and table: create some kind of automation that would, for example, save to a table every cards’ id, title and current phase. Is there a way to do something similar?

Hi, I was wondering what API to use for updating databases based on their connected cards e.g. Data gets updated so I need to auto update the database OR a card gets moved to archive so I want to remove the Data I am someone with very little coding knowledge (But I am learning, currently with html but moving onto python)

Hello,I am attempting to create a db record on the GraphQL API. The table (called “Assessments”) has a database connection field called “Candidate”. From the API, as I attempt to set the field values, I add a valid identifier for “Candidate” (candidate exists and the “Candidates” table, the value I’m setting is the title field). IF the same candidate has not been added to another assessment, the mutation is successful. IF the same candidate is already present on another assessment, the mutation fails with the following error: “Error on field "Candidate": Value You don't have permission to connect these cards/table records.” I’d like to stress that THIS QUERY WORKS as long as the Assessments table does not already contain an assessment with the same candidate that I’m attempting to add. So, I don’t personally believe the problem is in the query. I believe the problem might come from my own understanding of how Pipefy works. On the other hand, I definitely expect Pipefy to ALLOW what I’m

I’m trying to get data from a pipe using Google Apps Script and keep getting the error:Info {"errors":[{"message":"Unexpected end of document","locations":[]}]}I don’t think the problem is with the general script’s structure, since it works when I run another query.Also, I’m new to GRAPHQL - this is the first time I use it, for instance - so that’s another reason why I believe the problem might be in the query.A piece of the script I used to try is: const query = `{ allCards(pipe_id:${pipe_id}){ edges{ node { title current_phase { name } createdBy { name } createdAt fields { value name } } } }`; const graphql = JSON.stringify({ query: query, variables: null, }); const params = { method: "GET", payload: graphql, headers: { "Content-Type": "application/json", Authorization: `Bearer ${TOKEN}`, }, }; var response = UrlFetchApp.fetch(url, params);pi

Hi, I'm using node, and I got the example in the documentation, but when I run it, it gives me this error, and on the site where the example is executed, it's running normally.Thanks.Link example: https://developers.pipefy.com/reference/graphql-endpoint Code:sdk['graphql-endpoint']({ query: '{allCards(pipeId: 302194528){edges{node{id}}}}'}, { Authorization: 'Bearer *token*'}) .then(res => console.log(res)) .catch(err => console.error(err)) Response:​{>    '0': {>      instancePath: '/paths',>      schemaPath: '#/additionalProperties',>      keyword: 'additionalProperties',>      params: { additionalProperty: '' },>      message: 'must NOT have additional properties',>      isIdentifierLocation: true>    },>    stack: 'SyntaxError: OpenAPI schema validation failed.\n' +>      '\n' +>      'ADDITIONAL PROPERTY must NOT have additional properties\n' +>      '\n' +>      '  24 |   ],\n' +>      '  25 |   "paths": {\n' +>      '> 26

I have a situation and I can't find a solution.I need to make a query to filter a pipe, but in it, I need my client's ID that is filled in it in the databases.That is, I need the pipe query to bring the ID filled in it in the databases.Has anyone been through something like that?

Hi!I'm trying to get all records from a table, but using table_records isn't giving me all of them.Running the following code in Python I get 50 records, but my table has 94. Any ideas of how I can get all of them?import requestsimport jsonpayload = {"query": "{ table_records(table_id:\"TABLE_ID\") {edges {node {id }}}}"}headers = { "authorization": f"Bearer {pipefy_token}", "content-type": "application/json"}response = requests.request("POST", url, json=payload, headers=headers)json_data = json.loads(response.text)print(len(json_data["data"]["table_records"]["edges"])) 

Team,When I execute a graphql api for few case the api is success and it returns the data.But if we make any mistakes in constructing the query or some other error then that time in the response it has errors but it gives us 200 as API Status code. How can we distinguish success and failure APIs. Can‘t we find this from the API status code ?

Hey guys! I have a list of 500 options to a select field.When i do it through software screen, i have no trouble:  when i do it through API, if i send about 10 options, all good, but if i send about 20 options, my response is 200 but the options on pipe do not update. =(

Have you heard the expressions "single tenant" or "multi tenant" before? As a rule, companies in Pipefy are hosted in a multi-tenant environment, which means that they all coexist and run their processes, automations, integrations and so on in a single, unified cloud.However, some companies opt for the "single tenant" option:In a single tenant scenario, a company “purchases” its own cloud and, therefore, will no longer divide resources and processing queues with other companies, ensuring greater stability and lesser risk of slowness or latency caused by other companies in the same environment.In single-tenancy, a single instance of the software and supporting infrastructure serve a single customer. Each customer has his or her own independent database and instance of the software. Essentially, there is no sharing happening with this option. The separation is physical. Click here to check the new Single Tenant Documentation to learn all about it and whether it's an option your company s

Hey everyone!  We’ve been working on a series of articles intended for those who are new to programming and are interested in starting to know more about APIs.  Here the second one on How to use APIs and why they are so important to the digital market nowadays.  Hope you all like it and let’s start some discussions about, I’d love to know your impressions and ideas

Hi guys, I’ve looked up the documentation but couldn’t find anything specifying which fields are allowed at the AdvancedSearch option for the allCards query. Could you please list them here and/or append to the documentation? ThanksBernardo

Hello, I’m trying to upload files using api (application/pdf), and I have several problems but focus on current. I’m making an api call using graphql api as it is said there, but my response.body is always ReadableStream and when I tried to read that stream a got the Uint8Array. Am I doing something wrong or it is what it sould be and I just can’t figure out how to get that url

I have a question field selection option and 100 option values (my clients).How can send an update via API to change the values in the pipe so new cards have new options?

Hi! I’m trying to update the Status Field of a Table Record through integromat. My quesiton is: I couldn’t find the name of this field, what is it’s name. And also, wich values can be used to update it: Ativo e Concluído?

It would be great is we could see which users moved a ticket into a phase via the GraphQL API.At present we can see information regarding a phase movement via phases_history in the API but not who undertook this action. This would be extremely useful for auditing and training purposes. The activity history appears to present this information via the UI. Thanks

We would like to see who has moved a card into a phase, through a graphql query. This information is visible through Activity History in the UI but we can’t seem to get it via the API.(We have tried to use the phase_history field in graphql but it lacks the user id.) Is there a way to do this? Thanks  

The GraphQL API of Pipefy provides the function of WebHooks: you can register them, so that upon a certain action, an URL you specify is called, which enables you to use the GraphQL API to develop your own integrations and automations. These WebHooks can be registered for both Database Tables and Pipes. But: to query them, to check which WebHooks are registered on a pipe, the Documentation does not provide a straight-forward way: The object you are looking for is Webhook, and as you can see in Pipe, there is a field ‚webhooks‘ linking to said object; in Table or TableRecord, there is not. So, what is the trick? How can I query which WebHooks are attached to a DataBase?The trick is not obvious, but straight-forward: use the database id as a pipe id!Like this:query { pipes(ids:["yourTableId"]) { id webhooks{ id url name headers actions } }} 

Hi, I’m trying to update/add assignee to a table record field using their contact ID but I’ve been struggling terribly. I can update/add other record fields, using setTableRecordFieldValue, such as email address and phone numbers but the assignee one return empty value ({'data': {'setTableRecordFieldValue': {'table_record': {'id': 'record_id', 'title': 'record_name'}, 'table_record_field': {'value': '[]'}}}}).I’m really new to this pipefy api, can anyone please help?

Hello guys, EnglishI’m trying to connect a whatsapp chatbot to pipefy through API. Problem is chatbot uses JSON API to make calls. How can I convert GraphQL to Json ?PT-BR Estou tentando integrar um chatbot de whatsapp para fazer a criação de cards no pipefy através da API. Porém na configuração do step no chatbot ele só aceita código JSON. Como faço para converter a query de GraphQL para o código JSON?     mutation{  createCard(input:{          pipe_id:XXXXXXX,          phase_id:XXXXXXX,          fields_attributes: [              {field_id:"sua_empresa", field_value:"Teste"},              {field_id:"seu_nome", field_value:"test"}                 ]})          {card {id}}     }    

Boa tarde a todos, estou tentando criar um card via graphql, só que a api está me retornando erro. Alguem sabe oque pode ser? mutation { createCard( input: { pipe_id: {{pipe_code}} fields_attributes: [ { field_id:"c_digo_da_entrega_no_fornecedor", field_value:"""{{table4.selectedRow.data.freight_partner_external_id}}""" }, { field_id:"valor_do_frete", field_value: """{{table4.selectedRow.data.freight_price?table4.selectedRow.data.freight_price:0}}""" }, { field_id:"hor_rio_limite_de_chegada_para_carregamento_1", field_value:"""{{table4.selectedRow.data.freight_scheduled_delivey_datetime}}""" }, { field_id:"link_de_acompanhamento_1", field_value:"""{{table4.selectedRow.data.freight_tracking_link}}""" }, { field_id:"nome_do_motorista_1",

SOLVED Hello everybody.We are trying to use Pipefy API query cards to retrieve all cards of a pipe (https://api-docs.pipefy.com/reference/queries/#cards).Our requests were working fine until one week ago. From that time we are always retrieving a HTML as response with "Pipefy is currently experiencing technical difficulties".Does anybody have any clue about this issue?Thanks a lot.Caio

Hi,I am building an app to keep Database in pipefy in sync with external source. This database contains thousands of records that are added and updated on the daily basis.I’ve tried to use recordsImporter in GraphQL API to sync records, but it seems like it can only create records, but not update it. Is it correct? Are there any other ways to create/update/delete records in bulk through API or is it only possible to do it one by one?  Best Regards, Artem