Activities Data Set Verb Descriptions: Sheets

The Activities data set is more complex than the average ACC Data Schema data set due to the variable nature of payloads associated with the various "Activity Verbs" which define the particular activity taken in the system. For the Activities schema, there are several tables defined (one for each service) and for each of these table definitions, there are common columns and then many unique columns based on the particular service. The common columns included for all tables are:

• activity_id: Activity ID for this event
• bim360_account_id: BIM 360 HQ Account ID
• bim360_project_id: BIM 360 HQ Project ID
• activity_verb: Activity performed by the user
• created_by: Autodesk ID of the user performing the activity action
• created_at: The timestamp when the activity created

After these standard columns there are many service specific columns for the table definition. Columns may or many not contain data depending on the Activity Verb in question. The following summary details the particular columns applicable for an Activity Verb. Also, for certain Activity Verbs there are Related Tables (in a SQL relational sense) that can be associated with the verb. These tables use the activity_id as the foreign key for lookups and when there is an applicable foreign table, they are noted in the details below.

This description information is also made available programatically in the format of JSON files (one for each Activities table) in the "schemas" directory as part of every extract archive. The naming convention for this file is:

• activities_<service_group>_verb_column_details.json
  

The description file is an array of JSON objects with two primary fields:

• columns: Relevant columns for the verb
• related_tables: any tables with additional information on the verb in question

The following is an example JSON snippet from the Docs description file.

 {
   "activate-approval-workflow" : {
      "columns" : [
         "activity_id",
         "bim360_account_id",
         "bim360_project_id",
         "created_by",
         "created_at",
         "activity_verb",
         "object_display_name",
         "object_id",
         "object_object_type"
      ]
   },
   "add-attribute-to-namingstandard" : {
      "columns" : [
         "activity_id",
         "bim360_account_id",
         "bim360_project_id",
         "created_by",
         "created_at",
         "activity_verb",
         "object_display_name",
         "object_id",
         "object_object_type"
      ],
      "related_tables" : [
         "docs_naming_standards"
      ]
   },
   ...

Activity Verbs

Now that we have reviewed the data description for Activities data, the following is a detailed summary of 32 Activity Verbs for the Sheets Schema along with their relevant columns and any related tables.

add-sheet-tag change-discipline-order copy-sheet-from-project copy-sheet-to-project create-collection create-public-link-for-sheets create-version-set delete-collection	delete-public-link-for-sheet delete-sheet delete-version-set enable-collection export-sheet export-sheet-report move-sheet move-sheet-collection	print-sheet publish-sheet recall-public-link-for-sheet remove-sheet-tag remove-sheets-permission rename-collection rename-sheet-title rename-version-set	renumber-sheet restore-sheet resume-copy-sheet-container shared-with-recipients-for-sheets update-sheets-permission update-version-set view-sheet view-sheet-public-link

activity_verb	relevant_columns	related_tables
add-sheet-tag	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
change-discipline-order	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: SheetContainer]
copy-sheet-from-project	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_target_object_display_name Object Target Collection Display Name object_target_object_history Object Target Object History object_target_object_id Object Target Object Id object_target_object_object_type Object Target Collection Object Type [e.g.: Sheet] object_target_object_project Object Target Object Project object_target_object_version_set Object Target Collection Version Set object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
copy-sheet-to-project	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_source_object_display_name Object Source Collection Display Name object_source_object_history Object Source Object History object_source_object_id Object Source Object Id object_source_object_object_type Object Source Collection Object Type [e.g.: Sheet] object_source_object_project Object Source Object Project object_source_object_version_set Object Source Collection Version Set object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
create-collection	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: AccCollection]
create-public-link-for-sheets	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
create-version-set	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_id Object ID object_issuance_date Object Issuance Date object_object_type Object Object Type [e.g.: VersionSet]
delete-collection	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: AccCollection]
delete-public-link-for-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
delete-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_indirect Object Indirect object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
delete-version-set	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_id Object ID object_issuance_date Object Issuance Date object_object_type Object Object Type [e.g.: VersionSet]
enable-collection	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: SheetContainer]
export-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
export-sheet-report	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: SheetHistory]
move-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date target_display_name Target Display Name target_id Target ID target_issuance_date Target Issuance Date
move-sheet-collection	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: SheetHistory] target_acc_collection_display_name Target ACC Collection Display Name target_acc_collection_id Target ACC Collection Id target_display_name Target Display Name target_id Target ID
print-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
publish-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_source_file Object Source File object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
recall-public-link-for-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
remove-sheet-tag	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
remove-sheets-permission	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: SheetContainer] target_display_name Target Display Name target_id Target ID target_object_type Target Object Type [e.g.: company, role, user]
rename-collection	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: AccCollection]
rename-sheet-title	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_title Object Title object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
rename-version-set	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_id Object ID object_issuance_date Object Issuance Date object_object_type Object Object Type [e.g.: VersionSet]
renumber-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date target_display_name Target Display Name target_id Target ID target_object_type Target Object Type [e.g.: History]
restore-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
resume-copy-sheet-container	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: SheetContainer]
shared-with-recipients-for-sheets	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date target_display_name Target Display Name target_id Target ID
update-sheets-permission	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_id Object ID object_object_type Object Object Type [e.g.: SheetContainer] target_display_name Target Display Name target_id Target ID target_object_type Target Object Type [e.g.: company, group, role, user]
update-version-set	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_id Object ID object_issuance_date Object Issuance Date object_object_type Object Object Type [e.g.: VersionSet]
view-sheet	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date
view-sheet-public-link	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_acc_collection_display_name Object ACC Colledtion Display Name object_acc_collection_id Object ACC Collection Id object_collection_id Object Collection Id object_collection_instance_index Object Collection Instance Index object_collection_size Object Collection Size object_display_name Object Display Name object_history_display_name Object History Display Name object_history_id Object History Id object_id Object ID object_object_type Object Object Type [e.g.: Sheet] object_version_set_display_name Object Version Collection Display Name object_version_set_id Object Version Set Id object_version_set_issuance_date Object Version Collection Issuance Date target_display_name Target Display Name target_id Target ID