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

KeyDatatypeRequiredDescription
X-MSTR-ProjectIDstring
X-MSTR-AuthTokenstring