# Parse Jason payload have space in its key field

**URL:** <https://discourse.nodered.org/t/parse-jason-payload-have-space-in-its-key-field/14393>\
**Category:** General\
**Created:** [16 August 2019 13:13 UTC](https://discourse.nodered.org/t/parse-jason-payload-have-space-in-its-key-field/14393 "2019-08-16T13:13:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashish\_8284](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ashish_8284/32/3908_2.png) [@ashish\_8284](https://discourse.nodered.org/u/ashish_8284)\
**Post date:** [16 August 2019 13:13 UTC](https://discourse.nodered.org/t/parse-jason-payload-have-space-in-its-key-field/14393/1 "2019-08-16T13:13:49Z")

</div>

Hi,  
I have run node-red on my android mobile & want to read mobile gyro sensor data using exec mode.  
I get data as mentioned below.

16/08/2019, 18:21:48[node: b](http://localhost:1880/#)msg.payload : Object

object

BMI120 Accelerometer:object

values: array[3]

0: 1.7415618896484375

1: 5.5420684814453125

2: 7.62548828125

I wanted to parse data of array(Values).  
But due to Space in "BMI120 Accelerometer" I get Syntex error.

How to handle space in JSON payload key??

I am new in programming so this may look silly question. Forgive for that.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [16 August 2019 13:16 UTC](https://discourse.nodered.org/t/parse-jason-payload-have-space-in-its-key-field/14393/2 "2019-08-16T13:16:16Z")

</div>

You use `[""]`

E.g. `msg.payload["BMI120 Accelerometer"]`

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [16 August 2019 13:30 UTC](https://discourse.nodered.org/t/parse-jason-payload-have-space-in-its-key-field/14393/3 "2019-08-16T13:30:02Z")

</div>

This is the same answer I gave @ashish_8284 in slack before he posted the same question here.

To repeat what else I said in slack, this page in the docs explains how you can use the Debug sidebar to get the path to any message element - [https://nodered.org/docs/user-guide/messages](https://nodered.org/docs/user-guide/messages)

---

<div class="post-metadata">

**Author:** ![ashish\_8284](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ashish_8284/32/3908_2.png) [@ashish\_8284](https://discourse.nodered.org/u/ashish_8284)\
**Post date:** [17 August 2019 06:14 UTC](https://discourse.nodered.org/t/parse-jason-payload-have-space-in-its-key-field/14393/4 "2019-08-17T06:14:26Z")

</div>

Woring Function node is as below.

```auto
var value = msg.payload["LTR578 ALSPS"];
msg.payload = value.values[0];
msg.topic = 'X';
return msg;

```

Thanks for solution.
