Microsoft 365 ListItems

Microsoft 365 ListItems

Certified

List Business Central items

Retrieves items (products/services) from a Business Central company. Supports optional $filter and $top OData query parameters. Requires the Financials.ReadWrite.All API permission on the service principal.

yaml
type: io.kestra.plugin.microsoft365.dynamics365.businesscentral.ListItems

List items in Business Central

yaml
id: bc_list_items
namespace: company.team

tasks:
  - id: list
    type: io.kestra.plugin.microsoft365.dynamics365.businesscentral.ListItems
    tenantId: "{{ secret('AZURE_TENANT_ID') }}"
    clientId: "{{ secret('AZURE_CLIENT_ID') }}"
    clientSecret: "{{ secret('AZURE_CLIENT_SECRET') }}"
    environment: production
    companyId: "00000000-0000-0000-0000-000000000001"
    filter: "type eq 'Inventory'"
    top: 50
Properties

Client ID

Client ID of the Azure service principal. If you don't have a service principal, refer to create a service principal with Azure CLI.

Company ID

GUID of the Business Central company.

Business Central Environment Name

Name of the Business Central environment to target, e.g. production or sandbox. This is combined with the tenant ID to form the base URL: https://api.businesscentral.dynamics.com/v2.0/{tenantId}/{environment}/api/v2.0.

Tenant ID

Azure AD (Entra ID) tenant GUID used for authentication.

Business Central API endpoint

Override the Business Central API base URL. Useful for sovereign clouds (e.g. GovCloud, China). Defaults to https://api.businesscentral.dynamics.com when not set.

Client Secret

Service principal client secret. Use this for Client Secret authentication. Provide clientId, tenantId, and clientSecret. Either clientSecret OR pemCertificate must be provided, not both.

OData $filter expression

Optional OData filter, e.g. type eq 'Inventory'.

PEM Certificate

Alternative authentication method using certificate-based authentication. Use this for Client Certificate authentication. Provide clientId, tenantId, and pemCertificate. Either clientSecret OR pemCertificate must be provided, not both.

Reference (ref) of the pluginDefaults to apply to this task.

Default100

Maximum records to return ($top)

Maximum number of item records to return. Defaults to 100.

SubTypeobject

Items

List of item records returned by Business Central.

Total number of items

Count of items returned.

Unititems

Number of items returned