API

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 json payload = {"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 compan

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? Thanks Bernardo

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", field_value:"""{{table4.selectedRow.data.freight_delivery_point_of_contact}}""" }, { field_id:"contato_do_motorista_1", field_value:"""{{table4.selectedRow.data.freight_delivery_poc_phone}}""" }, { field_id: "identify_autom_tico", field_value: """{{table

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

Hello, When i make a request with the graphql, the response is in a different order for each card, what makes trouble for putting into a DataFrame. Ex: Sometimes the response is given by: Title, date, owner. But in a couple of cards the response is: Owner, title, date. May someone help me?

I'm trying to query all cards from pipe using Pipefy API Graphql, but some cards that appear in the pipe board aren't being returned in the api. In the code below I'm trying get all cards from my Pipe { pipe(id: 1260940) { phases { id, name, cards { edges {node { id, createdAt, fields { name value } }}} } }} Or if I search directly in the phase where are these "hidden" cards { phase(id: 8422613) { cards { edges { node { id } } } }} For example: the card #426803396, that is in this pipe (1260940) and this phase (8422613), isn't returned in any those queries above.

Dear all, Currently we are using the webhook API with some attachements, but we can't figure out the full path of the uploaded item: This is a response example "uploads/04442dae-6d3a-43a9-bd62-5b61e8d61def/Gui.png" Do you have any idea? Regarda

Olá, Estou tentando fazer uma query para filtrar todos os cards de um determinado CPF, porém não está funcionando, é possível utilizar campo customizado no filtro ou apenas os campos fixos do sistema? Obg.

Hi there: I’m trying to make querys from a server using NodeJS and always get error 401 “you are not authorized to access this page” const url = 'https://api.pipefy.com/graphql'; const options = { method: 'POST', headers: { Authorization: '***MY_TOKEN***', 'Content-Type': 'application/json' }, body: JSON.stringify({query: '{ me { name } }'}) } The thing is, I'm using the example in the documentation but it doesn't work. What I am doing wrong?

Hi, I am trying to update phase fields in my Pipe using the following GraphQL query: mutation { updatePhaseField( input: { id: "did_you_finish_the_task" label: "Have you finished the task?" options: ["Yep", "Nope"] required: false editable: true } ) { phase_field { id label } }} As far as I can tell the only way to specify the field is through the field ID. However my account is linked to many boards and companies and there are duplicate IDs across those. For example there could be multiple fields with IDs "did_you_finish_the_task" and I don’t want to accidentally rename the wrong one. So my question is how do I specify a certain field in a certain phase or board?