Topics started by davi96

3 Topics

davi96
davi96Regular Participant
asked in API

Is there a wait to get a pipe report via API or save a pipe's information to a table that could be pulled via API?

I don’t think it’s possible to directly get a pipe report via API, since I haven’t find anything related in the docs. Anyway, I’d be happy if I’m wrong on that.However, I can directly pull tables  - from the “database” feature - via API. So a workaround on pulling reports would be to connect the pipe to a table and then pull this table using the API. To be more precise on what I mean to connect pipe and table: create some kind of automation that would, for example, save to a table every cards’ id, title and current phase. Is there a way to do something similar?

4
davi96
2 years ago
davi96
davi96Regular Participant
posted in Customs Apps & Integrations

How to test if webhook is working?

I created a webhook in a pipe in order for it to export data to a Google Cloud Function that will, in turn, send it to a Google Cloud Pub/Sub topic.The Cloud function is all set up and tested, surely working when I do a POST request using curl with the same token.I set up the webhook using https://app.pipefy.com/graphiql with the following piece of code:mutation{ createWebhook(input:{ actions:"card.move" name:"Webhook-Test" url:"https://MY_CLOUD_FUNCTION_URL" email:"MY_EMAIL@MY_COMPANY.com" pipe_id:302214108 headers: "[{\"Authorization\":\"Bearer MY_VERY_LONG_TOKEN\"}]" }) { clientMutationId }}And it actually does create a webhook, as I could verify with the following piece of code:{pipe(id:302214108){id webhooks{id url headers actions}}}However, when I move some cards to test it, I don’t see any invocation in the cloud function dashboard. Is there a way to test and monitor the webhook? Any ideas that could help solve this? I’m totally lost with this, since I

3
Lucas Democh
2 years ago
davi96
davi96Regular Participant
asked in API

Info {"errors":[{"message":"Unexpected end of document","locations":[]}]}

I’m trying to get data from a pipe using Google Apps Script and keep getting the error:Info {"errors":[{"message":"Unexpected end of document","locations":[]}]}I don’t think the problem is with the general script’s structure, since it works when I run another query.Also, I’m new to GRAPHQL - this is the first time I use it, for instance - so that’s another reason why I believe the problem might be in the query.A piece of the script I used to try is: const query = `{ allCards(pipe_id:${pipe_id}){ edges{ node { title current_phase { name } createdBy { name } createdAt fields { value name } } } }`; const graphql = JSON.stringify({ query: query, variables: null, }); const params = { method: "GET", payload: graphql, headers: { "Content-Type": "application/json", Authorization: `Bearer ${TOKEN}`, }, }; var response = UrlFetchApp.fetch(url, params);pi

1
davi96
2 years ago

Community Experts Leaderboard

Terms & ConditionsCookie settings