Airtable Connector Error: API keys are deprecated and can no longer be used.

Like (1) Share

Report

Posted on 12 Feb 2024 15:01:22 by Verez88

As we know, from 2024 Airtable API keys are deprecated and can no longer be used. To continue using Airtable's API, migrate to personal access tokens or OAuth for integrations.

Microsoft Power Automate independent connector do not support OAuth, as it supports API Key option only. Has anyone solved this issue with data integration via PA with AirTable?

All responses (4)

Answers (1)

Verified answer

Charliemacdmv 235 on 12 Feb 2024 at 20:57:03

Like (0)

Report
Re: Airtable Connector Error: API keys are deprecated and can no longer be used.

I can't share mine with you as it has our specific GET URL.

Signup for Postman
Create a collection in Postman
Create a Token in AirTable
Create a URL for the function whether it's GET, POST, etc.
In the Postman Collection Select "NEW"
Then select HTTP request
Enter the GET/POST URL you created from AirTable
Under that section, select Authorization> Bearer
Enter the token you created in that section.
Run it to make sure it works.
Export it.
In Power Apps/Power Automate select custom connector and select Import from postman.
Select the file you just exported.
Fill in all the information including definitions.
One thing to note. Under Security. select API key. Parameter Label is "API Key", Parameter Name is Authorization. Location is Header.
Save the request - test it. When you test it, it will ask for the Token. the toke needs to be written like this. Bearer token#. So Bearer then space then Token Number.
Good Luck.