Parse HTML table from confluence page

Konstantin · April 27, 2022, 7:33am

Good time to all!
Tried to parse table from Confluence page to JSON but can’t understand how it must works

My scenario:

Get Confluence page via curl
There is HTML table on a page with names of employees and different dates with +

|Name|1|2|3|4|5|6|…|31|
|Employee1|+|||||+||
|Employee2|||+|+||+|||
etc

I need to get this table, parse it to JSON with params Name:“name” and Date:“number with +” and change Slack group based on this params
Try to use HTML parse node but got unstructured array of names and +

Please help and tell me where I was wrong )

MutedJam · April 27, 2022, 3:00pm

Hey @Konstantin, I’m sorry to hear you’re having trouble here.

Can you confirm the exact response structure you are getting from your HTTP Request node and the result you’d like to see at the end of your workflow? I am not super familiar with the Confluence API, so I’m sorry if these questions may sound odd.

Konstantin · April 27, 2022, 3:26pm

Sure, here is part of body extracted from confluence page
All body is very huge, there is separate table for every month

"body": "<h3>График</h3><p><br /></p><ac:structured-macro ac:name="expand" ac:schema-version="1" ac:macro-id="5d5af333-de95-4e60-a480-3b1a9fbbb844"><ac:parameter ac:name="title">Июнь</ac:parameter><ac:rich-text-body><p class="auto-cursor-target"><br /></p><table class="wrapped" style="text-decoration: none;width: 1287.0px;"><colgroup><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><tbody><tr><td rowspan="2" style="text-align: center;width: 248.0px;"><span>Сотрудник/Дата</span></td><td colspan="30" style="text-align: center;width: 1039.0px;"><span>июнь</span></td></tr><tr><td style="text-align: center;width: 29.0px;"><span>1</span></td><td style="text-align: center;width: 29.0px;"><span>2</span></td><td style="text-align: center;width: 30.0px;"><span>3</span></td><td class="highlight-grey" data-highlight-colour="grey" style="text-align: center;width: 30.0px;" title="Цвет фона: undefined"><span title="">4</span></td><td class="highlight-grey" data-highlight-colour="grey" style="text-align: center;width: 30.0px;" title="Цвет фона: undefined"><span title="">5</span></td><td style="text-align: center;width: 30.0px;"><span>6</span></td><td style="text-align: center;width: 29.0px;"><span>7</span></td><td style="text-align: center;width: 30.0px;"><span>8</span></td><td style="text-align: center;width: 30.0px;"><span>9</span></td><td style="text-align: center;width: 36.0px;"><span>10</span></td><td class="highlight-grey" data-highlight-colour="grey" style="text-align: center;width: 34.0px;" title="Цвет фона: undefined"><span title="">11</span></td><td class="highlight-grey" data-highlight-colour="grey" style="text-align: center;width: 36.0px;" title="Цвет фона: undefined"><span title="">12</span></td><td class="highlight-grey" data-highlight-colour="grey" style="text-align: center;width: 36.0px;" title="Цвет фона: undefined"><span title="">13</span></td><td style="text-align: center;width: 36.0px;"><span>14</span></td><td style="text-align: center;width: 36.0px;"><span>15</span></td><td style="text-align: center;width: 36.0px;"><span>16</span></td><td style="text-align: center;width: 35.0px;"><span>17</span></td><td class="highlight-grey" data-highlight-colour="grey" style="text-align: center;width: 36.0px;" title="Цвет фона: undefined"><span title="">18</span></td><td class="highlight-grey" data-highlight-colour="grey" style="text-align: center;width: 36.0px;" title="Цвет фона: undefined"><span title="">19</span></td><td style="text-align: center;width: 38.0px;"><span>20</span></td><td style="text-align: center;width: 36.0px;"><span>21</span></td><td style="text-align: center;width: 38.0px;"><span>22</span></td><td style="text-align: center;width: 38.0px;"><span>23</span></td><td style="text-align: center;width: 38.0px;"><span>24</span></td><td class="highlight-grey" data-highlight-colour="grey" style="text-align: center;width: 38.0px;" title="Цвет фона: undefined"><span title="">25</span></td><td class="highlight-grey" data-highlight-colour="grey" style="text-align: center;width: 38.0px;" title="Цвет фона: undefined"><span title="">26</span></td><td style="text-align: center;width: 37.0px;"><span>27</span></td><td style="text-align: center;width: 38.0px;"><span>28</span></td><td style="text-align: center;width: 38.0px;"><span>29</span></td><td style="text-align: center;width: 38.0px;"><span>30</span></td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Скорик Михаил Евгеньевич</span></td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;">+</td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;">+</td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Кирилловых Андрей Максимович</span></td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;">+</td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;">+</td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Мельников Евгений Евгеньевич</span></td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;">+</td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;">+</td><td style="width: 38.0px;"><br /></td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Никитин Петр Васильевич</span></td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;">+</td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;">+</td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Федоров Сергей Андреевич</span></td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;">+</td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Мелихова Ксения Алексеевна</span></td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;">+</td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Амбарцумян Артур Пушкинович</span></td><td style="width: 29.0px;">+</td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;">+</td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Полозов Александр Валерьевич</span></td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;">+</td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;">+</td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Янчий Александр Валерьевич</span></td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;">+</td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;">+</td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td></tr><tr><td style="text-align: left;width: 248.0px;"><span>Изотов Владислав Валериевич</span></td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;">+</td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;">+</td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td></tr><tr><td style="width: 248.0px;">Якимов Анатолий Павлович</td><td style="width: 29.0px;"><br /></td><td style="width: 29.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 30.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 29.0px;">+</td><td style="width: 30.0px;"><br /></td><td style="width: 30.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 34.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 35.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 36.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 36.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;">+</td><td style="width: 38.0px;"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td class="highlight-grey" data-highlight-colour="grey" style="width: 38.0px;" title="Цвет фона: undefined"><br /></td><td style="width: 37.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td><td style="width: 38.0px;"><br /></td></tr></tbody></table>

Here is parsing after HTML Extract node

"value": [
"Сотрудник/Дата",
"июнь",
"1",
"2",
"3",
"4",
"5",
"6",
"7",
"8",
"9",
"10",
"11",
"12",
"13",
"14",
"15",
"16",
"17",
"18",
"19",
"20",
"21",
"22",
"23",
"24",
"25",
"26",
"27",
"28",
"29",
"30",
"Скорик Михаил Евгеньевич",
"Кирилловых Андрей Максимович",
"Мельников Евгений Евгеньевич",
"Никитин Петр Васильевич",
"Федоров Сергей Андреевич",
"Мелихова Ксения Алексеевна",
"Амбарцумян Артур Пушкинович",
"Полозов Александр Валерьевич",
"Янчий Александр Валерьевич",
"Изотов Владислав Валериевич",
"Сотрудник/Дата"

I need to make correct table from this values in n8n but have no idea how to do this, sorry ((

MutedJam · April 27, 2022, 4:21pm

Thanks, that helps a lot with understanding the data you currently have. And you would like to get a JSON structure out of this?

If so, my first suggestion would be to first parse this row by row, then table cell by table cell. You can then use the first + second row as the key for all subsequent rows using a bit of custom JavaScript in the Function node. This is how it could look like in a workflow:

Hope this helps!

Konstantin · April 28, 2022, 8:28am

Hello, MutedJam!
Yes, this WF is great, thanks for You help!
Function needs to be changed a little bit to separate tables but all is great
Thanks once again