Hi,
I'm trying to retrieve school performance data from the StatsWales My Local School website. I've gotten a little way towards this but have hit a brick wall. Please excuse my ignorance as I'm a complete newbie to this stuff.
Dim dSet As New cDataSet, cb As New cBrowser, jo As New cJobject
dSet.populateJSON jo.deSerialize( _
).child("schools"), Range("test4!$a$1")
This is the overall list of schools with simple data like school type, school name, and so on. However, what I eventually want is to retrieve more complete data for each school. These are stored in separate jsons identified by a code number (e.g.
http://mylocalschool.wales.gov.uk/schools/6664000.json).
I initially tried to retrieve this data using the same code:
Dim dSet As New cDataSet, cb As New cBrowser, jo As New cJobject
dSet.populateJSON jo.deSerialize( _
).child("school"), Range("test5!$a$1")
However, this returned the error "school must be a rowise array object".
From reading this forum. I guessed that this was due to 'school' being a higher level array so I tried adding .child("basicDetails") immediately after .child("school"). However, this produced the identical error.
Next I moved on to your suggestion to add an entry to the rest library, and progress that way. However, I can't see that the mylocalschools website has a Rest API that I can use, so I'm a bit stuck.
Again, apologies for my massive ignorance, but hoping someone can help.