# Data Table not Updating with a new Row

**URL:** <https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680>\
**Category:** Help\
**Tags:** workflow\
**Created:** [April 1, 2019, 2:09am UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680 "2019-04-01T02:09:47Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![tirosh\_gutte](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tirosh\_gutte](https://forums.losant.com/u/tirosh_gutte)\
**Post date:** [April 1, 2019, 2:09am UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/1 "2019-04-01T02:09:47Z")

</div>

Hi,I am trying to get my data table to update.

So far I have a working webhook with data shown in the data explorer. The payload does not have a TableID. My payload has only:  
(root)  
“data”:

- 
  - “analoginput1”:xxxx
  - “analoginput2”:xxxx
  - “analoginput3”:xxxx
  - “analoginput4”:xxxx
  - “analoginput5”:xxxx
  - “analoginput6”:xxxx
  - “analoginput7”:xxxx
  - “analoginput8”:xxxx
  - “analoginput9”:xxxx

- “time”:1554084147939

The following separate work flows were set up (tried having both of the work flows under one work flow as well):  
Web hook–\> Webhook Reply–\>Device State  
Virtual Button–\> **Table Insert Row** –\> Debug

I also tried these workflows:  
Endpoint–\>Mutate–\> **Table Insert Row** –\> Webhook Reply  
Device State–\> **Table Insert Row** –\>Debug

**Table Insert Row** is set up with a Data Table ID Template that I created in Data Source\>Data Table with an arbitrary data table name (scroll down menu item) and arbitrary table column names (both set under the Data Table Dialog).

The Data Table set up as follows:  
Table Columns names are arbitrarily named  
Table Data Column type are set as Number (tried strings as well)  
Constraint set to: Required (Tried unique as well)

I can see that under data explorer data is being populated but I can not get the Data Table to populate with new rows (0).

Appreciate you showing me what I must be missing here.

---

<div class="post-metadata">

**Author:** ![JuliaKempf](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/juliakempf/32/2446_2.png) [@JuliaKempf](https://forums.losant.com/u/JuliaKempf)\
**Post date:** [April 1, 2019, 2:06pm UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/2 "2019-04-01T14:06:15Z")

</div>

Hi @tirosh_gutte,

I believe I see what could be the problem, but let me know if this does not solve it!

It sounds as though you are missing one piece from your Table: Insert Rows node. The column template and value template must also be populated to insert something into your data table. For example, it would be configured like so:

 ![12%20AM](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/2/2c8394e382188109b1615cec034dc0f156834f6f.png)

If I have a data table called “Working Table” that holds a first and last name, I will have to specify where they are on my payload to get them into a data table.

Hopefully this helps,  
Julia

---

<div class="post-metadata">

**Author:** ![tirosh\_gutte](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tirosh\_gutte](https://forums.losant.com/u/tirosh_gutte)\
**Post date:** [April 1, 2019, 7:49pm UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/3 "2019-04-01T19:49:56Z")

</div>

Thank you for your quick reply. I believe your suggestion was completed in the setup. Please review:

Under Table:Insert Rows  
I have the Data Table ID Template set on the following data table name: Test Data Table

 ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/c/c11eba985c98e024d2bff1909a52b3f0e9e1ab71.png)

I also tried this:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/2/22094dcd4359f9e51542349c55cc6e1a55e30891.png)

The above table ( **Test Data Table** ) was set up in:  
Data sources\>Data Tables\>Test data Table

 ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/0/0cda2c02b318af744916b9f496d633b7f33aa8b8.png)

Data is not populating in the data table. Please assist.

---

<div class="post-metadata">

