Android Question Read data from google sheet

Thread starter Sone
Start date Oct 23, 2018
Similar Threads Similar Threads

S

Sone

Member

Licensed User

Oct 23, 2018

#1

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

Sort by date Sort by votes

Erel

B4X founder

Staff member

Licensed User

Longtime User

Oct 23, 2018

#2

1. Use xCustomListView instead of ScrollView.

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

Upvote 0

S

Sone

Member

Licensed User

Oct 23, 2018

#3

Erel said:
1. Use xCustomListView instead of ScrollView.

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

from my googlesheet

Upvote 0

S

Sone

Member

Licensed User

Oct 23, 2018

#4

I make Shared to anyone who has link

Upvote 0

S

Sone

Member

Licensed User

Oct 23, 2018

#5

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

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

Oct 23, 2018

#6

Sone said:
If Job.Success Then

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

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

Oct 23, 2018

#7

Sone said:
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.

Last edited: Oct 23, 2018

Upvote 0

You must log in or register to reply here.

Similar Threads

Wish B4x Libraries Google Sheet to include 4 extra columns to specify the actual library url links per platform

Replies: 0

Views: 1K

Aug 24, 2025

Mashiane

Article

B4A Library GSheet Library (integrate google sheets into your B4X apps easily)

2 3 4

Replies: 64

Views: 35K

Feb 20, 2026

fernando1987

Locked
Article

B4A Class [class][B4X] Google OAuth2

2

Replies: 24

Views: 43K

Oct 29, 2025

Erel

Locked
Article

Android Tutorial NFC - Reading and Writing

2 3 4

Replies: 64

Views: 71K

May 8, 2022

Erel

Locked
Article

Android Tutorial Google Maps

8 9 10

Replies: 192

Views: 188K

Jul 7, 2025

Erel

Share:

Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email