Hello everyone, I had a series of doubts. I am conducting API tests from Zabbix to Power BI, and I wanted to know if there is a possibility to monitor and view the status of the ports on the switches and firewalls that I have in Zabbix. I have been trying to modify the item.get code in this way:
let
token = ZabbixToken,
Body =
"{""jsonrpc"": ""2.0"", ""method"": ""item.get"", ""params"": {""output"": ""extend"", ""search"": {""key_"": ""net.if.status""}}, ""auth"": """ & token & """, ""id"": 1}",
Source = Json.Document(
Web.Contents(
ZabbixURL,
[
Headers=[#"Content-Type"="application/json"],
Content = Text.ToBinary(Body)
]
)
),
result = Source[result]
in
result
But I am not getting any data. If anyone knows or has information on how to achieve this, I would appreciate your knowledge.
let
token = ZabbixToken,
Body =
"{""jsonrpc"": ""2.0"", ""method"": ""item.get"", ""params"": {""output"": ""extend"", ""search"": {""key_"": ""net.if.status""}}, ""auth"": """ & token & """, ""id"": 1}",
Source = Json.Document(
Web.Contents(
ZabbixURL,
[
Headers=[#"Content-Type"="application/json"],
Content = Text.ToBinary(Body)
]
)
),
result = Source[result]
in
result
But I am not getting any data. If anyone knows or has information on how to achieve this, I would appreciate your knowledge.