Thread Tools Display Modes
12-31-19, 09:47 AM   #1
mechno
A Defias Bandit
Join Date: Dec 2019
Posts: 2
Addon communication with Google Sheets API

Hi guys,
Is it possible to make Addon that will communicate with Google Sheets API? What I am trying to do is to create Addon that will download a database from Google Sheets every time you log into the game.
  Reply With Quote
12-31-19, 10:06 AM   #2
Rilgamon
Premium Member
 
Rilgamon's Avatar
Premium Member
AddOn Author - Click to view addons
Join Date: Sep 2009
Posts: 822
No connection possible. WoW-Lua is in a sandboxed environment. It only loads lua files on login.
So you'd have to change a lua-file and reload wow for the changes to take effect.
__________________
The cataclysm broke the world ... and the pandas could not fix it!
  Reply With Quote
12-31-19, 12:57 PM   #3
JDoubleU00
A Firelord
 
JDoubleU00's Avatar
AddOn Author - Click to view addons
Join Date: Mar 2008
Posts: 463
You might be able to store the data in saved variables and use Google Sheets to read that. It could parse the data and display it in Sheets in the format you want. The other thought is to use Lua to display a string that you would copy and paste into Sheets. This would be similar to how AskMrRobot does it.

Just some thoughts that I have never tried.
__________________
Author of JWExpBar and JWRepBar.
  Reply With Quote
12-31-19, 08:36 PM   #4
Xrystal
nUI Maintainer
 
Xrystal's Avatar
Premium Member
AddOn Author - Click to view addons
Join Date: Feb 2006
Posts: 5,892
Based on this description: What I am trying to do is to create Addon that will download a database from Google Sheets every time you log into the game.

You would likely have to write or find a program that converts from google sheets document into xml format and customize that so that it can easily be copied and pasted into the lua saved variables. And then log into the game and load that up. It will in no way be automatic, as each person using the addon will have to download the google sheet document, run the converter tool, modify the output ( if the converter tool doesn't do that part as well ) and add the information into the respective saved variable file and then log into wow which will then load up that saved variable file.

If you then wanted it to do the reverse .. they would need to do the reverse and if everyone was sharing the same google sheet document, they would have to send you the modified file and everyone would have to wait for you to update the online file to download it the next time they log in.
__________________
  Reply With Quote
12-31-19, 09:08 PM   #5
JDoubleU00
A Firelord
 
JDoubleU00's Avatar
AddOn Author - Click to view addons
Join Date: Mar 2008
Posts: 463
More thinking out loud, how does the WoWhead client do it?
__________________
Author of JWExpBar and JWRepBar.
  Reply With Quote
01-03-20, 05:38 AM   #6
mechno
A Defias Bandit
Join Date: Dec 2019
Posts: 2
thanks for help guys. I did the same way as AskMrRobot does it.
  Reply With Quote

WoWInterface » Developer Discussions » General Authoring Discussion » Addon communication with Google Sheets API

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off