Answered

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

(1) Share

Report

Posted on 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?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Charliemacdmv 235 on at

Like (0)

Report
Copy link

Link copied!

I had to create a custom connector. Create it in Postman and then import to Power apps. You can use the Token in Postman and it works in power apps.

Was this reply helpful? Yes No
Verez88 on at

Like (0)

Report
Copy link

Link copied!

Can you share more details about this connector? How you did it? How I can do it or can you share with me?

Was this reply helpful? Yes No
Verified answer

Charliemacdmv 235 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Verez88 on at

Like (0)

Report
Copy link

Link copied!

Thanks for detailed information, but I was stuck on the step no. 10.
Postman do not want to send the Request, asks me to Create a fork and after confirmation informs about the error.
I'm not sure which step I made a mistake at.

Was this reply helpful? Yes No