Remap msg properties

[dceejay]

I have just published a simple remap node - node-red-contrib-remap - that hopefully simplifies filtering and remapping properties within a msg.

The main use case is when fetching data from an API and you get back loads of info - usually too much - and just want to pick out the parts you want and maybe relabel them - eg .longitude to .lon - etc.

To make it simpler the node does not offer much configurability until you have sent it some example messages and then you can choose whether to block them, pass them as-is or relabel them.

It's not trying to be fancy so please don't overthink it

As usual, feedback, comments, and pull requests gratefully accepted.

[Colin]

Are we not supposed to be using naming like @dceejay/node-red-remap now?

[TotallyInformation]

Nice.

In my dreamworld, I'd love for this node (or some other) to be also able to reshape an object. For example grouping an input from CSV by a specific field. And also to be able to easily filter.

Also, does this do a deep copy of the input?

[jbudd]

Using default action "Remove all" I fed it the output from one of the Met Office APIs (both direct and via a Json parser node) and got

TypeError: Cannot create property '0' on string ''

Here is the payload, hourly forecasts for somewhere in South Wales, or possibly the Seychelles if I got latitude and longitude upside down.

{"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"Point","coordinates":[-3.0923,51.9847,535]},"properties":{"location":{"name":"Capel-y-Ffin Youth Hostel"},"requestPointDistance":936.8733,"modelRunDate":"2023-10-15T14:00Z","timeSeries":[{"time":"2023-10-15T14:00Z","screenTemperature":7.08,"maxScreenAirTemp":7.1,"minScreenAirTemp":6.67,"screenDewPointTemperature":0.96,"feelsLikeTemperature":5.87,"windSpeed10m":1.9,"windDirectionFrom10m":69,"windGustSpeed10m":3.09,"max10mWindGust":3.46,"visibility":36216,"screenRelativeHumidity":64.5,"mslp":102710,"uvIndex":2,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-15T15:00Z","screenTemperature":6.96,"maxScreenAirTemp":7.08,"minScreenAirTemp":6.93,"screenDewPointTemperature":-0.09,"feelsLikeTemperature":5.81,"windSpeed10m":1.84,"windDirectionFrom10m":77,"windGustSpeed10m":3.2,"max10mWindGust":3.51,"visibility":41007,"screenRelativeHumidity":60.41,"mslp":102693,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-15T16:00Z","screenTemperature":6.24,"maxScreenAirTemp":6.96,"minScreenAirTemp":6.24,"screenDewPointTemperature":-0.52,"feelsLikeTemperature":4.71,"windSpeed10m":2.11,"windDirectionFrom10m":88,"windGustSpeed10m":3.65,"max10mWindGust":4.03,"visibility":41749,"screenRelativeHumidity":61.75,"mslp":102652,"uvIndex":1,"significantWeatherCode":3,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":0},{"time":"2023-10-15T17:00Z","screenTemperature":4.83,"maxScreenAirTemp":6.24,"minScreenAirTemp":4.79,"screenDewPointTemperature":-0.05,"feelsLikeTemperature":2.96,"windSpeed10m":2.2,"windDirectionFrom10m":91,"windGustSpeed10m":4.67,"max10mWindGust":4.69,"visibility":38946,"screenRelativeHumidity":70.69,"mslp":102658,"uvIndex":1,"significantWeatherCode":3,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":0},{"time":"2023-10-15T18:00Z","screenTemperature":4.13,"maxScreenAirTemp":4.83,"minScreenAirTemp":4.1,"screenDewPointTemperature":-0.96,"feelsLikeTemperature":1.65,"windSpeed10m":2.73,"windDirectionFrom10m":100,"windGustSpeed10m":5.29,"max10mWindGust":5.43,"visibility":36994,"screenRelativeHumidity":69.61,"mslp":102670,"uvIndex":0,"significantWeatherCode":0,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":0},{"time":"2023-10-15T19:00Z","screenTemperature":3.73,"maxScreenAirTemp":4.13,"minScreenAirTemp":3.71,"screenDewPointTemperature":-0.63,"feelsLikeTemperature":1.1,"windSpeed10m":2.85,"windDirectionFrom10m":118,"windGustSpeed10m":5.54,"max10mWindGust":5.83,"visibility":32209,"screenRelativeHumidity":73.25,"mslp":102670,"uvIndex":0,"significantWeatherCode":2,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":0},{"time":"2023-10-15T20:00Z","screenTemperature":3.46,"maxScreenAirTemp":3.73,"minScreenAirTemp":3.45,"screenDewPointTemperature":-1.24,"feelsLikeTemperature":0.86,"windSpeed10m":2.79,"windDirectionFrom10m":119,"windGustSpeed10m":5.21,"max10mWindGust":5.78,"visibility":31003,"screenRelativeHumidity":71.55,"mslp":102670,"uvIndex":0,"significantWeatherCode":2,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":0},{"time":"2023-10-15T21:00Z","screenTemperature":3.39,"maxScreenAirTemp":3.45,"minScreenAirTemp":3.36,"screenDewPointTemperature":-1.72,"feelsLikeTemperature":0.45,"windSpeed10m":3.21,"windDirectionFrom10m":116,"windGustSpeed10m":5.88,"max10mWindGust":6.31,"visibility":31475,"screenRelativeHumidity":69.64,"mslp":102652,"uvIndex":0,"significantWeatherCode":2,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":0},{"time":"2023-10-15T22:00Z","screenTemperature":3.29,"maxScreenAirTemp":3.39,"minScreenAirTemp":3.27,"screenDewPointTemperature":-1.72,"feelsLikeTemperature":0.15,"windSpeed10m":3.45,"windDirectionFrom10m":117,"windGustSpeed10m":6.4,"max10mWindGust":6.89,"visibility":30311,"screenRelativeHumidity":70.09,"mslp":102629,"uvIndex":0,"significantWeatherCode":2,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":0},{"time":"2023-10-15T23:00Z","screenTemperature":2.95,"maxScreenAirTemp":3.29,"minScreenAirTemp":2.93,"screenDewPointTemperature":-1.54,"feelsLikeTemperature":-0.27,"windSpeed10m":3.5,"windDirectionFrom10m":115,"windGustSpeed10m":6.47,"max10mWindGust":7.25,"visibility":28843,"screenRelativeHumidity":72.79,"mslp":102580,"uvIndex":0,"significantWeatherCode":2,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":0},{"time":"2023-10-16T00:00Z","screenTemperature":2.46,"maxScreenAirTemp":2.95,"minScreenAirTemp":2.45,"screenDewPointTemperature":-1.73,"feelsLikeTemperature":-0.79,"windSpeed10m":3.48,"windDirectionFrom10m":112,"windGustSpeed10m":6.41,"max10mWindGust":7.59,"visibility":29871,"screenRelativeHumidity":74.54,"mslp":102544,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":3},{"time":"2023-10-16T01:00Z","screenTemperature":2.27,"maxScreenAirTemp":2.46,"minScreenAirTemp":2.26,"screenDewPointTemperature":-1.47,"feelsLikeTemperature":-1.1,"windSpeed10m":3.57,"windDirectionFrom10m":114,"windGustSpeed10m":6.58,"max10mWindGust":7.94,"visibility":29082,"screenRelativeHumidity":76.86,"mslp":102506,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":3},{"time":"2023-10-16T02:00Z","screenTemperature":2.15,"maxScreenAirTemp":2.27,"minScreenAirTemp":2.14,"screenDewPointTemperature":-1.51,"feelsLikeTemperature":-1.39,"windSpeed10m":3.81,"windDirectionFrom10m":112,"windGustSpeed10m":7.05,"max10mWindGust":8.42,"visibility":28166,"screenRelativeHumidity":77.3,"mslp":102455,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":3},{"time":"2023-10-16T03:00Z","screenTemperature":2,"maxScreenAirTemp":2.15,"minScreenAirTemp":1.99,"screenDewPointTemperature":-1.19,"feelsLikeTemperature":-1.61,"windSpeed10m":3.9,"windDirectionFrom10m":112,"windGustSpeed10m":7.31,"max10mWindGust":8.84,"visibility":27344,"screenRelativeHumidity":79.83,"mslp":102415,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":3},{"time":"2023-10-16T04:00Z","screenTemperature":1.97,"maxScreenAirTemp":2,"minScreenAirTemp":1.96,"screenDewPointTemperature":-1.02,"feelsLikeTemperature":-1.68,"windSpeed10m":3.89,"windDirectionFrom10m":110,"windGustSpeed10m":7.39,"max10mWindGust":9.1,"visibility":26246,"screenRelativeHumidity":80.96,"mslp":102376,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T05:00Z","screenTemperature":1.9,"maxScreenAirTemp":1.97,"minScreenAirTemp":1.88,"screenDewPointTemperature":-0.99,"feelsLikeTemperature":-1.82,"windSpeed10m":3.94,"windDirectionFrom10m":109,"windGustSpeed10m":7.53,"max10mWindGust":9.02,"visibility":25741,"screenRelativeHumidity":81.51,"mslp":102328,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T06:00Z","screenTemperature":1.92,"maxScreenAirTemp":1.94,"minScreenAirTemp":1.88,"screenDewPointTemperature":-0.96,"feelsLikeTemperature":-1.94,"windSpeed10m":4.18,"windDirectionFrom10m":107,"windGustSpeed10m":7.88,"max10mWindGust":9.3,"visibility":25956,"screenRelativeHumidity":81.53,"mslp":102297,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T07:00Z","screenTemperature":2.21,"maxScreenAirTemp":2.22,"minScreenAirTemp":1.92,"screenDewPointTemperature":-0.87,"feelsLikeTemperature":-1.74,"windSpeed10m":4.41,"windDirectionFrom10m":107,"windGustSpeed10m":8.5,"max10mWindGust":9.87,"visibility":25583,"screenRelativeHumidity":80.46,"mslp":102296,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T08:00Z","screenTemperature":2.73,"maxScreenAirTemp":2.74,"minScreenAirTemp":2.21,"screenDewPointTemperature":-0.92,"feelsLikeTemperature":-1.26,"windSpeed10m":4.71,"windDirectionFrom10m":108,"windGustSpeed10m":8.97,"max10mWindGust":10.26,"visibility":27217,"screenRelativeHumidity":77.22,"mslp":102280,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T09:00Z","screenTemperature":3.43,"maxScreenAirTemp":3.44,"minScreenAirTemp":2.73,"screenDewPointTemperature":-0.54,"feelsLikeTemperature":-0.4,"windSpeed10m":4.68,"windDirectionFrom10m":109,"windGustSpeed10m":8.77,"max10mWindGust":10.3,"visibility":26869,"screenRelativeHumidity":75.45,"mslp":102270,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T10:00Z","screenTemperature":4.06,"maxScreenAirTemp":4.11,"minScreenAirTemp":3.43,"screenDewPointTemperature":-0.01,"feelsLikeTemperature":0.51,"windSpeed10m":4.4,"windDirectionFrom10m":112,"windGustSpeed10m":7.84,"max10mWindGust":9.3,"visibility":26367,"screenRelativeHumidity":74.91,"mslp":102240,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T11:00Z","screenTemperature":4.82,"maxScreenAirTemp":4.86,"minScreenAirTemp":4.06,"screenDewPointTemperature":0.54,"feelsLikeTemperature":1.62,"windSpeed10m":4.05,"windDirectionFrom10m":113,"windGustSpeed10m":7.07,"max10mWindGust":7.89,"visibility":26069,"screenRelativeHumidity":74.06,"mslp":102207,"uvIndex":2,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T12:00Z","screenTemperature":5.51,"maxScreenAirTemp":5.52,"minScreenAirTemp":4.82,"screenDewPointTemperature":1.23,"feelsLikeTemperature":2.43,"windSpeed10m":4.11,"windDirectionFrom10m":112,"windGustSpeed10m":7.17,"max10mWindGust":7.17,"visibility":24933,"screenRelativeHumidity":73.96,"mslp":102147,"uvIndex":2,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T13:00Z","screenTemperature":5.88,"maxScreenAirTemp":5.9,"minScreenAirTemp":5.51,"screenDewPointTemperature":1.64,"feelsLikeTemperature":2.87,"windSpeed10m":4.14,"windDirectionFrom10m":108,"windGustSpeed10m":7.35,"max10mWindGust":7.35,"visibility":24931,"screenRelativeHumidity":74.33,"mslp":102087,"uvIndex":2,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T14:00Z","screenTemperature":6.33,"maxScreenAirTemp":6.35,"minScreenAirTemp":5.88,"screenDewPointTemperature":1.85,"feelsLikeTemperature":3.27,"windSpeed10m":4.44,"windDirectionFrom10m":108,"windGustSpeed10m":8.07,"max10mWindGust":8.07,"visibility":26909,"screenRelativeHumidity":73.06,"mslp":102019,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T15:00Z","screenTemperature":6.54,"maxScreenAirTemp":6.59,"minScreenAirTemp":6.33,"screenDewPointTemperature":2.25,"feelsLikeTemperature":3.41,"windSpeed10m":4.67,"windDirectionFrom10m":106,"windGustSpeed10m":8.53,"max10mWindGust":8.58,"visibility":27312,"screenRelativeHumidity":74.07,"mslp":101960,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T16:00Z","screenTemperature":6.2,"maxScreenAirTemp":6.54,"minScreenAirTemp":6.18,"screenDewPointTemperature":2.32,"feelsLikeTemperature":3.05,"windSpeed10m":4.54,"windDirectionFrom10m":102,"windGustSpeed10m":8.57,"max10mWindGust":8.71,"visibility":26068,"screenRelativeHumidity":76.28,"mslp":101931,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T17:00Z","screenTemperature":5.68,"maxScreenAirTemp":6.2,"minScreenAirTemp":5.66,"screenDewPointTemperature":2.68,"feelsLikeTemperature":2.42,"windSpeed10m":4.52,"windDirectionFrom10m":98,"windGustSpeed10m":9.14,"max10mWindGust":9.48,"visibility":23357,"screenRelativeHumidity":81.12,"mslp":101923,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T18:00Z","screenTemperature":5.22,"maxScreenAirTemp":5.68,"minScreenAirTemp":5.2,"screenDewPointTemperature":2.72,"feelsLikeTemperature":1.74,"windSpeed10m":4.75,"windDirectionFrom10m":96,"windGustSpeed10m":9.79,"max10mWindGust":10.41,"visibility":22406,"screenRelativeHumidity":83.98,"mslp":101917,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T19:00Z","screenTemperature":4.88,"maxScreenAirTemp":5.22,"minScreenAirTemp":4.86,"screenDewPointTemperature":2.47,"feelsLikeTemperature":1.1,"windSpeed10m":5.23,"windDirectionFrom10m":96,"windGustSpeed10m":10.51,"max10mWindGust":11.3,"visibility":22392,"screenRelativeHumidity":84.5,"mslp":101907,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T20:00Z","screenTemperature":4.6,"maxScreenAirTemp":4.88,"minScreenAirTemp":4.58,"screenDewPointTemperature":2.46,"feelsLikeTemperature":0.65,"windSpeed10m":5.47,"windDirectionFrom10m":96,"windGustSpeed10m":11.07,"max10mWindGust":11.87,"visibility":21873,"screenRelativeHumidity":86.03,"mslp":101915,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T21:00Z","screenTemperature":4.41,"maxScreenAirTemp":4.6,"minScreenAirTemp":4.38,"screenDewPointTemperature":2.53,"feelsLikeTemperature":0.19,"windSpeed10m":5.95,"windDirectionFrom10m":97,"windGustSpeed10m":11.8,"max10mWindGust":12.3,"visibility":21892,"screenRelativeHumidity":87.65,"mslp":101907,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":5},{"time":"2023-10-16T22:00Z","screenTemperature":4.26,"maxScreenAirTemp":4.41,"minScreenAirTemp":4.25,"screenDewPointTemperature":2.67,"feelsLikeTemperature":-0.06,"windSpeed10m":6.09,"windDirectionFrom10m":98,"windGustSpeed10m":11.99,"max10mWindGust":12.55,"visibility":16780,"screenRelativeHumidity":89.48,"mslp":101888,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-16T23:00Z","screenTemperature":4.14,"maxScreenAirTemp":4.26,"minScreenAirTemp":4.11,"screenDewPointTemperature":2.88,"feelsLikeTemperature":-0.26,"windSpeed10m":6.24,"windDirectionFrom10m":98,"windGustSpeed10m":12.25,"max10mWindGust":13.17,"visibility":15241,"screenRelativeHumidity":91.52,"mslp":101850,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":5},{"time":"2023-10-17T00:00Z","screenTemperature":4.06,"maxScreenAirTemp":4.18,"minScreenAirTemp":4.03,"screenDewPointTemperature":3.15,"feelsLikeTemperature":-0.38,"windSpeed10m":6.26,"windDirectionFrom10m":98,"windGustSpeed10m":12.3,"max10mWindGust":13.03,"visibility":12324,"screenRelativeHumidity":93.85,"mslp":101802,"uvIndex":0,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":7},{"time":"2023-10-17T01:00Z","screenTemperature":3.98,"maxScreenAirTemp":4.06,"minScreenAirTemp":3.97,"screenDewPointTemperature":3.42,"feelsLikeTemperature":-0.53,"windSpeed10m":6.38,"windDirectionFrom10m":96,"windGustSpeed10m":12.42,"max10mWindGust":13.34,"visibility":999,"screenRelativeHumidity":96.27,"mslp":101753,"uvIndex":0,"significantWeatherCode":6,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":17},{"time":"2023-10-17T02:00Z","screenTemperature":3.98,"maxScreenAirTemp":4.03,"minScreenAirTemp":3.97,"screenDewPointTemperature":3.5,"feelsLikeTemperature":-0.63,"windSpeed10m":6.64,"windDirectionFrom10m":97,"windGustSpeed10m":12.77,"max10mWindGust":14.06,"visibility":999,"screenRelativeHumidity":96.77,"mslp":101684,"uvIndex":0,"significantWeatherCode":6,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":17},{"time":"2023-10-17T03:00Z","screenTemperature":3.94,"maxScreenAirTemp":4.02,"minScreenAirTemp":3.92,"screenDewPointTemperature":3.57,"feelsLikeTemperature":-0.74,"windSpeed10m":6.8,"windDirectionFrom10m":96,"windGustSpeed10m":12.93,"max10mWindGust":14.81,"visibility":999,"screenRelativeHumidity":97.5,"mslp":101625,"uvIndex":0,"significantWeatherCode":6,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":18},{"time":"2023-10-17T04:00Z","screenTemperature":3.9,"maxScreenAirTemp":3.94,"minScreenAirTemp":3.9,"screenDewPointTemperature":3.56,"feelsLikeTemperature":-0.94,"windSpeed10m":7.2,"windDirectionFrom10m":95,"windGustSpeed10m":13.5,"max10mWindGust":15.88,"visibility":999,"screenRelativeHumidity":97.67,"mslp":101585,"uvIndex":0,"significantWeatherCode":6,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":18},{"time":"2023-10-17T05:00Z","screenTemperature":3.9,"maxScreenAirTemp":3.9,"minScreenAirTemp":3.9,"screenDewPointTemperature":3.59,"feelsLikeTemperature":-1.04,"windSpeed10m":7.51,"windDirectionFrom10m":95,"windGustSpeed10m":13.95,"max10mWindGust":16.56,"visibility":999,"screenRelativeHumidity":97.87,"mslp":101555,"uvIndex":0,"significantWeatherCode":6,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":18},{"time":"2023-10-17T06:00Z","screenTemperature":3.89,"maxScreenAirTemp":4.08,"minScreenAirTemp":3.85,"screenDewPointTemperature":3.59,"feelsLikeTemperature":-1.17,"windSpeed10m":7.81,"windDirectionFrom10m":96,"windGustSpeed10m":14.45,"max10mWindGust":16.74,"visibility":999,"screenRelativeHumidity":97.97,"mslp":101527,"uvIndex":0,"significantWeatherCode":6,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":17},{"time":"2023-10-17T07:00Z","screenTemperature":4.21,"maxScreenAirTemp":4.21,"minScreenAirTemp":3.89,"screenDewPointTemperature":3.52,"feelsLikeTemperature":-0.89,"windSpeed10m":8.19,"windDirectionFrom10m":96,"windGustSpeed10m":15.2,"max10mWindGust":17.74,"visibility":2553,"screenRelativeHumidity":95.38,"mslp":101527,"uvIndex":1,"significantWeatherCode":5,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":17},{"time":"2023-10-17T08:00Z","screenTemperature":4.76,"maxScreenAirTemp":4.76,"minScreenAirTemp":4.21,"screenDewPointTemperature":3.74,"feelsLikeTemperature":-0.29,"windSpeed10m":8.58,"windDirectionFrom10m":98,"windGustSpeed10m":15.9,"max10mWindGust":18.44,"visibility":9709,"screenRelativeHumidity":93.29,"mslp":101517,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":7},{"time":"2023-10-17T09:00Z","screenTemperature":5.51,"maxScreenAirTemp":5.51,"minScreenAirTemp":4.76,"screenDewPointTemperature":3.97,"feelsLikeTemperature":0.57,"windSpeed10m":8.86,"windDirectionFrom10m":99,"windGustSpeed10m":16.28,"max10mWindGust":19.16,"visibility":12732,"screenRelativeHumidity":89.99,"mslp":101494,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":6},{"time":"2023-10-17T10:00Z","screenTemperature":6.47,"maxScreenAirTemp":6.47,"minScreenAirTemp":5.57,"screenDewPointTemperature":4.02,"feelsLikeTemperature":1.68,"windSpeed10m":9.44,"windDirectionFrom10m":100,"windGustSpeed10m":16.78,"max10mWindGust":19.3,"visibility":24217,"screenRelativeHumidity":84.75,"mslp":101409,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-17T11:00Z","screenTemperature":7.36,"maxScreenAirTemp":7.36,"minScreenAirTemp":6.47,"screenDewPointTemperature":3.79,"feelsLikeTemperature":2.79,"windSpeed10m":9.68,"windDirectionFrom10m":102,"windGustSpeed10m":17.25,"max10mWindGust":19,"visibility":27899,"screenRelativeHumidity":78.51,"mslp":101340,"uvIndex":2,"significantWeatherCode":7,"precipitationRate":0,"totalPrecipAmount":0,"totalSnowAmount":0,"probOfPrecipitation":4},{"time":"2023-10-17T12:00Z","screenTemperature":8.09,"screenDewPointTemperature":3.66,"feelsLikeTemperature":3.69,"windSpeed10m":9.97,"windDirectionFrom10m":103,"windGustSpeed10m":17.91,"visibility":27682,"screenRelativeHumidity":73.79,"mslp":101272,"uvIndex":2,"significantWeatherCode":7,"precipitationRate":0,"probOfPrecipitation":4},{"time":"2023-10-17T13:00Z","screenTemperature":8.33,"screenDewPointTemperature":3.65,"feelsLikeTemperature":4.08,"windSpeed10m":9.59,"windDirectionFrom10m":101,"windGustSpeed10m":17.41,"visibility":28645,"screenRelativeHumidity":72.67,"mslp":101209,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"probOfPrecipitation":4},{"time":"2023-10-17T14:00Z","screenTemperature":8.52,"screenDewPointTemperature":3.64,"feelsLikeTemperature":4.36,"windSpeed10m":9.53,"windDirectionFrom10m":101,"windGustSpeed10m":17.19,"visibility":29460,"screenRelativeHumidity":71.63,"mslp":101139,"uvIndex":1,"significantWeatherCode":7,"precipitationRate":0,"probOfPrecipitation":6}]}}],"parameters":[{"totalSnowAmount":{"type":"Parameter","description":"Total Snow Amount Over Previous Hour","unit":{"label":"millimetres","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"mm"}}},"screenTemperature":{"type":"Parameter","description":"Screen Air Temperature","unit":{"label":"degrees Celsius","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"Cel"}}},"visibility":{"type":"Parameter","description":"Visibility","unit":{"label":"metres","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"m"}}},"windDirectionFrom10m":{"type":"Parameter","description":"10m Wind From Direction","unit":{"label":"degrees","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"deg"}}},"precipitationRate":{"type":"Parameter","description":"Precipitation Rate","unit":{"label":"millimetres per hour","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"mm/h"}}},"maxScreenAirTemp":{"type":"Parameter","description":"Maximum Screen Air Temperature Over Previous Hour","unit":{"label":"degrees Celsius","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"Cel"}}},"feelsLikeTemperature":{"type":"Parameter","description":"Feels Like Temperature","unit":{"label":"degrees Celsius","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"Cel"}}},"screenDewPointTemperature":{"type":"Parameter","description":"Screen Dew Point Temperature","unit":{"label":"degrees Celsius","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"Cel"}}},"screenRelativeHumidity":{"type":"Parameter","description":"Screen Relative Humidity","unit":{"label":"percentage","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"%"}}},"windSpeed10m":{"type":"Parameter","description":"10m Wind Speed","unit":{"label":"metres per second","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"m/s"}}},"probOfPrecipitation":{"type":"Parameter","description":"Probability of Precipitation","unit":{"label":"percentage","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"%"}}},"max10mWindGust":{"type":"Parameter","description":"Maximum 10m Wind Gust Speed Over Previous Hour","unit":{"label":"metres per second","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"m/s"}}},"significantWeatherCode":{"type":"Parameter","description":"Significant Weather Code","unit":{"label":"dimensionless","symbol":{"value":"https://metoffice.apiconnect.ibmcloud.com/metoffice/production/","type":"1"}}},"minScreenAirTemp":{"type":"Parameter","description":"Minimum Screen Air Temperature Over Previous Hour","unit":{"label":"degrees Celsius","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"Cel"}}},"totalPrecipAmount":{"type":"Parameter","description":"Total Precipitation Amount Over Previous Hour","unit":{"label":"millimetres","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"mm"}}},"mslp":{"type":"Parameter","description":"Mean Sea Level Pressure","unit":{"label":"pascals","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"Pa"}}},"windGustSpeed10m":{"type":"Parameter","description":"10m Wind Gust Speed","unit":{"label":"metres per second","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"m/s"}}},"uvIndex":{"type":"Parameter","description":"UV Index","unit":{"label":"dimensionless","symbol":{"value":"http://www.opengis.net/def/uom/UCUM/","type":"1"}}}}]}

