Create multi-table dataset
POST {{baseUrl}}/api/datasets/models
Request Body
{"name"=>"Test Customer_Order_Details", "description"=>"Customer purchase information", "folderId"=>"{{publicReportsFolderId}}", "tables"=>[{"name"=>"Customer", "columnHeaders"=>[{"name"=>"customer_id", "dataType"=>"DOUBLE"}, {"name"=>"customer_name", "dataType"=>"STRING"}]}, {"name"=>"Order", "columnHeaders"=>[{"name"=>"customer_id", "dataType"=>"DOUBLE"}, {"name"=>"order_date", "dataType"=>"DATETIME"}, {"name"=>"price", "dataType"=>"DOUBLE"}]}], "metrics"=>[{"name"=>"Price", "expressions"=>[{"tableName"=>"Order", "columnName"=>"price"}]}], "attributes"=>[{"name"=>"Customer", "attributeForms"=>[{"category"=>"ID", "expressions"=>[{"tableName"=>"Customer", "columnName"=>"customer_id"}, {"tableName"=>"Order", "columnName"=>"customer_id"}]}, {"category"=>"DESC", "expressions"=>[{"tableName"=>"Customer", "columnName"=>"customer_name"}]}]}, {"name"=>"Order_Date", "attributeForms"=>[{"category"=>"ID", "expressions"=>[{"tableName"=>"Order", "columnName"=>"order_date"}]}]}]}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
X-MSTR-ProjectID | string | ||
X-MSTR-AuthToken | string |