Skip to main content
Solved

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

  • July 15, 2021
  • 6 replies
  • 384 views

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?

Best answer by acco

Hey Leo,

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

&view=All%20projects%20

6 replies

  • Author
  • New Participant
  • July 15, 2021

Looks like I need the “metadata” API?


Forum|alt.badge.img+6
  • Participating Frequently
  • Answer
  • July 16, 2021

Hey Leo,

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

&view=All%20projects%20

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • July 16, 2021

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


  • Author
  • New Participant
  • July 16, 2021

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!


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • July 16, 2021

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”.


  • Author
  • New Participant
  • July 16, 2021

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.