How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Cube Data Tables API

Data Tables are a generic way to organize the source dimensions, mappings, uploads, and imports from an outside source into Cube (e.g. ERP connections, imported flat files,spreadsheet updates, employee rosters, etc).

Cube Data Tables API is one of 42 APIs that Cube publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Data Tables. The published artifact set on APIs.io includes an OpenAPI specification, an API reference, and API documentation.

This API exposes 13 operations across 7 paths, and defines 29 schemas. It is described by OpenAPI 3.2.0, at version 1.0.0 (1.0).

Requests are made against a single base URL, https://api.cubesoftware.com.

13 operations 7 paths 29 schemas 1 DELETE6 GET1 PATCH5 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
1.0.0 (1.0)
Base URL
https://api.cubesoftware.com
Authentication
OAuth 2.0
Terms of Service
Resource Areas
1

Authentication & Security 1

Cube Data Tables API declares 1 security scheme for authenticating requests. It supports OAuth 2.0 (OAuth2) using the authorizationCode flow.

  • OAuth2 — Standard Cube OAuth 2.0 flow

Paths & Operations 13

Across 7 paths, the API surfaces 13 operations — 1 DELETE, 6 GET, 1 PATCH, 5 POST. Each is listed below with its method, path, parameters, and response codes.

Data Tables 13

Data Tables are a generic way to organize the source dimensions, mappings, uploads, and imports from an outside source into Cube (e.g. ERP connections, imported flat files, spread…

GET
/data-tables
Retrieve Company Data Tables
list 1 param → 200
GET
/data-tables/{data_table_id}
Retrieve a Data Table
retrieve_3 2 params → 200
POST
/data-tables/{data_table_id}
Update a Data Table
data_tables_create 2 params body → 200
PATCH
/data-tables/{data_table_id}
This class exists to have a standard rate limit across all authenticated API endpoints
data_tables_partial_update 1 param body → 200
GET
/data-tables/{data_table_id}/dimensions
Retrieve Data Table Dimensions
data_tables_dimensions_retrieve 5 params → 200
POST
/data-tables/{data_table_id}/dimensions
Update Data Table Dimensions
data_tables_dimensions_create 5 params body → 200
GET
/data-tables/{data_table_id}/dimensions/mappings/rules
Retrieve AutoMappingRules for a Data Table
data_tables_dimensions_mappings_rules_list 2 params → 200
POST
/data-tables/{data_table_id}/dimensions/mappings/rules
Create and Modify AutoMappingRules for a Data Table
data_tables_dimensions_mappings_rules_create 2 params body → 200
GET
/data-tables/{data_table_id}/mappings
Retrieve Mappings for a Data Table
data_tables_mappings_retrieve 3 params → 200
POST
/data-tables/{data_table_id}/mappings
Update Mappings for a Data Table
data_tables_mappings_create 2 params body → 200
POST
/data-tables/{data_table_id}/schedule-import
Schedule and Update a Data Table Import
data_tables_schedule_import_create 2 params body → 200400404403
DELETE
/data-tables/{data_table_id}/schedule-import
Delete the Schedule for a Data Table Import
data_tables_schedule_import_destroy 2 params → 200403
GET
/data-tables/scheduled-imports
Retrieve Scheduled Data Table Imports
data_tables_scheduled_imports_retrieve 2 params → 200403

Schemas 29

The contract defines 29 schemas that model the data the API accepts and returns. The most detailed are SourceDimensionTree (22 properties), DimensionWithTld (16 properties), Dimension (15 properties), SourceDataTable (13 properties). Each schema is shown below with its type and property counts.

RelationshipTypeEnum
string
EMPLOYEE - Employee PARTNER - Partner
PatchedSourceDataTable
object
13 properties
Status2c8Enum
string
ENABLED - Enabled DISABLINGVALUES - Disabling Values CLEARINGVALUES - Clearing Values VALUESCLEARED - Values Cleared DISABLED - Disabled
DimensionMapping
object
5 properties 4 required
User
object
A serializer mixin that allows dynamic inclusion or exclusion of serializer fields by passing fields=[...] or excludefields=[...] when initializing.
9 properties 5 required
SourceDataTableTypeEnum
string
ADHOC - Ad Hoc ERPCONNECTION - ERP Connection GENERIC - Generic EMPLOYEEROSTER - Employee Roster HRIS - HRIS Connection
Type95aEnum
string
BASIC - Basic FORMULA - Formula TAG - Tag
AutoMappingRule
object
5 properties 4 required
WriteProtectionEnum
string
NONE - None BLOCK - Block ACTUALS - Actuals AI - AI
ScheduleDataTableImportRequest
object
6 properties 6 required
AutoMappingDoc
object
3 properties 2 required
RollupTypeEnum
string
SUM - Sum AVERAGE - Average BALANCE - Ending Balance BEGINNINGBALANCE - Beginning Balance
PriorTimeUnitEnum
string
DAY - Day MONTH - Month WEEK - Week QUARTER - Quarter YEAR - Year
Connection
object
7 properties 7 required
TimezoneEnum
string
Africa/Abidjan - Africa/Abidjan Africa/Accra - Africa/Accra Africa/AddisAbaba - Africa/AddisAbaba Africa/Algiers - Africa/Algiers Africa/Asmara - Africa/Asmara…
SourceDataTable
object
13 properties 12 required
DayOfWeekEnum
string
SUNDAY - Sun MONDAY - Mon TUESDAY - Tue WEDNESDAY - Wed THURSDAY - Thu FRIDAY - Fri SATURDAY - Sat
NullEnum
Dimension
object
15 properties 6 required
RuleEnum
string
IGNORE - Ignore ONETOONE - One-to-one MANYTOONE - Many-to-one
ScheduleCadenceEnum
string
WEEKLY - Weekly DAILY - Daily
IntegrationSourceEnum
string
METABASE - Metabase QUICKBOOKS - QuickBooks XERO - Xero NETSUITE - NetSuite SALESFORCE - Salesforce SAGEINTACCT - Sage Intacct RILLET - Rillet CAMPFIRE - Campf…
SourceDimensionTree
object
22 properties 12 required
ScheduledSourceDataTableImports
object
13 properties 6 required
CategoryEnum
string
BI - Business Intelligence GL - General Ledger HRIS - Human Resource Information Service SSO - Single Sign On CRM - Customer Relationship Management OTHER - Ot…
DimensionMappingNested
object
7 properties 4 required
DimensionWithTld
object
16 properties 7 required
Integration
object
5 properties 5 required
BlankEnum

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

cubesoftware-data-tables-api-openapi.yml Raw ↑

Other APIs Cube publishes across the network.

Cube Agents API
Cube Attributes API
Cube Audit Trail API
Cube Auth API
Cube Authentication API
Cube Canvases API
Cube ChatMessages API
Cube ChatSessions API
Cube ChatSettings API
Cube Comments API
Cube Companies API
Cube Company Groups API
Where this information came from

This is an independent, third-party profile of Cube Data Tables API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.