curl --request GET \
  --url 'https://app.teable.ai/api/admin/observability/table-query-ops/analyze?spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&maxIndexes=SOME_INTEGER_VALUE' \
  --header 'Authorization: Bearer REPLACE_BEARER_TOKEN'

const url = 'https://app.teable.ai/api/admin/observability/table-query-ops/analyze?spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&maxIndexes=SOME_INTEGER_VALUE';
const options = {method: 'GET', headers: {Authorization: 'Bearer REPLACE_BEARER_TOKEN'}};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}

const http = require('https');

const options = {
  method: 'GET',
  hostname: 'app.teable.ai',
  port: null,
  path: '/api/admin/observability/table-query-ops/analyze?spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&maxIndexes=SOME_INTEGER_VALUE',
  headers: {
    Authorization: 'Bearer REPLACE_BEARER_TOKEN'
  }
};

const req = http.request(options, function (res) {
  const chunks = [];

  res.on('data', function (chunk) {
    chunks.push(chunk);
  });

  res.on('end', function () {
    const body = Buffer.concat(chunks);
    console.log(body.toString());
  });
});

req.end();

import http.client

conn = http.client.HTTPSConnection("app.teable.ai")

headers = { 'Authorization': "Bearer REPLACE_BEARER_TOKEN" }

conn.request("GET", "/api/admin/observability/table-query-ops/analyze?spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&maxIndexes=SOME_INTEGER_VALUE", headers=headers)

res = conn.getresponse()
data = res.read()

