fuxingloh/airtable

A lightweight Java 8 Airtable API client for https://airtable.com/api with all features implemented.

airtable's Issues

setParameter call in QuerySpec.fields method should not use numeric indexes

When adding fields[21] (more than 21 fields), airtable API throws an error such as:

{
	"error": {
		"type": "INVALID_REQUEST_UNKNOWN",
		"message": "Invalid request: parameter validation failed. Check your request data."
	}
}

Don't ask me why this breaks airtable, but according to the airtable api docs, the list of fields params should only include the brackets, not a number. Here's an example from their docs:

For example, to only return data from Event Name and Performers, send these two query parameters:
fields%5B%5D=Fieldname1&fields%5B%5D=Fieldname2
Note: %5B%5D may be omitted when specifying multiple fields, but must always be included when specifying only a single field.

Submitting the requests without the numeric indexes in the fields[] works fine with 21 or more fields in the list.

Fixed here: #6

JDBC Driver

Does Airtable have any free JDBC Driver?
I am looking to integrate DbSchema, a database designer with Airtable.

Additional Functionality in AirtableApplication

Hi,

I've found your API very useful so far. I was wondering if maybe you could consider adding the following functionality to AirtableApplication API:

1. A method to get the name and/or the id of the base. At the moment it seems as though you can only retrieve the base name from the AirtableTable class.

2. List all of the tables in a given base.

3. Count how many records in total are in a given base.

Thanks,

Robert Boylan

Api keys are deprecated in favor of personal tokens

If you or a developer on your team has used an Airtable API key to build API integrations with Airtable, please migrate to using personal access tokens to authenticate your API requests before February 1st 2024. Your API key usage can be directly replaced with a personal access token provided as an Authorization: Bearer header.

In summary, Personal Access Tokens and OAuth are now available (as of January 2023). Airtable API keys will be deprecated on the following timeline:

August 1st, 2023: Users will no longer be able to create new API keys
February 1st, 2024 (next year): Existing API keys cannot be used to access the Airtable API

I tried to replace the api key with the token, but then the code does not work. Could you please extend the authorization with access tokens? 🙏