# Airtable API issues **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [September 4, 2023, 11:30pm UTC](https://community.thunkable.com/t/airtable-api-issues/2577282 "2023-09-04T23:30:03Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\ **Post date:** [September 4, 2023, 11:30pm UTC](https://community.thunkable.com/t/airtable-api-issues/2577282/1 "2023-09-04T23:30:03Z")
I am following a tutorial about accessing my Airtable database from Thunkable and have added Thunkable as a third-party integration from Airtable. After adding the Airtable base in Data Sources, if I click on the base name, I get a table view of the data, but when I try to run the API Get, I get an Authentication\_Required error. ![2023-09-04 19 21 26](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/4/c495296bc2ae33ffbc91a55487dc4e07298304d4.png) Also, if I go into Developers Hub on Airtable and click on the OAuth integrations, it does not show anything. Is there anything I else that I should be doing? Thanks Steve ---
**Author:** ![kizzy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kizzy/32/76421_2.png) [@kizzy](https://community.thunkable.com/u/kizzy)\ **Post date:** [September 4, 2023, 11:39pm UTC](https://community.thunkable.com/t/airtable-api-issues/2577282/2 "2023-09-04T23:39:19Z")
did you ad the base in airtable? from airtable website ---
**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\ **Post date:** [September 5, 2023, 1:28am UTC](https://community.thunkable.com/t/airtable-api-issues/2577282/3 "2023-09-05T01:28:10Z")
Ok, I have figured out the Authorization issue. I put the query in to Postman and it failed there as well. Then I remembered the Personal Access Token and created one and added it to the Headers under the Web API component. Property is Authorization and Value is Bearer {space} {followed by the PAT} So when I run it in Thunkable, I get the JSON response, however I can’t figure out to extract the information that I need to put into the label. The response is { “records”: [ { “id”: “rec2glWuWTcEi8Chg”, “createdTime”: “2023-09-05T00:07:14.000Z”, “fields”: { “Job Title”: “Network Analyst”, “Grade”: “G2” } }, { “id”: “rec3i3ubXuHO2LwRB”, “createdTime”: “2023-09-05T00:07:14.000Z”, “fields”: { “Job Title”: “Technician”, “Grade”: “G1” } } ] } I have tried this ![2023-09-04 21 24 30](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/8/d864c58a533b535e41abd4e58a1b2dbedd75fadf.png) and a few variations - Job Title alone, records, the fields, then Job Title, but they all come back null. Appreciate any assistance. Thanks Steve ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [September 5, 2023, 5:04am UTC](https://community.thunkable.com/t/airtable-api-issues/2577282/4 "2023-09-05T05:04:12Z")
Is there a reason you’re using the API blocks instead of the built-in Data Source blocks? See my response to your other topics here: [Querying an Airtable base - #3 by tatiang](https://community.thunkable.com/t/querying-an-airtable-base/2577247/3). Is it mainly so that you can retrieve data from multiple tables? ---
**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\ **Post date:** [September 5, 2023, 9:51am UTC](https://community.thunkable.com/t/airtable-api-issues/2577282/5 "2023-09-05T09:51:35Z")
Yes, I also want to be able to update the tables automagically from time to time. Understand that this cannot be done with local data sources. Was reading through other thread last night where you go through JSON requests. Will watch the video today. You also mentioned in the thread that you might explain the ability to display data from a JSON request in the Data Viewer List/Grid. Did you ever get around to that? Thanks Steve ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [September 5, 2023, 8:52pm UTC](https://community.thunkable.com/t/airtable-api-issues/2577282/6 "2023-09-05T20:52:27Z")
> [@steve\_synopsis](#): > > You also mentioned in the thread that you might explain the ability to display data from a JSON request in the Data Viewer List/Grid. Did you ever get around to that? Generally, to display an API response in a Data Viewer List, you have to create rows for the JSON data in a local data source which means that you’re looping through the JSON data. But no, I haven’t made a tutorial for that. There are two ways I use Airtable: 1. The built-in Data Source blocks… unless I need complex filtering for the results in which case I use #2 below. 2. The _filterByFormula_ command using the Airtable API ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [December 4, 2023, 8:52pm UTC](https://community.thunkable.com/t/airtable-api-issues/2577282/7 "2023-12-04T20:52:43Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.