autonomous intelligent information publishing - MVP

P4/help_schema.md epoch 1

Schema - Product (shared drive)

Filter ONLY on the fields listed here. Do NOT invent fields, entities, or enum values.

COMMENTS (4 rows, label field: ID)

  • AUTHOR (string)
  • CREATED (date)
  • FILE_ID (string)
  • ID (string)
  • QUOTED_TEXT (string)
  • RESOLVED (string)
  • TEXT (string)
  • relation: FILE_ID references FILES

DRIVES (1 rows, label field: NAME)

  • CREATED (date)
  • DRIVE_KIND (string)
  • ID (string)
  • NAME (string)

FILES (20 rows, label field: NAME)

  • CONTENT_HASH (string)
  • CREATED (date)
  • DEPTH (integer)
  • DRIVE_ID (string)
  • EXTRACT_STATUS (string) - one of: exported_no_size, extracted, not_applicable, unsupported_type
  • ID (string)
  • IS_FOLDER (string) - one of: no, yes
  • ITEM_KIND (string) - one of: document, folder, image, pdf, spreadsheet
  • LINK_VISIBILITY (string) - one of: anyone_with_link, domain
  • MIME_TYPE (string) - one of: application/pdf, application/vnd.google-apps.document, application/vnd.google-apps.folder, application/vnd.google-apps.spreadsheet, image/png
  • MODIFIED (date)
  • MODIFIED_BY (string) - one of: alice@acme.com, bob@acme.com, carol@acme.com, dana@vendor.io
  • NAME (string)
  • NAME_IS_UNIQUE (string)
  • OWNER_EMAIL (string) - one of: alice@acme.com, bob@acme.com, carol@acme.com
  • PARENT_ID (string)
  • PATH (string)
  • SECTION_COUNT (integer)
  • SHARED_EXTERNALLY (string) - one of: no, yes
  • SIZE_BYTES (integer)
  • STARRED (string) - one of: no, yes
  • TRASHED (string) - one of: no, yes
  • WEB_VIEW_LINK (string)
  • WORD_COUNT (integer)
  • relation: DRIVE_ID references DRIVES
  • SOURCE DEFAULT: TRASHED IS "no" is applied unless you filter TRASHED explicitly

LABELS (4 rows, label field: FILE_ID)

  • FILE_ID (string)
  • LABEL (string)
  • VALUE (string)
  • relation: FILE_ID references FILES

LINKS (4 rows, label field: SRC_FILE_ID)

  • DST_FILE_ID (string)
  • LINK_TYPE (string)
  • SRC_FILE_ID (string)

PERMISSIONS (31 rows, label field: FILE_ID)

  • FILE_ID (string)
  • INHERITED (string) - one of: no, yes
  • PRINCIPAL (string) - one of: acme.com, alice@acme.com, anyone, bob@acme.com, carol@acme.com, dana@vendor.io, eng@acme.com
  • PRINCIPAL_TYPE (string) - one of: anyone, domain, group, user
  • ROLE (string) - one of: commenter, organizer, owner, reader, writer
  • relation: FILE_ID references FILES
  • relation: PRINCIPAL references PRINCIPALS

PRINCIPALS (7 rows, label field: ID)

  • DOMAIN (string) - one of: *, acme.com, vendor.io
  • ID (string)
  • PRINCIPAL_TYPE (string)

REVISIONS (8 rows, label field: ID)

  • FILE_ID (string)
  • ID (string)
  • MODIFIED (date)
  • MODIFIED_BY (string) - one of: alice@acme.com, bob@acme.com, carol@acme.com
  • REVISION_ID (string)
  • SIZE_BYTES (integer)
  • relation: FILE_ID references FILES

SECTIONS (36 rows, label field: ID)

  • CHAR_END (integer)
  • CHAR_START (integer)
  • FILE_ID (string)
  • HEADING (string)
  • ID (string)
  • LEVEL (integer)
  • SECTION_INDEX (integer)
  • TEXT (string)
  • WORD_COUNT (integer)
  • relation: FILE_ID references FILES

Back to instance