Activities Data Set Verb Descriptions: Admin

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 Admin Schema along with their relevant columns and any related tables.

assign-admin assign-member change-forge-app-status change-project-status change-user-status create-account-role create-company create-forge-app	create-project create-project-company create-user delete-company delete-forge-app delete-project-company delete-user disable-company-creation	disable-project-creation edit-account edit-bu edit-company edit-project edit-user enable-company-creation enable-project-creation	export-users import-users invite-developer-to-app remove-admin remove-member resend-invitation-to-developer resend-invitations update-account-role

activity_verb	relevant_columns	related_tables
assign-admin	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_access_change_list Access change list in JSON Array Format object_display_name Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: user] object_services_list Service listing in JSON Array Format target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: account, project]
assign-member	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_access_change_list Access change list in JSON Array Format object_display_name Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: user] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: project]
change-forge-app-status	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: forge_app] object_status Status of the object being acted on object_status_was Old status of the object being acted on
change-project-status	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: project] object_status Status of the object being acted on object_status_was Old status of the object being acted on
change-user-status	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: collection, user] object_size Size of the object being acted on object_status Status of the object being acted on object_status_was Old status of the object being acted on
create-account-role	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: account_role] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: account]
create-company	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: company]
create-forge-app	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: forge_app]
create-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_display_name Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: project]
create-project-company	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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: company] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: project]
create-user	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: user]
delete-company	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: company]
delete-forge-app	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: forge_app]
delete-project-company	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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: company] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: project]
delete-user	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: user]
disable-company-creation	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: account] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: account]
disable-project-creation	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: account] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: account]
edit-account	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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_allow_edit_company Allow company edit object_display_name Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_name Name of the object being acted on object_name_was Previous name for the object being acted on object_object_type Type of the object being acted on [e.g.: account] object_update_image Image defintion
edit-bu	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: bu]
edit-company	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_name Name of the object being acted on object_name_was Previous name for the object being acted on object_object_type Type of the object being acted on [e.g.: company] object_update_image Image defintion target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: company]
edit-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_display_name Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_name Name of the object being acted on object_name_was Previous name for the object being acted on object_object_type Type of the object being acted on [e.g.: project] object_update_image Image defintion
edit-user	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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_access_change_list Access change list in JSON Array Format object_added_services Allowed services object_display_name Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: user] object_removed_services Removed services from the object target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: project]
enable-company-creation	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: account] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: account]
enable-project-creation	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: account] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: account]
export-users	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: collection]
import-users	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: collection] object_size Size of the object being acted on
invite-developer-to-app	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: user] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: forge_app]
remove-admin	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_access_change_list Access change list in JSON Array Format object_display_name Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: user] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: account, project]
remove-member	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_access_change_list Access change list in JSON Array Format object_display_name Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: user] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: project]
resend-invitation-to-developer	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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 Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: user] target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: forge_app]
resend-invitations	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_object_type Type of the object being acted on [e.g.: collection] object_size Size of the object being acted on
update-account-role	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account 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_default_access_level Default level of access for the object object_display_name Display name for the target being acted on object_id ID for the object being acted on - if the object_object_type is user, this ID is the admin_users id column, not the Autodesk ID object_name Name of the object being acted on object_object_type Type of the object being acted on [e.g.: account_role] object_service_name Service name for the object being acted on object_status Status of the object being acted on target_display_name Display name for the object being acted on target_id ID for the target being acted on - if the target_object_type is user, this ID is the admin_users id column, not the Autodesk ID target_object_type Object type for the target being acted on [e.g.: account]