Connect Microsoft Dynamics 365 Business Central to Microsoft Excel 365

Retrives the details of a record by it's ID.

Creates a new record.

Deletes an existing record.

Updates an existing record.

Retrives a list of records.

Make a custom API call to a specific endpoint

Append row of values to a worksheet

Update a row in a worksheet

Create a table in a worksheet

Delete a table from a worksheet

Add a worksheet to a workbook

Retrieve a list of workbooks

List rows of a table in a worksheet

Retrieve worksheets from a workbook

Clear a worksheet

Send a custom API call to a specific endpoint

Delete a workbook

Converts a table to a range

Delete a worksheet in a workbook

Append rows to a table

List columns of a table in a worksheet

Retrieve rows from a worksheet

Lookup a value in a table column in a worksheet