How to list all installed extensions/apps in your Business Central environment (Including hidden apps – “_Exclude_……”)

Dynamics 365 Business Central

Hi, Readers.
Today I would like to share another mini tip about Business Central, how to easily list all extensions/apps in your Business Central environment including hidden apps, for example, _Exclude_APIV2_, _Exclude_Microsoft Dynamics 365 – SmartList, etc.

As you might know, you manage apps and extensions on the Extension Management page. You can access this page from Home. Alternatively, choose the Search for Page or Report icon Lightbulb that opens the Tell Me feature. in the top right corner, enter Extension, and then choose the related link.

But this page doesn’t actually show all the extensions in the environment.

For example, _Exclude_Microsoft Dynamics 365 – SmartList

Items By Location:

PS: In the latest version, Microsoft hides the information of Exclude extension on the Page Inspection. But it actually exists anyway.

When you open table 2000000206 “Published Application” directly, an error will be prompted.

The table Published Application cannot be read because it contains system data.

So, what to do?
When we discussed how to get the list of Extension ID (App ID), Extension Name, Publisher, etc. via AL, we use table 2000000153 “NAV App Installed App”. We can use the same method this time.
To view a table, you add the table=<TableID> parameter to the client’s address (URL), replacing <TableID> with the ID of the table that you want to view.
For example,

https://businesscentral.dynamics.com/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox214/?table=2000000153

The list opened this time contains all extensions.
NAV App Installed App:

Very simple, isn’t it? Give it a try!!!😁

One last question, can these hidden extensions be uninstalled?
Since these extensions are not visible on the Extension Management page, we have to consider other ways.

We can use the UninstallExtension() method in codeunit 2504 “Extension Management”.

Source Code:

    /// <summary>
    /// Uninstalls an extension, based on its PackageId.
    /// </summary>
    /// <param name="PackageId">The ID of the extension package.</param>
    /// <param name="IsUIEnabled">Indicates if the uninstall operation is invoked through the UI.</param>
    /// <returns>True if the extention is uninstalled successfully; false otherwise.</returns>
    procedure UninstallExtension(PackageId: Guid; IsUIEnabled: Boolean): Boolean
    begin
        exit(ExtensionInstallationImpl.UninstallExtension(PackageId, IsUIEnabled));
    end;

I did a simple experiment.
First, find out the Package ID using the method mentioned above.

Then I created an extension to uninstall it.

It was successfully uninstalled.😁

In conclusion, these extensions can also be uninstalled. But please be careful with the content of app dependencies when uninstalling. (Please try not to do this……)

If you want to reinstall this extension, since it is Microsoft first party, you need to install it using the same method you used to install the AppSource extension.

To install AppSource Extension do following: In address bar, append following to the base business central URL
?aid= FIN&page=2503&filter=%27ID%27%20IS%20%27<App ID>%27&signInRedirected=1
Then replace part with the AppSource Extension’s App Id.

More details: How to install AppSource Extension in Dynamics 365 Business Central SaaS

PS:
1. If you need to download or view the standard source code of these hidden extensions, please refer to the links below.
Download Standard Source Code

2. All extensions information returned by automation APIs does not include hidden apps – “_Exclude_……”

More details: Automation APIs for Dynamics 365 Business Central SaaS

