get_xmlrpc module

GET_XMLRPC

Executes XMLRPC Call.

  • Parameters: p_JSON (str|list) – JSON Parameter.

    • EXA-CONNECTION (str): Exasol Connection

    • URL (str): URL - source of data

    • VERIFY (bool): verify SSL Certificate

    • ENCODING (str): Encoding (default utf8)

    • BODY (str): http body

    • TIMEOUT (float): Timeout in seconds

  • returns: str – JSON String

  • raises RequestException: In case of error.

Examples

Basic Call

1select get_xmlrpc('{"EXA-CONNECTION": "XMLRPC_API", "VERIFY": false, "BODY":"license_info"}');

Advanced Example with Parameters

1select get_xmlrpc('{"EXA-CONNECTION": "XMLRPC_API", "VERIFY": false, "BODY":"st_volume_info {\"params\": {\"vname\": \"LocalArchiveVolume1\"}}"}');

Chained JSON Extraction

1select json_extract(get_xmlrpc('{"EXA-CONNECTION": "XMLRPC_API", "BODY":"db_info"}'), '$.result_output#.name')
2from (
3   select json_extract(get_xmlrpc('{"BODY":"db_list"}'), '$.result_output#') emits(db_name varchar(30))
4);