How can I import a table from the web?

1

I manage a sports app on behalf of a local football team. At present, you can only view the latest league table by clicking on a link in the App, which opens the website in your browser:

https://matchcenter.ifv.ch/default.aspx?lng=1&cxxlnus=1&v=393&t=67764&a=trr&

image
image1241×461 25.9 KB

Is there a way to scrape the URL and reconstruct a couple of columns from the table in my app WITHOUT using google or Excel sheets? I prefer my app to only use Glide Tables.

Thanks in advance for any tips :slight_smile:

2

I dare say that it could be done using JavaScript, but have you considered using a webview? (if your plan supports it).

3

Thanks Darren. I understand the web view is only for Pro apps and mine is a Starter.

I don’t fancy getting into Java and had hoped the column type whereby you can simulate an Excel function would work. What do you think?

If not, I guess I will have to attach an Excel Sheet…

4

I’ve never used that Excel plugin, so I’m not sure if that would work.

I know that Google Sheets has an IMPORTHTML function, which would probably get the job done. I imagine that Excel most likely has a similar function.

1 Like
5

has this ever been done?

6

Some javascript and AI :salt:

Change the instruction to play with getting particular data or asking open ended questions perhaps if you don’t want to do more html parsing.

20230918_102935

20230918_102921
20230918_102921429×525 18.9 KB

20230918_102912
20230918_102912430×666 25 KB

20230918_102855

var parser = new DOMParser();
var doc = parser.parseFromString(p1, "text/html");
var tables = doc.getElementsByTagName('table');
return tables[0].innerHTML
5 Likes
7

AI is useless when it comes to handling tables of data. I wouldn’t trust it. Plus why would I pay to use AI when most spreadsheets offer the web import for free?

8

May I know why you say so? I think Jeremy’s case offers a solid point on how to use it. If you don’t pay for Business/Enterprise to use Call API, I think you can still get to somewhere really good with:

  • A Javascript column to fetch the endpoint.
  • An OpenAI column with a solid prompt to force the output into a table/markdown format.
2 Likes
9

I will take closer look and see if I can import a table to see how difficult it is… worth a plunge and will likely learn something along the way. Thanks.

1 Like
10

I’m building a few football apps as well, how are you dealing with styling the apps?

Like a table of league standings, it can be nicely designed using html in a rich text component. But that would make the table static and users cannot click to view more info on rows.

11

Please let us know if we can help somewhere.

12

Here’s a demo of my Football app :grinning:

2 Likes
13

very nice!! some similar concepts with my team app to be honest. I’ve only started working on that app this week… i’l share here later today.

1 Like