Replies posted by Marcos Carvalho

55 Replies

Douglas Costa
Douglas CostaRegular Participant
asked in Pergunte à Comunidade

Ajuda com Integromat/Make (Anexos)

hey @Lucas Democh, how are you?here the documentation you need 😀https://developers.pipefy.com/docs/how-to-upload-attachments-and-attach-to-a-card-recordHope it helps!

10
Marcos Carvalho
Pipefy Staff
10 months ago
Diego Anselmo Saiotti
Diego Anselmo SaiottiNew Member
asked in Customs Apps & Integrations

API call | exportPipeReport | Problems with download from Pipefy URL

hey @Diego Anselmo Saiotti your integration with Pipefy is working well. The issue is the urllib usage.  HTTPS support is only available if Python was compiled with SSL support (through the ssl module).Here some documentation that might help. https://docs.python.org/3/library/http.client.htmlSome users faced the same issue here: https://stackoverflow.com/questions/28376506/urllib-https-request-urlopen-error-unknown-url-type-httpsIn this case you need to check your environment and make the proper configuration to manipulate HTTPS urls.Hope it helps you. 

1
Marcos Carvalho
Pipefy Staff
1 year ago
Keto-Faster
Keto-FasterNew Member
asked in Ask the Community

Creating Card Checklist via the API

hey @Keto-Faster , I got it 😊 In the updateCard mutation, you can update some more attributes than the title as you can see below:   you can check this option in GraphiQL: https://app.pipefy.com/graphiqlBut about the Card Checklists, unfortunately is not possible to update or create new card checklists through our API, only Checklist Fields are available.  I’ll communicate this limitation to our product team. Thank you! 

5
Keto-Faster
11 months ago
Keto-Faster
Keto-FasterNew Member
asked in Ask the Community

Creating Card Checklist via the API

hey there @Keto-Faster, I’m Marcos from Pipefy Engineering Team.  In order to to list all fields and its values in a Card you can use this query below, where you can input the card ID and retrieve any information from any field inside it.  { card(id: $cardId) { fields { field { type } value } }}For more information about the Card query, you can check this reference https://developers.pipefy.com/reference/cardsAbout the checklist fields, if you want to create a new field to be in a specific phase but not fill its value yet,  you can use the mutation createPhaseField which allows you to create new fields. mutation { createPhaseField(input: {phase_id: $phaseID, type: "checklist_horizontal", label: "Checklist", options: ["a", "b", "c"]}) { clientMutationId }}  But if you want to insert values in existent field you can use the mutations updateCardField (that you mentioned) or updateFieldsValues. Here some examples: mutation { updateCardField(input: {card_

5
Keto-Faster
11 months ago
michael-cope
michael-copeNew Participant
asked in API

Additional Card Information from Webhooks

Hey @michael-cope, how are you? I’m Marcos from Pipefy Engineering Team.  In fact that’s how Pipefy Webhooks were designed, with a GraphQL flavor in mind and avoiding over or under fetching, since the card can contain many information like card values, information about the phases, emails sent and much more. Since each integration is unique, sending all the card information in the webhook payload could be too  much. With the card ID and this extra request, you can request just the information you want. But we want to hear you, what extra fields would you need in the webhook payload? Best regards, 

1
Marcos Carvalho
Pipefy Staff
1 year ago
matheus2hcosta
matheus2hcostaNew Participant
asked in Pergunte à Comunidade

Query para Conexão de Database

