You know the “Export” menu in the views? You can create an API call from every host/service view with filters set:
This makes designing the query a lot easier.
Columns must be defined with (multiple) “&columns=” parameters.
The available columns are documented in the api/doc/#section/Table-definitions and the manual creation of API queries is explained under api/doc/#section/Querying-Status-Data