Execute a Message SQL Query

Execute a Message SQL Query activity in the Databricks connector.

Compatibilidad de proyectos

Windows | Multiplataforma

Información general

Descripción	método API	Ruta de la API
Run the SQL that Genie generated for a message and return the result set under statement_response. Requires space_id, conversation_id and message_id.	Publicar	/genie_execute_query/{space_id}/{conversation_id}/{message_id}

Entrada

Parámetro	Descripción	Tipo de datos
Message Id *	ID of the Genie message. For example, 01f0a1b2c3d4e5f6a7b8c9d0e1f2a3b4.	String
Conversation Id *	ID of the Genie conversation. For example, 01f0a1b2c3d4e5f6a7b8c9d0e1f2a3b4.	String
Space Id *	ID of the Genie space. For example, 01f0a1b2c3d4e5f6a7b8c9d0e1f2a3b4.	String

* Required parameter.

Salida

Parámetro	Descripción	Tipo de datos
Statement Response	SQL Statement Execution API response: status, manifest and result.data_array.	object

Nota:

You might see variations in the output depending on where you run the activity. In API workflows and Maestro Flow, a single response object containing all the fields is returned. In RPA workflows, not all fields are exposed, but you can still retrieve them from the exposed response object.