Skip to main content

Retrieve column names via API

  • April 27, 2020
  • 5 replies
  • 223 views
Y
Forum|alt.badge.img+1

Hi there
is there any option to retrieve column names?
Something similar to Google Sheets:
Method: spreadsheets.values.get
if range A1:X1 provided, then column names are returned.

J

5 replies

D
  • dillingham
  • New Participant
  • May 26, 2020

Make a call to the table index and read the field keys.

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • May 28, 2020

However, if any fields are blank, the API will not return those fields.

D
I
I
  • Ishwar_Asolkar
  • New Participant
  • November 18, 2021

However, if any fields are blank, the API will not return those fields.


If all the fields are blank, then also how to retrieve the field names from the airtable API?

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • November 18, 2021

If all the fields are blank, then also how to retrieve the field names from the airtable API?


You can look into using the Metadata API to get all fields, even if there is no data.

I
M

Hello, I’m sorry to bring a somewhat aging post back to life, but I’m also interested in just being able to pull in the column names. It was mentioned to make a call on the index table. But I don’t see documentation for that. Is the index table something that always exists or something I’d have to create in my database?

Thank you for the help.

B
Terms & ConditionsAccessibility statement