Hello. I'm stuck on how to 'copy/store' topic_reads of error functions in several installations to another, single installation. We are currently filtering 50+ installations for error codes(Is an actual function from the device). Fortunately for us it is included in the metadata so filtering for type = state gets us far. The rest of the logic I've written in Node Red basicly stores the topic path + installation ID in flow.context if it a non 0 value, and 0 resets it.
The purpose of this aggregation of functions is to identify troublesome sensors so that in turn a service team can service the devices. Our idea is to make a a API call to the installation with the error functions in Grafana so we can get an overview on the faulty sensors, as making calls to 50 + installations with tens of thousands of topics impossible. Hence the idea to gather them first, send the smaller amount of data to an installation, then call for it.
Resulting in a list of {installation_id}/obj/lora/{EUI}/{error type}:

Assuming the filter works and I have an object with the format above, in what way should I send this data?(And remove it once the error states return 0, when error is solved.
Top of mind there are a few ways using the IoT Open API.
Write to a file
Use virtual devices for each function.
Write all the topic_reads to metadata of a function / installation / device.