This tag is intended for questions dealing with accessing and reading data elements or series in JSON objects and/or representing such data elements or series with transformations.
Questions tagged [json-extract]
126 questions
0
votes
2 answers
Does BigQuery support NaN inside Json?
Consider BigQuery Schema "Time=Timestamp, Data=String" and the following two rows
2012-11-01 03:45:23 UTC, { "Sensor1": [45.56], "Sensor2": [45.56], "Sensor3": [34.45]}
2012-11-01 05:45:23 UTC, { "Sensor1": [11.43], "Sensor2": [NaN], "Sensor3":…
Tunneller
- 381
- 2
- 13
0
votes
1 answer
How to extract an array using json extractor and parse it to remove dupes in Jmeter
JSON response is returned in the following format, I need to extract values from the first index of the array for example 925,88 using groovy or perhaps another language, and then store them into a variable to pass them along in the next request.…
Shavaiz Safdar
- 31
- 5
0
votes
1 answer
Python named style parameter substitution in a JSON path in a SQLite query?
I am trying to substitute a part of a JSON path with a Python variable in a SQLite select query that includes a JSON extract function. The query works if I do not use substitution:
c.execute("insert into rd_test values (?, ?)",
…
felixjrd
- 65
- 2
- 10
0
votes
1 answer
Metabase - create filter from json field
Is there a way to add a filter based on extracted data from a json field? currently I can do something like
json_extract(meta, '$.mp_origin_meta') AS booking_type)
or
meta->'$.mp_origin_meta'
to extract specific data by writing a native query, but…
Fatemeh Rostami
- 1,047
- 1
- 15
- 27
0
votes
2 answers
How to extract a token value which is available only in Inspect elements-> Application (Not in Inspect Elements-> Network) thru Jmeter?
How to extract a token value which is available only in Inspect elements-> Application (Not in Inspect Elements-> Network) thru Jmeter?
gopi
- 1
0
votes
0 answers
MariaDB Measured value JSON_EXTRACT
I am new to the forum and have a question. I query the MySQL database like this:
SELECT DISTINCT concat (value) FROM mqtt
WHERE topic LIKE 'Sens/005/pulse/SENSOR' AND date(ts)=curdate()
ORDER BY ts…
Thoralf Brandt
- 9
- 2
0
votes
1 answer
How to extract values from column of mysql table having partial Json array values and remaining with string values
Names of these 3 columns were Date, TargetName, Amount.
TargetName column has partial rows with json array values and remaining rows with strings.
I want to extract value[0] from json array.
With condition like [case when (targetName is Json type)…
0
votes
1 answer
In BigQuery, how to filter on json for rows with a condition on a subelement?
We use json_extract to extract fields for data in BigQuery
I can easily filter by event_type, but how can I filter by title extracted from the JSON? for example: only titles that contain the word "facebook"
if I query by operation it works…
user515766
- 349
- 2
- 5
- 7
0
votes
1 answer
I am extracting data from a Json in SQL and the data comes in lists, how do I get it from there?
thanks for reading it!
I am extracting data from a Json with operators in SQL, this is the code:
select lc.name as company,
lr.name as retailer,
ls.name as tienda,
sm.created_on as date,
sm.task_id as task_id,
…
Saul Romero
- 11
- 1
0
votes
2 answers
Query JSON file in Presto in S3
I have a file in S3, and Presto running on EMR. I see I can use Json_extract to read the json.
I am running the following query, however, I keep seeing null instead of the correct value.
select…
IndianGrandma007
- 155
- 1
- 6
0
votes
1 answer
MySQL 5.7 Concatenate values of JSON string into one string
I have a table where the content column consists of a JSON object, with an example value:
{"blocks":[{"score":"A"},{"score":"A"},{"score":"B"}]}
What I am trying to do is SELECT for a string representation of all the scores, so for this example I…
Chris Schlitt
- 133
- 3
- 12
0
votes
2 answers
JMeter- extract 'id' variables from JSON response and save it in CSV file and use it in tear down thread
In my post request create a job whose response have only id as follow,
{"id":626}
And I want to save the id value which is 626 in a csv or any file and after my test complete I want use all these value from this file to check the status of the job…
user14435933
0
votes
0 answers
JSON EXTRACT Search Key use LIKE
So I got JSON and Choice column on MySQL (10.3.15-MariaDB-1:10.3.15+maria~bionic)
This is the JSON =
{"04:17":62,"05:16":31,"06:15":18,"07:14":12,"08:13":8,"09:12":7,"10:11":6}
And the choice is half of the key like 04 / 17 / 08 / 12 etc.
I already…
Hasyidan Paramananda
- 169
- 3
- 15
0
votes
1 answer
I need to return value of json expression
My expression is
{
"author": "%{\"id\" => \"f63b6f8a-4e3e-4884-8ce8-21a7885da7a7\", \"name\" => \"Bye\", \"type\" => \"AUTOMATOR\"}"
}
How do I return AUTOMATOR in the above express?
I am using JSON_EXTRACT(author,"$.type"). Tt is not…
Manish Manohar
- 1
- 2
0
votes
1 answer
MySQL searching JSON array for value, using `like` or regexp
I have a table with a field called data_json.
An example of the JSON shape is below:
{
title: "My Title",
arr: ["hello there", "foobar", "foo hello bar"]
}
I'd simply like to find rows where data_json->'$.arr' contains a value, using regexp, or…
JS_Riddler
- 1,443
- 2
- 22
- 32