René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"JsonObject does not expose array values","articleBody":"Thanks for stopping by to let us know something could be better!\n\n**PLEASE READ**: If you have a support contract with Google, please create an issue in the [support console](https://cloud.google.com/support/) instead of filing on GitHub. This will ensure a timely response.\n\nPlease run down the following list and make sure you've tried the usual \"quick fixes\":\n\n  - Search the issues already opened: https://github.com/googleapis/python-spanner/issues ✅ \n  - Search StackOverflow: https://stackoverflow.com/questions/tagged/google-cloud-platform+python ✅ \n\nIf you are still having issues, please be sure to include as much information as possible:\n\n#### Environment details\n\n  - OS type and version:\n  - Python version: 3.10\n  - pip version: 25.2\n  - `google-cloud-spanner` version: 3.55.0\n\n#### Steps to reproduce\n\n  1. Have a Json column in Spanner with schema like e.g. {\"a\": 1, \"b\": [2,3]} \n  2. execute SQL selecting field b\n  3. Attempt to index into the array contained by b\n  4. error raised\n\n#### Code example\n\n```python\nwith my_database.snapshot() as snapshot:\n    result = snapshot.execute_sql(\"SELECT JSON_QUERY(my_json_col, '$.\"b\"') as b_col\nisinstance(b_col, google.cloud.spanner_v1.data_types.JsonObject) # True\nb_col[0] # raises error \n```\n\n#### Stack trace\n```\nTraceback (most recent call last):\n  File \"\u003cstring\u003e\", line 1, in \u003cmodule\u003e\nKeyError: 0\n```\n\nBasically, I see that holding arrays is seen as possible in JsonObject (https://github.com/googleapis/python-spanner/blob/9535e5e096f6ab53f2817af4fd7ac1fa2ca71660/google/cloud/spanner_v1/data_types.py#L34), and is successfully serialized, but you cannot index into it, if you have need to transform the data in code.\n\n_____________\nMaking sure to follow these steps will guarantee the quickest resolution possible.\n\nThanks!\n","author":{"url":"https://github.com/ajrock","@type":"Person","name":"ajrock"},"datePublished":"2025-11-07T14:13:13.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/1455/python-spanner/issues/1455"}