Code: Select all
/ip/firewall/nat/print where chain !="srcnat" and chain !="dstnat"
How to exclude content when query by rest api
Hi guys, i want to query some nat rules like this:
How to do this query by rest api? Thanks.
Re: How to exclude content when query by rest api
In the REST API, you need to use POST operation to do that. The ".query" parameter will control the filter string & that's the hard part. Essentially .query I think needs to need with "#!", but you'll have to play around.
Someone else just ask something similar, so this pretty similar to what your trying to do:
viewtopic.php?t=196021&hilit=post+rest#p1021063
Someone else just ask something similar, so this pretty similar to what your trying to do:
viewtopic.php?t=196021&hilit=post+rest#p1021063
Re: How to exclude content when query by rest api
Specifically, the syntax for the ".query" is use a stack (like an HP / RPN calculator), unlike "find"/"where" in script...
Using curl something like this should work:
So it's "#|!" that's needed, e.g. first "OR" the chain= ones (top two items in stack), then apply the "NOT" (!) using the result of the first operation. See https://help.mikrotik.com/docs/display/ ... PI-Queries for the gory details of how .query works, same for REST's POST as "old"/non-REST API
How to do this query by rest api? Thanks.Code: Select all/ip/firewall/nat/print where chain !="srcnat" and chain !="dstnat"
Using curl something like this should work:
Code: Select all
USER=admin ROUTER=192.168.88.1; curl -l -u $USER -X POST http://$ROUTER/rest/ip/firewall/nat/print -H "Content-Type: application/json" --data '{".query": ["chain=dstnat","chain=srcnat","#|!"]}'
So it's "#|!" that's needed, e.g. first "OR" the chain= ones (top two items in stack), then apply the "NOT" (!) using the result of the first operation. See https://help.mikrotik.com/docs/display/ ... PI-Queries for the gory details of how .query works, same for REST's POST as "old"/non-REST API
Re: How to exclude content when query by rest api
Hi @Amm0:Specifically, the syntax for the ".query" is use a stack (like an HP / RPN calculator), unlike "find"/"where" in script...How to do this query by rest api? Thanks.Code: Select all/ip/firewall/nat/print where chain !="srcnat" and chain !="dstnat"
Using curl something like this should work:
Code: Select allUSER=admin ROUTER=192.168.88.1; curl -l -u $USER -X POST http://$ROUTER/rest/ip/firewall/nat/print -H "Content-Type: application/json" --data '{".query": ["chain=dstnat","chain=srcnat","#|!"]}'
So it's "#|!" that's needed, e.g. first "OR" the chain= ones (top two items in stack), then apply the "NOT" (!) using the result of the first operation. See https://help.mikrotik.com/docs/display/ ... PI-Queries for the gory details of how .query works, same for REST's POST as "old"/non-REST API
Thank you for your help. I understand now.
Re: How to exclude content when query by rest api
Yeah basically REST's "POST" is just a wrapper around the older API. So anything that works there, is just mutated into JSON/etc.