René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"QAPage","mainEntity":{"@type":"Question","name":"How to fetch just the 'value' from a result set of Key value pair (dict) in Azure","text":"\u003cp dir=\"auto\"\u003e\u003ca class=\"user-mention notranslate\" data-hovercard-type=\"user\" data-hovercard-url=\"/users/jeffreyaven/hovercard\" data-octo-click=\"hovercard-link-click\" data-octo-dimensions=\"link_type:self\" href=\"https://github.com/jeffreyaven\"\u003e@jeffreyaven\u003c/a\u003e  How to fetch just the 'value' from a dict result set in Azure. I need to join it to other tables.\u003c/p\u003e\n\u003cp dir=\"auto\"\u003e\u003ccode class=\"notranslate\"\u003estackql = StackQL(output='dict') query = \"\"\"  select  name from azure.compute.virtual_machine_scale_sets where subscriptionId = '%s' and resourceGroupName = 'vmss-flex';  \"\"\" % (subscription_id) res = stackql.execute(query)  print(res)\u003c/code\u003e\u003c/p\u003e\n\u003cp dir=\"auto\"\u003eResult is \u003ccode class=\"notranslate\"\u003e[{'name': 'vmss1'}]\u003c/code\u003e\u003c/p\u003e\n\u003cp dir=\"auto\"\u003eI just need - vmss1.\u003cbr\u003e\nname.data or name.value does not work.\u003c/p\u003e\n\u003cp dir=\"auto\"\u003eI tried output = 'csv' and was able to get vmss1, but it was adding extra quotes to other json fields.\u003cbr\u003e\nAny help is appreciated.\u003c/p\u003e","upvoteCount":1,"answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"\u003cp dir=\"auto\"\u003ewhat's the error you are getting with this \u003ca class=\"user-mention notranslate\" data-hovercard-type=\"user\" data-hovercard-url=\"/users/vwake7/hovercard\" data-octo-click=\"hovercard-link-click\" data-octo-dimensions=\"link_type:self\" href=\"https://github.com/vwake7\"\u003e@vwake7\u003c/a\u003e the output format shouldn't affect this\u003c/p\u003e","upvoteCount":0,"url":"https://github.com/stackql/stackql/discussions/400#discussioncomment-9208280"}}}