Download a model as a live-formula Excel workbook

GET/api/v1/dashboards/{dashboard_id}/model/workbook

Stream the model as an .xlsx whose computed cells hold real Excel formulas — subtotals, roll-forwards and assumption references stay live, so an analyst can change a rate in the Assumptions sheet and watch every dependent line move.

This is deliberately separate from POST /{dashboard_id}/export. That route serialises stored widget snapshots and would flatten every formula to a frozen number; this one re-evaluates the spec against current ledger data and writes the formulas themselves.

Operation ID: download_model_workbook_api_v1_dashboards__dashboard_id__model_workbook_get·View as markdown·OpenAPI slice

Authentication

Bearer token authentication. Pass your DayZero API token in the Authorization header and the target business UUID in x-business-id.

Parameters

Path

dashboard_idstringrequired

Responses

200Successful Response

400Bad Request - Invalid input

401Unauthorized - Authentication required

403Forbidden - Insufficient permissions

404Not Found - Resource does not exist

422Validation Error

Schema: HTTPValidationError

detailarray · ValidationErrorValidationError

5 fields

locarray · string | integerrequired
msgstringrequired
typestringrequired
inputobject
ctxobject

Code samples

GET/api/v1/dashboards/{dashboard_id}/model/workbook

bash

curl -X GET 'https://api.ondayzero.com/api/v1/dashboards/{dashboard_id}/model/workbook' \
  -H 'Authorization: Bearer dz_your_token' \
  -H 'x-business-id: YOUR_BUSINESS_ID'