Usage
Querying

Querying

Data Types

Supported by:  

Google Spreadsheets will always return data as String values

BaseQL supports querying most Airtable data types, checkout our StangerThings kitchensink base (opens in a new tab):


{
strangerThings {
checkBox
rating
multiSelect
email
currency
attachments
}
}

Relationships & Nested values

Supported by:  

You can query nested values at an arbitrialy deep level:


{
people(name: "ben") {
name
friends {
name
friends {
name
}
}
}
}

Sanitization

Supported by:  

BaseQL will automatically sanitize table and column names to comply with the GraphQL Specification (opens in a new tab), by:

In addition, BaseQL will sanitize field names which collide with reserved fields. Currently the only reserved field is the id field.

Examples:

  • déjà vu% -> dejaVu
  • 99Ballons -> _99Ballons
  • ID -> _id

Misc GraphQL

Supported by:  

BaseQL currently supports other standard GraphQL features such as Aliases (opens in a new tab), Fragments (opens in a new tab), Operation Names (opens in a new tab) and Variables (opens in a new tab):


query Veganism($country: [String] = ["🇺🇸USA"]) {
vegan: people(vegan: true, country: $country) { ...peopleFields },
nonVegan: people(vegan: false, country: $country) { ...peopleFields }
}
fragment peopleFields on people {
name
vegan
country
friends {
name
vegan
country
}
}