I’m building a food ordering bot on Botpress and my menu data is stored in Supabase (in the menu_items table with fields like id, vendor_id, name, price). I want the bot to fetch the menu for a given vendor and show it to the user in chat so they can pick items.
Can you help me:
Write the Supabase query to get the menu by vendor_id.
Format the response (JSON or array) in a way Botpress can display as options.
Show how to pass the selected item back into the bot flow.”