This is an experiment on how to read a Google SpreadSheet that has been published to the web. The concept is to get the json version of the web item.
I have a test google spread sheet at: https://docs.google.com/spreadsheets/d/e/2PACX-1vT0KE8bTPLuh3NtL73pRRmptZsSIc-w1b_dFgGyDU3aNED4Mg9y-Pi-_1dHJQMjGFbMep18qq6Wf5CH/pubhtml
The ID is: 2PACX-1vT0KE8bTPLuh3NtL73pRRmptZsSIc-w1b_dFgGyDU3aNED4Mg9y-Pi-_1dHJQMjGFbMep18qq6Wf5CH and 1brWkVApKRJ3aRL6OfIQ4jlyx-wXmDhfpGjHIK6ACdQE
The json get is at: https://spreadsheets.google.com/feeds/list/1brWkVApKRJ3aRL6OfIQ4jlyx-wXmDhfpGjHIK6ACdQE/1/public/values?alt=json
Both of the above are confirmed to work.
If you observe the json schema, there are version encoding feed
The feed has a struct of Entry which is an array ( or slice) of another struct. This code is able to pick out the individual parts of Entry
Need to add this to a db now.
Also, the first row is ignored as I think it is suppose to be a Label row But I cannot find the JSON part that descibed the rows. If anyone has a comment on that.