This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Because of the multi-dimensional nature of your data arrays, it would be hard to build a one size fits all approach that works for everything. It's the same thing with complex JSON objects.
If you were to approach it, I think you'd need an iterative macro (maybe a nested iterative macro with sufficient depth to cover your maximum expected array dimension) to process each array. There's no guarantee that two arrays at the same level will have the same set of elements, so you'd have to deal with the fact that different schemas are likely to pop out of it.
You can build multi-dimensional arrays and JSON objects that are almost impossibly complicated to convert into a normal table structure, so without some sort of ground rules on array structure it is going to be complicated. I'll throw this in the 'someday' pile because it's an interesting problem, and wish you the best of luck.