API Data Provider - Online Help

Mode Tables

The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.

Mode Tables

Name Description
DataSources Returns a list of all data sources connected to your Mode organization
Definitions Returns a list all Definitions for a given organization
GroupMemberships Returns a list of all memberships in a given group
Groups Returns a list of all groups in your organization
Memberships Returns a list of all members in a given Mode organization
PermissionGrants Returns a list of all users or groups that have been granted permission to access a limited data source
Queries Returns a list of all queries for a given report
QueryRuns Returns a list of all query runs for a given report
ReportFilters Returns a list of all report filters available for a given report
ReportRuns Returns a list of all runs for a given report
Reports Returns a list of all reports in a given Space
ReportSchedules Returns a list of all schedules for a given report
ReportSubscriptions Returns a list of all subscriptions for a given report
ScheduleSubscriptions Returns a list of all subscriptions for a given Report Schedule
SpaceMemberships Returns a list of all memberships in a given Space
Spaces Returns a list representing all Spaces in an organization
User Returns information about a given user's accounts

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060.0