Ask the Community

Hi, I would love to send data from Pipefy to PowerBi and have interactive dashboards to keep track of my processes SLAs. Does any one here ever done that? 

It's possible to upload a file and create and/or delete attachments in pipes using GraphQL API?

Hi community   I'm trying to create a card in my pipe, but it only shows the error message ""query not found"":{""mutation"":""{ createCard( input:{ pipe_id:ID phase_id:ID title:'Test' fields_attributes:[ field_id:ID field_value:VALUE ]} ) { card { id title } } }""}Response: { ""errors"": [ { ""message"": ""query not found"" } ] } 

I have a REST service that sends a customized email notification to all employees. [ With JSONas input ]I want to integrate this REST API with Pipefy, so when a card is created in pipefy, I want toformat card info (Data from Pipefy webhook) and do the job.Information:Created a webhook in pipefy using "https://app.pipefy.com/graphiql" using mutation"createwebhook" and, webhook is created with an idQuestion:How can I use this webhook and how can I call my own REST API (or how this webhookinteracts with my REST API ?)Please suggest

 [GraphQL] Hello Everyone. I want to take a card ID and get all the standard AND custom data that has relations with it, so i.e: Card ABC has: Assignee Due date Company (that's a custom table I have created and inside this table, there's a custom ID i need to use) Etc... I am having trouble to get these information because I think that it's a simple "Inner Join" solution but after seeing all the reference APIs I couldnt understand the relationship between the tables. Someone ever did something like it and could help? Thanks!

How to get all cards from phase? And if the phase has more 50 cards, what i have to do?

