# JSON to tabular form

**URL:** <https://forum.inductiveautomation.com/t/json-to-tabular-form/107599>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [June 19, 2025, 9:41pm UTC](https://forum.inductiveautomation.com/t/json-to-tabular-form/107599 "2025-06-19T21:41:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![adesingh](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@adesingh](https://forum.inductiveautomation.com/u/adesingh)\
**Post date:** [June 19, 2025, 9:41pm UTC](https://forum.inductiveautomation.com/t/json-to-tabular-form/107599/1 "2025-06-19T21:41:42Z")

</div>

I am new to Ignition Vision, and am trying to get my data in the form of a table. I am importing the data into the table through an OPC tag {[SDFac]FML20/0.value}["Name"] , and am getting the output:

```python
[
        {
            "M_Funk": 11,
            "M_VKE": 1,
            "M_soll": 10
        },
        {
            "M_Funk": 34,
            "M_VKE": 23,
            "M_soll": 150
        },
        {
            "M_Funk": 4,
            "M_VKE": 13,
            "M_soll": 100
        },
        {
            "M_Funk": 16,
            "M_VKE": 1,
            "M_soll": 40
        },
        {
            "M_Funk": 15,
            "M_VKE": 16,
            "M_soll": 80
        },
        {
            "M_Funk": 16,
            "M_VKE": 2,
            "M_soll": 460
        },
        {
            "M_Funk": 1,
            "M_VKE": 1,
            "M_soll": 10
        },
        {
            "M_Funk": 4,
            "M_VKE": 1,
            "M_soll": 1
        },
        {
            "M_Funk": 16,
            "M_VKE": 1,
            "M_soll": 5
        },
        {
            "M_Funk": 18,
            "M_VKE": 1,
            "M_soll": 4
        },
        {
            "M_Funk": 19,
            "M_VKE": 2,
            "M_soll": 630
        },....]

```

on my table(in form of text).

I want to show this data in form of a table in Vision. Any help would be appricieted.

---

<div class="post-metadata">

**Author:** ![Lynn\_Martineau](https://avatars.discourse-cdn.com/v4/letter/l/f1d935/32.png) [@Lynn\_Martineau](https://forum.inductiveautomation.com/u/Lynn_Martineau)\
**Post date:** [June 19, 2025, 10:05pm UTC](https://forum.inductiveautomation.com/t/json-to-tabular-form/107599/2 "2025-06-19T22:05:40Z")

</div>

have you tried `system.dataset.toDataSet(dataset)`

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [June 20, 2025, 6:42am UTC](https://forum.inductiveautomation.com/t/json-to-tabular-form/107599/3 "2025-06-20T06:42:59Z")

</div>

```python
def json_to_dataset(data):
	if not data:
		return None
	headers = data[0].keys()
	return system.dataset.toDataSet(
		headers,
		[
			[row[h] for h in headers]
			for row in data
		]
	)

```

Put this is your library script, then on on your table's data put an expression binding calling this function with your raw data.

```python
runScript(
    'your_lib.json_to_dataset', 0,
    {raw_data}
)

```