DocumentVersions
Retrieve all versions of a specific document.
Columns
| Name | Type | Description |
| id | String | id |
| version_id [KEY] | String | version_id |
| Sharpness | String | file_meta_sharpness__v |
| Channels | String | file_meta_channels__v |
| Circle of Confusion | String | file_meta_circle_of_confusion__v |
| White Balance | String | file_meta_white_balance__v |
| Rendition Black Listed | Bool | rendition_black_list_flag__v |
| Sample Rate | String | file_meta_sample_rate__v |
| Format | String | format__v |
| Product | String | product__v |
| Version Creation Date | Datetime | version_creation_date__v |
| Medical Interaction | String | medx__v |
| Merge Fields | Bool | merge_fields__v |
| Major Version Number | Decimal | major_version_number__v |
| Created From | String | binder_created_from__v |
| Channel Assignment | String | channel_assignment__v |
| Sync Offline | Bool | syncoffline__v |
| Shutter Speed | String | file_meta_shutter_speed__v |
| Case | String | case__v |
| Brightness | String | file_meta_brightness__v |
| Source Document Name | String | source_document_name__v |
| Alpha Channel | String | file_meta_alpha_channel__v |
| Annotations (Links) | Decimal | annotations_links__v |
| Metadata | String | binder_metadata__v |
| Source Owner | String | source_owner__v |
| ISO Speed | String | file_meta_iso_speed__v |
| Link Status | String | link_status__v |
| Bookmarks Edited | Bool | bookmarks_edited__sys |
| GPS | String | file_meta_gps__v |
| Y Cb Cr Positioning | String | file_meta_ycbcr_positioning__v |
| Copyright | String | file_meta_copyright__v |
| Production CDN URL | String | production_cdn_url__v |
| Lifecycle Stage | String | stage__sys |
| Annotations (All) | Decimal | annotations_all__v |
| OCR Requested | Bool | ocr_requested__sys |
| Global Version ID | String | global_version_id__sys |
| Annotations (Permalinks) | Decimal | annotations_permalink__v |
| Light Source | String | file_meta_light_source__v |
| Status | String | status__v |
| Rendition Suppressed | Bool | suppress_rendition__v |
| Binder Locked | Bool | binder_locked__v |
| Last Auto-Filed Date | Datetime | binder_last_autofiled_date__v |
| Source Document ID | Decimal | source_document_id__v |
| File Name | String | filename__v |
| FTP Source Location | String | ftp_source_location__v |
| Device | String | file_meta_device__v |
| Media Description | String | file_meta_media_description__v |
| Latest Source Major Version | Decimal | latest_source_major_version__v |
| Source Vault Name | String | source_vault_name__v |
| File Security | String | file_security__v |
| Duration | String | file_meta_duration__v |
| Checked Out By | String | locked_by__v |
| Flash | String | file_meta_flash__v |
| Frame Rate | String | file_meta_frame_rate__v |
| Annotations (Auto Links) | Decimal | annotations_auto__v |
| Red Eye | String | file_meta_red_eye__v |
| Orientation | String | file_meta_orientation__v |
| Caller ID | String | caller_id__v |
| Certified Copy | Bool | certified_copy__v |
| Contrast | String | file_meta_contrast__v |
| Version Created By | String | version_created_by__v |
| Component Configuration | String | file_meta_component_configuration__v |
| Exposure Mode | String | file_meta_exposure_mode__v |
| Annotations (Anchors) | Decimal | annotations_anchors__v |
| Document Number | String | document_number__v |
| Reviewer | String | reviewer__v.users |
| Reviewer2 | String | reviewer__v.groups |
| Source Number | String | source_document_number__v |
| Lens | String | file_meta_lens__v |
| Media Title | String | file_meta_title__v |
| Minor Version Number | Decimal | minor_version_number__v |
| Display Resolution | String | file_meta_display_resolution__v |
| Language | String | file_meta_language__v |
| Metering Mode | String | file_meta_metering_mode__v |
| Album | String | file_meta_album__v |
| Media Comments | String | file_meta_comments__v |
| Lifecycle State Stage ID | String | state_stage_id__sys |
| File Created By | String | file_created_by__v |
| Viewer | String | viewer__v.users |
| Viewer2 | String | viewer__v.groups |
| Notes | String | notes__v |
| Source Vault Connection | String | source_connection__sys |
| Lifecycle | String | lifecycle__v |
| Aperture | String | file_meta_aperture__v |
| Genre | String | file_meta_genre__v |
| Publisher | String | file_meta_publisher__v |
| Field of View | String | file_meta_fields_of_view__v |
| Archived Date | Datetime | archived_date__sys |
| Claims | String | related_claims__v |
| Bound Source Minor Version | Decimal | bound_source_minor_version__v |
| File Last Modified Date | Datetime | file_modified_date__v |
| Approver | String | approver__v.users |
| Approver2 | String | approver__v.groups |
| File Created Date | Datetime | file_created_date__v |
| Global ID | String | global_id__sys |
| Exposure Compensation | String | file_meta_exposure_compensation__v |
| Subtype | String | subtype__v |
| Year | Decimal | file_meta_year__v |
| Original Date | String | file_meta_original_date__v |
| Light | String | file_meta_light__v |
| Template Document Type | String | template_doctype__v |
| Resolution | String | file_meta_resolution__v |
| Color Space | String | file_meta_color_space__v |
| File Last Modified By | String | file_modified_by__v |
| Distribution Contacts | String | distribution_contacts__v |
| Document Link | String | link__sys |
| Digital Publishing | Bool | cdn_content__v |
| Source Binding Rule | String | source_binding_rule__v |
| Consumer | String | consumer__v.users |
| Consumer2 | String | consumer__v.groups |
| CrossLink | Bool | crosslink__v |
| Is Latest Version | Bool | latest_version__v |
| Annotations (Notes) | Decimal | annotations_notes__v |
| Encoding Process | String | file_meta_encoding_process__v |
| Classification | String | classification__v |
| Suggested Links | Decimal | annotations_suggested__v |
| Focal Length | String | file_meta_focal_length__v |
| Saturation | String | file_meta_saturation__v |
| Checked Out | Bool | locked__v |
| Name | String | name__v |
| Megapixel | String | file_meta_megapixel__v |
| Disc Number | String | file_meta_disc_number__v |
| Pages | Decimal | pages__v |
| Checked Out Date | Datetime | locked_date__v |
| Bound Source Major Version | Decimal | bound_source_major_version__v |
| Preprocessed | Bool | preprocessed__v |
| Keywords | String | file_meta_keywords__v |
| Tags | String | tags__v |
| Type | String | type__v |
| Description | String | description__v |
| Export File Name | String | export_filename__v |
| Artist | String | file_meta_artist__v |
| Title | String | title__v |
| Size | Decimal | size__v |
| Source Vault Connection Name | String | source_connection_name__sys |
| Last Auto-Filed By | String | binder_last_autofiled_by__v |
| Software | String | file_meta_software__v |
| Pages OCR'ed (%) | Decimal | pages_ocred_percent__sys |
| Checksum | String | md5checksum__v |
| Staging CDN URL | String | staging_cdn_url__v |
| Bit Rate | String | file_meta_bit_rate__v |
| Annotations (Unresolved) | Decimal | annotations_unresolved__v |
| Last Modified By | String | last_modified_by__v |
| Document Version Link | String | version_link__sys |
| Annotations (Approved Links) | Decimal | annotations_approved__v |
| Gain Control | String | file_meta_gain_control__v |
| Created Date | Datetime | document_creation_date__v |
| Image Size | String | file_meta_image_size__v |
| Audio Codec | String | file_meta_audio_codec__v |
| Video Codecs | String | file_meta_video_codecs__v |
| Binder | Bool | binder__v |
| Key Message | String | key_message__v |
| Annotations (Resolved) | Decimal | annotations_resolved__v |
| Coordinator | String | coordinator__v.users |
| Coordinator2 | String | coordinator__v.groups |
| Author | String | file_meta_author__v |
| Annotations (Lines) | Decimal | annotations_lines__v |
| Last Modified Date | Datetime | version_modified_date__v |
| Batch Number | String | batch_number__v |
| Media Location | String | file_meta_location__v |
| External ID | String | external_id__v |
| Rendition Profile | String | rendition_profile__v |
| Source Vault ID | Decimal | source_vault_id__v |
| Annotations (Claim Links) | Decimal | annotations_claim__v |
| Created By | String | created_by__v |
| Disable Vault Overlays | Bool | disable_vault_overlays__v |
| Editor | String | editor__v.users |
| Editor2 | String | editor__v.groups |
| Latest Source Minor Version | Decimal | latest_source_minor_version__v |
| Owner | String | owner__v |
| Track | String | file_meta_track__v |
Pseudo-Columns
Pseudo-column fields are used in the WHERE clause of SELECT statements and offer more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ExternalIdColumn | String | Specifies the External Id column to be used for Update and Upsert operations. Should be set to an unique column different from Id |