Huh. That just looks like an ugly but usable JSON file, which reduces to a fairly straightforward parsing problem. I'm pretty sure there are even easy-use Python libs for dealing with JSON on the regular.
Doesn't look too bad at first glance. Everything depends on what you want to do with it, of course.
like I said I dont do code, but these types of posts and analysis are in need. that post was my first attempt and from discussions with others, people want to see more of this. however with power BI I am too limited
I can probably do some grunt-work transformations of data from JSON into something more tabular, if that's the sort of thing you're looking for.
I like to start with the question I'm trying to answer, mind you, because -- er, well, even when I do, I can sometimes get obsessed with solving a problem that I don't need to and waste a good three hours wrestling and swearing with something I don't even need to touch.
Ah, not to say that happened or anything. [grin]
The code isn't even the hard part on things like this, truthfully. It's looking at the data you have and trying to figure out what you can do with it.
and finding that story......