Query your own 1C database without new custom data processors
Connect any 1C:Enterprise configuration to the AI agent over OData: catalogues, documents, registers. The agent reads your metadata and answers from live data.
How the agent works with 1С:Предприятие
Any configuration on the 1C:Enterprise 8 platform that can publish the standard OData interface will do — industry-specific, customised in-house or written from scratch. The agent reaches it with ordinary HTTP requests to the published address, authenticating on every call, and uses only what OData offers by itself: filtering, ordering, expanding references and paging through results. No code is added inside the database for this.
The agent does not guess applied object names: it reads the /$metadata schema and lists which catalogues, documents, journals and information, accumulation, accounting and calculation registers are actually served outward. For a non-standard database that is a useful step in itself — you see what the publication really exposes before asking any substantive question about the data.
From there the agent works with your structure directly: it selects documents by period, counterparty or an arbitrary attribute and answers in the chat, with no new data processor needed from a developer; it takes the virtual tables of accumulation registers and returns balances and turnovers as of a date across the dimensions you need; and on a schedule it gathers the metrics of your configuration into a regular digest, even when the database has no standard report for the task.
Visibility is limited twice over: by the publication composition and by the permissions of the role of the user whose login and password are connected. The agent tells those two limits apart — an empty /$metadata or a missing object means it is not included in the publication composition rather than a permissions refusal, and the agent says exactly what needs fixing. Writing over OData is available only with the matching role permissions, so a read-only connection changes nothing in the database.
Integration scenarios
See what the publication actually exposes
The agent reads the /$metadata schema of your database and lists which catalogues, documents and registers are really served over OData.
Turnovers and balances by account
The agent pulls turnovers and balances for accounting accounts over a period, breaks them down by subconto and names the accounts with unusual movement.
Month-end close readiness
The agent checks that every document of the month is posted and shows open advances and balances on technical accounts before the close.
Stock levels and purchasing needs
The agent checks stock across warehouses, compares it with the sales rate and shows which items to reorder before you run out.
Receivables and overdue payments
The agent collects settlements, finds overdue receivables by counterparty and prepares a call list.
Covering customer orders
The agent matches customer orders against free stock and purchase orders and shows which lines are still not covered.
Wage fund by department
The agent totals the accruals for the month by department and calculation type and shows where payments grew the most.
Unpaid invoices and cash stuck with clients
The agent collects customer orders and invoices for the period and shows which ones are unpaid and how much money is stuck with clients.
Overdue approvals
The agent finds documents that have been sitting in approval longer than the regulated deadline and names the employees where the route stalled.
A regular digest from your database
The agent gathers the metrics of your configuration on schedule and sends them to the chat, even when no standard report covers the task.
Why an object is missing
The agent checks the publication composition against the role permissions and says whether an object is simply not published or closed off by rights, instead of a cryptic OData error.
1С:Предприятие examples
Прочитал /$metadata: в публикации 118 объектов — 47 справочников, 39 документов, 32 регистра.
Ваша отраслевая надстройка тоже видна: документ «ЗаявкаНаПеревозку» и регистр накопления «ЗагрузкаТранспорта» отдаются целиком. А вот журнала путевых листов в составе нет — его надо отметить на вкладке «Состав» и перепубликовать базу.
Объекты публикации по типам
Table · XLSXHow to connect
Before you connect
- A configuration on the 1C:Enterprise 8 platform.
- An IIS or Apache web server with the 1C extension modules.
- Infobase admin rights and access to the Configurator.
- 1
Publish the infobase in IIS/Apache with OData
Publish the 1C infobase through IIS or Apache and enable the standard OData interface.
- 2
On the Composition tab, tick the objects
On the publication's Composition tab, select the catalogues, documents and registers the agent may access.
- 3
Create a dedicated 1C user
Give the user OData remote-access rights and only the read or write permissions the work requires.
- 4
Enter the publication address and credentials
Use the base publication URL without /odata/standard.odata, plus the 1C username and password.
FAQ
With the publication address plus the login and password of a database user. The database is published on a web server with the standard OData interface enabled, the objects you need are ticked in the composition settings, and a separate user with the OData remote access role is created.
Any configuration on the 1C:Enterprise 8 platform that can publish the standard OData interface will work: 1C:Accounting, Trade Management, ERP, Payroll and HR, Small Firm Management, Document Management, industry-specific solutions and heavily customised databases. One connector covers them all — the platform's OData surface is shared — and the agent takes applied object names from /$metadata rather than guessing them.
Exactly what is ticked on the Composition tab of the OData settings and allowed by the user role: catalogues, documents, journals, information registers, accumulation registers, accounting registers and calculation registers.
An empty /$metadata or a missing object means it is not included in the publication composition, not that permissions were denied. The agent tells these cases apart and says exactly what needs fixing.