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
1 answer
Need to Extract all data based on condition in jmeter
I got below json as response from HttpRequest of jmeter.
[
{
"state": {
"data": {
"linearId": {
"externalId": null,
"id": "1234"
},
…
Viswa
- 3
- 2
0
votes
2 answers
Access JSON array values using JMeter JSON Extractor
I have the following JSON.
JSON -
{"data": {
"statusCode": 200,
"success": true,
"technicalSettings": [{
"program": "C:/temp/abc.exe",
"actions": "9",
"file_name": "abc1",
"new_file_name":…
RJM
- 271
- 1
- 5
- 32
0
votes
0 answers
Mysql query to search data into Mysql if column contain multidimensional array in JSON form?
I have a product table under which i have create field name : product_attributes under which I have stored all product attributes in json data as show…
Er Parwinder Hirkewal
- 306
- 5
- 14
0
votes
1 answer
JMeter JSON Extractor using -1 value for foreach controller with inconsistent array
JMeter JSON Extractor using -1 value for foreach controller with inconsistent array
I have this JSON response
[
{
"userId": 1,
"id": 1,
"title": " How to Shape of Character Design",
"write": "Jun Bale",
"date": "20/12/20",
…
Sandeep Sharma
- 109
- 2
- 15
0
votes
1 answer
SQL injection in stored procedures and JSON
I am working on an API in Node/JavaScript with a MySQL database. I think this is a question not related to Node/JavaScript, just SQL, but I'm not sure about that.
Here I have a minimal example. Lets say I have a stored procedure to create an…
Emille C.
- 562
- 1
- 7
- 23
0
votes
1 answer
Get object inside more than one object MYSQL JSON
How can I select array "1" inside the "flavor" object from json code in mysql
Attribute name: settings
{"without":{"usd":{"new":"5","old":"8"},"weight":"5"},"color":{"2","3"},"flavor":{"1","2"}}
And how can I get a number inside the "usd" object…
Makarious saad
- 21
- 1
- 5
0
votes
2 answers
Use of Json extractor
Im running a test plan containing 10 requests i need to get the variable value from 3rd response json to be passed to request URL of 10 th request passed . any way we can use json extractor to do this?
rakesh ravindran
- 9
- 3
0
votes
0 answers
Remove JSON object from json array in mysql
I have a column that saves JSON string and I want to get rid of "zipcode" for that JSON object. How can I achieve that using MySQL functions?
{name:"Alex", "address": [
{"type": "primary", "street": "bakers street", "zipcode": 90001},
{"type":…
ps_403
- 23
- 4
0
votes
0 answers
Laravel - Get value of a simple array made json through json_extract and eloquent select
I am trying to get the value of an array made json in Laravel through unquoting extraction operator but it doesn't work.
Json in database
["a","b","c"]
Eloquent
->select('data->[2] as data')
SQL generated for laravel
"select…
joserick
- 327
- 3
- 11
0
votes
0 answers
BigQuery Column with Json Data - Unnest and Extraction
I'm trying to unnest data from a JSON column into separate rows along with the other data in my table. This is what I have so far...
Select
*,
items
from
project.mytable as libraries,
unnest ( libraries.items )
This is the JSON in the…
Matt Bosma
- 1
- 2
0
votes
0 answers
json_extract sql iteration?
sorry I'm a beginner in coding.
I have a set of json array consisting of more than 100 variables. here's the example of the few data:
{"noreg":"643758","norm":"655","nama":"cindy minato…
Bonifacius Sarumpaet
- 1,263
- 1
- 8
- 21
0
votes
1 answer
Reading Multiple levels of repeated JSON structure data in Google BigQuery
I am trying to read the below JSON structure. Was able to get the data to 1 level and see its reading Correctly, but when I go deeper into the other sections.its not reading data correctly. Below is the Input data and the Code Iam using and Output…
Nanda
- 159
- 1
- 13
0
votes
1 answer
Json-path json extractor that consist from nodes with fullstop in their names
I use com.jayway.jsonpath:json-path for quick accessing and modifying nodes.
Example of pattern is: "$.dnode.meta" helps to manage data on meta node level that located inside of dnode. Example of json is:
{
"dnode": {
"meta": "some value"
…
Sergii
- 7,044
- 14
- 58
- 116
0
votes
1 answer
json-extract sqlite format
I used the following command
SELECT json_extract(data,'$.address') FROM data;
and output as CSV file.
Output in CSV file is
enter image description here
Field (column) in CSV file is saved as 2 lines for 1 field (column).
Eg-
"71 CHOA CHU KANG…
kkk
- 95
- 1
- 2
- 11
0
votes
1 answer
Mysql: where in returns no rows when used with json_extract
I am somewhat puzzled with the following simple statements.
create table Test(id integer, data json);
insert into Test(id, data) values(1, '{"name": "vova"}');
select * from Test
where json_extract(data, "$.name") IN ("vova", "mark");
Here select…
StackExploded
- 539
- 7
- 17