AI Chat Schema Context

Doku

Basis-Features
Zahlung
Inkasso
- Inkasso
- Inkassobeauftragte
Abo
- Quick Start
- Abos
- Produkte
- Gutscheine
- Abonnenten
Individualisieren
Verbinden
- Connected Services
- Drucken
- Slack
- Shopify
- Wix
- Webhooks
API-Referenz

Dokumentation

A compact skeleton of the analytics tables relevant to a prompt that the human user can query, with their columns and sample queries, when the data ends and the SQL rules to follow. The full detail of a table, column or sample is at its href, which is relative to the base path of the API (.../analytics/ai-chat/queries/) and is called with the same userId parameter and Account header. A table with the detail summary has no columns, state or type values and sample queries; fetch its href before using it in a query. In a table with the detail full an empty list means there is none, except for examples, whose number is capped.

Eigenschaften

Data Context

When the analytics data ends and how to treat to-date periods. Absent if the AI Chat service does not provide it.
Links Guidance

When to follow the hrefs of this skeleton, as advised by the AI Chat service. Absent if the AI Chat service does not provide it.
Query Rules

The SQL correctness rules to follow when writing queries for this schema. Absent if the AI Chat service does not provide them.
Tabellen

The analytics tables relevant to the prompt that the human user can query, sorted by table name in ascending order; empty if no table matches the prompt. A table with the detail full carries its columns, state and type values and sample queries. A table with the detail summary has only name, description, sharded, detail and href, so fetch the table detail at its href before the table is used in a query.
Tables Href

The href of the index of the tables the human user can query that the AI Chat schema catalog documents, for a table the prompt needs but the skeleton does not list. Absent if the AI Chat service does not provide it.