Hi, sorry if this topic exists, but I can not find the answer I need.
I am trying to build the assistant API, that queries a database from my CRM using client ID.
When I run the code, I get the message " queryClient({“client_id”:“1894991”}) and then I need to input the answer, but it is not returning any data connected to the client ID.
Can Assistant API retrieve data from an external database? What am I missing?
it sounds like you’re trying to use the assistants api function calling to check your crm based on certain queries. Function calling in the assistants api has proven difficult for many you may want to try it with the chat api instead. Is this correct?
Yes, that is correct. I tried with custom GPT, and it works, the Shema is calling API and it is retrieving data. I use this for the proof of concept, but I can not call My GPT into another app if I am not mistaken. So I would need to use the Assistant. I do not need to build a chatbot, but the bridge between my CRM and a customer platform.
I think based on what you said you could use the chat api which also supports function calling. If you’re just looking for a query and response without a lot of additional context, it’s your best bet. If you search the community you’ll find most people avoid using the assistant api as it’s unstable and can be incredibly costly.
Building APIs can sometimes be a maze, so no worries on asking. It sounds like you’re on the right track with querying your CRM database. When I was tinkering with a similar setup, I found that specifying the exact database connection parameters helped a ton.