WoWInterface

WoWInterface (https://www.wowinterface.com/forums/index.php)
-   General Authoring Discussion (https://www.wowinterface.com/forums/forumdisplay.php?f=20)
-   -   Addon communication with Google Sheets API (https://www.wowinterface.com/forums/showthread.php?t=57756)

mechno 12-31-19 09:47 AM

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.

Rilgamon 12-31-19 10:06 AM

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.

JDoubleU00 12-31-19 12:57 PM

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.

Xrystal 12-31-19 08:36 PM

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.

JDoubleU00 12-31-19 09:08 PM

More thinking out loud, how does the WoWhead client do it?

mechno 01-03-20 05:38 AM

thanks for help guys. I did the same way as AskMrRobot does it.


All times are GMT -6. The time now is 05:26 AM.

vBulletin © 2020, Jelsoft Enterprises Ltd
© 2004 - 2020 MMOUI