
Microsoft 365 ListItems
CertifiedList Business Central items
Microsoft 365 ListItems
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.
type: io.kestra.plugin.microsoft365.dynamics365.businesscentral.ListItemsExamples
List items in Business Central
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
clientId *Requiredstring
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.
companyId *Requiredstring
Company ID
GUID of the Business Central company.
environment *Requiredstring
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.
tenantId *Requiredstring
Tenant ID
Azure AD (Entra ID) tenant GUID used for authentication.
apiEndpoint string
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.
clientSecret string
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.
filter string
OData $filter expression
Optional OData filter, e.g. type eq 'Inventory'.
pemCertificate string
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.
pluginDefaultsRef Non-dynamicstring
Reference (ref) of the pluginDefaults to apply to this task.
top integerstring
100Maximum records to return ($top)
Maximum number of item records to return. Defaults to 100.
Outputs
items array
Items
List of item records returned by Business Central.
size integer
Total number of items
Count of items returned.
Metrics
count counter
itemsNumber of items returned