How to query applications for Api products ?

[#1]

The one way I am aware of is following, is there any other better way?

Run the following two queries and merge the results

To get the list of app_id associated with product run query:- [default@kms] get apiproducts_appslist['orgname@@@productname'];

For app details run query:- [default@kms] get apps['orgname@@@app_id'];