its not you, its me

[NickSee]

First of all thank you Oatybiscuit for all the work you've put into this. I currently have a working Node-Red Agile Prices flow thanks to you, and I saw and carried out the note about preventing homeassistant recorder warnings regarding the size of the array. I am trying to move on to displaying and being able to make use of the data. I had some trouble with HACS insisting that flex-table-card was already in the store - but not listed in resources and card not available. I believe I have overcome that after putting the js module into the HACS config/www/community file system, and some back and forth clicking update finally got a pair of cards for Agile Period and Agile Rates with the headings and no data.
I then go hunting for the problem and find the following in the log viewer: please can I ask anyone with expertise here to give me guidance as to where I should be focussing my learning - on the custom card side or is there something wrong on the array front?
2024-02-17 18:00:12.314 ERROR (MainThread) [homeassistant.util.logging] Exception in handle_entity_update when dispatching 'nodered_entity_697f3124.35d18_893ae24be6da2123': ({'type': 'nodered/entity', 'server_id': '697f3124.35d18', 'node_id': '893ae24be6da2123', 'state': '2024-02-17T18:00:00Z', 'attributes': {'array': [{'from': '2024-02-16T23:00:00Z', 'upto': '2024-02-16T23:30:00Z', 'import': 15.5085, 'export': 6.8, 'timefrom': '23:00', 'timeupto': '23:30', 'localdate': '2024-02-16', 'localfrom': '23:00 GMT', 'dstchange': False}, {'from': '2024-02-16T23:30:00Z', 'upto': '2024-02-17T00:00:00Z', 'import': 15.6975, 'export': 6.88, 'timefrom': '23:30', 'timeupto': '00:00', 'localdate': '2024-02-16', 'localfrom': '23:30 GMT', 'dstchange': False}, {'from': '2024-02-17T00:00:00Z', 'upto': '2024-02-17T00:30:00Z', 'import': 14.679, 'export': 6.48, 'timefrom': '00:00', 'timeupto': '00:30', 'localdate': '2024-02-17', 'localfrom': '00:00 GMT', 'dstchange': False}, {'from': '2024-02-17T00:30:00Z', 'upto': '2024-02-17T01:00:00Z', 'import': 15.939, 'export': 6.97, 'timefrom': '00:30', 'timeupto': '01:00', 'localdate': '2024-02-17', 'localfrom': '00:30 GMT', 'dstchange': False}, {'from': '2024-02-17T01:00:00Z', 'upto': '2024-02-17T01:30:00Z', 'import': 14.2485, 'export': 6.32, 'timefrom': '01:00', 'timeupto': '01:30', 'localdate': '2024-02-17', 'localfrom': '01:00 GMT', 'dstchange': False}, {'from': '2024-02-17T01:30:00Z', 'upto': '2024-02-17T02:00:00Z', 'import': 13.23, 'export': 5.93, 'timefrom': '01:30', 'timeupto': '02:00', 'localdate': '2024-02-17', 'localfrom': '01:30 GMT', 'dstchange': False}, {'from': '2024-02-17T02:00:00Z', 'upto': '2024-02-17T02:30:00Z', 'import': 14.0595, 'export': 6.24, 'timefrom': '02:00', 'timeupto': '02:30', 'localdate': '2024-02-17', 'localfrom': '02:00 GMT', 'dstchange': False}, {'from': '2024-02-17T02:30:00Z', 'upto': '2024-02-17T03:00:00Z', 'import': 13.23, 'export': 5.93, 'timefrom': '02:30', 'timeupto': '03:00', 'localdate': '2024-02-17', 'localfrom': '02:30 GMT', 'dstchange': False}, {'from': '2024-02-17T03:00:00Z', 'upto': '2024-02-17T03:30:00Z', 'import': 13.23, 'export': 5.93, 'timefrom': '03:00', 'timeupto': '03:30', 'localdate': '2024-02-17', 'localfrom': '03:00 GMT', 'dstchange': False}, {'from': '2024-02-17T03:30:00Z', 'upto': '2024-02-17T04:00:00Z', 'import': 13.23, 'export': 5.93, 'timefrom': '03:30', 'timeupto': '04:00', 'localdate': '2024-02-17', 'localfrom': '03:30 GMT', 'dstchange': False}, {'from': '2024-02-17T04:00:00Z', 'upto': '2024-02-17T04:30:00Z', 'import': 13.23, 'export': 5.93, 'timefrom': '04:00', 'timeupto': '04:30', 'localdate': '2024-02-17', 'localfrom': '04:00 GMT', 'dstchange': False}, {'from': '2024-02-17T04:30:00Z', 'upto': '2024-02-17T05:00:00Z', 'import': 13.23, 'export': 5.93, 'timefrom': '04:30', 'timeupto': '05:00', 'localdate': '2024-02-17', 'localfrom': '04:30 GMT', 'dstchange': False}, {'from': '2024-02-17T05:00:00Z', 'upto': '2024-02-17T05:30:00Z', 'import': 13.23, 'export': 5.93, 'timefrom': '05:00', 'timeupto': '05:30', 'localdate': '2024-02-17', 'localfrom': '05:00 GMT', 'dstchange': False}, {'from': '2024-02-17T05:30:00Z', 'upto': '2024-02-17T06:00:00Z', 'import': 13.23, 'export': 5.93, 'timefrom': '05:30', 'timeupto': '06:00', 'localdate': '2024-02-17', 'localfrom': '05:30 GMT', 'dstchange': False}, {'from': '2024-02-17T06:00:00Z', 'upto': '2024-02-17T06:30:00Z', 'import': 13.818, 'export': 6.15, 'timefrom': '06:00', 'timeupto': '06:30', 'localdate': '2024-02-17', 'localfrom': '06:00 GMT', 'dstchange': False}, {'from': '2024-02-17T06:30:00Z', 'upto': '2024-02-17T07:00:00Z', 'import': 14.847, 'export': 6.55, 'timefrom': '06:30', 'timeupto': '07:00', 'localdate': '2024-02-17', 'localfrom': '06:30 GMT', 'dstchange': False}, {'from': '2024-02-17T07:00:00Z', 'upto': '2024-02-17T07:30:00Z', 'import': 14.7525, 'export': 6.51, 'timefrom': '07:00', 'timeupto': '07:30', 'localdate': '2024-02-17', 'localfrom': '07:00 GMT', 'dstchange': False}, {'from':

[NickSee]

aha - didn't spend long enough waiting for log viewer to refresh because the useful information was after the array data but mangled in with some tuya unrelated stuff. Looks like I need to check units in node red:
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/sensor/init.py", line 639, in state
numerical_value = int(value)
^^^^^^^^^^
ValueError: invalid literal for int() with base 10: '2024-02-17T18:00:00Z'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/sensor/init.py", line 642, in state
numerical_value = float(value)
^^^^^^^^^^^^
ValueError: could not convert string to float: '2024-02-17T18:00:00Z'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/config/custom_components/nodered/init.py", line 141, in handle_entity_update
self.async_write_ha_state()
File "/usr/src/homeassistant/homeassistant/helpers/entity.py", line 945, in async_write_ha_state
self._async_write_ha_state()
File "/usr/src/homeassistant/homeassistant/helpers/entity.py", line 1066, in _async_write_ha_state
state, attr, capabilities, shadowed_attr = self.__async_calculate_state()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/src/homeassistant/homeassistant/helpers/entity.py", line 1003, in __async_calculate_state
state = self._stringify_state(available)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/src/homeassistant/homeassistant/helpers/entity.py", line 951, in _stringify_state
if (state := self.state) is None:
^^^^^^^^^^
File "/usr/src/homeassistant/homeassistant/components/sensor/init.py", line 646, in state
raise ValueError(
ValueError: Sensor sensor.octopus_agile_prices has device class 'monetary', state class 'measurement' unit 'AED' and suggested precision 'None' thus indicating it has a numeric value; however, it has the non-numeric value: '2024-02-17T18:00:00Z' ()

[NickSee]

My subject line 'its not you its me' was indeed 100% accurate. Geoff has gone to a lot of trouble to fully document his truly amazing work, including how some rule tightening meant that his state class ‘measurement’ in homeassistant configuration nodes needed to be removed, which he'd done - but I'd not made the changes in my nodered. As soon as those were done, all cards have come to life and I am so happy with that. Now on to changing API calls to reflect my Agile tariff and region. Thanks again Oaty you absolute diamond geezer.