Edit - No error when I set default action "Passthru all". Maybe this would be better as the initial value?

[marcus-j-davies]

Very nice!

Always a pleasure to see new stuff from the core team!
But may I inject some humour into this?

[dceejay]

You can try …. But the node does specify nodejs>=16 so it’s the scoring system having a laugh. Not sure something so simple needs an example

[Napalmcsr]

Did this work better on the Passthru all? I am seeing similar issues.

More information, When I removed the payload from the input selection and only went off of the msg. the error went away and it worked.

[dceejay]

Fix coming tomorrow
(and a bunch of enhancements)

[gerry]

Is this going to become a core node?

[Trying_to_learn]

Just mentioning:

I can't expand the picture to see what the node looks like when open.

[dceejay]

@gerry

Is this going to become a core node?

Probably not, (unless there is a lot of demand). Just something I needed for a while and to save typing while I recover from a broken hand

[cymplecy]

Now I've my brain in gear - this IS the node I've been looking for for a while

[TotallyInformation]

Just tried it (installed just now) on some existing data:

The error is from the initial push of data. The function reads an Excel file and converts it to JSON using:

It restructures the imported data as shown in the first image.

[dceejay]

v0.2 just published.... probably breaking (sorry... not sorry)

• much better merging of objects if you rename them to the same property.
• fix for silly string property update error.
• added examples.

[jbudd]

Sorry to hear about your injured hand Dave, hope it mends soon.

Can we look forward to a speech based editor any time soon?

"Alexa, connect a new debug node showing the whole message to function 53"

[TotallyInformation]

Working, thanks Dave.

I did my hand in last year so I know it isn't nice - my thumb actually. Took about 6m after the cast came off to completely heal. The monotonous hand exercises they give you really are worth keeping on with even well after it feels like you are back to normal.

[JeromeVISUALS]

Hi, thanks for the tool , did a quick test and looks like very useful.

I have 0.2.1 installed, but can't find any example...

[dceejay]

anyone else (not) see that ? The examples should be there

Did you restart the editor client ?

[cymplecy]

They are in mine

[marcus-j-davies]

This is all I need to see