Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How do I retrieve records from a view rather than all the records from a table?

Topic Labels: API
Solved
Jump to Solution
1061 6
cancel
Showing results for 
Search instead for 
Did you mean: 

I am using GET to retrieve data from a table in a base. Rather than getting all the records, I would like to get the records filtered by a view. My query looks something like this:

https://api.airtable.com/v0/appXXXXXXXXX.../TheTableIWant?fields%5B%5D=FIELD1&fields%5B%5D=FIELD2_ETC

What would the query look like to get a view?

1 Solution

Accepted Solutions
acco
6 - Interface Innovator
6 - Interface Innovator

Hey Leo,

Have you tried adding a query parameter naming the view, like this?

&view=All%20projects%20

See Solution in Thread

6 Replies 6

Looks like I need the “metadata” API?

acco
6 - Interface Innovator
6 - Interface Innovator

Hey Leo,

Have you tried adding a query parameter naming the view, like this?

&view=All%20projects%20

The REST API documentation is located at the link below. As @acco mentioned, you need to use the view parameter:

I could not find what I was looking for in the API docs. @acco’s response gave me what I was looking for. Thanks!

It’s in the exact same location where you got your GET statement from, under “List Records”.

I got my GET by stepping through someone else’s Airtable.swift package. Thanks to you and @acco taking the time to explain this I’m understanding how to use the doc’s.