Tetrapod

How to install

pip install -e git+https://github.com/uwekamper/tetrapod.git#egg=tetrapod

the 'tpod' command

Get your client ID und client secret from https://podio.com/settings/api

Then run the following command:

tpod init --client-id=<Podio-client-id> --client-secret=<Podio-client-secret>

This will create a hidden file called .tetrapod_credentials.json in the current working directory. The access token is valid for some hours.

Accessing single Podio items

You can find die item_id of any Podio item by opening a Podio item detail view in the Webbrowser and then clicking on 'Actions' and 'Developer info':

This will display among other things the item_id and the app_id:

Using the item_id you can now write a simple python programm that will read the details of one single item. Create file named get_item_data.py that contains the following Python code:

from tetrapod.session import create_podio_session

ITEM_ID=123456789 # <- Replace with your own item_id.


def get_podio_item(item_id):
    # reads the access token from .tetrapod_credentials.json
    podio = create_podio_session()

    # see https://developers.podio.com/doc/items/get-item-22360
    item_url = f'https://api.podio.com/item/{item_id}'

    # podio.get() works almost the same way that requests.get() works
    resp = podio.get(item_url)
    resp.raise_for_status()
    item_data = resp.json()
    return item_data


if __name__ == '__main__':
    item_data = get_podio_item(ITEM_ID)
    # print something from the item_data, then exit
    print(f"Item-ID: {item_data['item_id']}")
    print(f"Item title: {item_data['title']}")

Now run the program. The output should look like this:

$ python ./get_item_data.py
Item-ID: 123456789
Item title: Bow of boat
$ _ 

Working with higher number of Podio items

Podio has very strict API limits. Because of this, tetrapod includes an option to create a 'robust' session. If you create Podio session with the robust parameter, tetrapod will wait when the API limit is reached and it will also retry the request when Podio returns a '504 Gateway timeout' error.

from tetrapod.session import create_podio_session

podio = create_podio_session(robust=True)

Another hurdle is pagination. To download the data of a whole Podio app, we need to get the Podio items in smaller chunks:

from tetrapod.session import create_podio_session
from tetrapod.helpers import iterate_resource

app_id = 987654321 # <- Enter your own app_id here.

podio = create_podio_session(robust=True)
url = f'https://api.podio.com/item/app/{app_id}/filter/'

for item in iterate_resource(client, url, 'POST', limit=250):
    print(item['item_id'])

(The limit parameter can be anything from 1 to 500. On larger Podio apps it is wise to stay below 300 and reduce the limit if you see that the Podio API returns a lot of HTTP 504 Errors.

See https://developers.podio.com/doc/items/filter-items-4496747 for more info on the filter API endpoint.

Turning a whole Podio app into a Pandas dataframe

For this example to work Pandas needs to be installed already. Often you want to get all the data from one Podio app.

import tetrapod.dataframe
from tetrapod.session import create_podio_session

podio = create_podio_session(robust=True)
app_id = 987654321 # <- Replace with your own app_id here.

# You need to list the fields that should be included in the dataframe
df = tetrapod.dataframe.load_from_app(podio, app_id, labels=['Title', 'Description'])

# But you can also use the external_ids of the fields
df = tetrapod.dataframe.load_from_app(podio, app_id, external_ids=['title‘, 'description'])

Useful links

• https://github.com/finklabs/whaaaaat
• http://click.pocoo.org/5/
• https://github.com/asweigart/pyperclip
• http://urwid.org/
• http://npyscreen.readthedocs.io/introduction.html
• https://help.podio.com/hc/en-us/community/posts/206886967-Updating-a-Calculation-Field-Script-via-the-API
• https://requests-oauthlib.readthedocs.io/en/latest/
• https://sedimental.org/glom_restructured_data.html
• https://flit.readthedocs.io/en/latest/