Skip to main content

Hello.


I am really new to the Airtable API and for some reason connecting the API this way did not work-



    at = airtable.Airtable('Base_Key', 'Airtable_Key')


But I got it working this way -





get_url = ‘https://api.airtable.com/v0/BASE_ID/TABLE_NAME’


get_headers = {


‘Authorization’: ‘Bearer API_KEY’ }



Response = requests.get(get_url, headers=get_headers)


Response_Table = Response.json()





However, this fetches only the first 100 records and am reading about offset and pagination but I am unable to figure how to incorporate it into this code.



Thank you for the time!

Update :


I am trying this way -



get_url = 'https://api.airtable.com/v0/appXXXXXXXXXX/TABLE_NAME'


get_headers = {


    'Authorization': 'Bearer keyXXXXXXXXX' ,


    'Offset' : 'itrXXXXXXX/recXXXXXXX'


}





try :


    Response= requests.get(get_url, headers=get_headers})


    Response_Table = Response.json()


    #print(Response_Table)


    


except error as e:


    print(e)


And I get the error :



{'error': {'type': 'INVALID_OFFSET_VALUE', 'message': 'The value of offset ‘itrXXXXXX/recXXXXXX’ is invalid'}}



I would appreciate any leads. Thank you!

Update :


I am trying this way -



get_url = 'https://api.airtable.com/v0/appXXXXXXXXXX/TABLE_NAME'


get_headers = {


    'Authorization': 'Bearer keyXXXXXXXXX' ,


    'Offset' : 'itrXXXXXXX/recXXXXXXX'


}





try :


    Response= requests.get(get_url, headers=get_headers})


    Response_Table = Response.json()


    #print(Response_Table)


    


except error as e:


    print(e)


And I get the error :



{'error': {'type': 'INVALID_OFFSET_VALUE', 'message': 'The value of offset ‘itrXXXXXX/recXXXXXX’ is invalid'}}



I would appreciate any leads. Thank you!


After a lot of issues, I found this solution.


Posting it for anyone else facing the same problem.





global offset


offset = '0'


result = t]





while True :


    url = "https://api.airtable.com/v0/BASE_ID/TABLE_NAME"


    querystring = {


        "view":"Published View",


        "api_key":"YOUR_KEY",


        "offset": offset}





    try :


        response= requests.get(url, params=querystring)


        response_Table = response.json()


        records = list(response_Tablea'records'])


        result.append(records)


        #print(recordso0]s'id'] , len(records))


    


        try : 


            offset = response_Tablea'offset']


            #print(offset)


            


        except Exception as ex:


            #print(ex , offset)


            break


    


    except error as e:


        print(e)




Thank you!

Reply


Terms & Conditions