I was able to solve it with node-red.
I got a response from a guy at kepware who says he does this type of triggered reading and store to db all the time, it’s a feature that the product offers i guess.
Litmus told me they can solve it with a flow triggering a read once to a tag defining a block read.
Tatsoft said they can do it, but with 14,700 tags….each triggered individually.
Everything above required some level of customization to achieve it, but appears manageable.