1. #1
    High Overlord
    Join Date
    Jan 2010
    Location
    Dalaran
    Posts
    174

    Bliazzard API loot tracking

    I don't know if this goes here but here goes:

    So my GM has given me a challenge...figure out how to track loot using the blizzard api "If we could figure that out then we could populate our databases automatically"
    I think they want me to figure out who got loot and from what bosses and when. I offered to write it down and upload it as a spreed sheet but this is this challenge I was given.

    Problem is...I have no idea what the Blizz API is or how to use now that I'm looking at it. Help!

  2. #2
    Your Guild news page tells you who looted what recently. That would be an easier resource. It tracks epics and legendaries.

  3. #3
    use this URL: us.battle.net/api/wow/guild/alexstrasza/Lords%20of%20Alexstrasza?fields=news

    Fetches the news in a JSON structure.

  4. #4
    High Overlord
    Join Date
    Jan 2010
    Location
    Dalaran
    Posts
    174
    Now how would I convert that into a google spreadsheet. My brain is so fried right now >_<

  5. #5
    You either manually parse the entries and enter them into the docs OR write software to do it for you.

    For the later option, you'll need to read and parse the data from the battle.net API then upload it to google docs.

    Battle.net API: blizzard.github.com/api-wow-docs/
    JSON: w3schools.com/json/default.asp
    Google Spreadsheet API: developers.google.com/google-apps/spreadsheets/

    EDIT* Upon rereading your original post I now understand that what you wanted was the first option, manual entry.

    1) go to us.battle.net/api/wow/guild/alexstrasza/Lords%20of%20Alexstrasza?fields=news
    2) Select all and copy
    3) go to jsbeautifier.org/
    4) paste the data and click "Beautify Javascript or HTML"
    5) scan the page and look for entries starting with "type": "itemLoot", Your eyes will adjust eventually and it'll become much easier.
    6) Copy the relevant data from the next 3 lines.
    7) Mark your place. Use the timestamp so you'll remember the last entry you copied.
    Last edited by MrGneissGuy; 2012-12-29 at 02:17 AM.

  6. #6
    High Overlord
    Join Date
    Jan 2010
    Location
    Dalaran
    Posts
    174
    Gonna give that a try right now, thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •