How to query a subset of JSON?

[mskyttner]

Hi duckdbot, how do I query a subset of JSON, say from https://api.openalex.org/works/W2438877200, where I am only interested in the JSON subset under the key "abstract_inverted_index"?

I tried from read_json_auto('https://api.openalex.org/works/W2438877200'); but it returns an error:

Not implemented Error:
Duplicate name "the" in struct auto-detected in JSON, try ignore_errors=true

I believe the JSON is valid JSON

[lmangani]

Hi @mskyttner unfortunately the bot is offline due to authentication issues. Hope DuckDBot will be back soon.