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

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

 [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!

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" }){ clientMutationId url }}Then, I do the upload:curl --request PUT--url 'https://pipefy-production.s3-sa-east-1.amazonaws.com/orgs/ce63-a26b-412f-9d27-3a5776e16e/uploads/45da74d3-0e92-4e1c-a04e-2acc97169a3/SampleFile.pdf?...Signature=fa76e8bf28f88d8ceec1df8219912e10

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 request was malformatted.: invalid character 'W' after object key:value pair""}]}If I just remove the, after: \""WyIwLjYyNSIsIjIyOS4wIi

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'.",The allCards query { # searching cards based on limited parameters: y

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 ""response.text"" is not a dict object, so when I parse it with json.loads, script can't identify the keys and separate them.Whats going wrong?Thx!

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 table created I need to export the 3rd table records. Can Anyone of your community will let me know how I can achieve this as I am exploring this things o

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        }\n         inscriptions\n             proportions{\n              depth_pct\n                 table_pct\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 cards queryjson_query = {"query": "{ allCards(pipeId: %(pipeId)s, first: 50) { edges { node { id title assignees { id } comments { text } comments_count current_phase { name } done due_date fields { name value } la

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,          "column": 3        }      ],      "path": [        "allCards"      ],      "code": 30000,      "type": "ExecutionError"    }  ]}

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

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 @Lucas Pimenta  I'm having an issue installing your UIPath x Pipefy cpnnector. I keep getting the message "The file is not a valid nupkg file"I'm adding it in uipath studio community 2020.6.0 Can you assist please? ThanksJaco

Hi, Every time i enter my credentials in the home screen page, it takes me in but then kicks me out in the same instant… please assist.

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.

Here I share some ideas for using ChatGPT that can help when building queries and mutations. Mutation for updating cards: Here I think it's cool that it responds to an API limitation and brings a suggestion.I did a test giving the name of the fields and it already brings the custom code.  Query to search for cards: In addition to bringing the code suggestion, it brings clear explanations of which fields need to be changed.  Even with the limitations of updating ChatGPT, I believe it is a good tool to be used on a daily basis by those who work with Pipefy. It can also be used when creating interactions with Make/Integromat, among others. How have you been using ChatGPT together with Pipefy? 

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?  

Does anyone know how Pipefy's API consumption is counted? They're wanting to sell me an additional consumption package, but the team that wants to sell me doesn't know where I'm consuming. From my counts, I'm making around 2-3K API calls per month. According to the Pipefy team report, we are doing 15 K. They can't explain.

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.