# Query JSON / JSONATA not returning information
**URL:** https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853
**Category:** Ask for Help
**Created:** [September 6, 2023, 9:25pm UTC](https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853 "2023-09-06T21:25:56Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [September 6, 2023, 9:25pm UTC](https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853/1 "2023-09-06T21:25:56Z")
I have a very simple JSON object in a text column:
{“out-0”:“Who is the king of Belgium? The current king of Belgium is King Philippe. He was born on April 15, 1960, and is the eldest son of King Albert II and Queen Paola. As King, he serves as the General of the Belgian army and has also been involved in promoting Belgian companies and establishing business relations with other countries.”}
When I do Query JSON Column on this with out-0 as the JSONata query it doesn’t return anything.
When I try the following Javascript it also doesn’t do anything:
// Parse the JSON string into a JSON object
const jsonObject = JSON.parse(p1);
// Extract the value associated with the key “out-0”
const result = jsonObject[‘out-0’];
// Now, ‘result’ contains the value you’re interested in
When I do an Excel formula it works, however I assume this will only work for very simple JSON objects.
Excel Formula: MID(A1, LEN(“{”“out-0"”:“”“) + 1, LEN(A1) - LEN(”{““out-0"”:”“”) - LEN(“”“}”))
Any idea on why the JSONata is not working on my JSON object?
btw I tried different types of columns including the single row and also different jsonata queries such as: [‘out-0’]
Many thanks!
Tim
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [September 6, 2023, 11:21pm UTC](https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853/2 "2023-09-06T23:21:21Z")
Hola Tim!
I think your dash/hyphen “-” is confusing the expression. JSONata thinks it’s a subtraction expression 😉
Try with:
```auto
**."out-0"
```
Saludos!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 6, 2023, 11:48pm UTC](https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853/3 "2023-09-06T23:48:20Z")
```auto
`out-0`
```
should be enough.
JSONata treats white space and dashes as special characters, so when you have them as keys on a root level field, you can bind them to ` characters to escape it.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [September 7, 2023, 1:26am UTC](https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853/4 "2023-09-07T01:26:33Z")
> [@ThinhDinh](#):
>
> `out-0`
ufffs… my hat doesn’t have that rabbit! 😀
btw… how are these symbols ( `` ) called in English? … the Spanish language doesn’t have them.
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 7, 2023, 1:37am UTC](https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853/5 "2023-09-07T01:37:13Z")
> [@gvalero](#):
>
> `
A backtick or backquote, I believe.
---
### Author:  [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [September 7, 2023, 9:48am UTC](https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853/6 "2023-09-07T09:48:40Z")
thanks @gvalero and @ThinhDinh
I was trying ‘out-0’ as well but that didn’t work.
However with the `out-0` “backtick quotes” and with the solution of gustavo it works.
However i have no idea where to find these backtick quotes on my Belgium Azerty keyboard 😅
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 7, 2023, 9:52am UTC](https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853/7 "2023-09-07T09:52:24Z")
It’s left to the number 1 key on my MacOS keyboard. I use a standard one.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [September 7, 2023, 3:03pm UTC](https://community.glideapps.com/t/query-json-jsonata-not-returning-information/65853/8 "2023-09-07T15:03:59Z")
> [@Tim\_Gestels](#):
>
> my Belgium Azerty keyboard
no way… an AZERTY keyboard??
this will drive us crazy quickly 🥴
This is how our QWERTY keyboard looks like, the differences are noticeable.:
Saludos!