Failed autosizing columns of worksheet 'Subscriptions' about ari HOT 4 CLOSED

I found a fix, put limit lenght in properties where strlen(properties) < 123000

$Resource = az graph query -q "resources | where subscriptionId == '$SUBID' | where strlen(properties) < 123000 | order by id asc" --skip $Limit --first 1000 --output json --only-show-errors | ConvertFrom-Json

or

az graph query -q "Resources | where strlen(properties.definition.actions) < 120000" -o json

the best way to fix it with project-away
https://docs.microsoft.com/en-us/azure/data-explorer/kql-quick-reference

But Microsoft should fix a bug erro.

az graph query -q "Resources | project-away properties.definition.actions" -o json

from ari.

Deep in looking!

I don't know the reason ,in line 302 get empty variable! When run outside the script, extracted json has null id values and got Erro when run ConvertFrom-Json, in [].data has null values in id.

Line 302

$Resource = az graph query -q "resources | where subscriptionId == '$SUBID' | order by id asc" --skip $Limit --first 1000 --output json --only-show-errors | ConvertFrom-Json

PS Version

PS C:\Users\AZ_test> $PSVersionTable

Name                           Value
----                           -----
PSVersion                      5.1.19041.1023
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.19041.1023
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1

Sample to check

az graph query -q "Resources | where name matches regex '[A-Za-z 0-9]' " -o json | ConvertFrom-Json
ConvertFrom-Json : Cannot process argument because the value of argument "name" is not valid. Change the value of the "name" argument and run the operation again.
At line:1 char:84

• ... where name matches regex '[A-Za-z 0-9]' " -o json | ConvertFrom-Json
• • CategoryInfo : InvalidArgument: (:) [ConvertFrom-Json], PSArgumentException
  • FullyQualifiedErrorId: Argument,Microsoft.PowerShell.Commands.ConvertFromJsonCommand

az graph query -q "Resources | project name, type | where name matches regex '[íãõóêéç]' " -o json | ConvertFrom-Json

@ClaudioMerola
I guess, you should include one kind filter and pick what fields will need, in project parameters , the extraction will be cleaner.

from ari.

Hi,

Yea, very strange behavior.

Thanks for the fix, I included it in the version 1.4.11.

Thanks

from ari.

Thanks @ClaudioMerola !
it is not perfect because exclude resources witch big strings in properties.definition.actions, like big Logic Apps. In my company it was 3 from 400!

from ari.