Reproducible query — Product (shared drive)
LIST FILES LIMIT 5
Anyone opening this link re-runs the same query against epoch 1, so it returns the same answer — that is what makes a number in a report checkable later.
| PATH | NAME | ID | DRIVE_ID | PARENT_ID | DEPTH | IS_FOLDER | ITEM_KIND | MIME_TYPE | SIZE_BYTES | OWNER_EMAIL | CREATED | MODIFIED | MODIFIED_BY | TRASHED | STARRED | NAME_IS_UNIQUE | WORD_COUNT | SECTION_COUNT | CONTENT_HASH | EXTRACT_STATUS | WEB_VIEW_LINK | LINK_VISIBILITY | SHARED_EXTERNALLY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| /Product | Product | fld_product | drv_product | - | 0 | yes | folder | application/vnd.google-apps.folder | - | alice@acme.com | 2025-03-01T09:00:00Z | 2026-08-30T11:20:00Z | alice@acme.com | no | no | yes | - | - | - | not_applicable | open in Drive ↗ | domain | no |
| /Product/Roadmap | Roadmap | fld_roadmap | drv_product | fld_product | 1 | yes | folder | application/vnd.google-apps.folder | - | alice@acme.com | 2025-03-02T09:00:00Z | 2026-08-28T16:40:00Z | alice@acme.com | no | no | yes | - | - | - | not_applicable | open in Drive ↗ | domain | no |
| /Product/Roadmap/Roadmap 2026 | Roadmap 2026 | doc_roadmap26 | drv_product | fld_roadmap | 2 | no | document | application/vnd.google-apps.document | - | alice@acme.com | 2025-11-04T10:12:00Z | 2026-08-28T16:40:00Z | bob@acme.com | no | no | yes | 72 | 5 | b514ed617ee0a869 | exported_no_size | open in Drive ↗ | anyone_with_link | yes |
| /Product/Roadmap/Q3 Planning | Q3 Planning | doc_q3plan | drv_product | fld_roadmap | 2 | no | document | application/vnd.google-apps.document | - | bob@acme.com | 2026-05-18T08:30:00Z | 2026-07-02T13:05:00Z | bob@acme.com | no | no | yes | 41 | 4 | af4c1fbf58fb3d7a | exported_no_size | open in Drive ↗ | domain | no |
| /Product/Specs | Specs | fld_specs | drv_product | fld_product | 1 | yes | folder | application/vnd.google-apps.folder | - | alice@acme.com | 2025-03-02T09:05:00Z | 2026-08-25T09:15:00Z | alice@acme.com | no | no | yes | - | - | - | not_applicable | open in Drive ↗ | domain | no |
Showing 5 of 19 matching rows — raise LIMIT for more.
Applied the source default TRASHED IS "no". Drive hides trashed items by default, so counting them would disagree with what any Drive user sees. Filter TRASHED explicitly to override it.
Showing 5 of 19 matching rows (LIMIT applies; count is not the true total - use COUNT FILES for that).
epoch 1source gdrive:filesas of 2026-09-14T21:44:11Ztransforms type-coercion, source-default-filtercache hit
Applied source default TRASHED IS "no" — Drive hides trashed items by default, so counting them would disagree with what any Drive user sees.
Raw envelope — what an app or agent receives
{
"ok": true,
"query": null,
"verb": "LIST",
"subject": "FILES",
"data": {
"rows": [
{
"ID": "fld_product",
"DRIVE_ID": "drv_product",
"PARENT_ID": null,
"PATH": "/Product",
"NAME": "Product",
"DEPTH": 0,
"IS_FOLDER": "yes",
"ITEM_KIND": "folder",
"MIME_TYPE": "application/vnd.google-apps.folder",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2025-03-01T09:00:00Z",
"MODIFIED": "2026-08-30T11:20:00Z",
"MODIFIED_BY": "alice@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": null,
"SECTION_COUNT": null,
"CONTENT_HASH": null,
"EXTRACT_STATUS": "not_applicable",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/fld_product/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
},
{
"ID": "fld_roadmap",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_product",
"PATH": "/Product/Roadmap",
"NAME": "Roadmap",
"DEPTH": 1,
"IS_FOLDER": "yes",
"ITEM_KIND": "folder",
"MIME_TYPE": "application/vnd.google-apps.folder",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2025-03-02T09:00:00Z",
"MODIFIED": "2026-08-28T16:40:00Z",
"MODIFIED_BY": "alice@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": null,
"SECTION_COUNT": null,
"CONTENT_HASH": null,
"EXTRACT_STATUS": "not_applicable",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/fld_roadmap/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
},
{
"ID": "doc_roadmap26",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_roadmap",
"PATH": "/Product/Roadmap/Roadmap 2026",
"NAME": "Roadmap 2026",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "document",
"MIME_TYPE": "application/vnd.google-apps.document",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2025-11-04T10:12:00Z",
"MODIFIED": "2026-08-28T16:40:00Z",
"MODIFIED_BY": "bob@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 72,
"SECTION_COUNT": 5,
"CONTENT_HASH": "b514ed617ee0a869",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/doc_roadmap26/view",
"LINK_VISIBILITY": "anyone_with_link",
"SHARED_EXTERNALLY": "yes"
},
{
"ID": "doc_q3plan",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_roadmap",
"PATH": "/Product/Roadmap/Q3 Planning",
"NAME": "Q3 Planning",
"DEPTH": 2,
"IS_FOLDER": "no",
"ITEM_KIND": "document",
"MIME_TYPE": "application/vnd.google-apps.document",
"SIZE_BYTES": null,
"OWNER_EMAIL": "bob@acme.com",
"CREATED": "2026-05-18T08:30:00Z",
"MODIFIED": "2026-07-02T13:05:00Z",
"MODIFIED_BY": "bob@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": 41,
"SECTION_COUNT": 4,
"CONTENT_HASH": "af4c1fbf58fb3d7a",
"EXTRACT_STATUS": "exported_no_size",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/doc_q3plan/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
},
{
"ID": "fld_specs",
"DRIVE_ID": "drv_product",
"PARENT_ID": "fld_product",
"PATH": "/Product/Specs",
"NAME": "Specs",
"DEPTH": 1,
"IS_FOLDER": "yes",
"ITEM_KIND": "folder",
"MIME_TYPE": "application/vnd.google-apps.folder",
"SIZE_BYTES": null,
"OWNER_EMAIL": "alice@acme.com",
"CREATED": "2025-03-02T09:05:00Z",
"MODIFIED": "2026-08-25T09:15:00Z",
"MODIFIED_BY": "alice@acme.com",
"TRASHED": "no",
"STARRED": "no",
"NAME_IS_UNIQUE": "yes",
"WORD_COUNT": null,
"SECTION_COUNT": null,
"CONTENT_HASH": null,
"EXTRACT_STATUS": "not_applicable",
"WEB_VIEW_LINK": "https://drive.google.com/file/d/fld_specs/view",
"LINK_VISIBILITY": "domain",
"SHARED_EXTERNALLY": "no"
}
],
"count": 5,
"total": 19,
"limited": true
},
"_meta": {
"epoch": 1,
"provenance": {
"source": "gdrive:files",
"sync_id": "sync-fbaf01faca",
"source_freshness": "2026-09-14T21:44:11Z",
"representation_freshness": "2026-09-14T21:44:11Z",
"resolved_fields": [],
"transforms": [
"type-coercion",
"source-default-filter"
],
"source_defaults": [
{
"field": "TRASHED",
"op": "IS",
"value": "no",
"rationale": "Drive hides trashed items by default, so counting them would disagree with what any Drive user sees."
}
]
},
"related": [
"COUNT FILES",
"COUNT FILES BY IS_FOLDER"
],
"hints": [
"Applied the source default TRASHED IS \"no\". Drive hides trashed items by default, so counting them would disagree with what any Drive user sees. Filter TRASHED explicitly to override it.",
"Showing 5 of 19 matching rows (LIMIT applies; count is not the true total - use COUNT FILES for that)."
],
"cache": "hit"
}
}