Extracting value from nested JSON

mmiah · Sep 10, 2023

Hi - I have a nested JSON with the following column (queue)

queue = {duration=5, name=FirstQueue}

I'm trying to extract name value above but am getting an error using this: json_extract_scalar(queue, '$.name') As Queue,

Error message: FUNCTION_NOT_FOUND: line 7:1: Unexpected parameters, Expected: json_extract_scalar(varchar(x), jsonpath), json_extract_scalar(json, jsonpath)

I'm sure my syntax is incorrect can anyone help? Thank you!

BigDady · Sep 10, 2023

That is not how you write a JSON array and I found out you can't use normal methods if you only have a single object in the array and why would you? JSON is used to tie together a number of data objects for easy shipment.
Check out this page and see the code below. https://www.w3schools.com/js/js_json.asp

Code:

<!DOCTYPE HTML>
<html>
<head>
<title>Hello, HTML</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>

<body>
<div id="demo"></div>
</body>
<script>
let test = '{"queue" : [{"duration":"5", "name":"FirstQueue"},{"duration":"8", "name":"LastQueue"}]}';
const obj = JSON.parse(test);
document.getElementById("demo").innerHTML = obj.queue[0].name + " " + obj.queue[0].duration;
</script>
</html>

VBService · Sep 10, 2023

mmiah said:
Expected: json_extract_scalar(varchar(x), jsonpath),

did you tried like this

SQL:

json_extract_scalar('queue', $.name) As Queue

Issue with passing fetched data to POST form. How can I?	0	Jul 23, 2023
How to parse JSON passed on the command line?	3	Nov 7, 2013
Survey details won't go through using php, ajax, Mysql	0	Oct 26, 2023
Serialize my class as JSON causes "__init__() got an unexpectedkeyword argument 'indent'" ?	3	Dec 18, 2010
[SUMMARY] Parsing JSON (#155)	12	Feb 7, 2008
Extracting a value from an array	17	May 2, 2008
I Need Help with making a function that draws in a canvas using location data.	1	Dec 17, 2021
Novice to Generics Trying to Implement a Generic Priority Queue	13	Apr 8, 2011

Extracting value from nested JSON

mmiah

BigDady

VBService

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads