# Best Practice Software SQL Passthrough API

**Canonical:** https://apis.io/apis/best-practice/best-practice-sql-passthrough-api/  
**Provider:** Best Practice Software — https://apis.io/providers/best-practice/  
**Base URL:** https://api.haloconnect.io  
**Documentation:** https://docs.haloconnect.io/api-reference/integrator-openapi.html

Best Practice Software SQL Passthrough API is one of 5 APIs that [Best Practice Software](https://apis.io/providers/best-practice/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include SQL Passthrough. The published artifact set on APIs.io includes an OpenAPI specification, an API reference, API documentation, and a getting-started guide.

Send SQL queries to practices as immediate, async or registered queries. **Immediate queries** are small, time-sensitive queries that return a result in seconds. Response size is limited to 8MB. **Async queries** are queued for execution and results can be retrieved later. The workflow is: 1. **Submit async query** – Creates a query and returns a `queryId` on success. 2. **Get query status** – Check query status. When complete, includes pagination details. 3. **Get query result page** – Retrieve result pages using the pagination info from the status response. **Registered Queries** are also supported. See the [Registered Queries](#tag/Registered-Queries) section for more information.

## Machine-readable artifacts (9)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/best-practice/refs/heads/main/openapi/best-practice-sql-passthrough-api-openapi.yml
- **APIReference** — https://docs.haloconnect.io/api-reference/integrator-openapi.html
- **Documentation** — https://docs.haloconnect.io/halo-cloud/overview/
- **GettingStarted** — https://docs.haloconnect.io/halo-cloud/getting-started/
- **APIReference** — https://docs.haloconnect.io/api-reference/desktop-openapi.html
- **Documentation** — https://docs.haloconnect.io/halo-cloud/fhir-api/overview/
- **Documentation** — https://docs.haloconnect.io/halo-cloud/fhir-api/capabilities/
- **Documentation** — https://docs.haloconnect.io/halo-cloud/fhir-api/examples/
- **ImplementationGuide** — https://kb.bpsoftware.net/au/bppremier/devportal/Content/Halo/HaloResources.htm

## Other Best Practice Software APIs (4)

- [Best Practice Software FHIR API](https://apis.io/apis/best-practice/best-practice-fhir-api/)
- [Best Practice Software Registered Queries API](https://apis.io/apis/best-practice/best-practice-registered-queries-api/)
- [Best Practice Software Sites API](https://apis.io/apis/best-practice/best-practice-sites-api/)
- [Best Practice Software Tokens API](https://apis.io/apis/best-practice/best-practice-tokens-api/)

## Tags

SQL Passthrough

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/best-practice/best-practice-sql-passthrough-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/best-practice/.