Forum Discussion
Airtable integration
Hi ferdilda
Please show the code you are using to connect to Airtable. Please show both the query from Postman and what you are using in PQ/PBI.
Hide your API key/token of course.
I presume you are connecting via the API?
Authentication - Airtable Web API
Your request should look something like this
API_Token = "xxxxx", Base_ID = "xxxxx", Table_ID = "xxxxx", GetAPI = Json.Document(Web.Contents("https://api.airtable.com/v0/"&Base_ID&"/"&Table_ID, [Headers = [Authorization="Bearer "&API_Token] ] ))Regards
Phil
Super UserHi ferdilda
Please show the code you are using to connect to Airtable. Please show both the query from Postman and what you are using in PQ/PBI.
Hide your API key/token of course.
I presume you are connecting via the API?
Authentication - Airtable Web API
Your request should look something like this
API_Token = "xxxxx",
Base_ID = "xxxxx",
Table_ID = "xxxxx",
GetAPI = Json.Document(Web.Contents("https://api.airtable.com/v0/"&Base_ID&"/"&Table_ID,
[Headers = [Authorization="Bearer "&API_Token]
]
))
Regards
Phil
Community SupportHi ferdilda
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.
- v-aatheeque
Hi ferdilda
Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.