Execute a Message SQL Query

Execute a Message SQL Query activity in the Databricks connector.

Projektkompatibilität

Windows | Plattformübergreifend

Überblick

Beschreibung	API-Methode	API-Pfad
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.	Posten	/genie_execute_query/{space_id}/{conversation_id}/{message_id}

Eingabe

Parameter	Beschreibung	Datentyp
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.

Ausgabe

Parameter	Beschreibung	Datentyp
Statement Response	SQL Statement Execution API response: status, manifest and result.data_array.	object

Hinweis:

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.