Skip to main content

Hello Guys! I need some help here, I am using javascript fetch call to get values from airtable, I want Specific field Values using filterByFormula filter…

I want only those fields where field name {TaskDate} = CurrentDate and field name {FK_UserUsageID} = PK_UserUsageID…

I see many topics about filterByFormula but i can’t understand them because of the high level formulas using in them. I try code:


fetch(airtableURL + baseInfo + tblSchedule + apikey+"?filterByFormula=AND({TaskDate} = “+ CurrentDate +”,{FK_UserUsageID} = “+PK_UserUsageID+”)")


  .then(res => res.json())



  .then(res => {



    console.log(res)

})


but response is:


Object {

“error”: Object {

“message”: “Authentication required”,

“type”: “AUTHENTICATION_REQUIRED”,

},

}


I also use my apikey and all that needed. Please figure out my mistakes and tell me the solution.

Thanks in advance…

Hi @Usama_Khalid - in the API documentation for your base you will see an authentication section. From here it notes:


You can authenticate to the API by providing your API key in the HTTP authorization bearer token header. Alternatively, a slightly lower-security approach is to provide your API key with the api_key query parameter.


So you can do it directly in the URL, but it would take the form:


https://api.airtable.com/v0/YOUR_BASE_ID/Table?api_key=YOUR_API_KEY&filterByFormula......


So, note that the api_key param is a query param, i.e. after the ?


It is not clear from your code, but it looks like the api_key is before the query param, so this could be the issue.


The error message is around the authorisation, not the filter by formula.

Reply


Terms & Conditions