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