# Routing different Sparrow sensors to different fields

**URL:** <https://discuss.blues.com/t/routing-different-sparrow-sensors-to-different-fields/1501>\
**Category:** Notehub.io\
**Created:** [July 12, 2023, 6:15am UTC](https://discuss.blues.com/t/routing-different-sparrow-sensors-to-different-fields/1501 "2023-07-12T06:15:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rberkelm](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@rberkelm](https://discuss.blues.com/u/rberkelm)\
**Post date:** [July 12, 2023, 6:15am UTC](https://discuss.blues.com/t/routing-different-sparrow-sensors-to-different-fields/1501/1 "2023-07-12T06:15:21Z")

</div>

If I wanted to route the values of two Sparrow sensors on the same gateway (i.e. common device id) to different fields in ThingSpeak, could I do something like this?:  
(  
$result := {  
“api\_key”: $TSkey,  
“field1”: file = “20373358323650030028001b#air.qo” ? body.temperature,  
“field2”: file = “20373358323650030028001b#air.qo” ? body.humidity,  
“field3”: file = “20373358323650030028001b#air.qo” ? body.pressure,  
“field4”: file = “20373358323650030028001b#air.qo” ? body.voltage  
“field5”: file = “2037335832365003003f0048#air.qo” ? body.temperature,  
“field6”: file = “2037335832365003003f0048#air.qo” ? body.humidity,  
“field7”: file = “2037335832365003003f0048#air.qo” ? body.pressure,  
“field8”: file = “2037335832365003003f0048#air.qo” ? body.voltage  
};  
)

This doesn’t actually work, but can it be tweaked to make it work? “TSkey” in this route is set as an environmental variable at the device level.

---

<div class="post-metadata">

**Author:** ![RobLauer](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.blues.com/roblauer/32/1567_2.png) [@RobLauer](https://discuss.blues.com/u/RobLauer)\
**Post date:** [July 12, 2023, 2:41pm UTC](https://discuss.blues.com/t/routing-different-sparrow-sensors-to-different-fields/1501/2 "2023-07-12T14:41:25Z")

</div>

Hi @rberkelm,

I always recommend testing out new JSONata expressions in the [JSONata exerciser](https://try.jsonata.org/). I just ran your expression through (with a Sparrow Note of my own) and it worked great!

 ![image](https://us1.discourse-cdn.com/flex020/uploads/blues/original/1X/0d2deaa875e99022f2c4e57b1784daa8c3b0ff6d.png)

---

<div class="post-metadata">

**Author:** ![rberkelm](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@rberkelm](https://discuss.blues.com/u/rberkelm)\
**Post date:** [July 12, 2023, 11:50pm UTC](https://discuss.blues.com/t/routing-different-sparrow-sensors-to-different-fields/1501/3 "2023-07-12T23:50:07Z")

</div>

Thanks Rob,  
For some reason, my exerciser has a problem with the “#”?

 ![json exerciser1](https://us1.discourse-cdn.com/flex020/uploads/blues/original/1X/ab762b7e578d13909b938ecdf0b557aa4199217f.png)

---

<div class="post-metadata">

**Author:** ![rberkelm](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@rberkelm](https://discuss.blues.com/u/rberkelm)\
**Post date:** [July 13, 2023, 12:07am UTC](https://discuss.blues.com/t/routing-different-sparrow-sensors-to-different-fields/1501/4 "2023-07-13T00:07:07Z")

</div>

Never mind, it works now. I just typed in the file name rather than pasting it in…  
Thanks Rob!

---

<div class="post-metadata">

**Author:** ![RobLauer](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.blues.com/roblauer/32/1567_2.png) [@RobLauer](https://discuss.blues.com/u/RobLauer)\
**Post date:** [July 13, 2023, 1:18am UTC](https://discuss.blues.com/t/routing-different-sparrow-sensors-to-different-fields/1501/5 "2023-07-13T01:18:34Z")

</div>

Yeah check the smart quotes too around all the strings - that may be messing with things!