Solved

genietimPipefy Legend

How do I use an API-Uploaded File as an E-Mail Attachment using the API?

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

2 years ago

gonzalo9New Member

asked in Ask the Community

Phyton Mutation

I have probleme with create record in a table, I use the code bellow, but its not working the payload string….. import requestsurl = 'https://app.pipefy.com/graphiql'payload = "{\"query\":\"{mutation {createTableRecord(input: {table_id: "n1kpekCb", title: "my record", due_date: "2017-12-31T00:00-03:00", fields_attributes: [{field_id: "nombre", field_value: "Tom"}, {field_id: "apellido_paterno", field_value: "tom@trindade.com"}, {field_id: "apellido_materno", field_value: "Trindade"}, {field_id: "n_documento", field_value: "Tom"}, {field_id: "correo_electronico", field_value: "tom@trindade.com"}, {field_id: "telefono_celular", field_value: "tom@trindade.com"}, {field_id: "estado", field_value: "Activo"}, {field_id: "vendedor", field_value: "Sí"}, {field_id: "comprador", field_value: "Sí"}, {field_id: "arrendador", field_value: "Sí"}, {field_id: "arrendatario", field_value: "Sí"}]}) { table_record { id title due_date record_fields { name value } } } }\"}"headers = { 'authorization':

4 years ago

MichelNew Member

asked in Ask the Community

How can I upload or remove an attachment using API?

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

1 month ago

Nigel O'connellPipefy Staff

asked in Ask the Community

Return to more than 50 cards

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

3 years ago

Keto-FasterNew Member

asked in Ask the Community

Creating Card Checklist via the API

I’ve been reviewing the API to see how to work with Card Checklists. Based on documentation there, I’m not sure where they are available.Two questions on this: Are Card Fields the way to list card checklists on a card: https://api-docs.pipefy.com/reference/objects/CardField/ Can we add card checklists via the Update Card Field: https://api-docs.pipefy.com/reference/mutations/updateCardField/ Appreciate any thoughts or experience on doing this. Thanks.

1 year ago

alexei_moraisNew Member

asked in Pergunte à Comunidade

Incluir um Card em um Pipe usando C# ou VbScript

Olá pessoal ! Alguém tem algum exemplo de criação de um Card em um Pipe usando C#, VbScript ou POSTMAN? Usando o GraphiQL IDE com o comando:mutation {createCard(input: {pipe_id: 301418172fields_attributes: [{field_id: "produto", field_value: "produto1"}{field_id: "valor_produto", field_value: "1000"}]})}funciona OK.

3 years ago

Nigel O'connellPipefy Staff

asked in Ask the Community

How to interate through all cards with Python in Pipefy

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!

3 years ago

login7New Member

asked in API

Error 3000 - Algo deu errado GraphQL

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",

3 years ago

Thiago W.Pipefy Staff

asked in Ask the Community

Filter phases by name in Pipefy

Hello everyone. How can i filter phases by name? I don't know either. Here's what I'm trying:{ allCards(pipeId: 123, filter: {field: "current_phase", operator: equal, value: "456"}) { edges { node { id title current_phase { id } } } }}But it says: Something went wrong :-(Any help would be much appreciated.

2 years ago

daniel-chouchou23New Participant

asked in Pergunte à Comunidade

Como gerar bearer token

Desejo criar cards com php porem estou com problema em gerar o token bearer, como faço para gerar ?

8 months ago

bernardo-costaNew Member

asked in API

What fields can be used on allCards query AdvancedSearch?

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

2 years ago

Thiago W.Pipefy Staff

asked in Ask the Community

Hello! I'm trying to register a webhook, but I can’t do it. And I’m not finding anything about permissions and webhooks.

4 years ago

MichelNew Member

asked in Ask the Community

What is the purpose of CreatePresignedUrlInput?

I can send file thru S3 using the signed option, and also download back the same file. But, what tha purpose of this method, because I can't connect a file to database and card neither. What the objective to have a s3 object associated with my organization? Just to create markdown links to images or documents? I need to use the API to send to card file attachments. That option would work flawlessly.

4 years ago

genietimPipefy Legend

asked in Customs Apps & Integrations

What are the GraphQL API Limits?

I can imagine that there are certain limits to the GraphQL API. For example: - number of subsequent queries allowed per time unit - number of webhooks allowed - size of inputs/outputs - size of attachment files What are the numerical values of these (and possibly more) limits?

3 years ago

brennomaejiNew Participant

asked in Ask the Community

[GraphQL] Can I filter cards by custom field values?

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" } ]}

2 years ago

matheus2hcostaNew Member

asked in Pergunte à Comunidade

Query para Conexão de Database

Olá, Eu tenho uma query onde eu busco as informações dos cards da fase de um Pipe, em python:response_fields = 'id name cards_count cards { edges { node { id title fields { ' \ 'name value } } } }fields { id }'query = '{{ phase(id: {phase_id}) {{ {response_fields} }} }}'.format( phase_id=json.dumps(phase_id), response_fields=response_fields)self.__request(query).get('data', {}).get('phase') Eu criei uma conexão de database, e cards que tem uma conexão de database associada e preenchida não está retornando, gostaria de saber uma forma que eu poderia encaixar para trazer tanto os dados estão vindo da query (dados do formulario preenchido), assim como do database na mesma query

2 years ago

Paulo RibasPipefy Staff

asked in Ask the Community

Use webhooks to notified me

Hello! I would like to send a kind of request when a card is moved, for example. How can I do this integration? It's like zapier does, it can detect that a card is moved and a external routine is executed. Thanks.

4 years ago

Thiago W.Pipefy Staff

asked in Ask the Community

API problems

I'm trying to send a long string over the API. However, I cannot find out how to properly format/encode the string in order for Pipefy to simply add the text to the database record. Here's how I'm building the query: return `mutation { createTableRecord(input: { table_id: "**", fields_attributes: [ {field_id: "what", field_value: "${data.firstName}"}, {field_id: "nom", field_value: "${data.lastName}"}, {field_id: "email", field_value: "${data.Email}"}, {field_id: "cellulaire", field_value: "${data.Phone}"}, {field_id: "site_web", field_value: "${data.formRef}"}, {field_id: "message_soumis", field_value: "${data.Message}"},Here, data.Message has a long text in which there are newlines. This breaks it all:400 - {"errors":[{"locations":[{"column":51,"line":10}],"message":"token recognition error at: '\"Monsieur,\n'"} There are tens of such lines. How should I format/encode the text so it is added and properly formatted in the Pipefy DB record?