**Author:** ![JuliaKempf](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/juliakempf/32/2446_2.png) [@JuliaKempf](https://forums.losant.com/u/JuliaKempf)\
**Post date:** [April 1, 2019, 7:54pm UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/4 "2019-04-01T19:54:30Z")

</div>

Hi @tirosh_gutte,

That screenshot I uploaded seems to be getting cut off, it can be expanded if you click on it. Here is a better screenshot of what I was trying to show 😄

 ![27%20PM](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/2/260ea431c5126cf354eeeffed261623914d485c7.png)

In this you can see I have set values “First” and “Last” to where that value is on the payload.

Thanks,  
Julia

---

<div class="post-metadata">

**Author:** ![tirosh\_gutte](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tirosh\_gutte](https://forums.losant.com/u/tirosh_gutte)\
**Post date:** [April 2, 2019, 1:46am UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/5 "2019-04-02T01:46:16Z")

</div>

Hi Julia  
Thank you for the Fast Reply

my payload is as follows:

![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/f/f94384235542a0d80ecfd3ffcfb9880c35a5f55b.png)

I think I added the first and last item as per your instructions

 ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/7/79b6c1885e5dbc3ca0fd3e22407e5009d6fb2c68.png)

Still no data updated in the Data Table

Please assist

---

<div class="post-metadata">

**Author:** ![JuliaKempf](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/juliakempf/32/2446_2.png) [@JuliaKempf](https://forums.losant.com/u/JuliaKempf)\
**Post date:** [April 2, 2019, 3:10am UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/6 "2019-04-02T03:10:41Z")

</div>

Hello @tirosh_gutte,

To debug further, could you include a screenshot of the workflow with the payload? The Table: Insert Rows Node should be in the same workflow that outputs the attached payload.

Thanks! 😃  
Julia

---

<div class="post-metadata">

**Author:** ![tirosh\_gutte](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tirosh\_gutte](https://forums.losant.com/u/tirosh_gutte)\
**Post date:** [April 2, 2019, 12:15pm UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/7 "2019-04-02T12:15:20Z")

</div>

![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/9/930c526e852937edb1984301fb60b5fbdd6a52aa.png)

Let me know if you need additional screenshots  
Thank you

---

<div class="post-metadata">

**Author:** ![JuliaKempf](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/juliakempf/32/2446_2.png) [@JuliaKempf](https://forums.losant.com/u/JuliaKempf)\
**Post date:** [April 2, 2019, 3:04pm UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/8 "2019-04-02T15:04:10Z")

</div>

Hi @tirosh_gutte,

I would recommend setting up your workflow like so:

 ![26%20AM](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/0/0ceb8a0660b738d8761afe23e5898e5675bdac86.png)

The reason you were not getting anything into your Data Table is because your Virtual Button workflow does not have access to those values. Since they are two separate workflows, they have two separate payloads, so those analog values would have been inaccessible. Setting up like the above workflow will allow you to access those analog values and put the data into your table.

Let me know how else I can help!  
Julia

---

<div class="post-metadata">

**Author:** ![tirosh\_gutte](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tirosh\_gutte](https://forums.losant.com/u/tirosh_gutte)\
**Post date:** [April 2, 2019, 11:20pm UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/9 "2019-04-02T23:20:31Z")

</div>

HI Julia, I have set the workflow as you indicated:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/9/94ac40864d0790bc4aefc67da0eff03d39c5c6a9.png)  
… still **no** data is populating in to the data table  
Thank you for your help

---

<div class="post-metadata">

**Author:** ![JuliaKempf](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/juliakempf/32/2446_2.png) [@JuliaKempf](https://forums.losant.com/u/JuliaKempf)\
**Post date:** [April 3, 2019, 3:01am UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/10 "2019-04-03T03:01:35Z")

</div>

Hi @tirosh_gutte,

I took a look at your Data Table and it looks as though it is populating, but only populating the `analoginput1` value as seen here:

![55%20PM](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/9/968f9e0dbff4a76b8c0cd8da58d592b5e93c2a5a.png)

Within your workflow, however, you are setting `analoginput1` and `analoginput8`, but you will need to also set `analoginput2`, `analoginput3`, and so on. I have not watched the payload fire myself, but it could be possible nothing is coming through for `analoginput8` or the payload path could also be incorrect. You will, however, need to set your Table: Insert Rows for each analog input if you want the entire table to be populated:

 ![14%20PM](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/9/92ec7b57a3fed72b26cb480129433956b495d06c.png)  
 ![25%20PM](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/f/f18ec67a78bd7de8e885db56382857201849606e.png)

Each Value Template will need to point to where the `analoginput` value is on the payload.

Thanks,  
Julia

---

<div class="post-metadata">

**Author:** ![tirosh\_gutte](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tirosh\_gutte](https://forums.losant.com/u/tirosh_gutte)\
**Post date:** [April 3, 2019, 11:48am UTC](https://forums.losant.com/t/data-table-not-updating-with-a-new-row/1680/11 "2019-04-03T11:48:51Z")

</div>

Understood, Thank you  
You Solved It !
