1С:Предприятие

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

1С:Предприятие
Frozen chats — click a question
Что вообще отдаёт наша база?

Прочитал /$metadata: в публикации 118 объектов — 47 справочников, 39 документов, 32 регистра.

Ваша отраслевая надстройка тоже видна: документ «ЗаявкаНаПеревозку» и регистр накопления «ЗагрузкаТранспорта» отдаются целиком. А вот журнала путевых листов в составе нет — его надо отметить на вкладке «Состав» и перепубликовать базу.

Объекты публикации по типам

Table · XLSX

How 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. 1

    Publish the infobase in IIS/Apache with OData

    Publish the 1C infobase through IIS or Apache and enable the standard OData interface.

  2. 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. 3

    Create a dedicated 1C user

    Give the user OData remote-access rights and only the read or write permissions the work requires.

  4. 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.

Skills for 1С:Предприятие

Related integrations

Connection
API key

Connect 1С:Предприятие

Connecting takes a couple of minutes, and your data stays in your own systems.

Connect