Target tables for storing API Service Graph Connector for AWS API Gateway data

  • Release version: Australia
  • Updated March 12, 2026
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Target Tables for Storing API Service Graph Connector for AWS API Gateway Data

    This document outlines the target tables used to store data pulled from AWS API Gateway services via the ServiceNow API Service Graph Connector. These tables extend from the Configuration Item (CMDB) classes and capture essential information regarding the AWS API Gateway and related components.

    Show full answer Show less

    Key Features

    • AWS API Gateway [cmdbciawsapigateway]: Stores attributes such as ID, name, and operational status.
    • Managed API [cmdbcimanagedapi]: Captures details including lifecycle stage, base URL, and operational status.
    • API Frontend [cmdbciapifrontend]: Contains data on host, method, path, URL, and authorization.
    • API Backend [cmdbciapibackend]: Includes attributes like ID, URL, and operational status.
    • API Consumer [apiconsumer]: Records consumer ID and username.
    • API Policy [apipolicy]: Details on the name, consumer, and related managed API.
    • Key Value [cmdbkeyvalue]: Stores key-value pairs for configuration management.

    Key Outcomes

    By configuring the integration with AWS API Gateway, ServiceNow customers can effectively manage and analyze API-related data, ensuring accurate monitoring and reporting of their API services. This structured data storage aids in enhanced visibility and control over API operations, contributing to improved service delivery and operational efficiency.

    When you complete setting up the connection, you can configure the integration to periodically pull data from an AWS API Gateway service. The data is saved in tables that extend from the Configuration item [cmdb_ci] classes and other non-CMDB classes.

    AWS API Gateway [cmdb_ci_aws_api_gateway]

    The following attributes in the AWS API Gateway [cmdb_ci_aws_api_gateway] table are populated by collected data:
    Attribute label Attribute name
    ID id
    Name name
    Operational status operational_status
    Table 1. Relationships created for AWS API Gateway
    Parent class Relationship type Child class
    AWS API Gateway [cmdb_ci_aws_api_gateway] Provides::Provided by Managed API [cmdb_ci_managed_api]
    AWS API Gateway [cmdb_ci_aws_api_gateway] Reference API Policy [api_policy]
    AWS API Gateway [cmdb_ci_aws_api_gateway] Reference API Consumer [api_consumer]
    AWS API Gateway [cmdb_ci_aws_api_gateway] Uses::Used by DNS Alias [cmdb_ci_dns_alias]

    DNS Alias [cmdb_ci_dns_alias]

    The following attributes in the DNS Alias [cmdb_ci_dns_alias] table are populated by collected data:
    Attribute label Attribute name
    Name name
    Operational status operational_status

    Managed API [cmdb_ci_managed_api]

    The following attributes in the Managed API [cmdb_ci_managed_api] table are populated by collected data:
    Attribute label Attribute name
    Life Cycle Stage Status life_cycle_stage_status
    ID id
    Name name
    Base URL base_url
    Operational status operational_status
    Life Cycle Stage life_cycle_stage
    Model ID model_id
    Type type
    Table 2. Relationships created for Managed API
    Parent class Relationship type Child class
    Managed API [cmdb_ci_managed_api] Uses::Used by API Frontend [cmdb_ci_api_frontend]
    Managed API [cmdb_ci_managed_api] Uses::Used by API Backend [cmdb_ci_api_backend]
    Managed API [cmdb_ci_managed_api] Reference API Deployment [api_deployment]
    Managed API [cmdb_ci_managed_api] Reference Key Value [cmdb_key_value]

    API Frontend [cmdb_ci_api_frontend]

    The following attributes in the API Frontend [cmdb_ci_api_frontend] table are populated by collected data:
    Attribute label Attribute name
    Host host
    Method method
    Path path
    URL url
    Authorization authorization
    Name name
    Operational status operational_status
    Protocol protocol
    Table 3. Relationship created for API Frontend
    Parent class Relationship type Child class
    API Frontend [cmdb_ci_api_frontend] Use End Point To::Use End Point From API Backend [cmdb_ci_api_backend]

    API Backend [cmdb_ci_api_backend]

    The following attributes in the API Backend [cmdb_ci_api_backend] table are populated by collected data:
    Attribute label Attribute name
    ID id
    URL url
    Name name
    Operational status operational_status
    Type type

    API Consumer [api_consumer]

    The following attributes in the API Consumer [api_consumer] table are populated by collected data:
    Attribute label Attribute name
    ID id
    Username username
    API Gateway api_gateway

    API Consumer Access [api_consumer_access]

    The following attributes in the API Consumer Access [api_consumer_access] table are populated by collected data:
    Attribute label Attribute name
    API api
    API Consumer api_consumer
    State state

    API Deployment [api_deployment]

    The following attributes in the API Deployment [api_deployment] table are populated by collected data:
    Attribute label Attribute name
    Name name
    API api

    API Policy [api_policy]

    The following attributes in the API Policy [api_policy] table are populated by collected data:
    Attribute label Attribute name
    Name name
    Consumer consumer
    ID id
    Managed API managed_api
    Table 4. Relationship created for API Policy
    Parent class Relationship type Child class
    API Policy [api_policy] Reference Managed API [cmdb_ci_managed_api]

    Key Value [cmdb_key_value]

    The following attributes in the Key Value [cmdb_key_value] table are populated by collected data:
    Attribute label Attribute name
    Tag tag
    Configuration item configuration_item
    Key key
    Value value