# Airtable API fields not showing
**URL:** https://forum.adalo.com/t/airtable-api-fields-not-showing/2192
**Category:** Get Help
**Created:** [June 27, 2020, 5:39pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192 "2020-06-27T17:39:47Z")
**Posts on this page:** 18
**Page:** 1
### Author:  [@jromeo80](https://forum.adalo.com/u/jromeo80)
#### Post date: [June 27, 2020, 5:39pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/1 "2020-06-27T17:39:47Z")
Airtable API is connecting just fine and when I test the connection the fields are all showing the data. Unfortunately, when i pull the collection up, the a couple of the crucial fields I’m looking for are not there. Anybody else experience this problem?
---
### Author:  [@ashley](https://forum.adalo.com/u/ashley)
#### Post date: [June 28, 2020, 10:15pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/2 "2020-06-28T22:15:59Z")
Ensure that there is at least 1 record within that field. Ifthere are no records on that field nothing will come over.
---
### Author:  [@jromeo80](https://forum.adalo.com/u/jromeo80)
#### Post date: [June 28, 2020, 10:31pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/3 "2020-06-28T22:31:06Z")
Thanks Ashley. Every record in airtable has a value in that field that isn’t coming over. Even in the test connection in the api the field is showing up and the values from that field are also showing up in the airtable api documentation code. It’s a weird one.
---
### Author:  [@Ben](https://forum.adalo.com/u/Ben)
#### Post date: [June 30, 2020, 8:41pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/4 "2020-06-30T20:41:59Z")
Could you share what types of fields these are in airtable? Also a screenshot of the api response in the test step would be helpful
---
### Author:  [@jromeo80](https://forum.adalo.com/u/jromeo80)
#### Post date: [July 1, 2020, 1:51am UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/5 "2020-07-01T01:51:18Z")
Hey Ben. Thanks. I have tried multiple ways at it. The original field, and my preferred, is a “Rollup” field. With that said, I have tried doing a “formula” field and also a “number” field. You can see them below showing up with data in the api test run:
“earnings” is the rollup field
“field 38” is a formula field
“field 39” is a number field
I would guess that the next step would be to delete the collection and create it fresh, but I’m concerned about how much stuff that would break on the adalo side since I have made a ton of progress on that end getting it set up using that collection.
---
### Author:  [@jromeo80](https://forum.adalo.com/u/jromeo80)
#### Post date: [July 3, 2020, 2:54pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/6 "2020-07-03T14:54:15Z")
Hey @Ben. Wondering if you had a chance to look at this one. Have a client demo tonight and would love to get this last element in place. Let me know. Thanks!
---
### Author:  [@Ben](https://forum.adalo.com/u/Ben)
#### Post date: [July 7, 2020, 8:02pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/7 "2020-07-07T20:02:45Z")
@jromeo80 we have not been able to re-create this issue in our testing. Did you end up re-adding your external collection?
---
### Author:  [@jromeo80](https://forum.adalo.com/u/jromeo80)
#### Post date: [July 7, 2020, 10:28pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/8 "2020-07-07T22:28:53Z")
Hey Ben,
Didn’t do it. Instead created a new table in the airtable base. Did lookup fields for the stuff that wasn’t coming in and created a collection off of that. Worked perfectly. Hate that I had to do a workaround and create another table in airtable, but the thought of reconnecting everything if I redid the original collection is overwhelming. Lots of work so far off of that.
Other than that though the app is looking and working great though.
Jonathan
---
### Author:  [@ChristopheHK](https://forum.adalo.com/u/ChristopheHK)
#### Post date: [July 8, 2020, 12:45am UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/9 "2020-07-08T00:45:51Z")
I reproduce the problem. In my airtable data, I have one number field, which contains 0 or 1 (all rows in this table have this field set).
The external collection has been set up without any problem, the IsSuperUser field is shoNnik the Json.
But the external collection is built in Adalo without this number field.
What’s weird in that few hours ago, this field was in Adalo, but it has now disappeared. Note that in between, I removed a lookup field from the airtable table (no relation with the disappeared field) and had to rebuilt the external collection to take the change into account.
So the last update of the external collection made the number field disappeared, I assume.
---
### Author:  [@Vuotian](https://forum.adalo.com/u/Vuotian)
#### Post date: [October 23, 2020, 8:39am UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/10 "2020-10-23T08:39:37Z")
I have the same issue here. Worked last week, but now only text fields are coming to adalo. They are fine on the Api test screen. Any idea what has happened?
i dont want to re create
---
### Author:  [@anon78309838](https://forum.adalo.com/u/anon78309838)
#### Post date: [October 26, 2020, 3:04pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/11 "2020-10-26T15:04:20Z")
We have been experiencing some server issues over the course of the last few days. I can only apologise for those issues and I hope this issue is now resolved. Please let me know if it isn’t.
---
### Author:  [@f.guerouali](https://forum.adalo.com/u/f.guerouali)
#### Post date: [February 9, 2021, 1:28am UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/12 "2021-02-09T01:28:15Z")
hey, i have the same problem when connecting API Solr database, not all field are retrieved even when i test the connection all the field are there…
I need to know what is the problem before upgrading my plan
Thanks
---
### Author:  [@bhanu](https://forum.adalo.com/u/bhanu)
#### Post date: [February 9, 2021, 2:09am UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/13 "2021-02-09T02:09:32Z")
@f.guerouali make sure you have atleast one row in Airtable with data in all the fields (preferably first row), this will ensure to get all the fields.
When you don’t have the data in any of the columns during setup, you’ll not see those fields unfortunately. That was my experience.
---
### Author:  [@f.guerouali](https://forum.adalo.com/u/f.guerouali)
#### Post date: [February 9, 2021, 6:56am UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/14 "2021-02-09T06:56:59Z")
Very weird,all the field have value in m’y collection
---
### Author:  [@BackL](https://forum.adalo.com/u/BackL)
#### Post date: [June 11, 2021, 4:03am UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/15 "2021-06-11T04:03:30Z")
BUMP.
I’m having the same issue still. Roll up field that returns int value and appears on external collection response object doesn’t get added as a field.
---
### Author:  [@vino](https://forum.adalo.com/u/vino)
#### Post date: [August 22, 2021, 8:20pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/16 "2021-08-22T20:20:03Z")
> [@jromeo80](#):
>
> when i pull the collection up, the a couple of the crucial fields I’m looking for are not there. Anybody else experience this problem?
Hello, I am having exact same issue, please provide the solution for this matter?
---
### Author:  [@vino](https://forum.adalo.com/u/vino)
#### Post date: [August 22, 2021, 8:21pm UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/17 "2021-08-22T20:21:29Z")
Hello, no this issue still continue. Airtable data isn’t showing.
---
### Author:  [@JL\_LJ](https://forum.adalo.com/u/JL_LJ)
#### Post date: [August 25, 2021, 10:13am UTC](https://forum.adalo.com/t/airtable-api-fields-not-showing/2192/18 "2021-08-25T10:13:53Z")
Hi Vino,
Sometimes, I ran the API setup multiple times (Create the external collection or just Run Test again) and the fields appear. It is a very weird bug from Airtable/Adalo. Also make sure every column has data to read.