{"command":{"effect":"read","timeoutSeconds":30,"inputSchema":{"type":"object","properties":{"path":{"type":"object","properties":{"data_source_id":{"type":"string","minLength":1,"maxLength":2000}},"required":["data_source_id"],"additionalProperties":false},"query":{"type":"object","properties":{"filter_properties":{"type":"array","items":{"type":"string","maxLength":64000},"maxItems":100}},"required":[],"additionalProperties":false},"data":{"type":"object","additionalProperties":false,"properties":{"sorts":{"type":"array","items":{"anyOf":[{"type":"object","required":["property","direction"],"properties":{"property":{"type":"string","maxLength":64000},"direction":{"type":"string","enum":["ascending","descending"],"maxLength":64000}},"maxProperties":100},{"type":"object","required":["timestamp","direction"],"properties":{"timestamp":{"type":"string","enum":["created_time","last_edited_time"],"maxLength":64000},"direction":{"type":"string","enum":["ascending","descending"],"maxLength":64000}},"maxProperties":100}]},"maxItems":100},"filter":{"anyOf":[{"anyOf":[{"type":"object","required":["or"],"properties":{"or":{"$ref":"#/$defs/groupFilterOperatorArray"}},"maxProperties":100},{"type":"object","required":["and"],"properties":{"and":{"$ref":"#/$defs/groupFilterOperatorArray"}},"maxProperties":100}]},{"$ref":"#/$defs/propertyFilter"},{"$ref":"#/$defs/timestampFilter"}]},"start_cursor":{"type":"string","maxLength":64000},"page_size":{"type":"integer","minimum":1},"is_archived":{"type":"boolean"},"result_type":{"type":"string","enum":["page","data_source"],"maxLength":64000}},"maxProperties":100}},"required":["path","data"],"additionalProperties":false,"$defs":{"groupFilterOperatorArray":{"type":"array","maxItems":100,"items":{"anyOf":[{"$ref":"#/$defs/propertyOrTimestampFilter"},{"anyOf":[{"type":"object","required":["or"],"properties":{"or":{"$ref":"#/$defs/propertyOrTimestampFilterArray"}},"maxProperties":100},{"type":"object","required":["and"],"properties":{"and":{"$ref":"#/$defs/propertyOrTimestampFilterArray"}},"maxProperties":100}]}]}},"propertyOrTimestampFilter":{"anyOf":[{"$ref":"#/$defs/propertyFilter"},{"$ref":"#/$defs/timestampFilter"}]},"propertyFilter":{"anyOf":[{"type":"object","required":["title","property"],"additionalProperties":false,"properties":{"title":{"$ref":"#/$defs/textPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"title","maxLength":64000}},"maxProperties":100},{"type":"object","required":["rich_text","property"],"additionalProperties":false,"properties":{"rich_text":{"$ref":"#/$defs/textPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"rich_text","maxLength":64000}},"maxProperties":100},{"type":"object","required":["number","property"],"additionalProperties":false,"properties":{"number":{"$ref":"#/$defs/numberPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"number","maxLength":64000}},"maxProperties":100},{"type":"object","required":["checkbox","property"],"additionalProperties":false,"properties":{"checkbox":{"$ref":"#/$defs/checkboxPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"checkbox","maxLength":64000}},"maxProperties":100},{"type":"object","required":["select","property"],"additionalProperties":false,"properties":{"select":{"$ref":"#/$defs/selectPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"select","maxLength":64000}},"maxProperties":100},{"type":"object","required":["multi_select","property"],"additionalProperties":false,"properties":{"multi_select":{"$ref":"#/$defs/multiSelectPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"multi_select","maxLength":64000}},"maxProperties":100},{"type":"object","required":["status","property"],"additionalProperties":false,"properties":{"status":{"$ref":"#/$defs/statusPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"status","maxLength":64000}},"maxProperties":100},{"type":"object","required":["date","property"],"additionalProperties":false,"properties":{"date":{"$ref":"#/$defs/datePropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"date","maxLength":64000}},"maxProperties":100},{"type":"object","required":["people","property"],"additionalProperties":false,"properties":{"people":{"$ref":"#/$defs/peoplePropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"people","maxLength":64000}},"maxProperties":100},{"type":"object","required":["files","property"],"additionalProperties":false,"properties":{"files":{"$ref":"#/$defs/existencePropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"files","maxLength":64000}},"maxProperties":100},{"type":"object","required":["url","property"],"additionalProperties":false,"properties":{"url":{"$ref":"#/$defs/textPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"url","maxLength":64000}},"maxProperties":100},{"type":"object","required":["email","property"],"additionalProperties":false,"properties":{"email":{"$ref":"#/$defs/textPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"email","maxLength":64000}},"maxProperties":100},{"type":"object","required":["phone_number","property"],"additionalProperties":false,"properties":{"phone_number":{"$ref":"#/$defs/textPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"phone_number","maxLength":64000}},"maxProperties":100},{"type":"object","required":["relation","property"],"additionalProperties":false,"properties":{"relation":{"$ref":"#/$defs/relationPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"relation","maxLength":64000}},"maxProperties":100},{"type":"object","required":["created_by","property"],"additionalProperties":false,"properties":{"created_by":{"$ref":"#/$defs/peoplePropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"created_by","maxLength":64000}},"maxProperties":100},{"type":"object","required":["created_time","property"],"additionalProperties":false,"properties":{"created_time":{"$ref":"#/$defs/datePropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"created_time","maxLength":64000}},"maxProperties":100},{"type":"object","required":["last_edited_by","property"],"additionalProperties":false,"properties":{"last_edited_by":{"$ref":"#/$defs/peoplePropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"last_edited_by","maxLength":64000}},"maxProperties":100},{"type":"object","required":["last_edited_time","property"],"additionalProperties":false,"properties":{"last_edited_time":{"$ref":"#/$defs/datePropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"last_edited_time","maxLength":64000}},"maxProperties":100},{"type":"object","required":["formula","property"],"additionalProperties":false,"properties":{"formula":{"$ref":"#/$defs/formulaPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"formula","maxLength":64000}},"maxProperties":100},{"type":"object","required":["unique_id","property"],"additionalProperties":false,"properties":{"unique_id":{"$ref":"#/$defs/numberPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"unique_id","maxLength":64000}},"maxProperties":100},{"type":"object","required":["rollup","property"],"additionalProperties":false,"properties":{"rollup":{"$ref":"#/$defs/rollupPropertyFilter"},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"rollup","maxLength":64000}},"maxProperties":100},{"type":"object","required":["verification","property"],"additionalProperties":false,"properties":{"verification":{"anyOf":[{"$ref":"#/$defs/verificationPropertyStatusFilter"},{"$ref":"#/$defs/verificationPropertyDoesNotEqualFilter"}]},"property":{"type":"string","maxLength":64000},"type":{"type":"string","const":"verification","maxLength":64000}},"maxProperties":100}]},"textPropertyFilter":{"anyOf":[{"anyOf":[{"type":"object","required":["equals"],"properties":{"equals":{"type":"string","maxLength":64000}},"maxProperties":100},{"type":"object","required":["does_not_equal"],"properties":{"does_not_equal":{"type":"string","maxLength":64000}},"maxProperties":100},{"type":"object","required":["contains"],"properties":{"contains":{"type":"string","maxLength":64000}},"maxProperties":100},{"type":"object","required":["does_not_contain"],"properties":{"does_not_contain":{"type":"string","maxLength":64000}},"maxProperties":100},{"type":"object","required":["starts_with"],"properties":{"starts_with":{"type":"string","maxLength":64000}},"maxProperties":100},{"type":"object","required":["ends_with"],"properties":{"ends_with":{"type":"string","maxLength":64000}},"maxProperties":100}]},{"$ref":"#/$defs/existencePropertyFilter"}]},"existencePropertyFilter":{"anyOf":[{"type":"object","required":["is_empty"],"properties":{"is_empty":{"type":"boolean","const":true}},"maxProperties":100},{"type":"object","required":["is_not_empty"],"properties":{"is_not_empty":{"type":"boolean","const":true}},"maxProperties":100}]},"numberPropertyFilter":{"anyOf":[{"anyOf":[{"type":"object","required":["equals"],"properties":{"equals":{"type":"number"}},"maxProperties":100},{"type":"object","required":["does_not_equal"],"properties":{"does_not_equal":{"type":"number"}},"maxProperties":100},{"type":"object","required":["greater_than"],"properties":{"greater_than":{"type":"number"}},"maxProperties":100},{"type":"object","required":["less_than"],"properties":{"less_than":{"type":"number"}},"maxProperties":100},{"type":"object","required":["greater_than_or_equal_to"],"properties":{"greater_than_or_equal_to":{"type":"number"}},"maxProperties":100},{"type":"object","required":["less_than_or_equal_to"],"properties":{"less_than_or_equal_to":{"type":"number"}},"maxProperties":100}]},{"$ref":"#/$defs/existencePropertyFilter"}]},"checkboxPropertyFilter":{"anyOf":[{"type":"object","required":["equals"],"properties":{"equals":{"type":"boolean"}},"maxProperties":100},{"type":"object","required":["does_not_equal"],"properties":{"does_not_equal":{"type":"boolean"}},"maxProperties":100}]},"selectPropertyFilter":{"anyOf":[{"anyOf":[{"type":"object","required":["equals"],"properties":{"equals":{"$ref":"#/$defs/stringOrStringArray"}},"maxProperties":100},{"type":"object","required":["does_not_equal"],"properties":{"does_not_equal":{"$ref":"#/$defs/stringOrStringArray"}},"maxProperties":100}]},{"$ref":"#/$defs/existencePropertyFilter"}]},"stringOrStringArray":{"anyOf":[{"type":"string","maxLength":64000},{"type":"array","items":{"type":"string","maxLength":64000},"maxItems":100}]},"multiSelectPropertyFilter":{"anyOf":[{"anyOf":[{"type":"object","required":["contains"],"properties":{"contains":{"$ref":"#/$defs/stringOrStringArray"}},"maxProperties":100},{"type":"object","required":["does_not_contain"],"properties":{"does_not_contain":{"$ref":"#/$defs/stringOrStringArray"}},"maxProperties":100}]},{"$ref":"#/$defs/existencePropertyFilter"}]},"statusPropertyFilter":{"anyOf":[{"$ref":"#/$defs/statusValueFilter"},{"$ref":"#/$defs/existencePropertyFilter"}]},"statusValueFilter":{"anyOf":[{"type":"object","required":["equals"],"properties":{"equals":{"$ref":"#/$defs/stringOrStringArray"}},"maxProperties":100},{"type":"object","required":["does_not_equal"],"properties":{"does_not_equal":{"$ref":"#/$defs/stringOrStringArray"}},"maxProperties":100},{"type":"object","required":["group_equals"],"properties":{"group_equals":{"$ref":"#/$defs/statusGroupNames"}},"maxProperties":100},{"type":"object","required":["group_does_not_equal"],"properties":{"group_does_not_equal":{"$ref":"#/$defs/statusGroupNames"}},"maxProperties":100}]},"statusGroupNames":{"anyOf":[{"$ref":"#/$defs/stringRequest"},{"type":"array","minItems":1,"maxItems":100,"items":{"$ref":"#/$defs/stringRequest"}}]},"stringRequest":{"type":"string","minLength":1,"maxLength":100},"datePropertyFilter":{"anyOf":[{"anyOf":[{"type":"object","required":["equals"],"properties":{"equals":{"$ref":"#/$defs/dateOrRelativeDate"}},"maxProperties":100},{"type":"object","required":["before"],"properties":{"before":{"$ref":"#/$defs/dateOrRelativeDate"}},"maxProperties":100},{"type":"object","required":["after"],"properties":{"after":{"$ref":"#/$defs/dateOrRelativeDate"}},"maxProperties":100},{"type":"object","required":["on_or_before"],"properties":{"on_or_before":{"$ref":"#/$defs/dateOrRelativeDate"}},"maxProperties":100},{"type":"object","required":["on_or_after"],"properties":{"on_or_after":{"$ref":"#/$defs/dateOrRelativeDate"}},"maxProperties":100},{"type":"object","required":["this_week"],"properties":{"this_week":{"$ref":"#/$defs/emptyObject"}},"maxProperties":100},{"type":"object","required":["past_week"],"properties":{"past_week":{"$ref":"#/$defs/emptyObject"}},"maxProperties":100},{"type":"object","required":["past_month"],"properties":{"past_month":{"$ref":"#/$defs/emptyObject"}},"maxProperties":100},{"type":"object","required":["past_year"],"properties":{"past_year":{"$ref":"#/$defs/emptyObject"}},"maxProperties":100},{"type":"object","required":["next_week"],"properties":{"next_week":{"$ref":"#/$defs/emptyObject"}},"maxProperties":100},{"type":"object","required":["next_month"],"properties":{"next_month":{"$ref":"#/$defs/emptyObject"}},"maxProperties":100},{"type":"object","required":["next_year"],"properties":{"next_year":{"$ref":"#/$defs/emptyObject"}},"maxProperties":100}]},{"$ref":"#/$defs/existencePropertyFilter"}]},"dateOrRelativeDate":{"anyOf":[{"type":"string","maxLength":64000},{"$ref":"#/$defs/relativeDateValue"}]},"relativeDateValue":{"type":"string","enum":["today","tomorrow","yesterday","one_week_ago","one_week_from_now","one_month_ago","one_month_from_now"],"maxLength":64000},"emptyObject":{"type":"object","additionalProperties":false,"properties":{},"maxProperties":100},"peoplePropertyFilter":{"anyOf":[{"anyOf":[{"type":"object","required":["contains"],"properties":{"contains":{"$ref":"#/$defs/personIdOrMe"}},"maxProperties":100},{"type":"object","required":["does_not_contain"],"properties":{"does_not_contain":{"$ref":"#/$defs/personIdOrMe"}},"maxProperties":100}]},{"$ref":"#/$defs/existencePropertyFilter"}]},"personIdOrMe":{"anyOf":[{"$ref":"#/$defs/idRequest"},{"type":"string","const":"me","maxLength":64000}]},"idRequest":{"type":"string","maxLength":64000},"relationPropertyFilter":{"anyOf":[{"anyOf":[{"type":"object","required":["contains"],"properties":{"contains":{"$ref":"#/$defs/idRequest"}},"maxProperties":100},{"type":"object","required":["does_not_contain"],"properties":{"does_not_contain":{"$ref":"#/$defs/idRequest"}},"maxProperties":100}]},{"$ref":"#/$defs/existencePropertyFilter"}]},"formulaPropertyFilter":{"anyOf":[{"type":"object","required":["string"],"properties":{"string":{"$ref":"#/$defs/textPropertyFilter"}},"maxProperties":100},{"type":"object","required":["checkbox"],"properties":{"checkbox":{"$ref":"#/$defs/checkboxPropertyFilter"}},"maxProperties":100},{"type":"object","required":["number"],"properties":{"number":{"$ref":"#/$defs/numberPropertyFilter"}},"maxProperties":100},{"type":"object","required":["date"],"properties":{"date":{"$ref":"#/$defs/datePropertyFilter"}},"maxProperties":100}]},"rollupPropertyFilter":{"anyOf":[{"type":"object","required":["any"],"properties":{"any":{"$ref":"#/$defs/rollupSubfilterPropertyFilter"}},"maxProperties":100},{"type":"object","required":["none"],"properties":{"none":{"$ref":"#/$defs/rollupSubfilterPropertyFilter"}},"maxProperties":100},{"type":"object","required":["every"],"properties":{"every":{"$ref":"#/$defs/rollupSubfilterPropertyFilter"}},"maxProperties":100},{"type":"object","required":["date"],"properties":{"date":{"$ref":"#/$defs/datePropertyFilter"}},"maxProperties":100},{"type":"object","required":["number"],"properties":{"number":{"$ref":"#/$defs/numberPropertyFilter"}},"maxProperties":100}]},"rollupSubfilterPropertyFilter":{"anyOf":[{"type":"object","required":["rich_text"],"properties":{"rich_text":{"$ref":"#/$defs/textPropertyFilter"}},"maxProperties":100},{"type":"object","required":["number"],"properties":{"number":{"$ref":"#/$defs/numberPropertyFilter"}},"maxProperties":100},{"type":"object","required":["checkbox"],"properties":{"checkbox":{"$ref":"#/$defs/checkboxPropertyFilter"}},"maxProperties":100},{"type":"object","required":["select"],"properties":{"select":{"$ref":"#/$defs/selectPropertyFilter"}},"maxProperties":100},{"type":"object","required":["multi_select"],"properties":{"multi_select":{"$ref":"#/$defs/multiSelectPropertyFilter"}},"maxProperties":100},{"type":"object","required":["relation"],"properties":{"relation":{"$ref":"#/$defs/relationPropertyFilter"}},"maxProperties":100},{"type":"object","required":["date"],"properties":{"date":{"$ref":"#/$defs/datePropertyFilter"}},"maxProperties":100},{"type":"object","required":["people"],"properties":{"people":{"$ref":"#/$defs/peoplePropertyFilter"}},"maxProperties":100},{"type":"object","required":["files"],"properties":{"files":{"$ref":"#/$defs/existencePropertyFilter"}},"maxProperties":100},{"type":"object","required":["status"],"properties":{"status":{"$ref":"#/$defs/statusPropertyFilter"}},"maxProperties":100}]},"verificationPropertyStatusFilter":{"type":"object","required":["status"],"additionalProperties":false,"properties":{"status":{"type":"string","enum":["verified","expired","none"],"maxLength":64000}},"maxProperties":100},"verificationPropertyDoesNotEqualFilter":{"type":"object","required":["does_not_equal"],"additionalProperties":false,"properties":{"does_not_equal":{"type":"string","enum":["verified","expired","none"],"maxLength":64000}},"maxProperties":100},"timestampFilter":{"anyOf":[{"$ref":"#/$defs/timestampCreatedTimeFilter"},{"$ref":"#/$defs/timestampLastEditedTimeFilter"}]},"timestampCreatedTimeFilter":{"type":"object","required":["created_time","timestamp"],"additionalProperties":false,"properties":{"created_time":{"$ref":"#/$defs/datePropertyFilter"},"timestamp":{"type":"string","const":"created_time","maxLength":64000},"type":{"type":"string","const":"created_time","maxLength":64000}},"maxProperties":100},"timestampLastEditedTimeFilter":{"type":"object","required":["last_edited_time","timestamp"],"additionalProperties":false,"properties":{"last_edited_time":{"$ref":"#/$defs/datePropertyFilter"},"timestamp":{"type":"string","const":"last_edited_time","maxLength":64000},"type":{"type":"string","const":"last_edited_time","maxLength":64000}},"maxProperties":100},"propertyOrTimestampFilterArray":{"type":"array","maxItems":100,"items":{"$ref":"#/$defs/propertyOrTimestampFilter"}}}},"name":"Query a data source","id":"notion.api.post-database-query","example":{"path":{"data_source_id":"00000000-0000-0000-0000-000000000001"},"data":{}},"maxRequests":1,"summary":false}}