CUcubesoftware
Data Tables

Update a Data Table

Changed on

Allows updating a data table. This currently supports modifying settings for data tables tied to Salesforce connections and name, description fields for all data tables.

post/data-tables/{data_table_id}

Request

  • Base URL
    https://api.cubesoftware.com
  • Auth
    • OAuth 2
      Authorization code: https://portal.cubesoftware.com/o/authorize/
      Token URL: https://api.cubesoftware.com/o/token/
    • or none

Path parameters

data_table_idstring uuid required

Headers

X-Company-IDstring required

Associates request with company

Request body

idstring uuid required
namestring required
activeboolean required
settingsobject required
created_atstring date-time required
type'AD_HOC' | 'ERP_CONNECTION' | 'GENERIC' | 'EMPLOYEE_ROSTER' | 'HRIS' | 'HEADCOUNT' | 'PLANNING_TABLE' required
  • AD_HOC - Ad Hoc
  • ERP_CONNECTION - ERP Connection
  • GENERIC - Generic
  • EMPLOYEE_ROSTER - Employee Roster
  • HRIS - HRIS Connection
  • HEADCOUNT - Headcount Model
  • PLANNING_TABLE - Planning Table
type_friendlystring required
last_importobject required
last_successful_importobject required
source_typestring required

Returns the human-friendly category of the connection's Integration, if the table has a connection. Otherwise, returns 'Data Table'.

Returns: The human-friendly source category

mapping_dataobject required
descriptionstring

Response

The data table object

idstring uuid required
namestring required
activeboolean required
settingsobject required
created_atstring date-time required
type'AD_HOC' | 'ERP_CONNECTION' | 'GENERIC' | 'EMPLOYEE_ROSTER' | 'HRIS' | 'HEADCOUNT' | 'PLANNING_TABLE' required
  • AD_HOC - Ad Hoc
  • ERP_CONNECTION - ERP Connection
  • GENERIC - Generic
  • EMPLOYEE_ROSTER - Employee Roster
  • HRIS - HRIS Connection
  • HEADCOUNT - Headcount Model
  • PLANNING_TABLE - Planning Table
type_friendlystring required
last_importobject required
last_successful_importobject required
source_typestring required

Returns the human-friendly category of the connection's Integration, if the table has a connection. Otherwise, returns 'Data Table'.

Returns: The human-friendly source category

mapping_dataobject required
descriptionstring

Changes

  • 14bc2527c11cRevision changes
    • warning

      added the new PLANNING_TABLE enum value to the //// response property for the response status

    • info

      added the new PLANNING_TABLE enum value to the request property //// (media type: application/json)

    • info

      added the new PLANNING_TABLE enum value to the request property //// (media type: application/x-www-form-urlencoded)

    • info

      added the new PLANNING_TABLE enum value to the request property //// (media type: multipart/form-data)

  • 29a7569c2f46Revision changes
    • warning

      added the new HEADCOUNT enum value to the //// response property for the response status

    • info

      added the new HEADCOUNT enum value to the request property //// (media type: application/json)

    • info

      added the new HEADCOUNT enum value to the request property //// (media type: application/x-www-form-urlencoded)

    • info

      added the new HEADCOUNT enum value to the request property //// (media type: multipart/form-data)