
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 18, 2022 10:06 AM
Hello, completely new to Airtable and fairly new on dealing with APIs. I was super excited that I was able to get an API connection to work and successfully pull the data I needed a few weeks ago. Today I went back because I forgot to include two fields in the original pull of the data. I amended my Body JSON query to include these two new fields and when I use the “Open Field Mapping” button in the Data Fetcher app everything actually looks fine (it’s pulling in the new fields). But, when I run the query, I receive the following warning with the yellow exclamation:
Can’t update field: invalid field config. Failed schema validation: symbol is not included in the .(type=number).options schema
Because I’m fairly new both APIs and Airtable, is someone able to give me a “laymans” explanation of what I can search for to troubleshoot this warning. Interestingly, while I see Airtable successfully pulling in the two new fields (and with the right data populating), when I go to the actual table and view I am populating with the data, the fields are there but none of the data is populated.
Any threads of help very much appreciated!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 18, 2022 06:36 PM
Welcome to the community, @Justin_Eppley!
It sounds like you’re trying to bring in symbols into a number field, which isn’t allowed.
I’m assuming that your symbol is the dollar sign, in which case you could switch your number field to a currency field.
Although a better catch-all solution would be to just switch your field to a text field, and then you can covert it later to a more appropriate field type.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 18, 2022 06:36 PM
Welcome to the community, @Justin_Eppley!
It sounds like you’re trying to bring in symbols into a number field, which isn’t allowed.
I’m assuming that your symbol is the dollar sign, in which case you could switch your number field to a currency field.
Although a better catch-all solution would be to just switch your field to a text field, and then you can covert it later to a more appropriate field type.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 18, 2022 11:08 PM
@ScottWorld Thanks for the welcome and for the solution. I took the advice of just using the catch-all but only after starting from scratch in a new table. The thinking is that I’ll just change the field types then in the program I’m actually bringing the data into after Airtable so hopefully I won’t get an error when I go back. Seems like I shouldn’t based on the logic. Thanks again!
