Android Question Read data from google sheet

[Sone]

I am making app to read data from google spreadsheet and view in scrollview.
I tried using

job.Download("https://spreadsheets.google.com/tq?key=xxxxxxxxxx") but error

java.lang.RuntimeException: JSON Array expected.

Thanks

 

[Erel]

1. Use xCustomListView instead of ScrollView.

2. Where does this link come from? Is this a public sheet?

 

[Sone]

1. Use xCustomListView instead of ScrollView.

2. Where does this link come from? Is this a public sheet?

from my googlesheet

 

[Sone]

I make Shared to anyone who has link

 

[Sone]

If Job.Success Then
Dim response As String = Job.GetString
Dim parser As JSONParser
parser.Initialize(response)
Dim rows As List
rows = parser.NextArray (the error is here)

any advice is appreciated

 

[DonManfred]

If Job.Success Then

Please use [CODE]code here...[/CODE] tags when posting code.

 

[DonManfred]

any advice is appreciated

check the Documentation on how it works.
https://developers.google.com/sheets/api/

https://developers.google.com/sheets/api/reference/rest/ ' REST Api, can easily be used using okhttputils2.