Export an Excel File (XLSX)

post/datamart.exportdata/xlsx

Downloads an XLSX file. The returned file contains all definitions (meta) and the data. This is useful for importing the Data Source, Datamart, or Data Feed definitions + data in some other instance or partition.

Securitybasic or X-PriceFx-jwt
Request
query Parameters
timeout
string
Default: "60"

Set this parameter to override the default timeout (60 seconds) of the query. The maximum allowed timeout is 300 seconds. The default timeout value and the maximum timeout value can be configured in the backend. Setting higher timeout can be useful, for example, when a query takes long time (e.g., when processing large tables).

Example: timeout=20
Request Body schema: application/json
required
object
fieldCollections
required
Array of strings
sanitize
required
boolean
Responses
200

OK - returns the XLSX file (binary data): Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Request samples
application/json
{
  • "data": {
    • "fieldCollections": [
      • "DMDS.Transactions"
      ],
    • "sanitize": true
    }
}