I'm attempting to build an 'ai-powered search' that will match a user's text query (phrase, statement, question, etc) with companies from one of my databases in xano.
(I have detailed descriptions and descriptor tags for every company record in the database)
The workflow I'm trying to set up is as follows:
User inputs [text] in search bar -> API endpoint runs with the [text] as the input-> Query all records from a xano database -> External API request to OpenAI -> Use of chat completion or embeddings to match & rank within the queried records from xano -> Final response is several records from the database/collection that match.
I'm having difficulty creating the logic to use OpenAI's API to match a user's search input among all the records from a database query.