could someone please help an api novice with the syntax to only select records where device = eth0 on this curl statement [darren.brent@dc2tools1 ~]$ curl --noproxy "*" -s -X GET -H "Authorization: Bearer $AUTHTOKEN" https://XX.XX.XX.XX/api/v3/grid/metric-query?query=node_network_transmit_bytes_total --insecure
#storagegrid API
wheat thicket
example of output
{"responseTime":"2023-06-12T15:56:46.037Z","status":"success","apiVersion":"3.4","data":{"resultType":"vector","result":[{"metric":{"name":"node_network_transmit_bytes_total","device":"bond0","instance":"FRNKGEATSN0301ADM01","job":"node","node_id":"6d4ebab1-9fc9-4939-91fe-8520347e6e5e","site_id":"e1d5d656-34e7-4934-b419-b049252b3711","site_name":"eu-central-2-s1"},"value":[1686585406.031,"131257768283"]},{"metric":{"name":"node_network_transmit_bytes_total","device":"bond0","instance":"FRNKGEATSN0301GWN01","job":"node","node_id":"a6ef0fc7-f91e-4cef-bed1-0d3eff661145","site_id":"e1d5d656-34e7-4934-b419-b049252b3711","site_name":"eu-central-2-s1"},"value":[1686585406.031,"45853091569502"]},{"metric":{"name":"node_network_transmit_bytes_total","device":"bond0","instance":"FRNKGEATSN0301GWN02","job":"node","node_id":"7503fd12-6ce7-4979-b494-7493ce9708f8","site_id":"e1d5d656-34e7-4934-b419-b049252b3711","site_name":"eu-central-2-s1"},"value":[1686585406.031,"23697303233"]},{"metric":{"name":"node_network_transmit_bytes_total","device":"bond0","instance":"FRNKGEATSN0301SNC01","job":"node","node_id":"8af32ca4-6925-4860-832b-3a3b2d638959","site_id":"e1d5d656-34e7-4934-b419-b049252b3711","site_name":"eu-central-2-s1"},"value":[1686585406.031,"80151290220939"]},{"metric":{"name":"node_network_transmit_bytes_total","device":"bond0","instance":"FRNKGEATSN0301SNC02","job":"node","node_id":"73e674be-c45d-478d-a0ee-751fb2a3faa0","site_id":"e1d5d656-34e7-4934-b419-b049252b3711","site_name":"eu-central-2-s1"},"value":[1686585406.031,"81219398719991"]},{"metric":{"name":"node_network_transmit_bytes_total","device":"bond0","instance":"FRNKGEATSN0301SNC03","job":"node","node_id":"63d7a253-bda7-4ff2-aaba-e1cb442aa5da","site_id":"e1d5d656-34e7-4934-b419-b049252b3711","site_name":"eu-central-2-s1"},"value":[1686585406.031,"81051551579816"]},{"metric":{"name":"node_network_transmit_bytes_total","device":"bond0","instance":"MNCHGEAOSN0501ADM01","job":"node","node
lament scarab
hi @wheat thicket the SG API you're calling does not support filtering. You'll need to make the request you pasted and filter outside the API, using one of jq, gron, python, go, etc