Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Airtable.get returning empty records (record exists in airtable but returning [])

Topic Labels: API
2322 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dilraj_Somel
5 - Automation Enthusiast
5 - Automation Enthusiast

I looked at this as well, but not sure if it’s the same problem

I haven’t changed my API in a long time, but for some reason when I do the following get:

returned_dictionary = at.get(unit_history, view='Default', filter_by_formula = search_term)

Where search_term is equal to: '{Unit I.D.} = "510040000751373238393835"'

And here is the data in the TABLE and the CORRECT COLUMN. (Click the image to see the record.)
image.png

but returned_dictionary just returns OrderedDict([('records', [])])

1 Reply 1

I would guess that the view, “Default” has changed or been removed. Try changing this:

returned_dictionary = at.get(unit_history, view='Default', filter_by_formula = search_term)

to this

returned_dictionary = at.get(unit_history, view='', filter_by_formula = search_term)