Airtable integration

[ferdilda]

I am connecting to an airtable table and getting only a record with nothing in it. It pulls up data in Postman.

[Rufyda]

I'm glad you found a solution! We're here in the community to support each other.

Regards,
Rufyda Rahma | MIE

[PhilipTreacy · Accepted solution]

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

[v-aatheeque]

Hi @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.