---
title: "Get daily calendar data"
method: GET
path: "/table/{tableId}/aggregation/calendar-daily-collection"
tags: ["aggregation"]
---

# Get daily calendar data

`GET /table/{tableId}/aggregation/calendar-daily-collection`

Returns records and count distribution across dates based on specified date range and fields

## Path parameters

- `tableId` string, required

## Query parameters

- `viewId` string — Set the view you want to fetch, default is first view. result will filter and sort by view options.
- `filter` string — A filter object for complex query conditions based on fields, operators, and values. Use our visual query builder at https://app.teable.ai/developer/tool/query-builder to build filters.
- `search` union — Search for records that match the specified field and value
  - string[]
  - string[]
  - union[]
    - union
      - string
      - string
      - boolean
- `ignoreViewQuery` union — When a viewId is specified, configure this to true will ignore the view's filter, sort, etc
  - string
  - boolean
- `startDate` string, required
- `endDate` string, required
- `startDateFieldId` string, required
- `endDateFieldId` string, required

## Response `200`

Calendar daily collection for the view

- object
  - `countMap` object, required
  - `records` object[], required
    - `id` string, required — The record id.
    - `name` string — primary field value
    - `fields` object, required — Objects with a fields key mapping fieldId or field name to value for that field.
    - `autoNumber` number — Auto number, a unique identifier for each record
    - `createdTime` string — Created time, date ISO string (new Date().toISOString).
    - `lastModifiedTime` string — Last modified time, date ISO string (new Date().toISOString).
    - `createdBy` string — Created by, user name
    - `lastModifiedBy` string — Last modified by, user name
    - `permissions` object — Permissions for the record
    - `undeletable` boolean — Whether the record is undeletable

---

[API](https://skmtc.net/teable/apis/teable-app.md) · [All operations](https://skmtc.net/teable/apis/teable-app/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/teable/teable-app/versions/7515f3b33d79/schema)