Notifications
Clear all
Topic starter
Seeking assistance with an Airtable API GET request. I've developed a GPT assistant for e-commerce clients designed to recommend products. The workflow enabling the GPT to suggest products is configured using webhooks, OpenAI, searching Airtable records, and making an API call via callin.io.
The webhook captures the user's query, for instance, "I want a blue bag".
The OpenAI module is prompted to convert this query into an Airtable formula. This formula is then used to filter records and identify the best product(s) for the user. The screenshot below illustrates the latter part of the prompting.
Subsequently, the Airtable 'Search Records' module retrieves information from fields for the recommended product. The screenshot displays the module's setup and the values stored in variables. Another screenshot shows how the "result" variable holds the formula generated by the OpenAI module.
This is where I require some assistance. I need help with the URL, as I am encountering a 404 error as shown below.
I have included the 'List Records' URL for my table from the Airtable documentation, appended the "filter by records" parameter to this URL, and also included the "result" variable that stores the formula.
I consulted ChatGPT for assistance. It repeatedly stated that callin.io would automatically ensure the formula value is URL-encoded. I've considered prompting the OpenAI module to convert the formula into a URL-encoded format. I am open to any advice, as I suspect I'm overlooking a critical detail. Any help would be greatly appreciated.
Posted : 05/04/2024 1:17 am
The URL field you've entered is incorrect. It appears you've included the initial part of the URL, which is already provided for you.
Kindly refer to the description situated below the URL field for additional details.
Posted : 05/04/2024 2:07 am
Topic starter
Ahhhhh right, thank you so much!
Posted : 05/04/2024 11:14 am
Topic starter
So here is the new URL.
Although now it comes up with this 403 error.
My Airtable connection is configured using the Personal Access Token option, and I've assigned every possible scope to my personal access token, also including my base.
What am I missing?
Posted : 05/04/2024 11:52 am