Hi doers!This will be a rather lengthy explanation of my problem, whose TLDR is: Uploading Files via API leads to URLs containing a “org/”, which seems to make it impossible to set them as attachment sources using the GraphQL API. Here the full explanation: I am trying to send E-Mails using Pipefy GraphQL API. In general, I do not have any problems with this. I can send E-Mails even with attachments. BUT: only if the attachments were uploaded manually. I am not able to do the attachment when using files uploaded via GraphQL API. Step 1: Upload (works)The upload works as described on this page:First, I request the URL to upload to:mutation { createPresignedUrl(input: { organizationId: 123, fileName: "MyDocument.pdf" }){

Does allCards return more than 50 cards per query, or do we need to pass the ""first"" combined with ""after"" parameters?

Hello, all.I'm trying to get all cards from a pipe consuming the GraphQL API with Python.Everything was working until I had to use pagination to get more than 50 cards.Below, the code that is returning errors:url = ""https://api.pipefy.com/graphql""payload = ""{\""query\"": \""{ allCards(pipeId: XXXXXX, first: 50, after: \""WyIwLjYyNSIsIjIyOS4wIiw1MzExMzQ5M10=\"") { edges { node { id title phases_history { phase { name } firstTimeIn lastTimeOut } } cursor } pageInfo { endCursor hasNextPage } } }\""}""headers = {'Content-Type': 'application/json','Authorization': 'Bearer <MY-AUTH-KEY>'}response = requests.request(""POST"", url, data=payload, headers=headers)response_body = response.textprint(response_body)Below, the error that returns:{""errors"":[{""message"":""Error parsing GraphQL request: error decoding JSON. This likely means that the GraphQL

Hi! I'm working in a python script that read some fields from all cards from a pipe and them write it to pandas in Python. The main idea is to iterate through all key values from json list. Here's my code: import requests import jsonurl = ""https://api.pipefy.com/graphql""payload = ""{\""query\"":\""{ allCards (pipeId:127682, first:50) { edges { node { id title fields { name report_value updated_at value } } } }} \""}"" headers = { 'authorization': ""Bearer ""my_token"""", 'content-type': ""application/json"" }response = requests.request(""POST"", url, data=payload, headers=headers) print(response.text)Since here, all it's ok.But when I try to parse it with json with this code:json_dic=json.loads(response.text)for key in json_dic: print (key,"":"",json_dic[key])I just got an another list like the first ""print"", it seems that ""resp

Hi,I am trying to understand how to provide parameters to the allCards query.  It seems there is no place where simple example queries are shown, so its becoming difficult to understand how to construct API queries.Right now I am experimenting with basic queries and trying them with GraphiQL. With the below query I try to filter cards and retrieve all cards where a certain field has a value equal to a certain value, Eduardo in this example. The below query returns errors, it seems it is expecting a string. The error does not resolve if I enclose the field name and/or value between “”. The query below does retrieve values if the 4th line is completely removed (i.e. the line with the filter).How are this filters constructed? What is the basic grammar? What am I missing? Thanks! errors": [{      "message": "Argument 'field' on InputObject 'AdvancedSearch' has an invalid value (field_24_string). Expected type 'String'.",

I am getting Error Json payload request error.https://api.reportresults.gia.edu this is my request Json payload'{"query":"{\n  getReport(report_number: \"'6425815757'\") {\n      report_date\n          report_number\n            report_type\n        results {        \n        ... on LabGrownDiamondGradingReportResults {\n               identification\n            shape_and_cutting_style\n            measurements\n            carat_weight\n                color_grade\n              color_origin\n            color_distribution\n            color_distribution_code\n          clarity_characteristics\n              clarity_grade\n            cut_grade\n             polish\n               symmetry\n              fluorescence\n            key_to_symbols {\n      order            \n          characteristic            \n            image        \n            location\n

Hello all, I need to download all cards from a Pipe. I have over 1,000 cards. My current Python process for downloading all cards uses pagination. The first 50 cards are queried/downloaded quickly (i.e., json objects are saved practically immediately). But every subsequent card takes nearly 1 second. This takes a long time. Is there a Python process that downloads many cards more quickly? Here’s my current process: # packagesimport jsonimport requests# tokenpipefy_token = "token goes here"# pipefy class for later usePipefy = pipefy.Pipefy(pipefy_token)# graphqlurl = "https://api.pipefy.com/graphql"# headersheaders = {    "Accept": "application/json",    "Content-Type": "application/json",    "Authorization": "Bearer %s" % pipefy_token}# pipe IDpipe_id = “#########”# first 50

Hi Team,I want to explore the pipefy as this is low code no code application where we can do the multiple things automate. It would be really great if it will guide me how I can achieve my self learning assignment though this Pipefy Tool.Import CSV and Excel file in pipefy : I tried to do this with importer application However, It only allow to import the Excel files. We need to do the Header mapping as headers are not in same order so, how can we achieve this through Pipefy. Once header mapping done then we need to store the each files of data into 2 tables in 1 Database : I am able to store data into Database through Excel sheet. however, for csv it is still question and header mappping once data is stored into 2 tables I have to compare 2 tables and findout the difference and stored it into the 3rd Table of that database. Once 3rd ta

I’ve seen here (https://developers.pipefy.com/changelog/new-graphql-feature-query-cards-by-updated_at) that we can filter cards by using built-in field liks update_at. How can I filter my cards by a custom field? Let’s say i have a field called “customer_id”. I tried this but didnt get it to work: query allCardUpdatedYesterday { allCards(first: 20, pipeId: 123,filter: { field: "customer_id", operator: equal, value: "87y8-b7a6b-8a6c"}) { edges { node { id title } } } } Do I have to prefix the field id with something? The response I get does not add much: {  "data": {    "allCards": null  },  "errors": [    {      "message": "Something went wrong",      "locations": [        {          "line": 18,          "c

Is there any way to clone / duplicate a specific card via graphql?

Pessoal, tudo bem? Dúvida: estou criando um forms/card, onde contém várias datas. Antes que cada data expire, eu gostaria de ser lembrado (dai pode ser slack, email). Alguém tem uma ideia? 

I am trying to acces pipefy data through the API, however, I am not able no find my organization ID or my pipe ID anywhere, I am just missing those to finish everything. Thanks,Leo

HI Team, In Our pipe: 1004580 , A card is getting created multiple time with title:[66.0, 76.0, 67.0, 75.0, 49.0, 48.0, 54.0, 48.0, 54.0, 55.0] Can you please tell me how I can delete those duplicate cards.

I have a Long text field in a parent card that should be updated with the Long text values from various connected child cards. Each update should show. In other words: Parent card Comment field: Updated comments 1 from Child card #1 Updated comments 1 from Child card #2 Updated comments 1 from Child card #3 What is the API call to update & append a field?  

Olá, boa noite, minha empresa é toda gerenciada pelo pipefy, porém ainda não faço uso de Interações, e sei que não consigo fazer calculos basicos entre campos, pergunta? qual a melhor solução? Consigo deixar uma planilha na nuvem e tentar importar dados pra essa planilha com formulas e depois ler os dados dessa planilha já pronta, ou tentar integração com um software de erp mesmo?? trabalho bem com planilhas, é possivel eu importar dados para dentro de uma planilha na nuvem e depois ler ela já com os calculos feitos??

Olá. Qual a maneira mais facil de saber um ID de um campo do formulário?

Hi People, We need to clear 2000 register of a database?, how i can do fast? thanks

 Hi, I am testing pipefy webhooks, but I have created two webhhooks for the same endpoint and I would like to remove one of them.