Confluence page has Confluence database

The Teamwork Graph API is coming soon. The relationship types documented here are indicative of what will be available in the Graph via the Teamwork Graph API. Please note that relationships, their properties, and functionality may change before and during the Early Access Program.

Interested in early access? Express your interest in joining the EAP

The ConfluencePageHasConfluenceDatabase relationship represents the link between a Confluence page and a Confluence database within the Teamwork Graph. It allows you to:

Retrieve databases within a specific Confluence page
Find which Confluence page contains a database
Traverse and analyze page-database relationships

Relationship type: Canonical

From object type	To object type
Confluence page - `ati:cloud:confluence:page`	Confluence database - `ati:cloud:confluence:database`

Cypher

We recommend using parameterized Cypher queries rather than placing parameters directly in the query string. This helps improve performance.

Forward query

GraphQL

1
2
query ConfluencePageHasConfluenceDatabase_CypherQuery($cypherQuery: String!, $params: JSON!) {
 graphStore @optIn(to: ["GraphStore", "GraphStoreCypherQueryV2"]) {
  cypherQueryV2(query: $cypherQuery, params: $params) {
   edges {
    node {
     columns {
      key
      value {. on GraphStoreCypherQueryV2NodeList {
        nodes {
         data {. on ConfluenceDatabase {
           id
          }
         }
        }
       }. on GraphStoreCypherQueryV2AriNode {
        data {. on ConfluenceDatabase {
          id
         }
        }
       }. on GraphStoreCypherQueryV2BooleanObject {
        bool_val: value
       }. on GraphStoreCypherQueryV2IntObject {
        int_val: value
       }. on GraphStoreCypherQueryV2FloatObject {
        float_val: value
       }. on GraphStoreCypherQueryV2StringObject {
        str_val: value
       }
      }
     }
    }
   }
  }
 }
}

Params

1
2
{
 "cypherQuery": "MATCH (page:ConfluencePage {ari: $id})-[:confluence_page_has_confluence_database]->(database:ConfluenceDatabase) RETURN database",
 "params": {
  "id": "$id"
 }
}

Inverse query

GraphQL

1
2
query ConfluencePageHasConfluenceDatabase_CypherQuery($cypherQuery: String!, $params: JSON!) {
 graphStore @optIn(to: ["GraphStore", "GraphStoreCypherQueryV2"]) {
  cypherQueryV2(query: $cypherQuery, params: $params) {
   edges {
    node {
     columns {
      key
      value {. on GraphStoreCypherQueryV2NodeList {
        nodes {
         data {. on ConfluencePage {
           id
          }
         }
        }
       }. on GraphStoreCypherQueryV2AriNode {
        data {. on ConfluencePage {
          id
         }
        }
       }. on GraphStoreCypherQueryV2BooleanObject {
        bool_val: value
       }. on GraphStoreCypherQueryV2IntObject {
        int_val: value
       }. on GraphStoreCypherQueryV2FloatObject {
        float_val: value
       }. on GraphStoreCypherQueryV2StringObject {
        str_val: value
       }
      }
     }
    }
   }
  }
 }
}

Params

1
2
{
 "cypherQuery": "MATCH (page:ConfluencePage)-[:confluence_page_has_confluence_database]->(database:ConfluenceDatabase {ari: $id}) RETURN page",
 "params": {
  "id": "$id"
 }
}