Zabbix API | Power BI | item.get | Date range for getting item details

[debayanbanerjee]

Hello.

I am not able to find a way how to pass a date range parameter ( from (date) and to (date) into the item.get API query.

The parameters time_till and time_from are not working (The API query is running though). This is the query I am using.

let
token = *hidden*
ZabbixURL = *hidden*
Body =
"{
""jsonrpc"": ""2.0"",
""method"": ""item.get"",
""params"": {
""output"": """output"": [""name"", ""hostid"", ""lastvalue"", ""prevvalue"", ""lastclock""]
},
""auth"": """ & token & """,
""id"": 1
}",
Source = Json.Document(
Web.Contents(
ZabbixURL,
[
Headers=[
[HASHTAG="t3950"]content-type[/HASHTAG]="application/json"
],
Content = Text.ToBinary(Body)
]
)
)
in
Source

Any help?

[cyber]

Are you sure you are supposed to be able to do that? What would from and to give to item.get query, which gives you item configuration? There is really nothing to do with date range...

[debayanbanerjee]

I need a date range to fold the query and set up incremental refresh on the generated dataset.

[cyber]

I need a date range to fold the query and set up incremental refresh on the generated dataset.

Whatever that means.. but you do not have any date range selection in item.get method...

[debayanbanerjee]

Ok. Let me rephrase.

In power bi the 'last value' and 'prev value' is updated everytime the data is refreshed. I need to store the previous values as well, that is done using incremental refresh. In order for incremental refresh to work we need to pass a date or a date range so that it does not retrieve all the data all over again. So if I define a start date then the API ideally should not fetch anything before that date (limits the size of the dataset).

Now, as you are saying that there is not date range selection in item.get method, what can be a work around? is there a data range selection in host.get method? I can then make a relationship between the hostid and itemid.

Hope it is clearer now. :-)

Can't I set up something using 'lastclock' in item.get? Say I don't need any more items before lastclock value is so and so? will mathematical operators like less than or greater than work with lastclock value ?

[mcflurry]

You have to retrieve data from api in trends and history, not in items.

[debayanbanerjee]

I am getting parsing error on using the trend.get api as mentioned in the documentation. The 'itemids' is from my own data. Is there anything that I am doing wrong?

let
token = hidden,
ZabbixURL = hidden,
Body =
"{
""jsonrpc"": ""2.0"",
""method"": ""trend.get"",
""params"": {
""output"":
[
""itemid"",
""clock"",
""num"",
""value_min"",
""value_avg"",
""value_max"",
]
""itemids"": [
""87322""
],
""limit"": ""1""
},
""id"": 1
}",
Source = Json.Document(
Web.Contents(
ZabbixURL,
[
Headers=[
[HASHTAG="t3950"]content-type[/HASHTAG]="application/json"
],
Content = Text.ToBinary(Body)
]
)
)
In
Source

[mcflurry]

I am getting parsing error on using the trend.get api as mentioned in the documentation. The 'itemids' is from my own data. Is there anything that I am doing wrong?

Follow this:

https://blog.zabbix.com/zabbix-api-c...postman/12198/

With postman you can fine-tune the API queries, it was quite useful for me.

[debayanbanerjee]

I am sorry. It was my mistake. In a hurry to copy paste I was overwriting the auth token. Now the history and trend apis are working.