jnd | JSON Never Dies - a binary JSON encoding experiment | JSON Processing library

Here you go : Abc.*?Val\s*?{(\d*?)}

This should have two groups that match the digits. Example here: https://regex101.com/r/2l8eRu/1

Nevermind.

I read about canonical name being a composed attribute and therefore nor searchable. I cut the canonical name string after the last / and used this to search for cn which works fine.

Your first step should be to increase the intervals at which you run the script. There is no need to have it run every 3 seconds (!). Even once a minute would be sufficient but I, personally, would set it to something such as once every ten minutes, since the battery level doesn't tends to only change once within a ten minute window. Even if it changed twice (e.g. dropping from 97% to 96% then to 95%), there would be no negative consequences from your script registering the level going from 97% straight down to 95% in a ten minute interval.

The next thing you can do is store those base 64 strings in properties rather than variables. Properties are set once and stored between subsequent runs of a script. If the values of the properties aren't altered, then the script doesn't need to read a new set of values each time it executes. As they are set at compile time, the overhead is reduced at run time.

The next thing you can do is get rid of the do shell script commands. They incur a lot of overhead. Instead, you can use AppleScriptObjC calls to obtain the information you need. There is still a slight overhead in implementing AppleScriptObjC compared to vanilla AppleScript, but it won't be as great as the cost of creating multiple shell processes:

Try to check your query text

You can convert output to Series with index which create new columns names: