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:

{
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, by:

• Deburring & removing special and Non-ASCII characters.
• Trim spaces by camelCase’ing
• Prepending an underscore when it starts with a number

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, Fragments, Operation Names and Variables:

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
}
}