Help with puppeteer ,cheerio and json

[sdetweil]

@lolo ignore the class= for the moment. that will just make it look prettier w colors etc

A table is a list of rows. Which contain a list of columns
A table is table
A row is tr
A column is td

Your data is an array []
Of objects{}

You can use the for loop to process you data
This is pseudo code, I am on my phone
for(let item of array_name){
Create row.
Create td = item.element_name
Etc
}

[lolo]

Thanks for replay.
I believe, I dint explained well.
This is table from website. Screenshot.

The data what i menage to collect is from prev sibling of tr class tableRow.
What i wish to get is tr class datum as first date and then data of street, street number, time (all in span) as data object in array, till next tr datum and then same after.
For each span id is different but they sharing same part of one number in id.
I cant use for for each as element (td or tr) as plenty of them are useless.
And here I’m stuck. I tried different approaches but then all data was multiplying or got empty object in arrays
example from website

[sdetweil]

@lolo but u have the date already in the object. Sort them maybe, but cheerio should return the list in order.

[lolo]

Yes I’m getting date , but this one is endWork (kraj). When the interruption will end, not to start. I know maybe I should use that.

[lolo]

I think i managed to sort it out.

	const $ = cheerio.load(html);
    
	var water = [];
        var waterList = [];
        var el = $('#cphContent_cphSadrzaj_upVoda table tbody ');
    
	if (el) {
               var elementWater = $('#cphContent_cphSadrzaj_upVoda table tbody  span').filter(function () {
                  return $(this).text() === self.place;
                   }).parent().parent();
             $(elementWater).each(function (jex, edate) {

            const $edate = $(edate);
            var startDate = $edate.prev().find('tr[class="datum"]>th>div').text().trim();
            var street = $edate.find('span[id*="Label2"]').text();
            var streetNmbr = $edate.find('span[id*="Label7"]').text();
            var startTime = $edate.find('span[id*="Label8"]').text();
            var endTime = $edate.find('span[id*="Label9"]').text();
            var endWork = $edate.find('span[id*="Label10"]').text();

            var water = {
                startDate,
                street,
                streetNmbr,
                startTime,
                endTime,
                endWork
            };
            
        
            waterList.push(water);
            console.log(water);
        });

    };
    if (!el) {
        console.log('No new entries!');
    };
    var waterWork = JSON.parse(JSON.stringify(waterList));
    self.sendSocketNotification('ELECTRIC_POWER_DISCONNECTED', waterWork);

Now i can get all data sorted by config.place

 {
  startDate: '09.12.2020',
  street: 'ISTARSKA, Rijeka',
  streetNmbr: '64',
  startTime: '10:00',
  endTime: '14:00',
  endWork: '09.12.20'
}

[sdetweil]

@lolo cool

[lolo]

This is output of my module. Any suggestion about styling.



croatian

I know there are more things to make it better but i have to learn it first.

[sdetweil]

@lolo i cannot help with look. Totally useless here