Metadata API Python3 Get Request

Both of those requests look fine. I’m not sure about Python specifics, you can try the same with curl in your terminal to help isolate the issue:

curl "https://api.airtable.com/v0/meta/bases/appXXXXXXXX/tables" \
-H "Authorization: Bearer keyXXXXXXXXXXX" \
-H "x-airtable-client-secret: yourorg-XXXXXXXXXXXXXXXXXX"

Note HTTP header names are case insensitive. If that curl requeset works for you, then you know it’s something with the Python wrapper/lib you’re using.

curl "https://api.airtable.com/v0/meta/bases/appXXXXXXXX/tables" \
-H "Authorization: Bearer keyXXXXXXXXXXX" \
-H "x-airtable-client-secret: yourorg-XXXXXXXXXXXXXXXXXX"

Thanks for the response. I am still getting {“error”:{“type”:“NOT_FOUND”}} with CURL.
My client secret key does not start with yourorg-xxxx though it’s just bdTxxxxxx
The client secret key is the Meta API key right?
Is it possible to reset it? I’m 100% sure I’ve copied it correctly?

Hey @Peter_Stavrou – got it, totally possible they changed the format of the client secret key.

Indeed, the client secret key is the Meta API key.

It 404s on both /v0/meta/bases and on /v0/meta/bases/My_BaseID/tables? Because my next suspicion is just that My_BaseID might be wrong (grab this ID from either the /v0/meta/bases endpoint or via examples at airtable.com/api)

Both give me 404 which confirms that BaseID is not wrong.

If you don’t mind using all Python code (and skipping curl), this is some sample code I put together to test the API:

----------------------------------------------
# 2021-02-02 v0.01  runs under Python 3.9 (should work with 3.5+)

     # from airtable import Airtable                 # you might need to include this (I didn't have to)
    from airtable.auth import AirtableAuth

    import requests
    import json

    API_KEY  = 'keyABCDEF01234567'            # your API key
    BASE_KEY  = 'appABCDEF000111'             # base key with the tables to list
    CLIENT_SECRET  = "pythonorg-000123abcdef"  # sample secret for 'python org' company

    auth_info = AirtableAuth( API_KEY )
    meta_hdr  = {"X-Airtable-Client-Secret": CLIENT_SECRET }

    resp = requests.get( "https://api.airtable.com/v0/meta/bases/"+ BASE_KEY +"/tables", 
                         auth=auth_info, headers=meta_hdr)

    table_dict = json.loads( resp.text )

        for tbl in table_dict[ 'tables' ]:
            print( tbl['name'] )
    ----------------------------------------------

I hope that helps to get you started.

jd

----------------------------------------------
# 2021-02-02 v0.01  runs under Python 3.9 (should work with 3.5+)

     # from airtable import Airtable                 # you might need to include this (I didn't have to)
    from airtable.auth import AirtableAuth

    import requests
    import json

    API_KEY  = 'keyABCDEF01234567'            # your API key
    BASE_KEY  = 'appABCDEF000111'             # base key with the tables to list
    CLIENT_SECRET  = "pythonorg-000123abcdef"  # sample secret for 'python org' company

    auth_info = AirtableAuth( API_KEY )
    meta_hdr  = {"X-Airtable-Client-Secret": CLIENT_SECRET }

    resp = requests.get( "https://api.airtable.com/v0/meta/bases/"+ BASE_KEY +"/tables", 
                         auth=auth_info, headers=meta_hdr)

    table_dict = json.loads( resp.text )

        for tbl in table_dict[ 'tables' ]:
            print( tbl['name'] )
    ----------------------------------------------

Thanks heaps jd!

I’m still getting 404 error so I’m guessing there is an issue with my keys.
I’ll follow this up and try your code afterwards.