Hi Vicki,
this is a well-known problem and AFAIK there is even an RFE.
As long as we do not have another solution, just put your Array into an
object, and you can parse it with JSON_TABLE, i.e.
Select *
From JSON_TABLE('{"root": ' concat YourJSONArray concat '}', ...
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vicki
Wilson
Sent: Montag, 6. April 2020 23:00
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: JSON_VALUE/JSON_TABLE Path Expression question
I am trying to use JSON_VALUE and/or JSON_TABLE for some JSON that doesn't
seem to have a typical set-up.
I've been able to use both JSON_VALUE and JSON_TABLE for other pieces of
JSON. My non-typical JSON looks like:
["sometextherebutnocolonforanarry",{"arrayKey1":"Key1value","arraykey2":"key
2value"}]
I don't actually care what's in the first text area. I'm interested in the
values for the key pairs. But I have not been able t
Specifying the arrayKey1 in JSON_VALUE is not working - which makes sense
because I don't know how to account for the first fragment.
Vic
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
