---
title: "Return a data table of all foods and custom items."
method: GET
path: "/food/database-entries/table"
tags: ["food"]
---

# Return a data table of all foods and custom items.

`GET /food/database-entries/table`

## Query parameters

- `filter` string
- `limit` number
- `offset` string
- `order` string
- `created_after` string

## Response `200`

successful operation

- object
  - `has_next` boolean
  - `next` string
  - `rows` FoodDatabaseTableResponseRow[]
    - `created_time` string, date-time, required
    - `definition_type` string
    - `first_report_date` string, date-time — First date of draft report containing this food item
    - `food_name` string, required
    - `is_associated_with_me` boolean
    - `is_custom_item` boolean, required
    - `last_updated_by_user_id` integer
    - `meal_count` integer — Total number of meals containing this food item
    - `option_value_preparation_method` string
    - `option_values` object
    - `recent_meals` RecentMeal[]
      - `meal_id` integer, required
      - `patient_id` integer, required
      - `patient_is_priority` boolean, required
      - `queue_id` integer, required
    - `related_patient_draft_reports` object[]
      - `patient_id` integer
      - `patient_report_id` integer
    - `reviewed_by_user_id` integer
    - `reviewed_time` string, date-time
    - `scraped_by_user_id` integer
    - `scraped_time` string, date-time
    - `status` string, required
    - `triaged_by_user_id` integer
    - `triaged_time` string, date-time
    - `updated_time` string, date-time, required

---

[API](https://skmtc.dev/rxfoodapp/apis/inneranalytics-mnt-server.md) · [All operations](https://skmtc.dev/rxfoodapp/apis/inneranalytics-mnt-server/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/rxfoodapp/inneranalytics-mnt-server/revisions/0703cbbbefe8/schema)
