Mastering List records from Business Central

What It Does

• Uses the Business Central (Online) connector in Power Automate.
• Retrieves rows from the BC API v2.0 table you specify—e.g., items, customers, salesOrders.

⚙️ Configuration

• Environment Name: Your production environment (e.g., Production)
• Company ID: The company’s GUID, not the display name
• API Category: v2.0
• Entity Name: Table name, lowercase & plural (e.g., items)
• Top Count: Optional. Number of records to fetch (e.g., 100)
• Filter Query: use OData filters like blocked eq false