Is this relevant to API? Please remove.
A suggestion
Sort:
Hmmm
Oct 9, 2020
0
#4
The API has endpoints you can use to retrieve that kind of data. If you have some basic programming skills you should be able to write a script that pulls the data and plugs it into a spreadsheet.
MGleason,
Are you telling me to write a program
I don't know how to I'm twelve yrs old
Oct 11, 2020
0
#6
I learned when I was 13. Anyone can learn some basic coding skills. There's plenty of guides online.
For example, there are several here that you can read online for free: https://inventwithpython.com/
Oct 11, 2020
0
#7
Well as we are being generous and ecumenical, here is a VBA subroutine to pull data string from API.
Public Function get_data_string(up_http, ModName) As String
Dim xmlhttp
Set xmlhttp = CreateObject("msxml2.xmlhttp.6.0")
With xmlhttp
icount = 0
Do
.Open "get", up_http, False
.setRequestHeader "User-Agent", ModName & ", username: ???????; contact: email address"
On Error Resume Next
.send
icount = icount + 1
get_data_string = .responseText
On Error GoTo 0
Loop While get_data_string = "" And icount < 100
End With
If icount >= 100 Then
MsgBox "No data for " & up_http, vbInformation
Stop
End If
Set xmlhttp = Nothing
End Function
Tricky_Dicky wrote:
Well as we are being generous and ecumenical, here is a VBA subroutine to pull data string from API.
Public Function get_data_string(up_http, ModName) As String
Dim xmlhttp
Set xmlhttp = CreateObject("msxml2.xmlhttp.6.0")
With xmlhttp
icount = 0
Do
.Open "get", up_http, False
.setRequestHeader "User-Agent", ModName & ", username: ???????; contact: email address"
On Error Resume Next
.send
icount = icount + 1
get_data_string = .responseText
On Error GoTo 0
Loop While get_data_string = "" And icount < 100
End With
If icount >= 100 Then
MsgBox "No data for " & up_http, vbInformation
Stop
End If
Set xmlhttp = Nothing
End Function
Thanks 
Can there be an option in which all the club member's names, roles and some more info get converted into a google spreadsheet ?? And new members will be automatically added to the spreadsheet?