1C:Enterprise

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 1C:Enterprise

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 OData 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 outside the OData composition rather than a permissions refusal; the agent names what to add and can tick it in your browser. 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 OData composition 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 OData composition against the role permissions and says whether an object is simply outside the composition or closed off by rights, instead of a cryptic OData error.

1C:Enterprise examples

1C:Enterprise
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.
  • The Configurator is needed only for the first web-server publication.
  • In 1C:Fresh and in the cloud the infobase is already published.
  • Server admits listed addresses only? Allow connections from 158.160.205.91 and 87.228.27.163.
  1. 1

    Publish the infobase in IIS/Apache with OData

    Publish the infobase through IIS/Apache with the standard OData interface. For direct cloud access, use a public HTTPS address.

  2. 2

    Add the objects to the OData composition

    In the infobase: Standard OData interface settings, Composition tab. Tick the objects and save. The agent can do it in your browser if you are signed in as admin.

  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

    Enter the publication address, 1C username and password. For a server reachable only inside the office, use its internal address and open the app on a computer there.

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 outside the OData composition, not that permissions were denied. The agent tells these cases apart, names what to add and can tick it in your browser.

Connection
API key
Documentation
1C:Enterprise

Connect 1C:Enterprise

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

Connect