> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://docs.termina.ai/api-reference/data/benchmark/get-columns-metadata/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.termina.ai/_mcp/server. # Columns Metadata GET https://app.termina.ai/api/v1/data/benchmark/metadata/columns Get metadata for all benchmark metrics/columns. Returns comprehensive information about each metric including: - Friendly display names - Units (percent, ratio, scalar, dollar) - Scaling type (geometric or arithmetic) - Performance direction (reverse = lower is better) - Suggested cutoff values Reference: https://docs.termina.ai/api-reference/data/benchmark/get-columns-metadata ## Authentication - `Authorization` header (bearer token, required) — Bearer authentication of the form `Bearer `, where token is your auth token. ## Servers - `https://app.termina.ai` (Production server, default) - `https://app.termina.dev` (Development server) - `http://localhost:8000` (Local development server) ## Response ### 200 Successful Response - `columns` (list of ColumnMetadata, required) — A list of column metadata. - `name_map` (map from string to ColumnMetadata, required) — A mapping column names to their metadata for lookup convenience. ## Types ### ColumnMetadata - `name` (string, required) — The name of the column. - `friendly_name` (string, required) — The friendly displayable name of the column. - `unit` (enum, required) — The unit of the category. - Allowed values: `string`, `percent`, `ratio`, `scalar`, `dollar` - `scaling` (enum, required) — The scaling type of the column. Geometric indicates exponential changes are expected, while arithmetic indicates linear changes. - Allowed values: `geometric`, `arithmetic` - `reverse` (boolean, required) — Whether the column is expected to be higher or lower for better performance. False means higher is better, True means lower is better. - `cutoff` (double, optional, nullable) — The **suggested** cutoff value for the column. This is a guideline for when the absolute value of the column is considered saturated. ## Examples **Response** ```json { "columns": [ { "name": "cmgr12", "friendly_name": "CMGR12", "unit": "dollar", "scaling": "arithmetic", "reverse": false, "cutoff": 10 } ], "name_map": { "cmgr12": { "name": "cmgr12", "friendly_name": "CMGR12", "scaling": "arithmetic", "reverse": false } } } ``` **SDK Code** ```python import requests url = "https://app.termina.ai/api/v1/data/benchmark/metadata/columns" headers = {"Authorization": "Bearer "} response = requests.get(url, headers=headers) print(response.json()) ``` ```javascript const url = 'https://app.termina.ai/api/v1/data/benchmark/metadata/columns'; const options = {method: 'GET', headers: {Authorization: 'Bearer '}}; try { const response = await fetch(url, options); const data = await response.json(); console.log(data); } catch (error) { console.error(error); } ``` ```go package main import ( "fmt" "net/http" "io" ) func main() { url := "https://app.termina.ai/api/v1/data/benchmark/metadata/columns" req, _ := http.NewRequest("GET", url, nil) req.Header.Add("Authorization", "Bearer ") res, _ := http.DefaultClient.Do(req) defer res.Body.Close() body, _ := io.ReadAll(res.Body) fmt.Println(res) fmt.Println(string(body)) } ``` ```ruby require 'uri' require 'net/http' url = URI("https://app.termina.ai/api/v1/data/benchmark/metadata/columns") http = Net::HTTP.new(url.host, url.port) http.use_ssl = true request = Net::HTTP::Get.new(url) request["Authorization"] = 'Bearer ' response = http.request(request) puts response.read_body ``` ```java import com.mashape.unirest.http.HttpResponse; import com.mashape.unirest.http.Unirest; HttpResponse response = Unirest.get("https://app.termina.ai/api/v1/data/benchmark/metadata/columns") .header("Authorization", "Bearer ") .asString(); ``` ```php request('GET', 'https://app.termina.ai/api/v1/data/benchmark/metadata/columns', [ 'headers' => [ 'Authorization' => 'Bearer ', ], ]); echo $response->getBody(); ``` ```csharp using RestSharp; var client = new RestClient("https://app.termina.ai/api/v1/data/benchmark/metadata/columns"); var request = new RestRequest(Method.GET); request.AddHeader("Authorization", "Bearer "); IRestResponse response = client.Execute(request); ``` ```swift import Foundation let headers = ["Authorization": "Bearer "] let request = NSMutableURLRequest(url: NSURL(string: "https://app.termina.ai/api/v1/data/benchmark/metadata/columns")! as URL, cachePolicy: .useProtocolCachePolicy, timeoutInterval: 10.0) request.httpMethod = "GET" request.allHTTPHeaderFields = headers let session = URLSession.shared let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in if (error != nil) { print(error as Any) } else { let httpResponse = response as? HTTPURLResponse print(httpResponse) } }) dataTask.resume() ```