Stack Overflow
Stack Overflow

Questions tagged [json-query]

Use this tag for tasks involving queries against a JSON document, such as extracting JSON components from a JSON text. The tag can also be used for query languages intended for specifying such queries.

254 questions
0
votes
2 answers

AWS CLI Query IF condition

Could I get help on getting the values of Alias record in the cli table output? The test.emea.example.com. is an alias. BTW, if the DNS record is multi-value, how to flat and concatenate the values Below is the example: $ aws route53…
Tiger peng
  • 647
  • 6
  • 10
0
votes
0 answers

Oracle json query nested array

I would like to query this json example and select the questions.title and questions.answers[].references[].id (a string joined with "," is fine). So far I end up with the following, using json_table, with no success with reference ids: select…
Pietro
  • 1,815
  • 2
  • 29
  • 63
0
votes
1 answer

How can I get and print specific data from a json query?

So i want to be able to pull data based on a certain condition, from this data i then want to be able to print multiple items from this query...here's what ive done so far: def rec(): qe = JsonQ(r"C:\ShopFloor\data.json") res =…
EcSync
  • 842
  • 1
  • 6
  • 20
0
votes
1 answer

Json_query check which rows have a special value in their json list

I have a table that each row contains a json column. Inside the json column I have an object containing an array of tags. What I want to do is to see which rows in my table have the tag that I am searching for. Here is an example of my data: Row 1:…
Ashkan S
  • 10,464
  • 6
  • 51
  • 80
0
votes
1 answer

Query in JSONB array of Postgres database

Below JSON is one of the column of type JSONB in my table 'logic', I want to query to check how many rows are there with type: QUESTION (any entry within conditions). { "name": null, "conditions": [ { "type": "QUESTION", …
Sekhar Dutta
  • 89
  • 1
  • 8
0
votes
1 answer

Ansible pull data from API response

I am trying to use the JSON response from an API to lookup the UUID of a VM I am trying to back up using the hostname. The API returns a list of hashes which include the hostnames and UUID of that hostname. I'd like to get Ansible to return the UUID…
Aaron
  • 3
  • 1
0
votes
1 answer

java.lang.IllegalArgumentException- Property must not be null

I am using SpringBoot1.5.4 Along with that I have spring-data-mongodb. Now I am fetching data from a document using Json Query by @Query annotation. I have following implementation: In PlayAndEarnProgramRepository: @Query(value="{'_id' : ?0 ,…
Jayesh Choudhary
  • 748
  • 2
  • 12
  • 30
0
votes
3 answers

Multiply VBA InputBox value (decimal) by cell value (decimal) derived from a Json url Web Query

(Updated) I'm new to VBA and have been trying various things for hours but I can't seem to figure out how to simply multiply a decimal user input of 1.1 by the cell value of C1 (71388.92). Here is what I've tried last: Private Sub…
kymadic
  • 1
  • 5
0
votes
2 answers

SQL Query into Json Data

I have a table which have many column. One column has json value like { "RequiredForCompany":1, "RequiredOnScreen":0, "Editable":[], "Visible":[], "Expression":{}, "GroupFields":[142,156] } I want to query into this json value with…
Md. Abdul Alim
  • 707
  • 1
  • 6
  • 19
0
votes
1 answer

Ansible json_query - struggling with syntax

I have read this question and this one as well as the relevant Ansible documentation. I still can't work out what the correct syntax to use is. I am trying the following: # Find all of the load-balancers reference - name: Gather facts about all…
Andy
  • 2,095
  • 1
  • 29
  • 59
0
votes
2 answers

How to extract some value from diff fields of an object in one command

there is json data like this ➜ ~ cat foo.json | jq { "data": { "foo": [ { "table": "aaa" }, { "table": "bbb" } ], "bar": [ { "table": "ccc" }, { "table": "ddd" …
zhuguowei
  • 8,401
  • 16
  • 70
  • 106
0
votes
1 answer

How can I catch VpcId if I know a related tag's value ahead?

I have the following output of aws ec2 describe-vpcs: { "Vpcs": [ { "VpcId": "vpc-1f0e197d", "InstanceTenancy": "default", "Tags": [ { "Value":…
Itai Ganot
  • 5,873
  • 18
  • 56
  • 99
0
votes
1 answer

Optimize JSON denormalization using JQ - "cartesian product" from 1:N

I have a JSON database change log, output of wal2json. It looks like this: {"xid":1190,"timestamp":"2018-07-19 17:18:02.905354+02","change":[ {"kind":"update","table":"mytable2","columnnames":["id","name","age"],"columnvalues":[401,"Update…
Ondra Žižka
  • 43,948
  • 41
  • 217
  • 277
0
votes
1 answer

Elastic Nested query - display only the first 2 inner hits

How do I change my query to display only the 5 first orders within the orderbook? My data is structure like this. Order is a nested type. Orderbook |_ Orders This is my query GET /orderindex/_search { "size": 10, "query": { …
Guid
  • 123
  • 2
  • 17
0
votes
0 answers

Json query String for getting value with Condition

I want to get the value of vehicleCodeelement where vehicleLease is AS PER LAW OF ENFORCMENT. Could someone please help me with JSON query ? Please find JSON data below. { "StateOffers": [ [{ "vehicleCode":…
Ashutosh Dalai
  • 67
  • 1
  • 7
1 2 3
…
16
17