print(data.decode("utf-8"))

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://app.teable.ai/api/admin/observability/table-query-ops/analyze",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://app.teable.ai/api/admin/observability/table-query-ops/analyze"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.get("https://app.teable.ai/api/admin/observability/table-query-ops/analyze")
  .header("Authorization", "Bearer <token>")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://app.teable.ai/api/admin/observability/table-query-ops/analyze")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "scope": {
    "maxIndexes": 123,
    "spaceId": "<string>",
    "baseId": "<string>",
    "tableId": "<string>"
  },
  "scannedViewCount": 123,
  "parsedViewCount": 123,
  "scannedRelationFieldCount": 123,
  "candidateIndexCount": 123,
  "validatedRecommendationCount": 123,
  "rejectedCandidateCount": 123,
  "skippedViewCount": 123,
  "recommendedIndexSet": [
    {
      "index": "<string>",
      "indexKind": "<string>",
      "accessPath": "<string>",
      "fields": [
        "<string>"
      ],
      "optimizedSources": [
        "<string>"
      ],
      "optimizedQueryShapes": [
        "<string>"
      ],
      "explainStatus": "validated",
      "confidence": "<string>",
      "nextAction": "ready_for_confirmation",
      "sourceKind": "direct_field",
      "formulaEvidence": {
        "referencedFieldIds": [
          "<string>"
        ],
        "functionNames": [
          "<string>"
        ],
        "skippedReasons": [
          "<string>"
        ],
        "formulaFieldId": "<string>",
        "sourceKind": "formula_result",
        "expressionIndexable": true,
        "expressionIndexSkippedReasons": [
          "<string>"
        ],
        "predicatePushdown": {
          "supported": true,
          "operatorFamilies": [
            "<string>"
          ],
          "sourceFunctionNames": [
            "<string>"
          ],
          "skippedReasons": [
            "<string>"
          ]
        }
      },
      "explainMethod": "explain",
      "explainReason": "<string>",
      "explainCostBefore": 123,
      "explainCostAfter": 123,
      "explainCostDeltaPct": 123,
      "explainPlanNodeBefore": "<string>",
      "explainPlanNodeAfter": "<string>",
      "explainUsesCandidateIndex": true,
      "hypotheticalIndexStatement": "<string>"
    }
  ],
  "rejectedCandidates": [
    {
      "index": "<string>",
      "indexKind": "<string>",
      "accessPath": "<string>",
      "fields": [
        "<string>"
      ],
      "optimizedSources": [
        "<string>"
      ],
      "optimizedQueryShapes": [
        "<string>"
      ],
      "explainStatus": "validated",
      "confidence": "<string>",
      "nextAction": "ready_for_confirmation",
      "sourceKind": "direct_field",
      "formulaEvidence": {
        "referencedFieldIds": [
          "<string>"
        ],
        "functionNames": [
          "<string>"
        ],
        "skippedReasons": [
          "<string>"
        ],
        "formulaFieldId": "<string>",
        "sourceKind": "formula_result",
        "expressionIndexable": true,
        "expressionIndexSkippedReasons": [
          "<string>"
        ],
        "predicatePushdown": {
          "supported": true,
          "operatorFamilies": [
            "<string>"
          ],
          "sourceFunctionNames": [
            "<string>"
          ],
          "skippedReasons": [
            "<string>"
          ]
        }
      },
      "explainMethod": "explain",
      "explainReason": "<string>",
      "explainCostBefore": 123,
      "explainCostAfter": 123,
      "explainCostDeltaPct": 123,
      "explainPlanNodeBefore": "<string>",
      "explainPlanNodeAfter": "<string>",
      "explainUsesCandidateIndex": true,
      "hypotheticalIndexStatement": "<string>"
    }
  ],
  "coverageReport": {
    "scannedSourceCount": 123,
    "parsedSourceCount": 123,
    "shapeCreatedSourceCount": 123,
    "candidateGeneratedSourceCount": 123,
    "explainValidatedSourceCount": 123,
    "rejectedSourceCount": 123,
    "skippedSourceCount": 123,
    "skippedReasons": {},
    "formulaFields": [
      {
        "referencedFieldIds": [
          "<string>"
        ],
        "functionNames": [
          "<string>"
        ],
        "skippedReasons": [
          "<string>"
        ],
        "formulaFieldId": "<string>",
        "sourceKind": "formula_result",
        "expressionIndexable": true,
        "expressionIndexSkippedReasons": [
          "<string>"
        ],
        "predicatePushdown": {
          "supported": true,
          "operatorFamilies": [
            "<string>"
          ],
          "sourceFunctionNames": [
            "<string>"
          ],
          "skippedReasons": [
            "<string>"
          ]
        }
      }
    ],
    "scannedFormulaFieldCount": 123,
    "validatedFormulaFieldCount": 123,
    "rejectedFormulaFieldCount": 123,
    "skippedFormulaFieldCount": 123,
    "formulaSkippedReasons": {},
    "sources": [
      {
        "sourceType": "saved_view",
        "sourceId": "<string>",
        "tableId": "<string>",
        "statuses": [
          "scanned"
        ],
        "candidateIndexKeys": [
          "<string>"
        ],
        "recommendedIndexKeys": [
          "<string>"
        ],
        "rejectedIndexKeys": [
          "<string>"
        ],
        "shapeHash": "<string>",
        "queryKind": "<string>",
        "skippedReason": "<string>",
        "error": "<string>"
      }
    ]
  },
  "queryRiskReports": [
    {
      "sourceType": "saved_view",
      "sourceId": "<string>",
      "tableId": "<string>",
      "queryKind": "<string>",
      "shapeHash": "<string>",
      "riskLevel": "none",
      "riskScore": 123,
      "reasonCodes": [
        "<string>"
      ],
      "shapeSummary": {
        "filterFields": [
          {
            "fieldId": "<string>",
            "operatorFamily": "<string>",
            "sourceKind": "<string>"
          }
        ],
        "sortFields": [
          {
            "direction": "asc",
            "source": "<string>",
            "fieldId": "<string>",
            "systemColumn": "<string>"
          }
        ],
        "formulaFields": [
          {
            "referencedFieldIds": [
              "<string>"
            ],
            "functionNames": [
              "<string>"
            ],
            "skippedReasons": [
              "<string>"
            ],
            "formulaFieldId": "<string>",
            "sourceKind": "formula_result",
            "expressionIndexable": true,
            "expressionIndexSkippedReasons": [
              "<string>"
            ],
            "predicatePushdown": {
              "supported": true,
              "operatorFamilies": [
                "<string>"
              ],
              "sourceFunctionNames": [
                "<string>"
              ],
              "skippedReasons": [
                "<string>"
              ]
            }
          }
        ],
        "search": {
          "fieldCount": 123,
          "allFields": true,
          "valueLengthBucket": "<string>"
        },
        "aggregation": {
          "groupFieldCount": 123,
          "metricCount": 123,
          "hasFilter": true
        },
        "relation": {
          "relationKind": "<string>",
          "sourceTableId": "<string>",
          "targetTableId": "<string>",
          "fieldReferenceCount": 123,
          "hasTargetFilter": true,
          "hasTargetSort": true
        }
      },
      "physicalStats": {
        "estimatedRows": 123
      },
      "indexInventory": {
        "state": "<string>",
        "existingIndexStructures": [
          "<string>"
        ],
        "candidateIndexStructures": [
          "<string>"
        ],
        "abnormalIndexes": [
          "<string>"
        ]
      },
      "remediationSummary": {
        "hasIndexRecommendation": true,
        "recommendedIndexKeys": [
          "<string>"
        ],
        "rejectedIndexKeys": [
          "<string>"
        ],
        "nextAction": "ready_for_confirmation"
      },
      "sourceName": "<string>",
      "planEvidence": {
        "explainStatus": "validated",
        "explainMethod": "explain",
        "explainReason": "<string>",
        "costBefore": 123,
        "costAfter": 123,
        "costDeltaPct": 123,
        "planNodeBefore": "<string>",
        "planNodeAfter": "<string>",
        "usesCandidateIndex": true
      }
    }
  ],
  "rows": [
    {
      "index": "<string>",
      "indexKind": "<string>",
      "accessPath": "<string>",
      "fields": [
        "<string>"
      ],
      "optimizedSources": [
        "<string>"
      ],
      "optimizedQueryShapes": [
        "<string>"
      ],
      "explainStatus": "validated",
      "confidence": "<string>",
      "nextAction": "ready_for_confirmation",
      "sourceKind": "direct_field",
      "formulaEvidence": {
        "referencedFieldIds": [
          "<string>"
        ],
        "functionNames": [
          "<string>"
        ],
        "skippedReasons": [
          "<string>"
        ],
        "formulaFieldId": "<string>",
        "sourceKind": "formula_result",
        "expressionIndexable": true,
        "expressionIndexSkippedReasons": [
          "<string>"
        ],
        "predicatePushdown": {
          "supported": true,
          "operatorFamilies": [
            "<string>"
          ],
          "sourceFunctionNames": [
            "<string>"
          ],
          "skippedReasons": [
            "<string>"
          ]
        }
      },
      "explainMethod": "explain",
      "explainReason": "<string>",
      "explainCostBefore": 123,
      "explainCostAfter": 123,
      "explainCostDeltaPct": 123,
      "explainPlanNodeBefore": "<string>",
      "explainPlanNodeAfter": "<string>",
      "explainUsesCandidateIndex": true,
      "hypotheticalIndexStatement": "<string>"
    }
  ]
}