missing python json module

[aeshna-cyanea]

Describe the problem to be solved

the formula docs promise access to the python standard library, but to my chagrin i could not load/process a column with json data from within a formula by using python's built in json.loads() function.

Describe the solution you would like

enable reading json!

[paulfitz]

Hi @aeshna-cyanea, you just need to import the module you need, for example this is a valid formula:

import json
json.loads("22")

[aeshna-cyanea]

apologies! wires must have crossed in my brain because regular expressions work in formulas without needing imports so i thought it applied to other modules

[paulfitz]

Makes sense @aeshna-cyanea, the "data engine" implementing formulas uses a few modules itself so those are already imported. I can see how that's confusing.