Hi, I am using Assistant API for VBA Excel project and currently having issues on getting the message from assistant.
The message and run are successfully created. However, when I tried to get message from the assistant, the message content is always null.
“{
““object””: ““list””,
““data””: [
{
““id””: ““msg_bbbbbbb””,
““object””: ““thread.message””,
““created_at””: 1715911173,
““assistant_id””: ““asst_aaaaaaa””,
““thread_id””: ““thread_aaaaaaa””,
““run_id””: ““run_bbbbbbbb””,
““role””: ““assistant””,
““content””: ,
““attachments””: ,
““metadata””: {}
},
{
““id””: ““msg_aaaaaaa””,
““object””: ““thread.message””,
““created_at””: 1715911166,
““assistant_id””: null,
““thread_id””: ““thread_aaaaaaa””,
““run_id””: null,
““role””: ““user””,
““content””: [
{
““type””: ““text””,
““text””: {
““value””: ““Compare documents on the attachment””,
““annotations””:
}
}
],
““attachments””: [
{
““file_id””: ““file-xxxxxxx””,
““tools””: [
{
““type””: ““file_search””
}
]
},
{
““file_id””: ““file-xxxxxxx””,
““tools””: [
{
““type””: ““file_search””
}
]
}
],
““metadata””: {}
}
],
““first_id””: ““msg_aaaaaaa””,
““last_id””: ““msg_bbbbbbb””,
““has_more””: false
}”
In VBA I am not using stream function, I create message → create run → delay for 10 second → get message list.
Can anyone suggest better approach to use assistant API in VBA excel?