Hello

the centreon API does not support “selection fields” in the query, so you can’t output specific fields (some api do, some don’t, it is what it is)

the point is that it *is* an API, focusing on the P for “Programming”, this json output is yours to use in a program, or script that will consume that data and do the stuff you want and the provider didn’t bother to code in its interface.

“You get data, now go play somewhere else and don’t bother me”, api in a nutshell

Postman is simply a tool to query api, do debugging, simplify a few quirks to “post” “update” instead of doing curl command line, but that’s all it does

I know you can do post-query parsing and things in postman, but that is someting i don’t really know, maybe some postman guru can tell

without programming a thing that will query the api, you could use postman to get the json and save it in a text file, then either use excel to do magic in powerquery, or use a scripting tool, that’s easier to manipulate a json file than to get it from an api call

quickest way :  powershell. (at least for me, i don’t know python or javascript and I’m on windows)

save your json in a file from the postman output, here svc.json,

$toto is now your json database, and you can query it :

in your case you may need to change $_.host.id to $_.hosts.id (with an s) and you may get multiple lines, I don’t really understand your api call

my query was simpler and return “host” singular, not plural (and I may have a different api version)

i’m sure there are way to curl the json directly and parse it with awk or some linux magic somewhere, chose your poison ;)