Hi @seank1968, this looks a bit tricky as some of the values in the meta_data:value field are arrays of different types while some other values are primitives. So you’d need different routes for processing if you want to do this in a no-code fashion which can get a rather tricky.
It might be easier here to use a Function node and a custom JS snippet in order to get the desired results.
Unfortunately the most recent example data you have shared doesn’t seem to be valid JSON. Would you be able to share the exact data structure you are currently working with, ideally copied straight from n8n’s JSON view by first selecting the outer most brackets and then copying the value like so:
It would be great if you could also confirm the exact format of the transformation you’d like to see using the JSON format. This way I should be able to help you build a suitable transformation Function.