Scrape data from ajax

user_15141002 0
Viewed 130

I'm trying to scrape from https://www.goaloong.net/

This my first goal:

enter image description here

I need to have all the live events, excluded next and finished matches.

My difficulty is to extract only the data I need and find the live event time. I need this data: ID-START TIME-LEAGUE-HOME-AWAY-SCORE-TIME

This data are here https://www.goaloong.net/gf/data/bf_us.js.

Can you offer me some help please?

Thanks

UPDATE:

Added vba code

Sub get_test()

Dim objHTML As HTMLDocument
Dim objElement As Object
Set objHTML = New HTMLDocument
    Url = "https://www.goaloong.net/gf/data/bf_us.js"
With CreateObject("MSXML2.XMLHTTP")
    .Open "GET", Url, False
    .Send
    objHTML.body.innerHTML = .ResponseText
End With

a = objHTML.body.innerHTML
   
Row = Split(a, ";")

leng = UBound(Row) - LBound(Row)
For n = 2 To leng
Cells(n, 1) = Row(n)
Next n

End Sub
vba excel ajax javascript
1 Answers

Here is an overview of the datafields in array A. I have all 35 fields included, but 17 are unnown what they are for. Among other things, you should be able to see from the descriptions how you can calculate the correct playing time. For this you need the values 6 and 7 depending on the value 8. You can calculate with the given times no matter in which time zone a match takes place, because it is sufficient if all given times refer to the same time zone.

You can split the JS by CrLf into its rows:

splitAllJsRows = Split(.ResponseText, Chr(13))

enter image description here

user_100468970
Related