using
\nexec azure.resource_graph.resources.resources\n@data__query = \n'{\n \"query\": \"Resources | project id, name, type, location, tags | limit 3\"\n}';\nBut I am getting the error
\nHTTP response error. Status code 400. Detail: { \"httpError\": { \"statusCode\": 400, \"body\": {\"error\":{\"code\":\"BadRequest\",\"details\":[{\"code\":\"RequestDeserializationFailure\",\"message\":\"An error occurred when deserializing the request body: Unexpected character encountered while parsing value: {. Path 'query', line 1, position 10..\"}],\"message\":\"Please provide below info when asking for support: timestamp = 2024-06-02T11:34:03.2700414Z, correlationId = 72de4bdd-bdfa-4113-9d8a-c658019f7c3e.\"}} } }\nI tried multiple variations of the query, provided required parameters as mentioned here. Any help is appreciated.
","upvoteCount":1,"answerCount":11,"acceptedAnswer":{"@type":"Answer","text":"try:
\nstackql >>SELECT * FROM\nstackql >>azure.resource_graph.graph_resources\nstackql >>WHERE data__query =\nstackql >>\"spotresources\nstackql >>| where type == 'microsoft.compute/skuspotevictionrate/location'\nstackql >>| where location in ('westeurope','northeurope')\nstackql >>| project skuName=tostring(sku.name), location, evictionRate=properties.evictionRate\nstackql >>| order by skuName\"\nstackql >>and data__subscriptions = '[\"0123456789\"]';Azure Resource Graph query #422
-
|
@jeffreyaven I am trying to run this Azure Resource Graph query from Azure Resource Graph using But I am getting the error I tried multiple variations of the query, provided required parameters as mentioned here. Any help is appreciated. |
Beta Was this translation helpful? Give feedback.
Replies: 11 comments 19 replies
-
|
hey @vwake7, try this: exec azure.resource_graph.resources.resources
@@json='{ "query": "Resources | project id, name, type, location, tags | limit 3" }'; |
Beta Was this translation helpful? Give feedback.
-
|
Hi @jeffreyaven , anytime I change or anything else I get below error |
Beta Was this translation helpful? Give feedback.
-
|
try the attached test spec @vwake7 note the resource name includes a reserved work used like (try without any new lines first): SELECT * FROM
azure.resource_graph.graph_resources
WHERE data__query = '{ "query": "Resources | project id, name, type, location, tags | limit 3"}';looks like additional params include:
you will need to replace the let me know how this goes resource_graph.zip (youll need to unzip of course) |
Beta Was this translation helpful? Give feedback.
-
|
@jeffreyaven I am using Azure Provider v24.04.00223, after replacing the resource_graph.yaml file I am getting the original error Also I tried this using the latest docker image, not sure if that matters. |
Beta Was this translation helpful? Give feedback.
-
|
I will have to test this locally and let you know |
Beta Was this translation helpful? Give feedback.
-
|
ok the below works with this updated spec: resource_graph.zip SELECT *
FROM azure.resource_graph.graph_resources
WHERE data__query = 'Resources | project name, type, location, resourceGroup | limit 50';a couple of points to note:
If this works we can merge this into the next release of |
Beta Was this translation helpful? Give feedback.
-
|
Thanks will let you know @jeffreyaven . But how to provide additional parameters like subscriptions? |
Beta Was this translation helpful? Give feedback.
-
|
yes but subscriptions is an array, so |
Beta Was this translation helpful? Give feedback.
-
|
@jeffreyaven the data__query works like a charm. But trying to figure out data__subscriptions. |
Beta Was this translation helpful? Give feedback.
-
|
try: stackql >>SELECT * FROM
stackql >>azure.resource_graph.graph_resources
stackql >>WHERE data__query =
stackql >>"spotresources
stackql >>| where type == 'microsoft.compute/skuspotevictionrate/location'
stackql >>| where location in ('westeurope','northeurope')
stackql >>| project skuName=tostring(sku.name), location, evictionRate=properties.evictionRate
stackql >>| order by skuName"
stackql >>and data__subscriptions = '["0123456789"]'; |
Beta Was this translation helpful? Give feedback.
-
|
@jeffreyaven this works thanks, appreciate the support. so this is an object. Please go ahead and merge it with the next Azure release. Has the release date been fixed? |
Beta Was this translation helpful? Give feedback.
-
|
might be a week or two in the middle of a new |
Beta Was this translation helpful? Give feedback.
-
|
how is your javascript/typescript @vwake7 if you wanted to build a new |
Beta Was this translation helpful? Give feedback.
-
|
@jeffreyaven If you are having hard deadlines, please don't count me. But I have an intern starting in a couple of weeks. |
Beta Was this translation helpful? Give feedback.
-
|
No hard deadlines @vwake7 the scripting to create these specs is pretty involved however but if they know Typescript/JavaScript I can walk them through it, there is some refactoring I want to do on the |
Beta Was this translation helpful? Give feedback.
-
|
Sounds good @jeffreyaven , once I have the intern I will let you know. |
Beta Was this translation helpful? Give feedback.
-
|
@vwake7 fix has been pushed to the dev registry, test this: export DEV_REG="{ \"url\": \"https://registry-dev.stackql.app/providers\" }"
./stackql --registry="${DEV_REG}" shell |
Beta Was this translation helpful? Give feedback.
-
|
@jeffreyaven , getting the certificate error. Is the name of the registry different for dev. |
Beta Was this translation helpful? Give feedback.
-
|
upgrade to the latest |
Beta Was this translation helpful? Give feedback.
-
|
Thanks @jeffreyaven , it works |
Beta Was this translation helpful? Give feedback.
-
|
cool, have merged this into the prod registry now, so you can get rid of the |
Beta Was this translation helpful? Give feedback.
-
|
@jeffreyaven , this works. Thanks for the quick turnaround. |
Beta Was this translation helpful? Give feedback.
-
|
no problems @vwake7 |
Beta Was this translation helpful? Give feedback.
-
|
@jeffreyaven , Is this change applied to pystackql as well? |
Beta Was this translation helpful? Give feedback.
-
|
Hey @vwake7 from pystackql import StackQL
stackql = StackQL()
stackql.upgrade()pull the latest docs using stackql.executeStmt("REGISTRY PULL azure") |
Beta Was this translation helpful? Give feedback.
-
|
hey @vwake7 we have updated stackql-azure-openapi and pushed a new this includes the fix for one you have started stackQL using the dev registry like this: export DEV_REG="{ \"url\": \"https://registry-dev.stackql.app/providers\" }"
./stackql --registry="${DEV_REG}" shellyou can also specify then try: SELECT *
FROM azure.resource_graph.resources
WHERE data__query = 'Resources | project name, type, location, resourceGroup | limit 50';as well as any other would be great to get your feedback! |
Beta Was this translation helpful? Give feedback.
-
|
Also @vwake7 remember to pull the latest |
Beta Was this translation helpful? Give feedback.
-
|
@jeffreyaven will let u know once I am done. |
Beta Was this translation helpful? Give feedback.
-
|
@jeffreyaven the change looks good. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks @vwake7 will publish to the prod registry later today |
Beta Was this translation helpful? Give feedback.
try: