Google Docs script for pulling character information from the wow API

[luxlunae]

How much work would it take me to port these scripts to VBA for excel? Assuming an intermediate level of VBA expertise but no experience at all with the actual pulling of data from a web source.

[Destahd]

OP Updated with new version of the basic script, now shows primary professions also.

Any desire for secondary ones? First Aid, Archeology, Cooking and whatever the fourth one is?

I created a second, separate script for per-slot iLvl information, the reasons why it is a second script are below.

this looks sweet! Thanks.

can iLevel for all item slots be added?

I added a second script with a second function wowi() for this, it is attached to the OP.

I tinkered around with the end of the script a bit to have it look up the item id and then the item iLevel. As you mentioned, it requires an extra look up for each item. I'm not sure if there is a cleaner way to do it or not.

See the items script for the cleaner way, it's done now.

I recommend against using the items script, it takes forever (near 1 minute) to run and often times out.

It also triggers a ratelimit from google docs itself, because it is doing too many lookups too quickly...

How much work would it take me to port these scripts to VBA for excel? Assuming an intermediate level of VBA expertise but no experience at all with the actual pulling of data from a web source.

This I don't know how to answer, alas. I would imagine it is not difficult... For context, I never worked with js before this script and it wasn't really difficult (outside the loop for the items, the rest was quite straight forward...)