Hi, Readers.
I was asked a question recently, is there any simple way to view the current list of all APIs in Business Central?
As you might know, we can get a list of APIs by accessing the endpoint.
For example:
1. Standard APIs (v2.0)
Endpoint: https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox01/api/v2.0/
More details: Endpoints for the APIs for Dynamics 365 Business Central On-Premises and Online
![](https://yzhums.com/wp-content/uploads/2022/03/image-4-1024x776.png)
List: (2022/03/01)
{"@odata.context":"https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox01/api/v2.0/$metadata","value":[{"name":"entityDefinitions","kind":"EntitySet","url":"entityDefinitions"},{"name":"companies","kind":"EntitySet","url":"companies"},{"name":"subscriptions","kind":"EntitySet","url":"subscriptions"},{"name":"items","kind":"EntitySet","url":"items"},{"name":"inventoryPostingGroups","kind":"EntitySet","url":"inventoryPostingGroups"},{"name":"generalProductPostingGroups","kind":"EntitySet","url":"generalProductPostingGroups"},{"name":"unitsOfMeasure","kind":"EntitySet","url":"unitsOfMeasure"},{"name":"pictures","kind":"EntitySet","url":"pictures"},{"name":"defaultDimensions","kind":"EntitySet","url":"defaultDimensions"},{"name":"itemVariants","kind":"EntitySet","url":"itemVariants"},{"name":"customers","kind":"EntitySet","url":"customers"},{"name":"customerFinancialDetails","kind":"EntitySet","url":"customerFinancialDetails"},{"name":"agedAccountsReceivables","kind":"EntitySet","url":"agedAccountsReceivables"},{"name":"contactsInformation","kind":"EntitySet","url":"contactsInformation"},{"name":"contacts","kind":"EntitySet","url":"contacts"},{"name":"vendors","kind":"EntitySet","url":"vendors"},{"name":"agedAccountsPayables","kind":"EntitySet","url":"agedAccountsPayables"},{"name":"companyInformation","kind":"EntitySet","url":"companyInformation"},{"name":"salesInvoices","kind":"EntitySet","url":"salesInvoices"},{"name":"dimensionSetLines","kind":"EntitySet","url":"dimensionSetLines"},{"name":"salesInvoiceLines","kind":"EntitySet","url":"salesInvoiceLines"},{"name":"locations","kind":"EntitySet","url":"locations"},{"name":"pdfDocument","kind":"EntitySet","url":"pdfDocument"},{"name":"attachments","kind":"EntitySet","url":"attachments"},{"name":"customerPaymentJournals","kind":"EntitySet","url":"customerPaymentJournals"},{"name":"customerPayments","kind":"EntitySet","url":"customerPayments"},{"name":"accounts","kind":"EntitySet","url":"accounts"},{"name":"taxGroups","kind":"EntitySet","url":"taxGroups"},{"name":"journals","kind":"EntitySet","url":"journals"},{"name":"journalLines","kind":"EntitySet","url":"journalLines"},{"name":"employees","kind":"EntitySet","url":"employees"},{"name":"timeRegistrationEntries","kind":"EntitySet","url":"timeRegistrationEntries"},{"name":"generalLedgerEntries","kind":"EntitySet","url":"generalLedgerEntries"},{"name":"currencies","kind":"EntitySet","url":"currencies"},{"name":"paymentMethods","kind":"EntitySet","url":"paymentMethods"},{"name":"dimensions","kind":"EntitySet","url":"dimensions"},{"name":"dimensionValues","kind":"EntitySet","url":"dimensionValues"},{"name":"paymentTerms","kind":"EntitySet","url":"paymentTerms"},{"name":"shipmentMethods","kind":"EntitySet","url":"shipmentMethods"},{"name":"itemCategories","kind":"EntitySet","url":"itemCategories"},{"name":"cashFlowStatements","kind":"EntitySet","url":"cashFlowStatements"},{"name":"countriesRegions","kind":"EntitySet","url":"countriesRegions"},{"name":"salesOrders","kind":"EntitySet","url":"salesOrders"},{"name":"salesOrderLines","kind":"EntitySet","url":"salesOrderLines"},{"name":"retainedEarningsStatements","kind":"EntitySet","url":"retainedEarningsStatements"},{"name":"balanceSheets","kind":"EntitySet","url":"balanceSheets"},{"name":"trialBalances","kind":"EntitySet","url":"trialBalances"},{"name":"incomeStatements","kind":"EntitySet","url":"incomeStatements"},{"name":"taxAreas","kind":"EntitySet","url":"taxAreas"},{"name":"salesQuotes","kind":"EntitySet","url":"salesQuotes"},{"name":"salesQuoteLines","kind":"EntitySet","url":"salesQuoteLines"},{"name":"salesCreditMemos","kind":"EntitySet","url":"salesCreditMemos"},{"name":"salesCreditMemoLines","kind":"EntitySet","url":"salesCreditMemoLines"},{"name":"purchaseInvoices","kind":"EntitySet","url":"purchaseInvoices"},{"name":"purchaseInvoiceLines","kind":"EntitySet","url":"purchaseInvoiceLines"},{"name":"projects","kind":"EntitySet","url":"projects"},{"name":"bankAccounts","kind":"EntitySet","url":"bankAccounts"},{"name":"vendorPayments","kind":"EntitySet","url":"vendorPayments"},{"name":"applyVendorEntries","kind":"EntitySet","url":"applyVendorEntries"},{"name":"vendorPaymentJournals","kind":"EntitySet","url":"vendorPaymentJournals"},{"name":"salesShipments","kind":"EntitySet","url":"salesShipments"},{"name":"salesShipmentLines","kind":"EntitySet","url":"salesShipmentLines"},{"name":"purchaseReceipts","kind":"EntitySet","url":"purchaseReceipts"},{"name":"purchaseReceiptLines","kind":"EntitySet","url":"purchaseReceiptLines"},{"name":"purchaseOrders","kind":"EntitySet","url":"purchaseOrders"},{"name":"purchaseOrderLines","kind":"EntitySet","url":"purchaseOrderLines"},{"name":"itemLedgerEntries","kind":"EntitySet","url":"itemLedgerEntries"},{"name":"opportunities","kind":"EntitySet","url":"opportunities"},{"name":"customerReturnReasons","kind":"EntitySet","url":"customerReturnReasons"},{"name":"customerSales","kind":"EntitySet","url":"customerSales"},{"name":"vendorPurchases","kind":"EntitySet","url":"vendorPurchases"}]}
2. Automation APIs (v2.0)
Endpoint: https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox01/api/microsoft/automation/v2.0/
![](https://yzhums.com/wp-content/uploads/2022/03/image-5-1024x683.png)
List: (2022/03/01)
{"@odata.context":"https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox01/api/microsoft/automation/v2.0/$metadata","value":[{"name":"entityDefinitions","kind":"EntitySet","url":"entityDefinitions"},{"name":"companies","kind":"EntitySet","url":"companies"},{"name":"subscriptions","kind":"EntitySet","url":"subscriptions"},{"name":"configurationPackages","kind":"EntitySet","url":"configurationPackages"},{"name":"file","kind":"EntitySet","url":"file"},{"name":"automationCompanies","kind":"EntitySet","url":"automationCompanies"},{"name":"extensions","kind":"EntitySet","url":"extensions"},{"name":"userGroups","kind":"EntitySet","url":"userGroups"},{"name":"profiles","kind":"EntitySet","url":"profiles"},{"name":"userGroupPermissions","kind":"EntitySet","url":"userGroupPermissions"},{"name":"users","kind":"EntitySet","url":"users"},{"name":"userGroupMembers","kind":"EntitySet","url":"userGroupMembers"},{"name":"userPermissions","kind":"EntitySet","url":"userPermissions"},{"name":"scheduledJobs","kind":"EntitySet","url":"scheduledJobs"},{"name":"permissionSets","kind":"EntitySet","url":"permissionSets"},{"name":"extensionUpload","kind":"EntitySet","url":"extensionUpload"},{"name":"extensionDeploymentStatus","kind":"EntitySet","url":"extensionDeploymentStatus"}]}
Yes, this is one way to do it, but it is very inconvenient, you need to set up the authentication method first and you also need to use a tool to access it. In this post, I will share a very simple way, hope it will help.
This time we need to use Page Metadata Virtual Table.
Page Metadata Virtual Table: The Page Metadata virtual table (ID 2000000138) contains data about the pages in database.
table 2000000138 “Page Metadata”:
![](https://yzhums.com/wp-content/uploads/2022/03/image-1-1024x405.png)
The following are the fields in the Page Metadata virtual table.
![](https://yzhums.com/wp-content/uploads/2022/03/image-3-399x1024.png)
You can see that there is a PageType field here. More details about PageType.
![](https://yzhums.com/wp-content/uploads/2022/03/image-2-1024x537.png)
So you can force Business Central to run “Page Metadata” table by adding the ?table=2000000138 parameter to the URL, such as in the following example:
https://businesscentral.dynamics.com/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox01?table=2000000138
![](https://yzhums.com/wp-content/uploads/2022/03/image-6-1024x81.png)
![](https://yzhums.com/wp-content/uploads/2022/03/image-7-1024x516.png)
You can filter the API PageType to see a list of all APIs.
![](https://yzhums.com/wp-content/uploads/2022/03/image-8-1024x516.png)
Give it a try!!!😁
![](https://yzhums.com/wp-content/uploads/2022/03/image-9-1024x516.png)
PS: You can also see APIPublisher, APIGroup, APIVersion, EntityName, EntitySetName, SourceTable, etc. directly on this page. More details about API Page Type.
![](https://yzhums.com/wp-content/uploads/2022/03/image-11-1024x516.png)
END
Hope this will help.
Thanks for reading.
ZHU
コメント