How to query Installed Packages Name and AppExchange Ready columns

Question

How do I get the installed packages "Name" and "AppExchange Ready"?

PackageLicence and Publisher objects are not providing the above information. Can anyone please suggest in what way I can retrieve those details?

Any thoughts would be appreciated.

Thank you

Answer 1

You can use below Query with Tooling API enabled -

SELECT Id, SubscriberPackageId, SubscriberPackage.NamespacePrefix,
      SubscriberPackage.Name, SubscriberPackageVersion.Id,
      SubscriberPackageVersion.Name, SubscriberPackageVersion.MajorVersion,
      SubscriberPackageVersion.MinorVersion,
      SubscriberPackageVersion.PatchVersion,
      SubscriberPackageVersion.BuildNumber,
      SubscriberPackageVersion.IsSecurityReviewed
   FROM InstalledSubscriberPackage
   ORDER BY SubscriberPackageId

Field from the documentation -

IsSecurityReviewed - Specifies whether the package has passed the security review required for publishing in AppExchange.

Reference -

1. InstalledSubscriberPackage object - https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_installedsubscriberpackage.htm

2. SubscriberPackageVersion - https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_subscriberpackageversion.htm