Constructing a multi-field sorting query for Airtable's API

Other Questions Airtable
1

Help with Airtable API sorting query

I’m working on a project that uses Airtable’s API. I need to create a query that sorts data by multiple fields in different directions. Here’s what I’m trying to do:

let sortOptions = [
  { column: 'name', order: 'asc' },
  { column: 'price', order: 'desc' },
  { column: 'type', order: 'asc' }
];

function buildSortQuery(options) {
  let query = '';
  options.forEach((option, index) => {
    query += `&order[${index}][column]=${encodeURIComponent(option.column)}`;
    query += `&order[${index}][direction]=${option.order}`;
  });
  return query;
}

This doesn’t work right. How can I properly encode the URI for multiple sort fields and directions? Any tips or examples would be great. Thanks!

2

I’ve worked extensively with Airtable’s API, and I can confirm that the ‘sort’ parameter is indeed the way to go for multi-field sorting. Here’s a slightly different approach that might be more flexible:

function buildSortQuery(options) {
  return options.reduce((query, option, index) => {
    query += `sort[${index}][field]=${encodeURIComponent(option.column)}&`;
    query += `sort[${index}][direction]=${option.order}`;
    return index < options.length - 1 ? query + '&' : query;
  }, '');
}

This method uses reduce() to build the query string, which can be more efficient for larger datasets. It also handles the trailing ‘&’ issue automatically.

One additional tip: make sure your Airtable base has the appropriate permissions set. Sometimes, sorting issues can be related to access rights rather than query syntax. Always double-check your API key and base permissions if you encounter unexpected behavior.

3

I’ve encountered a similar issue with Airtable’s API. The key is to use the ‘sort’ parameter instead of ‘order’. Here’s a revised version of your function that should work:

function buildSortQuery(options) {
  return options.map((option, index) => 
    `sort[${index}][field]=${encodeURIComponent(option.column)}&` +
    `sort[${index}][direction]=${option.order}`
  ).join('&');
}

This will generate a query string like:

sort[0][field]=name&sort[0][direction]=asc&sort[1][field]=price&sort[1][direction]=desc&sort[2][field]=type&sort[2][direction]=asc

Remember to prepend this with a ‘?’ or ‘&’ depending on whether it’s the first or subsequent parameter in your API call.

4

hey mate, i’ve dealt with this before. try using the sort parameter instead of order. somethin like this:

let query = '&sort[0][field]=name&sort[0][direction]=asc&sort[1][field]=price&sort[1][direction]=desc'

airtable’s api is kinda picky bout the syntax. hope this helps!