Import Business Central Entity

Description

Imports one Business Central OData v2.0 entity, scoped to the connection’s company, over your Business Central connection into a project table. Pick the connection, the entity type, and any filters; the step pulls matching records and writes them, with no OData query to author.

Configuration

Field	Required	Notes
Business Central Connection	Yes	The Business Central connection to read through.
Target Table	Yes	The project table the results are written to. It is overwritten in full on every run.
Entity Type	Yes	Which entity to pull. Default accounts. One of accounts, generalLedgerEntries, customers, vendors, items, journals.
Filters	No	An array of {field, operator, value} clauses, ANDed into the request’s $filter, checked against the entity’s own queryable-field allowlist. An unsupported field is rejected, not silently dropped. Blank pulls the whole entity.

Note

The company comes from the connection, not from this step. Business Central scopes every read to one company, and the connection carries that company along with the environment — so there is no company or environment field on the step. To pull the same entity from a second company, create a second Business Central connection pointing at it.

Note

generalLedgerEntries is Business Central’s read-only, posted-only ledger — it never includes a line still sitting in an unposted journal batch, so it’s the entity to pull for a trial balance or GL detail rather than querying a journal directly.

Related

• Business Central Steps
• Connect to Business Central — step-by-step walkthrough
• Business Central REST Connector