---
title: "Get patient's daily water and meal consumption data for multiple dates within search query, max of 31 days."
method: GET
path: "/patients/{patient_id}/daily_consumptions"
tags: ["daily consumption"]
---

# Get patient's daily water and meal consumption data for multiple dates within search query, max of 31 days.

`GET /patients/{patient_id}/daily_consumptions`

If some days' reports are missing in the database, those dates will be missing in response. At least either date_since or date_until needs to be provided.

## Path parameters

- `patient_id` integer, required

## Query parameters

- `date_since` string
- `date_until` string
- `size` integer
- `order_by` 'asc' | 'desc'

## Response `200`

successful operation

- DailyConsumptionQueryResponse
  - `more_data` boolean, required
  - `results` DailyConsumptionResponse[], required
    - `log_date` string, required — calendar date in format YYYY-MM-DD
    - `meals` MealResponse[], required
      - `created_by_user_id` integer, nullable
      - `id` integer, required
      - `is_deleted` boolean
      - `last_updated_by_user_id` integer, nullable
      - `meal_date` string, required — calendar date in format YYYY-MM-DD
      - `meal_items` MealItemResponse[], required
        - `addons` string[], required
        - `audio_photo_id` integer, nullable
        - `base_food_name` string
        - `calcium_mg` number, nullable
        - `calculated_servings` number
        - `carbohydrate_g` number, required
        - `cc_columns` CcColumnsRequest
          - `cc_added_sugars` boolean, nullable
          - `cc_additives` boolean, nullable
          - `cc_beverage` boolean, nullable
          - `cc_calcium` boolean, nullable
          - `cc_complexcarbs` boolean, nullable
          - `cc_composite_dish` boolean, nullable
          - `cc_cooked` boolean, nullable
          - `cc_fish` boolean, nullable
          - `cc_fried` boolean, nullable
          - `cc_fruit` boolean, nullable
          - `cc_gluten_free` boolean, nullable
          - `cc_grains` boolean, nullable
          - `cc_healthy_fat` boolean, nullable
          - `cc_high_fiber` boolean, nullable
          - `cc_legume` boolean, nullable
          - `cc_meat` boolean, nullable
          - `cc_non_meat_animal_protein` boolean, nullable
          - `cc_nuts_seeds` boolean, nullable
          - `cc_omega_three` boolean, nullable
          - `cc_plant_based` boolean, nullable
          - `cc_plant_based_whole` boolean, nullable
          - `cc_plant_protein` boolean, nullable
          - `cc_pork` boolean, nullable
          - `cc_poultry` boolean, nullable
          - `cc_processed` boolean, nullable
          - `cc_protein` boolean, nullable
          - `cc_raw` boolean, nullable
          - `cc_redmeat` boolean, nullable
          - `cc_shellfish` boolean, nullable
          - `cc_simplecarbs` boolean, nullable
          - `cc_standalone_food` boolean, nullable
          - `cc_sugar_free` boolean, nullable
          - `cc_sugary_beverage` boolean, nullable
          - `cc_supplement` boolean, nullable
          - `cc_ultraprocessed` boolean, nullable
          - `cc_unhealthy_fat` boolean, nullable
          - `cc_vegetable` boolean, nullable
          - `cc_whole` boolean, nullable
          - `cc_whole_foods` boolean, nullable
        - `cc_servings` CcServingsResponse, nullable — Servings-weighted CC values. Keys match `CcColumnsRequest` fields. Values are derived from calculated servings (clamped to 0-5, rounded to 0.1) and the corresponding boolean CC flag, matching the `health_data_table` nutrients aggregation semantics for `cc_*` fields.
        - `cholesterol_mg` number, nullable
        - `created_by_user_id` integer, nullable
        - `created_time` string, date-time, required
        - `custom_addons` MealItemCustomAddonResponse[], nullable
          - `calculated_servings` number, nullable
          - `carbohydrate_g` number
          - `cc_columns` CcColumnsRequest
            - `cc_added_sugars` boolean, nullable
            - `cc_additives` boolean, nullable
            - `cc_beverage` boolean, nullable
            - `cc_calcium` boolean, nullable
            - `cc_complexcarbs` boolean, nullable
            - `cc_composite_dish` boolean, nullable
            - `cc_cooked` boolean, nullable
            - `cc_fish` boolean, nullable
            - `cc_fried` boolean, nullable
            - `cc_fruit` boolean, nullable
            - `cc_gluten_free` boolean, nullable
            - `cc_grains` boolean, nullable
            - `cc_healthy_fat` boolean, nullable
            - `cc_high_fiber` boolean, nullable
            - `cc_legume` boolean, nullable
            - `cc_meat` boolean, nullable
            - `cc_non_meat_animal_protein` boolean, nullable
            - `cc_nuts_seeds` boolean, nullable
            - `cc_omega_three` boolean, nullable
            - `cc_plant_based` boolean, nullable
            - `cc_plant_based_whole` boolean, nullable
            - `cc_plant_protein` boolean, nullable
            - `cc_pork` boolean, nullable
            - `cc_poultry` boolean, nullable
            - `cc_processed` boolean, nullable
            - `cc_protein` boolean, nullable
            - `cc_raw` boolean, nullable
            - `cc_redmeat` boolean, nullable
            - `cc_shellfish` boolean, nullable
            - `cc_simplecarbs` boolean, nullable
            - `cc_standalone_food` boolean, nullable
            - `cc_sugar_free` boolean, nullable
            - `cc_sugary_beverage` boolean, nullable
            - `cc_supplement` boolean, nullable
            - `cc_ultraprocessed` boolean, nullable
            - `cc_unhealthy_fat` boolean, nullable
            - `cc_vegetable` boolean, nullable
            - `cc_whole` boolean, nullable
            - `cc_whole_foods` boolean, nullable
          - `cc_servings` CcServingsResponse, nullable — Servings-weighted CC values. Keys match `CcColumnsRequest` fields. Values are derived from calculated servings (clamped to 0-5, rounded to 0.1) and the corresponding boolean CC flag, matching the `health_data_table` nutrients aggregation semantics for `cc_*` fields.
          - `custom_item` boolean, nullable
          - `energy_kcal` number
          - `fat_g` number
          - `fiber_g` number
          - `food_image_url` string, nullable, required
          - `food_name` string, required
          - `food_name_translations` object, nullable, required
          - `id` integer
          - `is_foundational_item` boolean — Derived from the resolved food ontology; true for structural container items that do not contribute numeric CC servings.
          - `netcarb_g` number
          - `nutrient_overrides` NutrientOverrideCollection
            - `aa_patient` NutrientOverridesResponse
              - …
            - `bb_reviewer` NutrientOverridesResponse
              - …
            - `cc_external` NutrientOverridesResponse
              - …
            - `dd_estimate` NutrientOverridesResponse
              - …
            - `ee_validation` NutrientOverridesResponse
              - …
          - `preparation_method` '' | 'homemade' | 'restaurant' | 'cpg' | 'store_bought' | 'other'
          - `protein_g` number
          - `rxfood_id` string, nullable
          - `serving_unit_amount` number, required
          - `serving_unit_label` string, required
          - `serving_unit_label_translations` object, nullable, required
          - `servings` number, required
          - `source_meal_id` integer, nullable — meal id the row was copied from when logging from recent items
          - `source_meal_item_custom_addon_id` integer, nullable — custom addon id the row was copied from when logging from recent items
          - `source_meal_item_id` integer, nullable — meal item id the row was copied from when logging from recent items
        - `custom_item` boolean, nullable
        - `custom_item_source` string, nullable
        - `custom_item_source_id` string, nullable
        - `custom_nutrient_estimates` NutrientEstimatesRequest
          - `added_sugars_g` number, nullable
          - `alcohol_g` number, nullable
          - `caffeine_mg` number, nullable
          - `calcium_mg` number, nullable
          - `carbohydrate_g` number, nullable
          - `cholesterol_mg` number, nullable
          - `choline_mg` number, nullable
          - `energy_kcal` number, nullable
          - `fat_g` number, nullable
          - `fattyacids_totalmonounsaturated_g` number, nullable
          - `fattyacids_totalpolyunsaturated_g` number, nullable
          - `fattyacids_totalsaturated_g` number, nullable
          - `fattyacids_totaltrans_g` number, nullable
          - `fiber_g` number, nullable
          - `folate_dfe_ug` number, nullable
          - `grams_per_cubic_inch` number, nullable
          - `insoluble_dietary_fiber_g` number, nullable
          - `iron_mg` number, nullable
          - `magnesium_mg` number, nullable
          - `netcarb_g` number, nullable
          - `niacin_mg` number, nullable
          - `omega_three_fatty_acids_g` number, nullable
          - `pantothenic_acid_mg` number, nullable
          - `phosphorus_mg` number, nullable
          - `polyols_g` number, nullable
          - `potassium_mg` number, nullable
          - `protein_g` number, nullable
          - `riboflavin_mg` number, nullable
          - `selenium_mcg` number, nullable
          - `sodium_mg` number, nullable
          - `soluble_dietary_fiber_g` number, nullable
          - `sugars_g` number, nullable
          - `thiamin_mg` number, nullable
          - `vitamin_a_iu` number, nullable
          - `vitamin_a_rae_ug` number, nullable
          - `vitamin_b12_ug` number, nullable
          - `vitamin_b6_mg` number, nullable
          - `vitamin_c_mg` number, nullable
          - `vitamin_d2d3_ug` number, nullable
          - `vitamin_d_iu` number, nullable
          - `vitamin_e_mg` number, nullable
          - `vitamin_k_ug` number, nullable
          - `water_g` number, nullable
          - `zinc_mg` number, nullable
        - `energy_kcal` number, required
        - `extra_addons` string[]
        - `fat_g` number
        - `fiber_g` number
        - `food_name` string, required
        - `food_name_alias` string, nullable
        - `food_name_alias_translations` object, nullable
        - `food_name_translations` object, nullable, required
        - `food_ontology` string[], nullable
        - `food_photo_url` string, nullable, required
        - `food_replacement_name` string, nullable
        - `ghg_equivalent_kg` number, nullable
        - `glycemic_load` string, nullable
        - `grams_per_cubic_inch` number, nullable
        - `id` integer, required
        - `is_foundational_item` boolean — Derived from the resolved food ontology; true for structural container items that do not contribute numeric CC servings.
        - `k_level` string, nullable
        - `last_updated_by_user_id` integer, nullable
        - `meal_audio_url` string, nullable
        - `meal_nlp_phrase` string, nullable
        - `meal_photo_id` integer, nullable
        - `meal_photo_url` string, nullable
        - `net_serving_size_g` number
        - `netcarb_g` number
        - `note` string, nullable
        - `nutrient_overrides` NutrientOverrideCollection
          - `aa_patient` NutrientOverridesResponse
            - `cc_columns` CcColumnsRequest
              - …
            - `created_time` string, date-time, required
            - `metadata` object, nullable
            - `nutrients` NutrientEstimatesRequest
              - …
            - `ontology` FoodOntologyVTO
              - …
            - `source_id` string, required
            - `source_name` 'patient' | 'reviewer' | 'external' | 'estimate' | 'validation', required
            - `updated_time` string, date-time, required
          - `bb_reviewer` NutrientOverridesResponse
            - `cc_columns` CcColumnsRequest
              - …
            - `created_time` string, date-time, required
            - `metadata` object, nullable
            - `nutrients` NutrientEstimatesRequest
              - …
            - `ontology` FoodOntologyVTO
              - …
            - `source_id` string, required
            - `source_name` 'patient' | 'reviewer' | 'external' | 'estimate' | 'validation', required
            - `updated_time` string, date-time, required
          - `cc_external` NutrientOverridesResponse
            - `cc_columns` CcColumnsRequest
              - …
            - `created_time` string, date-time, required
            - `metadata` object, nullable
            - `nutrients` NutrientEstimatesRequest
              - …
            - `ontology` FoodOntologyVTO
              - …
            - `source_id` string, required
            - `source_name` 'patient' | 'reviewer' | 'external' | 'estimate' | 'validation', required
            - `updated_time` string, date-time, required
          - `dd_estimate` NutrientOverridesResponse
            - `cc_columns` CcColumnsRequest
              - …
            - `created_time` string, date-time, required
            - `metadata` object, nullable
            - `nutrients` NutrientEstimatesRequest
              - …
            - `ontology` FoodOntologyVTO
              - …
            - `source_id` string, required
            - `source_name` 'patient' | 'reviewer' | 'external' | 'estimate' | 'validation', required
            - `updated_time` string, date-time, required
          - `ee_validation` NutrientOverridesResponse
            - `cc_columns` CcColumnsRequest
              - …
            - `created_time` string, date-time, required
            - `metadata` object, nullable
            - `nutrients` NutrientEstimatesRequest
              - …
            - `ontology` FoodOntologyVTO
              - …
            - `source_id` string, required
            - `source_name` 'patient' | 'reviewer' | 'external' | 'estimate' | 'validation', required
            - `updated_time` string, date-time, required
        - `nutrition_response` UsdaNutritionResponse
          - `acetic_acid_g` number, nullable
          - `added_sugars_g` number, nullable
          - `alanine_g` number, nullable
          - `alcohol_g` number, nullable
          - `alpha_linolenic_acid_g` number, nullable
          - `alpha_tocopherol_mg` number, nullable
          - `arginine_g` number, nullable
          - `ash_g` number, nullable
          - `aspartic_acid_g` number, nullable
          - `beta_sitosterol_mg` number, nullable
          - `beta_tocopherol_mg` number, nullable
          - `caffeine_mg` number, nullable
          - `calcium_mg` number, nullable
          - `campesterol_mg` number, nullable
          - `carbohydrate_g` number, nullable
          - `carotene_alpha_ug` number, nullable
          - `carotene_beta_ug` number, nullable
          - `cholesterol_mg` number, nullable
          - `choline_mg` number, nullable
          - `chromium_ug` number, nullable
          - `citric_acid_g` number, nullable
          - `copper_mg` number, nullable
          - `cryptoxanthin_beta_ug` number, nullable
          - `cystine_g` number, nullable
          - `delta_tocopherol_mg` number, nullable
          - `energy_kcal` number, nullable
          - `energy_kj` number, nullable
          - `erythritol_g` number, nullable
          - `fat_g` number, nullable
          - `fattyacid_10_0_g` number, nullable
          - `fattyacid_12_0_g` number, nullable
          - `fattyacid_14_0_g` number, nullable
          - `fattyacid_14_1_g` number, nullable
          - `fattyacid_15_0_g` number, nullable
          - `fattyacid_15_1_g` number, nullable
          - `fattyacid_16_0_g` number, nullable
          - `fattyacid_16_1_g` number, nullable
          - `fattyacid_17_0_g` number, nullable
          - `fattyacid_17_1_g` number, nullable
          - `fattyacid_18_0_g` number, nullable
          - `fattyacid_18_1_g` number, nullable
          - `fattyacid_18_2_g` number, nullable
          - `fattyacid_18_3_g` number, nullable
          - `fattyacid_18_4_g` number, nullable
          - `fattyacid_20_0_g` number, nullable
          - `fattyacid_20_1_g` number, nullable
          - `fattyacid_20_4_g` number, nullable
          - `fattyacid_20_5_n3_g` number, nullable
          - `fattyacid_22_0_g` number, nullable
          - `fattyacid_22_1_g` number, nullable
          - `fattyacid_22_5_n3_g` number, nullable
          - `fattyacid_22_6_n3_g` number, nullable
          - `fattyacid_24_0_g` number, nullable
          - `fattyacid_24_1_g` number, nullable
          - `fattyacid_4_0_g` number, nullable
          - `fattyacid_6_0_g` number, nullable
          - `fattyacid_8_0_g` number, nullable
          - `fattyacids_totalmonounsaturated_g` number, nullable
          - `fattyacids_totalpolyunsaturated_g` number, nullable
          - `fattyacids_totalsaturated_g` number, nullable
          - `fattyacids_totaltrans_g` number, nullable
          - `fattyacids_trans_monoenoic_g` number, nullable
          - `fattyacids_trans_polyenoic_g` number, nullable
          - `fiber_g` number, nullable
          - `fluoride_ug` number, nullable
          - `folate_dfe_ug` number, nullable
          - `folate_food_ug` number, nullable
          - `folate_total_ug` number, nullable
          - `folic_acid_ug` number, nullable
          - `fructose_g` number, nullable
          - `galactose_g` number, nullable
          - `gamma_tocopherol_mg` number, nullable
          - `glucose_g` number, nullable
          - `glutamic_acid_g` number, nullable
          - `glycine_g` number, nullable
          - `grams_per_cubic_inch` number, nullable
          - `histidine_g` number, nullable
          - `hydroxyproline_g` number, nullable
          - `insoluble_dietary_fiber_g` number, nullable
          - `iodine_ug` number, nullable
          - `iron_mg` number, nullable
          - `isoleucine_g` number, nullable
          - `isomalt_g` number, nullable
          - `lactic_acid_g` number, nullable
          - `lactitol_g` number, nullable
          - `lactose_g` number, nullable
          - `leucine_g` number, nullable
          - `linoleic_acid_g` number, nullable
          - `lutein_zeaxanthin_ug` number, nullable
          - `lycopene_ug` number, nullable
          - `lysine_g` number, nullable
          - `magnesium_mg` number, nullable
          - `malic_acid_g` number, nullable
          - `maltitol_g` number, nullable
          - `maltose_g` number, nullable
          - `manganese_mg` number, nullable
          - `mannitol_g` number, nullable
          - `methionine_g` number, nullable
          - `molybdenum_ug` number, nullable
          - `netcarb_g` number, nullable
          - `niacin_mg` number, nullable
          - `nitrogen_g` number, nullable
          - `omega_six_fatty_acids_g` number, nullable
          - `omega_three_fatty_acids_g` number, nullable
          - `pantothenic_acid_mg` number, nullable
          - `phenylalanine_g` number, nullable
          - `phosphorus_mg` number, nullable
          - `phytosterols_mg` number, nullable
          - `polyols_g` number, nullable
          - `potassium_mg` number, nullable
          - `proline_g` number, nullable
          - `protein_g` number, nullable
          - `retinol_ug` number, nullable
          - `riboflavin_mg` number, nullable
          - `selenium_mcg` number, nullable
          - `serine_g` number, nullable
          - `sodium_mg` number, nullable
          - `soluble_dietary_fiber_g` number, nullable
          - `sorbitol_g` number, nullable
          - `starch_g` number, nullable
          - `stigmasterol_mg` number, nullable
          - `sucrose_g` number, nullable
          - `sugars_g` number, nullable
          - `theobromine_mg` number, nullable
          - `thiamin_mg` number, nullable
          - `threonine_g` number, nullable
          - `total_sterols_mg` number, nullable
          - `tryptophan_g` number, nullable
          - `tyrosine_g` number, nullable
          - `usda_id` integer, nullable
          - `valine_g` number, nullable
          - `vitamin_a_iu` number, nullable
          - `vitamin_a_rae_ug` number, nullable
          - `vitamin_b12_added_ug` number, nullable
          - `vitamin_b12_ug` number, nullable
          - `vitamin_b6_mg` number, nullable
          - `vitamin_c_mg` number, nullable
          - `vitamin_d2_ug` number, nullable
          - `vitamin_d2d3_ug` number, nullable
          - `vitamin_d3_ug` number, nullable
          - `vitamin_d_iu` number, nullable
          - `vitamin_e_added_mg` number, nullable
          - `vitamin_e_mg` number, nullable
          - `vitamin_k_dihydrophylloquinone_ug` number, nullable
          - `vitamin_k_menaquinone_ug` number, nullable
          - `vitamin_k_ug` number, nullable
          - `water_g` number, nullable
          - `xylitol_g` number, nullable
          - `zinc_mg` number, nullable
        - `nutrition_source` string, nullable
        - `original_meal_photo_url` string, nullable
        - `parent_food_name` string, nullable
        - `patient_id` integer, required
        - `percent_eaten` number
        - `preparation_method` '' | 'homemade' | 'restaurant' | 'cpg' | 'store_bought' | 'other'
        - `protein_g` number
        - `recipe_id` integer, nullable
        - `recipe_structure` object, nullable
        - `rxfood_id` string, nullable
        - `serving_type_label` string, nullable
        - `serving_type_multiplier` number, nullable
        - `serving_unit_amount` number, required
        - `serving_unit_label` string, required
        - `serving_unit_label_translations` object, nullable, required
        - `servings` number, required
        - `similar_items` string[]
        - `sodium_mg` number, nullable
        - `source_meal_id` integer, nullable — meal id the row was copied from when logging from recent items
        - `source_meal_item_custom_addon_id` integer, nullable — custom addon id the row was copied from when logging from recent items
        - `source_meal_item_id` integer, nullable — meal item id the row was copied from when logging from recent items
        - `updated_time` string, date-time, required
        - `vitamin_d_iu` number, nullable
      - `meal_name` 'breakfast' | 'lunch' | 'dinner' | 'snack', required
      - `meal_name_translations` object, nullable
      - `meal_photo_id` integer, nullable
      - `meal_photo_original_url` string, nullable
      - `meal_photo_resized_url` string, nullable
      - `meal_time` string, required — time in format hh:mm:ss
      - `patient_id` integer, required
    - `water` WaterResponse
      - `cups` number, required
      - `id` integer, nullable
      - `patient_id` integer, required
      - `water_date` string, required — calendar date in format YYYY-MM-DD

## Changes

- **2026-09-03** `7d063ed4f8ca` — 2 info
  - added the optional property `results/items/meals/items/meal_items/items/recipe_id` to the response with the `200` status
  - added the optional property `results/items/meals/items/meal_items/items/recipe_structure` to the response with the `200` status

[Change history](https://skmtc.dev/rxfoodapp/apis/inneranalytics-mnt-server/changes/patients/:patient_id/daily_consumptions/get.md)

---

[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.dev/rxfoodapp/apis/inneranalytics-mnt-server/revisions/750cc0d96a93?raw)