API Data Provider - Online Help

Opsgenie Tables

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

Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

Opsgenie Tables

Name Description
ActionChannels Returns channels for a specified team.
Actions Returns actions for a specified team.
CustomUserRoles Returns custom user roles in Opsgenie.
Escalations Returns escalations in OpsGenie.
ForwardingRules Returns forwarding rules in OpsGenie.
IncidentTemplates Returns incident templates of account.
SavedSearches Returns saved searches.
ScheduleOverrides Returns schedule overrides in Opsgenie.
ScheduleRotations Returns rotations for a given schedule.
Schedules Returns schedules in Opsgenie.
ScheduleTimeline Returns the timeline of the given schedule that includes time and on-call recipient details.
ServiceAudienceTemplates Returns audience template of a given service.
ServiceIncidentRules Returns incident rules for a given service.
Services Returns a given team/customer's services. If the APIKey belongs to a team, then team services will be retrieved. Otherwise, customer services will be retrieved.
TeamLogs Returns logs for a give team.
TeamRoles Returns roles for a give team.
TeamRoutingRules Returns routing rules for a give team.
Teams Returns teams in your account.
UserContacts Returns contacts for a give user.
UserEscalations Returns escalations for a give user.
UserForwardingRules Returns forwarding rules for a give user.
Users Returns users in your account.
UserSchedules Returns schedules for a give user.
UserTeams Returns teams for a give user.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8487.0