Olá @matheus2hcosta , como vai? Sou o Marcos, desenvolvedor aqui na Pipefy  Você precisa trazer os registros de database que estão conectados com os cards da phase que está buscando?  Se sim, sua busca já deveria retornar todos os cards, independentemente se há conexões ou não. Aí teremos que analisar melhor o permissionamento do database conectado e do pipe em questão. Ou precisa trazer os cards da phase, que estão conectados com um registro de database ? Se for este o caso, vc pode buscar as child_relations, que é uma busca que traz os cards conectados ( que chamados de child relation )  { phase(id: 312411623) { cards { edges { node { id title child_relations { cards { id fields { value } } } } } } }}Que retornará: { "data": { "phase": { "cards": { "edges": [ { "node": { "id": "503715193",

1
Marcos Carvalho
Pipefy Staff
2 years ago
Marcos Carvalho
Pipefy Staff
Marcos CarvalhoPipefy Staff
published in API

💎 Pipefy GraphQL API Reference documentation is now updated!

hey @Grafeno sorry about that and thanks for the feedback. we’ll provide a better description for this mutation and its’ fields. as soon as we update it, I let you know here, ok? 

6332
Marcos Carvalho
Pipefy Staff
2 years ago
bernardo-costa
bernardo-costaNew Member
asked in API

What fields can be used on allCards query AdvancedSearch?

Hi @bernardo-costa, This AdvancedSearch option can be used just for the “due_date” and “updated_at” fields. But in order to do that, you must provide a valid datetime value just like this one: "2017-12-18T00:00:00-02:00" Here some code snippets for you:{ allCards(pipeId: 12345678, filter: {field: "updated_at", operator: gt, value: "2017-12-18T00:00:00-02:00"}) { edges { node { id } } }}  { allCards(pipeId: 12345678, filter: {field: "due_date", operator: gt, value: "2017-12-18T00:00:00-02:00"}) { edges { node { id } } }}  Hope it helps you 

2
bernardo-costa
2 years ago
login7
login7New Participant
asked in API

Error 3000 - Algo deu errado GraphQL

hey @xp-hf , if you want to list all the records in a database to be used in your mutation, you can do something like this:  { table(id: "4asda4w3") { table_records { edges { node { id } } } }}You’ll get in return: { "data": { "table": { "table_records": { "edges": [ { "node": { "id": "96385214" } }, { "node": { "id": "74185296" } }, { "node": { "id": "87456985" } }, { "node": { "id": "87654321" } }, { "node": { "id": "12345678" } } ] } } }}  then you can use one of these ids in your mutation: mutation{ createCard( input: { pipe_id: 219739 fields_attributes: [ {field_id: "connector", field_value:[12345678]} ] } ) { card {

3
Marcos Carvalho
Pipefy Staff
2 years ago
login7
login7New Participant
asked in API

Error 3000 - Algo deu errado GraphQL

Hey @login7 , how are you?It seems that some field value is being sent in a invalid format. Please double check your fields types and inputs to make sure everything is ok.  Here something to help you on it:     If you need anything else, please let me know.   

3
Marcos Carvalho
Pipefy Staff
2 years ago
genietim
genietimPipefy Legend
asked in Ask the Community

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

Hey Tim,  It seems to be correct. I’m also fetching card data and it returns (with the orgs/… prefix) { "data": { "card": { "attachments": [ { "createdAt": null, "path": "orgs/abcf59db-49a5-419e-bd3c-40f781d7cdcc/uploads/89cc28f1-5bb0-4b63-b81d-946aaa8893d6/Ruby.pdf", "url": "https://app-storage-service.pipefy.com/v1/signed/orgs/abcf59db-49a5-419e-bd3c-40f781d7cdcc/uploads/89cc28f1-5bb0-4b63-b81d-946aaa8893d6/Ruby.pdf?expires_on=1619720179&signature=%2BM8aCLJvIlU9pY5Rm4y8o0YNMM3qNAUKBglhMAnM1FI%3D" } ] } }}  Could you please create a test Org and try to generate the link from there?  If this error persists, I believe it will be necessary to have a deeper look by Support Team.  Please let us know

11
tobiasbaco
2 years ago
genietim
genietimPipefy Legend
asked in Ask the Community

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

hey @genietim,  I believe the error is happening in your step 2. In the query query { card(id: 123) { attachments { url createdAt } }}Change for this one: { card(id: 123) { attachments { createdAt path url } }} Are you sure that the url in query payload has the pipefy-production.s3-sa-east-1.amazonaws.com domain? Because is must return a url and path like these from our storage-service:  { "data": { "card": { "attachments": [ { "createdAt": null, "path": "uploads/7dad8421-2726-4e06-a740-835abe81d085/Ruby1.pdf", "url": "https://app-storage-service.pipefy.com/v1/signed/uploads/7dad8421-2726-4e06-a740-835abe81d085/Ruby1.pdf?expires_on=1619638284&signature=I5jsrbvBnOFVC%2F3dPTijC4jGe0CPajNKOBVOhdFpSVY%3D" } ] } }}  Then using it with this address you will sucessfully create and send the inbox email: mutation { createInboxEmail(input: {card_id: "123", from: "pipe123@mail.pipefy.com", subject:

11
tobiasbaco
2 years ago
Juliana Spinardi
Pipefy Staff
Juliana SpinardiPipefy Staff
published in Customs Apps & Integrations

Sample Apps

Hey @silvio.angelo,  Thank you for your report.  We’ll take a look a this example app in order to fix or send you the correct files, ok?  Feel free to reach us. 

3197
d-drynov
1 year ago
genietim
genietimPipefy Legend
asked in Customs Apps & Integrations

What are the GraphQL API Limits?

hey @genietim , how are you? Pipefy GraphiQL API limits are:  number of subsequent queries allowed per time unit: our rate limit is 500 requests for each 30 seconds; number of webhooks allowed: the number of webhooks is based in the process size and it depends on the organization subscription as well. We’d recommend to not have more than 30 webhooks for each pipe, but it is customizable.  size of inputs/outputs: the inputs and outputs are based mainly in your process size, using the pre-built queries and mutations. But in a response payload, for example, each request only returns 50 records, requiring then using pagination.  size of attachment files: limit of 512MB for each file. hope it helps you  

2
Marcos Carvalho
Pipefy Staff
3 years ago
brennomaeji
brennomaejiNew Participant
asked in Ask the Community

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

Hey @brennomaeji ,  Unfortunately it’s not possible to filter by fields in the allCards query.  The only filter available is the updated_at filter, like this:{ allCards(pipeId: 576018, first:5 filter: {field: "updated_at", operator: gte, value: "2019-04-02T00:00:00-00:00" AND:[{field: "updated_at", operator: lte, value: "2019-04-03T00:00:00-00:00"}]}) { edges { node { id title } } pageInfo { hasNextPage endCursor } }}  But if you want, the Cards query has more options:   Hope it helps you 

2
tiago
2 years ago
joaoluizbt
joaoluizbtRegular Participant
posted in Pergunte à Comunidade

Como alterar a forma de exibição do conteúdo de um campo conectado no template de e-mail?

Olá @joaoluizbt ,   Em um campo conectado, você pode selecionar cada item de forma individual como campo dinâmico.     Basta selecionar o campo dinâmico de cada item e adicionar em cada bullet point:               Desta forma os itens não estarão separados por vírgula:    Espero que isto ajude =D  Boa tarde, @Marcos Carvalho . Obrigado pela resposta. Eu fiz isso, no item quantidade eu selecionei o campo quantidade, e no item descrição, eu selecionei o campo descrição. A divisão dos itens dentro do card acontece normalmente, o problema é que eu tenho mais de um card neste campo conectado, aí no item de quantidade aparecem dois valores e no campo descrição aparecem dois valores também, ambos separados por vírgula, indicando que cada um pertence a um card.   Se eu conseguisse mudar a exibição dos itens de cada card, seria o ideal. Eu poderia criar um campo para cada item, mas não existe uma quantidade padrão, podem ser dois itens, mas podem ser mais de cem, ficaria

7
joaoluizbt
3 years ago
joaoluizbt
joaoluizbtRegular Participant
posted in Pergunte à Comunidade

Como alterar a forma de exibição do conteúdo de um campo conectado no template de e-mail?

Olá @joaoluizbt , Em um campo conectado, você pode selecionar cada item de forma individual como campo dinâmico.  Basta selecionar o campo dinâmico de cada item e adicionar em cada bullet point:       Desta forma os itens não estarão separados por vírgula:  Espero que isto ajude =D 

7
joaoluizbt
3 years ago
Nigel O'connell
Pipefy Staff
Nigel O'connellPipefy Staff
asked in Ask the Community

Get connected TableRecords from Card

Hey Nigel,  To get the connected table records or cards, you need to query the child_relations, if it’s a child relation, or parent_relations, if it’s a parent relation   Like this:  { card(id: 987654321) { fields { name value } child_relations { id cards { id title fields { name value } } } parent_relations { id cards { id title fields { name value } } } } } 

1
Marcos Carvalho
Pipefy Staff
3 years ago
Nigel O'connell
Pipefy Staff
Nigel O'connellPipefy Staff
asked in Ask the Community

How to interate through all cards with Python in Pipefy

Hey @m.sabadini ,   We need to use pagination in order to keep Pipefy infrastructure safe.  To paginate you need to use pageInfo attribute.   { allCards(pipeId: 987654) { edges { node { id } } pageInfo { endCursor } }}  In the response payload you’ll get a string to use in your next query:   ], "pageInfo": { "endCursor": "WyIyLjgyODEyNSIsIjI5MC4wIiwzNzc4MzQ5MDld" } } }}  Like this:  { allCards(pipeId: 987654, after:"WyIyLjgyODEyNSIsIjI5MC4wIiwzNzc4MzQ5MDld") { edges { node { id } } pageInfo { endCursor } }}  Hope it helps you  =D 

4
m.sabadini
3 years ago
Nigel O'connell
Pipefy Staff
Nigel O'connellPipefy Staff
asked in Ask the Community

browser and tech req

Hey Nigel,  We support the current and the two latest version of Microsoft Edge, Google Chrome, Mozilla Firefox and Safari. Internet Explorer 11 is supported as well.  

1
Marcos Carvalho
Pipefy Staff
3 years ago
diego287
diego287Regular Participant
asked in Pergunte à Comunidade

Criação de card para usuário - API PHP

Olá Diego, como vai? Caso queira criar o card já com o assignee selecionado, basta adicionar o input assignee_ids conforme exemplo abaixo: mutation { createCard(input: { pipe_id: 301418657, assignee_ids: 987654, fields_attributes: {field_id: "book", field_value: "Call Of the Wild"}}) { clientMutationId card{ id title fields{ name value } } }} Desta forma, o campo de fixo de Assignee do card já será preenchido com o user ID 987654.  Mas caso tenha um campo de assignee no formulário, poderá criar desta forma:  mutation { createCard(input: { pipe_id: 301418657, fields_attributes:[ {field_id: "book", field_value: "Catch 22"} {field_id: "assignee", field_value: 987654} ]}) { clientMutationId card{ id title fields{ name value } } }} Espero que isso possa te ajudar 

1
Marcos Carvalho
Pipefy Staff
3 years ago
A
Pipefy Staff
Amanda L.Pipefy Staff
asked in Ask the Community

card.delete on webhook

Hello Amanda, how are you?  We don't have a card.delete webhook action. We only support these actions: card.create  card.move card.late card.expired card.overdue card.doneSo if you want to be notified about done cards, you can create a webhook with the [card.done] action.  But maybe you want a CardDelete mutation to delete cards in Pipefy using API. If that’s the case, here the documentation how you can run it:  https://api-docs.pipefy.com/reference/mutations/deleteCard/ Here an example: mutation { deleteCard(input: {id: 2762646}) { success }} Hope it helps 

1
Marcos Carvalho
Pipefy Staff
3 years ago
Nigel O'connell
Pipefy Staff
Nigel O'connellPipefy Staff
asked in Ask the Community

Remove assignee

Hey Nigel,  If your card has just one assignee, you can run a updateCard mutation with an empty value in the assignee field_value, like this:  mutation{updateCard(input:{id:123456789, assignee_ids:[0]}) { clientMutationId card{pipe { id}assignees { id }}}} But it’s important to mention here that this mutation replace any value in the assignee field_value.So if there’s more than on assignee you must run the mutation with the assignee id you need to keep in the card, excluding the rest of assignee ids. Like this: My card has two assignees:  { "data": { "card": { "assignees": [ { "id": "654321" }, { "id": "987654" } ] } }}But I want to keep just the 987654. So my mutation will be:mutation{updateCard(input:{id:392042201, assignee_ids:[987654]}) { clientMutationId card{pipe { id}assignees { id }}}} Hope it helps you :) 

1
Marcos Carvalho
Pipefy Staff
3 years ago
diego287
diego287Regular Participant
asked in Pergunte à Comunidade

Error 30000 - Criação API usando PHP

Olá Diego, como vai?  Poderia compartilhar o exemplo da sua requisição? Alguns escapes podem estar faltando, mas mesmo assim nossa API entendeu a mutation e criou pipe, retornando um erro na sua tela.  Compartilho abaixo um exemplo de mutation de criação de pipe para que possa comparar.  Em GraphQL:  mutation { createPipe(input: {name: "API Test", organization_id: 300424275}) { clientMutationId pipe { id } }}  Em PHP através da lib cURL:  $curl = curl_init();curl_setopt_array($curl, array( CURLOPT_URL => "https://api.pipefy.com/graphql", CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => "", CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => "POST", CURLOPT_POSTFIELDS =>"{\"query\":\"mutation {\\n createPipe(input: {name: \\\"Pipefy API Test\\\", organization_id: 300424275}) {\\n clientMutationId\\n pipe {\\n id\\n }\\n

1
Marcos Carvalho
Pipefy Staff
3 years ago
Nigel O'connell
Pipefy Staff
Nigel O'connellPipefy Staff
asked in Ask the Community

ID of connected Cards

Hey Nigel, how are you? Sure, you can query all the connected cards using parent_relations or child_relations like this: { card(id: 1234567) { parent_relations { cards { id title } } child_relations { cards { id title } } }} 

1
Marcos Carvalho
Pipefy Staff
3 years ago

Community Experts Leaderboard

Terms & ConditionsCookie settings