{}

{
  "error": "Export failed",
  "message": "The cube does not exist"
}

Export MDX query results to file

Exports the result of a MDX query in CSV or Arrow format to a file in the server or in the cloud.

Local Server Export: Files are exported to directories under the system temporary directory:

Linux/Unix: /tmp/<directoryName>
Windows: C:\Users\<userName>\AppData\Local\Temp\<directoryName>

The target directory must already exist before export. The export will fail if the directory does not exist.

Cloud Export: Cloud exports are supported for configured cloud storage providers. For cloud exports, the directoryName should specify the cloud path (e.g., S3 bucket path).

POST

activeviam

pivot

rest

v10

cube

dataexport

export

{}

{
  "error": "Export failed",
  "message": "The cube does not exist"
}

Body

application/json

The MDX query to run and export options

jsonMdxQuery

object

Show child attributes

outputConfiguration

object

Show child attributes

{key}

any

Response

The export was a success

Empty export success response

Example:

{}

AI Optimizer

Auto-Explain

BI Adapter REST API

Bulk REST API

Content Server REST API

Database REST API

JWT API

Configuration REST API

Data Export

Discovery REST API

Continuous GAQ Query REST API

GAQ Query REST API

Query REST API (V10)

Query REST API (V9)

Database REST API v9

Query History REST API (Experimental)

Version REST API

XMLA API

Export MDX query results to file

Body

Response