4 years ago

Thiago W.Pipefy Staff

asked in Pergunte à Comunidade

Integração Python e Pipefy CARDS

Tenho um código que faz a comunicação com os cards do pipefy, porém não estou conseguindo interpretar os dados, vou mandar o código para entenderem e o resultado, porém, basicamente o que eu preciso é mandar isso para um DataFrame.. -- coding: utf-8 -- import json import pandas as pd import requests from requests.auth import HTTPBasicAuth import gspread from oauth2client.service_account import ServiceAccountCredentials from df2gspread import df2gspread as d2g import os import time from datetime import datetime import collections from urllib.request import urlopen from pandas.io.json import json_normalize #{ # allCards(pipeId: 178186, first: 50, after:"WyI5LjUiLCIxNjMyLjAiLDI5MjQ2MDg5XQ==") &#123; # pageInfo &#123; # endCursor # hasNextPage # &#125; # edges &#123; # node &#123; # id # title # fields &#123; # value # &#

4 years ago

Paulo RibasPipefy Staff

asked in Ask the Community

Trying to get all Cards

Hi.Using Python to make requests, what is wrong with the query bellow?pipeId = '171258'query =""""""{""query"": ""{allCards(pipeId: %s, first: 30, after: 'WyIxLjAiLCI1ODAuMCIsMzI0OTU0NF0'){pageInfo{endCursor hasNextPage}edges{node{id title}}}}""}""""""%(pipeid)The query worked pretty well until I added the ""after"" parameter.I already tried variations like:after: ""WyIxLjAiLCI1ODAuMCIsMzI0OTU0NF0""after: \""WyIxLjAiLCI1ODAuMCIsMzI0OTU0NF0\""after: \n""WyIxLjAiLCI1ODAuMCIsMzI0OTU0NF0\n""but without success, any help here will be immensely handful! Thanks

4 years ago

Paulo RibasPipefy Staff

asked in Ask the Community

How I Update value of Radio and Select via API??

"Hello guys, can anybody help me?I am not able to modify values of a radio and a select. Would anyone give me an example of how I change the values via API.

4 years ago

Amanda L.Pipefy Staff

asked in Ask the Community

How may i do two mutations on cards, using just one "play"?

If i run code below, just the card 999 is updated. How may i update two or more cards.mutation {updateCardField(input: {card_id: 888, field_id: ""user_id_ad"", new_value: ""2""},input: {card_id: 999, field_id: ""user_id_ad"", new_value: ""2""}){card {id}}}

4 years ago

Sérgio MoreiraNew Participant

asked in Ask the Community

webhooks

Good morning. How many times pipefy reports an event. For example, if there is an error in the community does pipefy warn you again? Thanks

3 years ago

Nigel O'connellPipefy Staff

asked in Ask the Community

Trying to get all pipes using Python

Hi, Can't figure what is wrong with my code in Python, I'm trying to get all the pipes from a company, my code is the following and the response I getting is 404, I already tried different things like make the "query" in a single row using "\" to escape the caracteres: import requests url = "https://api.pipefy.com/graphql" headers = { 'authorization': "Bearer company_token", 'content-type': "application/json" } query = """ { "query": "{organization(id: 16094){pipes{id}}}" } """ response = requests.get(url, data=query, headers=headers) print(response.text)

3 years ago

Paulo RibasPipefy Staff

asked in Ask the Community

Query Member ID Users

Is it possible - through the API - to query member IDs all at once?If so, how can I do it, I searched the documentation and didn't find it. thanks in advance

3 years ago

Page 1 / 2

Solved

Community Experts Leaderboard

Sign Up Now!

Join us in the Pipefy Community! 🚀

Scanning file for viruses.

This file cannot be downloaded