Forum Discussion

ferdilda's avatar
ferdilda
Frequent Visitor
9 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
    9 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

     

     

     

4 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    9 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
      Icon for Community Support rankCommunity Support
      9 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
        Icon for Community Support rankCommunity Support
        9 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.