Skip to main content
Solved

API call | exportPipeReport | I'not retrieving ID from json return

  • July 28, 2022
  • 2 replies
  • 291 views

Diego Anselmo Saiotti

 

Hi!

 

I’m trying to recover one specific info from a POST that i’ve done.

import requests
import json

url = "https://api.pipefy.com/graphql"

payload = {"query": "mutation {exportPipeReport(input: { pipeId:\"XXXXX\", pipeReportId: \"XXXXX\"}) {pipeReportExport {id}}}"}
headers = {
"Authorization": "Bearer XXXX",
"Content-Type": "application/json"
}

response = requests.request("POST", url, json=payload, headers=headers)
data = json.loads(response.text)

Id_relatorio = data['data']

print(Id_relatorio)

I’m using python 3, but i can only recover the entire data: 

{
"data": {
"exportPipeReport": {
"pipeReportExport": {
"id": "302968765"
}
}
}
}

 

Do you have any idea how to manipulate the returning JSON, with python, in order to print only the “ID” info?

 

Thanks!

Best answer by João Nicolete

Hi! 

You can do it like this: 

 Id_relatório = data['data']['exportPipeReport']['pipeReportExport']['id']

That way you will retrieve just the id value from the JSON. 

Let us know if that works or if you run throught any problems.

This topic has been closed for replies.

2 replies

João Nicolete
Pipefy Staff
  • Pipefy Staff
  • Answer
  • July 29, 2022

Hi! 

You can do it like this: 

 Id_relatório = data['data']['exportPipeReport']['pipeReportExport']['id']

That way you will retrieve just the id value from the JSON. 

Let us know if that works or if you run throught any problems.


Diego Anselmo Saiotti

WOW! Tks! Worked fine!