> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://apidocs.polytomic.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://apidocs.polytomic.com/_mcp/server.

# Get Harbor Saved Query

GET https://app.polytomic.com/api/harbors/{harbor_id}/saved-queries/{saved_query_id}

Returns the current published version of one Harbor saved query.

The response contains the current immutable `revision_id`, SQL template,
parameter contract, expected columns, and publication provenance. Validation
inputs are draft-only and are never part of a published response.

A Harbor profile credential can retrieve a saved query only from its own Harbor.

## Harbor Activity

When you use a Harbor profile credential, send a new nonzero UUID in
`X-Polytomic-Activity-Request-ID` for each request. A missing or invalid ID
returns `400 Bad Request`. Reusing a consumed ID returns `409 Conflict`.

If you supply `X-Polytomic-Harbor-Session`, the session must be active and bound
to your credential and Harbor. An invalid session returns `403 Forbidden`.
Direct scoped REST requests may omit the session header.

Polytomic records `saved_query.fetched` before returning the definition. The
event identifies the saved query, exact immutable revision, published version,
and bounded name snapshot. It does not indicate query execution. Activity
excludes SQL, parameter defaults and validation values, expected column names,
and result rows. If Polytomic cannot record the event, the request returns
`503 Service Unavailable` without saved-query data.

Reference: https://apidocs.polytomic.com/api-reference/harbors/get-saved-query

## Authentication

- `Authorization` header (bearer token, required) — Bearer user API key
- `Authorization` header (basic auth, required) — Basic organization-scoped API key

## Request

### Path parameters

- `harbor_id` (string, required) — Unique identifier of the Harbor.
- `saved_query_id` (string, required) — Unique stable identifier of the saved query.

### Headers

- `X-Polytomic-Harbor-Session` (string, optional)
- `X-Polytomic-Activity-Request-ID` (string, optional)

## Response

### 200

OK

- `data` (HarborSavedQueryResponse, optional)

## Errors

### 400 Bad Request Error

Bad Request

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 403 Forbidden Error

Forbidden

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 404 Not Found Error

Not Found

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 409 Conflict Error

Conflict

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 422 Unprocessable Entity Error

Unprocessable Entity

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 500 Internal Server Error

Internal Server Error

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 503 Service Unavailable Error

Service Unavailable

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

## Types

### HarborSavedQueryResponse

- `change_note` (string, optional, nullable) — Note supplied when this version was published.
- `description` (string, optional) — Business definition and usage notes.
- `expected_columns` (list of string, optional, nullable) — Expected ordered result-column names.
- `id` (string, optional) — Stable saved-query identifier.
- `name` (string, optional) — Human-readable saved-query name.
- `owner` (string, optional) — Human-readable owner label.
- `parameters` (list of HarborSavedQueryParameter, optional, nullable) — Published typed scalar parameter declarations.
- `published_at` (datetime, optional) — When this version was published.
- `published_by` (string, optional, nullable) — Actor that published this version. Null for the system actor.
- `published_by_type` (string, optional) — Type of actor that published this version.
- `revision_id` (string, optional) — Immutable identifier of this exact published definition.
- `sql_template` (string, optional) — Published SQL template.
- `updated_at` (datetime, optional) — When this version's draft was last updated before publication.
- `version` (integer, optional) — Current published version number.

### HarborSavedQueryParameter

- `name` (string, required) — Template parameter name referenced as \{\{start\_date}}.
- `type` (enum, required) — Scalar parameter type.
  - Allowed values: `string`, `number`, `boolean`, `date`, `timestamp`, `uuid`
- `default_value` (any, optional) — JSON scalar used when the parameter is omitted, matching the declared type. Use default_value, not default. Optional parameters without a default bind SQL NULL.
- `required` (boolean, optional) — When true, rejects explicit null during validation and execution and allows omission only when default_value is present.

## Examples

**Response**

```json
{
  "data": {
    "change_note": "string",
    "description": "string",
    "expected_columns": [
      "string"
    ],
    "id": "248df4b7-aa70-47b8-a036-33ac447e668d",
    "name": "string",
    "owner": "string",
    "parameters": [
      {
        "name": "start_date",
        "type": "string",
        "default_value": null,
        "required": true
      }
    ],
    "published_at": "2024-01-15T09:30:00Z",
    "published_by": "248df4b7-aa70-47b8-a036-33ac447e668d",
    "published_by_type": "string",
    "revision_id": "248df4b7-aa70-47b8-a036-33ac447e668d",
    "sql_template": "string",
    "updated_at": "2024-01-15T09:30:00Z",
    "version": 1
  }
}
```

**SDK Code**

```python
import requests

url = "https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.json())
```

```javascript
const url = 'https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d';
const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

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.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d"

	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(res)
	fmt.Println(string(body))

}
```

```ruby
require 'uri'
require 'net/http'

url = URI("https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d")

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
```

```java
import com.mashape.unirest.http.HttpResponse;
import com.mashape.unirest.http.Unirest;

HttpResponse<String> response = Unirest.get("https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d")
  .header("Authorization", "Bearer <token>")
  .asString();
```

```php
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

$response = $client->request('GET', 'https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d', [
  'headers' => [
    'Authorization' => 'Bearer <token>',
  ],
]);

echo $response->getBody();
```

```csharp
using RestSharp;

var client = new RestClient("https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d");
var request = new RestRequest(Method.GET);
request.AddHeader("Authorization", "Bearer <token>");
IRestResponse response = client.Execute(request);
```

```swift
import Foundation

let headers = ["Authorization": "Bearer <token>"]

let request = NSMutableURLRequest(url: NSURL(string: "https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d")! 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()
```