trying to display survey data on a thingsboard map
14:42 19 May 2026

I am trying tto display the information sent by a small survey device onto a things board map, and failing miserably.
the device sends a json string to the thingsboard via mqtt. the message is this:
{"site":"Gsrden","latitude":51.791267,"longitude":-3.011633,"csq":23,"rssi":-67,"status":"PASS"}
all i want to do is show an icon at the coordinates given, change the colour to red or green depending on the status value, and show the other details in the tooltip.
this is proving to be impossible.
the best i can do is to get the last message data displayed on the map, but i may have over a hundred survey sites to display.
can anyone help?

thingsboard