Forum Discussion

ferdilda's avatar
ferdilda
Frequent Visitor
8 months ago
Solved

Airtable integration

I am connecting to an airtable table and getting only a record with nothing in it. It pulls up data in Postman.
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    8 months ago

    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

     

     

     

PhilipTreacy's avatar
PhilipTreacy
Super User
8 months ago

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's avatar
v-aatheeque
Community Support
8 months ago

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's avatar
    v-aatheeque
    Community Support
    8 months ago

    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.