Stack Overflow
Stack Overflow

Questions tagged [json-extract]

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.

126 questions
0
votes
1 answer

Extract json from text using SIddhi Execution Json API

I am trying to extract a valid json from text using Siddhi json Execution API. I have downloaded siddhi-execution-json-1.1.1.jar from wso2 store and following the example mentioned in the documentation there. But the same syntax above is not giving…
Rahul Anand
  • 523
  • 1
  • 7
  • 20
0
votes
2 answers

Convert epoch to date using DATEADD

I explored a lot. I am using this to convert epoch time to date: CASE WHEN json_extract_path_text(cli, 'pickupDate') IS NULL OR json_extract_path_text(cli, 'pickupDate') = '' THEN DATEADD(SECOND, CONVERT(bigint, json_extract_path_text(cli,…
user3681970
  • 1,201
  • 4
  • 19
  • 37
0
votes
1 answer

How to extract multiple correlating variables from a JSon

I have to extract multiple correlating variables from a response (which is json) in JMeter. Part of the response is listed below: [ { "data": { "id": "efaa6876-7a8d-4723-9d85-1ed99e822f06", "type": "courses", "attributes": { …
user270219
  • 91
  • 6
0
votes
0 answers

BigQuery getting exhausted after a few json extraction

I have created a json extraction query from a string field in BigQuery following this answer. But interestingly this query is always working for a first few rows then it is returning empty result. I checked whether the empty results are because they…
Syed Arefinul Haque
  • 1,123
  • 2
  • 14
  • 38
0
votes
0 answers

How to Query json attribute with IN clause in mysql

I have to query the citizenId in JSON column named id_card to see whether it's '1103701468998' or '1555123407115' or not. Somehow, I can't query from the table with JSON_EXTRACT() as below sql select * from ( SELECT case_id, application_id, status,…
Peem
  • 91
  • 1
  • 9
0
votes
1 answer

Convert json string to rows in mysql

How can I convert this json string to a mysql row in…
Parsa Saei
  • 1,263
  • 5
  • 21
  • 38
0
votes
1 answer

how to JSON_EXTRACT using key from a column?

Bigquery JSON_EXTRACT function takes a string as the key to return the value. Is it possible to take the string from a column? The json_string_expr to process is like {'A': '123', 'B': '456'}. I want to take the key from a column list. The Bigquery…
Layla
  • 413
  • 4
  • 7
0
votes
2 answers

How to write a SQL query to pull a value from a nested json object identified by a variable field name

Problem: how to write a sqlite statement to select a value from a nested json object when the needed name is dynamic / variable. It is also important that this can be done from a single sql statement. Eventually, this will be executed from within a…
C0ntr07
  • 51
  • 1
  • 1
  • 9
0
votes
1 answer

json_unquote and extract giving nulls

I'm using this bit of mysql code to pull out pieces of data from an array, but I'm getting back nulls when I run it. Is it a double quote issue that my script is not addressing? Any help is appreciated. Here is the a sample of the script that I'm…
nkramer52
  • 53
  • 6
0
votes
1 answer

Storing the output json parameters as variable in jmeter using it in next request

I have a http request which gives json output as : { "MESSAGE_CODE":200, "MESSAGE_DESCRIPTION":"OTP Generated Successfully", "data": { "otp":"123456", "otpGeneratedDate":"yyyy-mm-dd" } } I want to use otp as the input parameter in json for my next…
Mehul Jain
  • 1
0
votes
1 answer

Mysql JSON_EXTRACT ignore some fields when doing 'not matching' requests

I went into some trouble when performing some select JSON_EXTRACT requests on JSON data stored in a Mysql database. Each row doesn't have exactly the same JSON data structure. All is going well when I'm using JSON_EXTRACT to select fields matching a…
Bertrand
  • 1,840
  • 14
  • 22
-1
votes
1 answer

I want to execute loop depending on the Json Extractor & In loop i want to add another json extractor in Json Expression according to loop iteration

I have added one sampler & get the response of it. In Response there is Big Json array, like There are multiple AppObjects array & In one AppObjects array there are multiple DSQ array. Now i used Json Extractor to get all the AppObjects. Here is the…
Krina Modi
  • 5
  • 2
-1
votes
1 answer

how to cast this data as json in mysql?

I have data in one of my table columns as like {x:1,y:2} . I wanted to cast the data to json like {"x":"1","y":"2"} I tried to use JSON_QUOTE and cast as JSON with no success.
Pvria Ansari
  • 406
  • 4
  • 20
-1
votes
1 answer

How to check value in JSON?

I need to check if the value is in this JSON field SELECT * FROM my_table WHERE JSON_EXTRACT(my_column, '$[*]') = 1 OR SELECT * FROM my_table WHERE 1 IN (JSON_EXTRACT(my_column, '$[*]')) My field: [1,2,3,4] RESOLUTION WORK: SELECT * FROM my_table…
Mateusz Chmielnicki
  • 1
  • 2
-1
votes
1 answer

JMETER: How to add value from CSV file in Json Extractor?

I want to pass value from my csv file in json extractor but it's not working. I have tried like [?(@.name == '${UserName}')].id but when i am simply writing Username without taking it from CSV then it is working.
Praveen Bhatt
  • 1
1 2 3
…
8
9