Target tables for storing API Service Graph Connector for Apigee X data

  • Release version: Yokohama
  • Updated December 11, 2025
  • 4 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 Apigee X Data

    This document outlines the target tables used for storing data collected through the API Service Graph Connector for Apigee X. After setting up the connection, the integration can periodically pull data from an Apigee X application and save it in various tables that extend from Configuration Item (CMDB) classes and other non-CMDB tables. These tables include Google Organization Project, Apigee API Gateway, Managed API, API Deployment, API Consumer, API Frontend, API Backend, API Product Bundle, API Consumer Subscription, Cloud Organizations, and Google Organization Folder.

    Show full answer Show less

    Key Features

    • Google Organization Project [cmdbcigcpproject]: Stores attributes like name, object ID, and operational status.
    • Apigee API Gateway [cmdbciapigeeapigateway]: Captures details like ID, name, and operational status.
    • Managed API [cmdbcimanagedapi]: Includes attributes such as description, version, base URL, and lifecycle stage status.
    • API Deployment [apideployment]: Contains information about the API name and consumer.
    • API Consumer [apiconsumer]: Records details such as ID, email, and registration date.
    • API Frontend [cmdbciapifrontend]: Encompasses attributes like API version, host, and operational status.
    • API Backend [cmdbciapibackend]: Stores URL, name, and operational status.
    • API Product Bundle [cmdbciapiproductbundle]: Includes details like creation date, description, and operational status.
    • API Consumer Subscription [cmdbciapiconsumersubscription]: Captures subscription details including creation date and operational status.
    • Cloud Organizations [cmdbcicloudorg]: Records attributes such as object ID and operational status.
    • Google Organization Folder [cmdbcigcpfolder]: Contains parent-child relationships and attributes like name and operational status.
    • DNS Alias [cmdbcidnsalias]: Captures the name and operational status.

    Key Outcomes

    By utilizing these tables, customers can effectively manage and analyze their API data within ServiceNow, ensuring visibility into the status and relationships of various components in the Apigee X environment. This setup enables better operational efficiency and informed decision-making regarding API management and integrations.

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

    Google Organization Project [cmdb_ci_gcp_project]

    The following attributes in the Google Organization Project [cmdb_ci_gcp_project] table are populated by collected data:
    Attribute label Attribute name
    Parent parent_ci
    Name name
    Object ID object_id
    Install Status install_status
    Operational status operational_status
    Parent Id parent_id
    Parent Type parent_type
    Project Id project_id
    Time time
    Table 1. Relationships created for Google Organization Project
    Parent class Relationship type Child class
    Google Organization Project [cmdb_ci_gcp_project] Reference Cloud Organizations [cmdb_ci_cloud_org]
    Google Organization Project [cmdb_ci_gcp_project] Reference Google Organization Folder [cmdb_ci_gcp_folder]
    Google Organization Project [cmdb_ci_gcp_project] Contains::Contained by Apigee API Gateway [cmdb_ci_apigee_api_gateway]

    Apigee API Gateway [cmdb_ci_apigee_api_gateway]

    The following attributes in the Apigee API Gateway [cmdb_ci_apigee_api_gateway] table are populated by collected data:
    Attribute label Attribute name
    ID id
    Name name
    Install Status install_status
    Operational status operational_status
    Table 2. Relationships created for Apigee API Gateway
    Parent class Relationship type Child class
    APIgee API Gateway [cmdb_ci_apigee_api_gateway] Provides::Provided by Managed API [cmdb_ci_managed_api]
    APIgee API Gateway [cmdb_ci_apigee_api_gateway] Reference API Consumer [api_consumer]
    Apigee API Gateway [cmdb_ci_apigee_api_gateway] Provides::Provided by API Consumer Subscription [cmdb_ci_api_consumer_subscription]
    Apigee API Gateway [cmdb_ci_apigee_api_gateway] Provides::Provided by API Product Bundle [cmdb_ci_api_product_bundle]

    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
    Description short_description
    Life Cycle Stage life_cycle_stage
    ID id
    Name name
    Version version
    Base URL base_url
    Model ID model_id
    Correlation ID correlation_id
    Life Cycle Stage Status life_cycle_stage_status
    Operational status operational_status
    Table 3. 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] Uses::Used by DNS Alias [cmdb_ci_dns_alias]

    API Deployment [api_deployment]

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

    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
    API Gateway api_gateway
    Custom ID custom_id
    Email email
    Registration Date registration_date
    Username username

    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
    API Version api_version
    Host host
    Method method
    Path path
    URL url
    Description short_description
    Name name
    Operational status operational_status
    Protocol protocol
    Table 4. 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
    URL url
    Name name
    Operational status operational_status
    Type type

    API Product Bundle [cmdb_ci_api_product_bundle]

    The following attributes in the API Product Bundle [cmdb_ci_api_product_bundle] table are populated by collected data:
    Attribute label Attribute name
    ID id
    Creation Date creation_date
    Description short_description
    Discovered Access Type discovered_access_type
    Discovered Approval Type discovered_approval_type
    Last Modified Date last_modified_date
    Name name
    Operational status operational_status
    Table 5. Relationships created for API Product Bundle
    Parent class Relationship type Child class
    API Product Bundle [cmdb_ci_api_product_bundle] Contains::Contained by API [cmdb_ci_api]
    API Product Bundle [cmdb_ci_api_product_bundle] Used by::Uses API Consumer Subscription [cmdb_ci_api_consumer_subscription]
    API Product Bundle [cmdb_ci_api_product_bundle] Reference Key Value [cmdb_key_value]

    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

    API Consumer Subscription [cmdb_ci_api_consumer_subscription]

    The following attributes in the API Consumer Subscription [cmdb_ci_api_consumer_subscription] table are populated by collected data:
    Attribute label Attribute name
    ID id
    Creation Date creation_date
    API Consumer api_consumer
    Discovered State discovered_state
    Last Modified Date last_modified_date
    Name name
    Operational status operational_status
    Table 6. Relationship created for API Consumer Subscription
    Parent class Relationship type Child class
    API Consumer Subscription [cmdb_ci_api_consumer_subscription] Reference Key Value [cmdb_key_value]

    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
    Auth Method access_type
    State state
    Valid to valid_to
    API Product Bundle api_product_bundle
    API Consumer Subscription api_consumer_subscription
    API api
    API Consumer api_consumer

    Cloud Organizations [cmdb_ci_cloud_org]

    The following attributes in the Cloud Organizations [cmdb_ci_cloud_org] table are populated by collected data:
    Attribute label Attribute name
    Object ID object_id
    Install Status install_status
    Name name
    Operational status operational_status
    Time time
    Table 7. Relationship created for Cloud Organizations
    Parent class Relationship type Child class
    Cloud Organizations [cmdb_ci_cloud_org] Contains::Contained by Google Organization Folder [cmdb_ci_gcp_folder]

    Google Organization Folder [cmdb_ci_gcp_folder]

    The following attributes in the Google Organization Folder [cmdb_ci_gcp_folder] table are populated by collected data:
    Attribute label Attribute name
    Parent parent_ci
    Object ID object_id
    Install Status install_status
    Name name
    Operational status operational_status
    Parent Id parent_id
    Parent Type parent_type
    Time time
    Table 8. Relationships created for Google Organization Folder
    Parent class Relationship type Child class
    Google Organization Folder [cmdb_ci_gcp_folder] Reference Google Organization Folder [cmdb_ci_gcp_folder]
    Google Organization Folder [cmdb_ci_gcp_folder] Reference Cloud Organizations [cmdb_ci_cloud_org]

    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