---
title: "appends a data view (pivot table) that summarizes and analyzes the data on a given table"
method: POST
path: "/api/notebook/appendDataView"
---

# appends a data view (pivot table) that summarizes and analyzes the data on a given table

`POST /api/notebook/appendDataView`

appends a data view (pivot table) that summarizes and analyzes the data on a given table

## Query parameters

- `notebookId` string, required

## Request body

- object
  - `tableId` string, required — the id of the table you want to use in the data view
  - `columns` object[], required — the columns from the table you want to use to the data view
    - `name` string, required — Column name
    - `aggregation` 'average' | 'max' | 'median' | 'min' | 'span' | 'sum' | 'stddev' — Aggregates the data from the column
    - `round` string — Optional. The number of decimal places it rounds to. Use negative numbers to round to decimal points. Example: to round to the thousanth use "-3". When using dates you can round to "quarter", "year", "month" or "day"

## Response `200`

Ok

- object
  - `result` unknown
  - `notebookErrors` unknown[]
    - unknown

## Changes

> 8 revisions in range; 1 could not be searched.

- **2023-11-27** `c2d57e621a13` — 4 breaking, 2 info
  - the request property `columns` became required
  - the request property `tableId` became required
  - the `columns` request property type/format changed from ``/`` to `array`/``
  - the `tableId` request property type/format changed from ``/`` to `string`/``
  - …2 more
- **2023-11-20** `ee7eb73634d2` — 2 breaking, 1 warning, 2 info
  - the `columns` request property type/format changed from `array`/`` to ``/``
  - the `tableId` request property type/format changed from `string`/`` to ``/``
  - removed the optional property `result` from the response with the `200` status
  - the request property `columns` became optional
  - …1 more
- **2023-11-19** `35c27bb79744` — 3 warning, 2 info
  - removed the optional property `createdElementId` from the response with the `200` status
  - removed the optional property `createdElementName` from the response with the `200` status
  - removed the optional property `createdElementType` from the response with the `200` status
  - added the optional property `notebookErrors` to the response with the `200` status
  - …1 more
- **2023-11-08** `d0f9de8761ec` — 1 breaking, 1 warning
  - added the new required request property `columns`
  - removed the request property `columnNames`
- …earlier changes not shown

[Full history](https://skmtc.dev/decipad/apis/create-and-modify-a-decipad-notebook/changes/api/notebook/appendDataView/post.md)

---

[API](https://skmtc.dev/decipad/apis/create-and-modify-a-decipad-notebook.md) · [All operations](https://skmtc.dev/decipad/apis/create-and-modify-a-decipad-notebook/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/decipad/create-and-modify-a-decipad-notebook/revisions/5f77d79b504f/schema)