https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox213/api/microsoft/automation/v2.0/companies(de688871-0a8b-ed11-aad5-000d3a23152c)/extensions
{
    "@odata.context": "https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox213/api/microsoft/automation/v2.0/$metadata#companies(de688871-0a8b-ed11-aad5-000d3a23152c)/extensions",
    "value": [
        {
            "@odata.etag": "W/\"JzIwOzEzMjI1MDIxOTAxNTU4MTg4NTY3MTswMDsn\"",
            "packageId": "a65318e5-57b9-484d-87d8-0e408a01288e",
            "id": "334ef79e-547e-4631-8ba1-7a7f18e14de6",
            "displayName": "Business Central Intelligent Cloud",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzE4MTc5NDE1ODMyODMxNTcxODU2MTswMDsn\"",
            "packageId": "9c5e25a3-de01-4bce-875d-130a1614d23d",
            "id": "2a89f298-7ffd-44a5-a7ce-e08dac98abce",
            "displayName": "Essential Business Headlines",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzQ1NzQzNTQzNTQ4MTA4NjM4MjUxOzAwOyc=\"",
            "packageId": "c9abbcb0-38b7-4d05-9c3e-15309c140699",
            "id": "63ca2fa4-4f03-4f2b-a480-172fef340d3f",
            "displayName": "System Application",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 52589,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzYyODg5ODkzMTIxMTk3NzM5MDMxOzAwOyc=\"",
            "packageId": "64724842-3255-452d-a9d9-1d6eccd115bd",
            "id": "a2cc2ef8-949f-43d4-45b8-10bd6f8bc62c",
            "displayName": "API Reports - Finance",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzY4MDczMzE4NzI4MzA0NTM4MzcxOzAwOyc=\"",
            "packageId": "061c1858-824e-49dd-847d-28231df288d3",
            "id": "58623bfa-0559-4bc2-ae1c-0979c29fd9e0",
            "displayName": "Intelligent Cloud Base",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzkwMTUxOTU4NDQ0MDc1NTM5NjIxOzAwOyc=\"",
            "packageId": "9f7a671f-4102-49d4-8929-32bdd335e223",
            "id": "437dbf0e-84ff-417a-965d-ed2bb9650972",
            "displayName": "Base Application",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 52875,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzQ0MTkyNTUxMDk4NzI2ODk1NDgxOzAwOyc=\"",
            "packageId": "2525fd67-1854-4229-a4c5-35a5ffeeaabe",
            "id": "e97bbbc7-16b6-470b-9428-376baa778970",
            "displayName": "Send remittance advice by email",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzE4MzEyNDI0NDE5NjU0NDU4NjkyMTswMDsn\"",
            "packageId": "91527f9b-3139-48f0-8459-39e1cd2e3305",
            "id": "2654d7e7-9afd-4947-9e02-6bb8f3e0cd04",
            "displayName": "Universal Print Integration",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5Ozk5NjM3MzE3NjgzMTk3OTc5MzExOzAwOyc=\"",
            "packageId": "7b39617e-4fc4-473f-8233-3adbef2509ac",
            "id": "70912191-3c4c-49fc-a1de-bc6ea1ac9da6",
            "displayName": "Intrastat Core",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 52527,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzExMzIxMDg4MjI5MzAwMDQ3MTc1MTswMDsn\"",
            "packageId": "68d9cf7b-b138-40d1-b2c8-3b5486588f55",
            "id": "3d5b2137-efeb-4014-8489-41d37f8fd4c3",
            "displayName": "Late Payment Prediction",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzI3NDAzNjU4MjI0NDE0MDMwNzcxOzAwOyc=\"",
            "packageId": "158b8e41-6131-4928-aa58-3d4aa574c9ff",
            "id": "7961e9dc-a8e5-49b1-839b-3a78803a4cb8",
            "displayName": "Troubleshoot FA Ledger Entries",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzEzMzgwMTI2MDM0NTA0Mzk3NTExMTswMDsn\"",
            "packageId": "fea2cfdf-9e03-4093-8847-483aee8348df",
            "id": "ec255f57-31d0-4ca2-b751-f2fa7c745abb",
            "displayName": "Shopify Connector",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5Ozk4NjA0Mjk3ODM4MDEyODUyNzcxOzAwOyc=\"",
            "packageId": "c701af6f-f162-496d-b780-48c6489aaa31",
            "id": "c50a4bf0-db51-4ad2-88d5-fe2287da0eb8",
            "displayName": "VAT Group Management",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzEzOTkyMTA1OTU5MDk1OTYzMjA5MTswMDsn\"",
            "packageId": "8460a965-9bed-4ecb-93f3-4d899c1b0370",
            "id": "6992416f-3f39-4d3c-8242-3fff61350bea",
            "displayName": "Business Central Cloud Migration - Previous Release",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzE1NDgyNzQyMDA3MDM4NDIxOTk5MTswMDsn\"",
            "packageId": "785a2f23-7de2-4a4a-848c-66dd8f2758df",
            "id": "1d540b30-208b-4993-a46d-ac65fbfe6dd3",
            "displayName": "Test212",
            "publisher": "Default publisher",
            "versionMajor": 1,
            "versionMinor": 0,
            "versionBuild": 0,
            "versionRevision": 0,
            "isInstalled": true,
            "publishedAs": " Dev"
        },
        {
            "@odata.etag": "W/\"JzE5OzIwNzE5ODIzNDI0Mjg2NjA2ODcxOzAwOyc=\"",
            "packageId": "0f7b9ffe-6b85-4997-ae0c-69ced73ee66e",
            "id": "e6328152-bb29-4664-9dae-3bc7eaae1fd8",
            "displayName": "Email - Outlook REST API",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzE2MTAxNzAyNzk3MTEzMTE1MzU3MTswMDsn\"",
            "packageId": "41c0e796-2c9a-49ab-bdfb-770b530b675c",
            "id": "c512d720-63b9-4b26-b062-a0c09b4ed322",
            "displayName": "Company Hub",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzEwODc2ODE2NDkzNTE1NzM3NjMwMTswMDsn\"",
            "packageId": "0bce8607-f210-4804-8ee7-7ae0e8eec5ba",
            "id": "aefe4506-6a2f-4ce4-8ba3-2c87dbc26f53",
            "displayName": "Spanish language (Spain)",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 52283,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzkyODk2MDE2MzE4NDAyNzQ2MzgxOzAwOyc=\"",
            "packageId": "3f97642e-48db-49a4-a559-7bfb58de0e9d",
            "id": "aceb66c8-472e-437c-81d3-27e6c07d0f14",
            "displayName": "Email - Microsoft 365 Connector",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzcxNjUxNjU5NzEzMzkyNDAzODgxOzAwOyc=\"",
            "packageId": "c8a252e6-6017-4eea-8a15-88ccd1f2e99a",
            "id": "8fc50dfb-d338-4fd9-9499-5e44cc8cbf50",
            "displayName": "Email - SMTP API",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzY2MTcwMDUwNjM4NjYzNTE0MjgxOzAwOyc=\"",
            "packageId": "76bad106-3f02-43a8-b75c-8fd742eab21e",
            "id": "e2ae191d-8829-44c3-a373-3749a2742d4d",
            "displayName": "Service Declaration",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzEyMjI2OTM1Nzk2MjE3ODI1MTI1MTswMDsn\"",
            "packageId": "35b9ef4f-5702-425d-a31a-a3b57f520cbf",
            "id": "d09fa965-9a2a-424d-b704-69f3b54ed0ce",
            "displayName": "Payment Links to PayPal",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzE1MDY3MjQ0MTUyMjkzMDI0MDI0MTswMDsn\"",
            "packageId": "80243d59-fe5c-4c74-8516-aafcfbf362a1",
            "id": "ac14293f-1eb7-4a7b-9936-b280da31970b",
            "displayName": "Data Search",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzEzNjYxMDI0NzYzNjg3MTczNzY0MTswMDsn\"",
            "packageId": "247f3c50-b71a-452b-bd2f-b7f7df508eb8",
            "id": "08d69832-9231-429e-be2c-8bab2c96905b",
            "displayName": "Email - Current User Connector",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzEyMDY4NDkzOTEyNTA3NjYxMjUzMTswMDsn\"",
            "packageId": "2450a991-3bee-430d-9c9f-c6699675e2d8",
            "id": "7819d79d-feea-4f09-bbed-5bbaca4bf323",
            "displayName": "Data Archive",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5Ozg1NzczOTMzNjU1ODY0MjQzNTgxOzAwOyc=\"",
            "packageId": "1f4a7ba8-d5a8-495e-8218-d03c842e7427",
            "id": "79b1a79a-2f66-4736-bc1b-8abb3537eb51",
            "displayName": "Simplified Bank Statement Import",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzE2NjU4MzIwNzQ3MTY3ODM5MzY3MTswMDsn\"",
            "packageId": "983f2e47-26e3-486e-b100-d287a3920c24",
            "id": "c1335042-3002-4257-bf8a-75c898ccb1b8",
            "displayName": "Application",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE4OzEwMjI1OTM0MDg5Mjg3ODI1NTE7MDA7Jw==\"",
            "packageId": "d327c9a1-c222-4e04-af1e-e35f08b69b61",
            "id": "c75a45c6-4e83-46e1-b17b-48c6506c19f3",
            "displayName": "French language (France)",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 52283,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzE2MzI4NTMzNzkwMjQ3ODg1ODUwMTswMDsn\"",
            "packageId": "a30eca80-9d73-4f1a-ade4-e3cfa77e070d",
            "id": "57623bfa-0559-4bc2-ae1c-0979c29fc8d1",
            "displayName": "Business Central Cloud Migration API",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzIwOzExNjQ4NDYxNTk1Mjg2OTM1OTMwMTswMDsn\"",
            "packageId": "eebecb77-446c-486e-a836-ec35ff023eb8",
            "id": "a53a4bb0-aa53-8ff8-77d6-fe3388db0eb8",
            "displayName": "Recommended Apps",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzQ2Nzg1MTk2MDAzMjA4Nzg5MDkxOzAwOyc=\"",
            "packageId": "655f3cad-3870-4041-a2c7-ef482adf20d2",
            "id": "c526b3e9-b8ca-4683-81ba-fcd5f6b1472a",
            "displayName": "Sales and Inventory Forecast",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE5OzU4MzcyNzUzMjUxNjExNzg1NjYxOzAwOyc=\"",
            "packageId": "67949d34-cf96-4a9e-8fc6-f1837f7595bf",
            "id": "8c972578-fe72-4aa5-ae51-cc5575fef2ea",
            "displayName": "Send To Email Printer",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        },
        {
            "@odata.etag": "W/\"JzE4OzUyNjY2ODcwNzc3NjIwMDY4MDE7MDA7Jw==\"",
            "packageId": "71569f5b-2234-4dd5-916d-f56abfe5ed3c",
            "id": "68e13fa3-217a-4be0-9141-99e5bf0ca818",
            "displayName": "Email - SMTP Connector",
            "publisher": "Microsoft",
            "versionMajor": 21,
            "versionMinor": 3,
            "versionBuild": 51409,
            "versionRevision": 51727,
            "isInstalled": true,
            "publishedAs": "Global"
        }
    ]
}

END

Hope this will help.

Thanks for reading.

ZHU

コメント

Copied title and URL