Hi I'm creating a databricks app and I want to show genie space conversations messages both from users and genie.
This is the api i'm using : GET /api/2.0/genie/spaces/{space_id}/conversations/{conversation_id}/messages/{message_id}
Get conversation message | Genie API | REST API reference | Azure Databricks
I could get user questions but I can't really get genie's response. Only things I get is query data which I don't really need. So far best I could do was to use query title. But on messages that didn't use SQL query it doesn't even show any response from genie.
Here is an example of data I got :
{
"id":"asfsadf21312",
"space_id":"asdf123123",
"conversation_id":"sdaf123123",
"user_id":1231241235,
"created_timestamp":1782291337250,
"last_updated_timestamp":1782291413342,
"status":"COMPLETED",
"content":"Describe this dataset and the important KPIs/categories I can analyze",
"attachments":[
{
"query":{
"title":"Stock breakdown by logistic status",
"query":"\nSELECT \n MEASURE(`Total Stock`) AS total_stock",
"statement_id":"01f16fasasdsadf3",
"thoughts":[
{
"thought_type":"THOUGHT_TYPE_DATA_SOURCING",
"content":"stocks"
}
]
},
"attachment_id":"12312sadasdf"
}
],
"auto_regenerate_count":0,
"message_id":"123asf"
}
According to API docs it should also return text object but I haven't gotten one. Is there any other way around that I could get the genie's actual response that I see on databricks UI?
Any help would be appreciated!!