I built a python code to connect Pipefy to PowerBI, and achieved the result of a general exported report through a cards query, gathering all field data. But, connection fields only return their title in a similar fashion to “ connected_card_title]”.
Searching the API documentation I found reference to:
Which I thought would be the solution to gather connected field data. Still, it only added to the field object the following:
{'connectedRepoItems': o{}], 'name': '...', 'value': '...'}
It can identify, correctly, which fields are connections, returning e{}], and which fields aren’t returning ‘None’.
However, there is no information attached that could lead me to the connected card or register data.
Is there a way to directly gather data from a connected field, or will I need to pull data from all pipefy sources and compare titles to achieve it?
The problem of the latter is pipe connections where it’s possible to have cards with the same title and the added efficiency cost.
TL;DR Is there a query method that returns connected field data?