Acquiring Column List
Full list of columns can be acquired via a curl query that doesn’t ask for a field::
curl -X 'GET' 'https://192.168.3.166/api/filter/query?query=%5Bhosts%5D%20state%20%3D%201&' -H 'accept: application/json' -H 'Authorization: Basic YWRtaW46YWRtaW4=' -H 'X-CSRF-TOKEN: ' -k | jq
Columns List Part 1:
"accept_passive_checks": {},
"acknowledged": {},
"acknowledgement_type": {},
"action_url": {},
"active_checks_enabled": {},
"address": {},
"alias": {},
"check_command": {},
"check_flapping_recovery_notification": {},
"check_freshness": {},
"check_interval": {},
"check_options": {},
"check_period": {},
"check_source": {},
"check_type": {},
"checks_enabled": {},
"childs": {},
"comments": {},
"comments_with_info": {},
"contact_groups": {},
"contacts": {},
"current_attempt": {},
"current_notification_number": {},
"custom_variable_names": {},
"custom_variable_values": {},
"custom_variables": {},
"display_name": {},
"downtimes": {},
"downtimes_with_info": {},
"event_handler": {},
"event_handler_enabled": {},
"execution_time": {},
"filename": {},
"first_notification_delay": {},
"flap_detection_enabled": {},
"groups": {},
"hard_state": {},
"has_been_checked": {},
"high_flap_threshold": {},
"hourly_value": {},
"icon_image": {},
"icon_image_alt": {},
"in_check_period": {},
"in_notification_period": {},
"initial_state": {},
"is_executing": {},
"is_flapping": {},
"last_check": {},
"last_hard_state": {},
"last_hard_state_change": {},
"last_notification": {},
"last_state": {},
"last_state_change": {},
"last_time_down": {},
"last_time_unreachable": {},
"last_time_up": {},
"latency": {},
"long_plugin_output": {},
"low_flap_threshold": {},
"max_check_attempts": {},
"modified_attributes": {},
"modified_attributes_list": {},
"name": {},
"next_check": {},
"next_notification": {},
"no_more_notifications": {},
"notes": {},
"notes_url": {},
"notification_interval": {},
"notification_period": {},
"notifications_enabled": {},
"num_services": {},
"num_services_crit": {},
"num_services_hard_crit": {},
"num_services_hard_ok": {},
"num_services_hard_unknown": {},
"num_services_hard_warn": {},
"num_services_ok": {},
"num_services_pending": {},
"num_services_unknown": {},
"num_services_warn": {},
"obsess": {},
"parents": {},
"pending_flex_downtime": {},
"percent_state_change": {},
"perf_data_raw": {},
"plugin_output": {},
"pnpgraph_present": {},
"process_performance_data": {},
"process_performance_data_services": {},
"retry_interval": {},
"scheduled_downtime_depth": {},
"services": {},
"services_with_info": {},
"services_with_state": {},
"should_be_scheduled": {},
"state": {},
"state_type": {},
"statusmap_image": {},
"total_services": {},
"worst_service_hard_state": {},
"worst_service_state": {},
"state_text": {},
"checks_disabled": {},
"first_group": {},
"duration": {},
"comments_count": {},
"state_type_text": {},
"check_type_str": {},
"custom_commands": {},
"config_allowed": {},
"source_node": {},
"source_type": {},
"perf_data": {},
"unacknowledged_problem": {},
"acknowledged_problem": {},
"config_url": {},
"public_custom_variables": {}