I was recently asked how to extract structured data from a JSON URL inside a formula function.

Example JSON URL:
https://raw.githubusercontent.com/codemirror/CodeMirror/master/package.json

Solution:
SCRIPT(`
JSON.parse(
formula(
'READRES("https://github.com/codemirror/CodeMirror/raw/master/package.json")'
)
).name
`)


In this I'm extracting just the 'name' property, but you could use any JS processing to extract and reformat more properties.