You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We are querying an API that returns data in JSON but does not allow to filter by date, so we are trying to filter data retrieved by date using available options in this plugin. As far as I know, there are two options: JSONPath and JSONata.
In JSONPath we cannot longer rely on filtering due to security reasons.
And in JSONata, which allows filtering, macros are not enabled on JSONata processing. So I cannot simply go and filter by dashboard date $.data[createdAt < $__isoFrom()].
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi team,
We are querying an API that returns data in JSON but does not allow to filter by date, so we are trying to filter data retrieved by date using available options in this plugin. As far as I know, there are two options: JSONPath and JSONata.
In JSONPath we cannot longer rely on filtering due to security reasons.
And in JSONata, which allows filtering, macros are not enabled on JSONata processing. So I cannot simply go and filter by dashboard date
$.data[createdAt < $__isoFrom()]
.Not the same, but it may be also related with this other discussion.
Thanks for your efforts maintaining this plugin, its really useful.
Beta Was this translation helpful? Give feedback.
All reactions