# Perspective table JSON FORMAT, expression syntax to get selected row ID

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-json-format-expression-syntax-to-get-selected-row-id/31633>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [January 27, 2020, 4:34am UTC](https://forum.inductiveautomation.com/t/perspective-table-json-format-expression-syntax-to-get-selected-row-id/31633 "2020-01-27T04:34:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![guganathan.r](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@guganathan.r](https://forum.inductiveautomation.com/u/guganathan.r)\
**Post date:** [January 27, 2020, 4:34am UTC](https://forum.inductiveautomation.com/t/perspective-table-json-format-expression-syntax-to-get-selected-row-id/31633/1 "2020-01-27T04:34:13Z")

</div>

Hi, I have Perspective table, data populated by a named query in JSON FORMAT. I need to know expression syntax to get selected row ID.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [January 27, 2020, 2:35pm UTC](https://forum.inductiveautomation.com/t/perspective-table-json-format-expression-syntax-to-get-selected-row-id/31633/2 "2020-01-27T14:35:19Z")

</div>

Do you mean:

```auto
{../path.to.table.props.selection.selectedRow}

```

---

<div class="post-metadata">

**Author:** ![guganathan.r](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@guganathan.r](https://forum.inductiveautomation.com/u/guganathan.r)\
**Post date:** [January 28, 2020, 4:56am UTC](https://forum.inductiveautomation.com/t/perspective-table-json-format-expression-syntax-to-get-selected-row-id/31633/3 "2020-01-28T04:56:39Z")

</div>

Yes, I want to get value from ID column.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [January 28, 2020, 2:03pm UTC](https://forum.inductiveautomation.com/t/perspective-table-json-format-expression-syntax-to-get-selected-row-id/31633/4 "2020-01-28T14:03:15Z")

</div>

Should be something like:

```auto
{../path.to.table.props.selection.data[0].ID}

```

---

<div class="post-metadata">

**Author:** ![guganathan.r](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@guganathan.r](https://forum.inductiveautomation.com/u/guganathan.r)\
**Post date:** [January 29, 2020, 8:23am UTC](https://forum.inductiveautomation.com/t/perspective-table-json-format-expression-syntax-to-get-selected-row-id/31633/5 "2020-01-29T08:23:36Z")

</div>

that works well. Thanks.