2. PHPRunner General questions
  3. [SOLVED] rest api connection phprunner + airtable
This topic is locked
[SOLVED]

rest api connection phprunner + airtable

 		2/26/2024 4:55:31 AM
PHPRunner General questions
J
 Jan author

Everyone, a few years ago I built an application with phprunner that allowed me to read-populate an "airtable" table. Worked great. But since February 2024, airtable has changed the API connection from "API key" to "0auth 2.0 - user"
this means that the program I created no longer works. In the meantime, I have created a token in "airtable" ("client-ID" + "client-secret"). and made the adjustment in prprunner, but I can't get the program to work. In my opinion, the example on the link below is no longer usable:
https://xlinesoft.com/blog/2021/06/23/working-with-airtables-rest-api/

Does anyone have experience with the new airtable method, how should you make the connection in phprunner?
Admin 2/27/2024

The built-in REST API connection supports "Oauth 2.0 - user" method.

J
 		Jan author 2/28/2024

That is indeed correct, I use "auth0 2.0 - user" see screenshots, unfortunately I can no longer connect to airtable, what am I doing wrong?

img alt

img alt

this error appears:

img alt

Admin 2/29/2024

You need to make sure that you specified correct client_id and other credentials. Also, you need to make sure you properly configured redirect_uri of your application on Airtable's side. Refer to PHPRunner's manual that explains how to figure out the correct callback URL: https://xlinesoft.com/phprunner/docs/rest-api-connections.htm
J
 		Jan author 7/10/2024

After a few months of intensive searching I found the solution to the problem.
It is enough to keep all parameters, but only a Personal access token ( PAT ) needs to be created in the airtable account. The token number needs to be added in phprunner, see screenshots below:

img alt

OLD : Bearer keyXXXXXXXXXXXXXX

New: Bearer patXXXXXXXX.XXXXXXXXXXXXXXXX

img alt