Data catalog

Authorization: Bearer YOUR_API_KEY_HERE

GET https://api.planasonix.com/api/catalog/tables

{
  "data": [
    {
      "id": "cat_tbl_01inventory",
      "fqn": "analytics.finance.gl_postings",
      "database": "analytics",
      "schema": "finance",
      "name": "gl_postings",
      "row_estimate": 128000000,
      "last_profiled_at": "2025-03-26T22:00:00Z",
      "tags": ["finance", "erp", "pii:none"]
    }
  ],
  "meta": {
    "page": { "limit": 50, "cursor": "eyJuZXh0IjoiY2F0X3RibF8wMiJ9" }
  }
}

GET https://api.planasonix.com/api/catalog/tables/search?q=revenue

{
  "data": [
    {
      "id": "cat_tbl_03rev",
      "fqn": "analytics.marts.fct_daily_revenue",
      "name": "fct_daily_revenue",
      "snippet": "… daily **revenue** by region and product line …",
      "score": 0.92
    }
  ]
}

GET https://api.planasonix.com/api/catalog/tables/{id}

{
  "data": {
    "id": "cat_tbl_01inventory",
    "fqn": "analytics.finance.gl_postings",
    "description": "General ledger posting lines synced from NetSuite",
    "owner_team": "finance-data",
    "columns": [
      {
        "name": "posting_id",
        "type": "varchar(64)",
        "nullable": false,
        "description": "Source system natural key"
      },
      {
        "name": "amount_cents",
        "type": "bigint",
        "nullable": false,
        "description": "Signed amount in minor currency units"
      }
    ],
    "tags": ["finance", "erp", "pii:none"],
    "updated_at": "2025-03-26T22:00:00Z"
  }
}

GET https://api.planasonix.com/api/catalog/tables/{id}/impact

{
  "data": {
    "table_id": "cat_tbl_01inventory",
    "downstream": [
      {
        "resource_type": "pipeline",
        "id": "pl_01hqxyz",
        "name": "finance_mart_refresh"
      },
      {
        "resource_type": "catalog_table",
        "id": "cat_tbl_02marts",
        "fqn": "analytics.marts.fct_gl_balances"
      }
    ],
    "blast_radius_score": "high"
  }
}

GET https://api.planasonix.com/api/catalog/tables/{id}/lineage

{
  "data": {
    "table_id": "cat_tbl_01inventory",
    "upstream": [
      { "id": "cat_tbl_00raw", "edge_type": "copy", "pipeline_id": "pl_ingest_erp" }
    ],
    "downstream": [
      { "id": "cat_tbl_02marts", "edge_type": "transform", "pipeline_id": "pl_01hqxyz" }
    ]
  }
}

GET https://api.planasonix.com/api/catalog/tables/{id}/contracts

{
  "data": [
    {
      "contract_id": "ctr_01j9k8u9v0w1x2y3",
      "name": "customer_360_core",
      "status": "active",
      "assigned_at": "2025-03-22T16:00:00Z"
    }
  ]
}

POST https://api.planasonix.com/api/catalog/tables/{id}/contracts
Content-Type: application/json

{
  "contract_id": "ctr_01j9k8u9v0w1x2y3"
}

{
  "data": {
    "table_id": "cat_tbl_01inventory",
    "contract_id": "ctr_01j9k8u9v0w1x2y3",
    "assigned_at": "2025-03-27T16:00:00Z"
  }
}

DELETE https://api.planasonix.com/api/catalog/tables/{id}/contracts/{contractId}

{
  "data": {
    "table_id": "cat_tbl_01inventory",
    "contract_id": "ctr_01j9k8u9v0w1x2y3",
    "removed": true
  }
}

GET https://api.planasonix.com/api/glossary/domains

POST https://api.planasonix.com/api/glossary/domains
Content-Type: application/json

{
  "name": "Finance",
  "slug": "finance",
  "description": "Revenue, costs, GL, and planning definitions"
}

{
  "data": {
    "id": "gdom_01j9kb2c3d4e5f6g7",
    "name": "Finance",
    "slug": "finance",
    "created_at": "2025-03-27T16:10:00Z"
  }
}

GET https://api.planasonix.com/api/glossary/terms

POST https://api.planasonix.com/api/glossary/terms
Content-Type: application/json

{
  "name": "Active subscriber",
  "slug": "active-subscriber",
  "domain_id": "gdom_01j9kb2c3d4e5f6g7",
  "definition": "A customer with a paid plan in good standing and at least one successful bill in the last 35 days.",
  "aliases": ["paying subscriber"]
}

GET https://api.planasonix.com/api/glossary/terms/{id}
PUT https://api.planasonix.com/api/glossary/terms/{id}
DELETE https://api.planasonix.com/api/glossary/terms/{id}

{
  "definition": "… updated wording after legal review …",
  "status": "pending_review"
}

POST https://api.planasonix.com/api/glossary/terms/{id}/approve
Content-Type: application/json

{
  "comment": "Approved by data council 2025-03-27"
}

{
  "data": {
    "id": "gtrm_01j9kc3d4e5f6g7h8",
    "status": "approved",
    "approved_at": "2025-03-27T17:00:00Z",
    "approved_by": "usr_01h8abc"
  }
}