Metadata API Python3 Get Request

[Peter_Stavrou]

I’m trying to access the metadata but I keep getting a 404 error.
I have a feeling that the problem is with the headers.

headers = {
"Authorization":"Bearer My_User_API",
"X-Airtable-Client-Secret": "Meta_Secret_Token"
}

response=requests.get("https://api.airtable.com/v0/meta/bases/My_BaseID/tables", headers=headers)

# I also tried
response=requests.get("https://api.airtable.com/v0/meta/bases", headers=headers)

Any ideas?

[acco]

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.

[Peter_Stavrou]

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?

[acco]

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)

[Peter_Stavrou]

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

[JerryD]

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

[Peter_Stavrou]

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.