Register
Page 1 of 4 123 ... Last
Results 1 to 10 of 40
  1. #1
    Erorus's Avatar
    Posts
    1,404
    Reputation
    114
    Tagged in
    677 Posts
    Add to this user's reputation

    [API] Market XML Feed

    (C&P from devblog)

    Market data per realm via XML is now available.

    Login to your account, scroll towards the bottom. Pick a realm. Copypaste the URL. That static URL allows you to pull an entire realm's data. There are no additional parameters. You can do 5 pulls per 24 hour period right now (although either number may change in either direction, depending on usage). This means you can pull one realm 5 times, or you can pull 5 realms once each, or do A-, H-, A-, H-, A- for one day.. 5 pulls across all realms per day. For now. You'll want to pull it once, then cache it locally if you want to work with it.

    That URL is specific to your account, so if you share it, then the other party may use up your allotted pulls for the day. It's also the same string as is used in the RSS feeds. Knowing it doesn't allow anyone to log in as you, but you want to keep it to yourself all the same.

    For each item, you may get up to 6 values:
    market - the latest market value, in copper
    quantity - the sum total of items (not auctions) seen for that item during the most recent scan
    marketaverage - the average market value, in copper, over the past 2 weeks-ish
    marketstddev - the standard deviation for market value, in copper, over the past 2 weeks-ish
    reagentprice - the cheapest price to craft one of that item based on the market values of its components as of the most recent scan
    lastseen - the most recent date this item was seen on a scan for that realm

    Basically they're the same values you'd see on the category page or on your market watch list.

    So, check it out, send over any suggestions. Don't break it. Or, well, if you're gonna break it, maybe sooner is better than later.

  2. #2
    This is insanely awesome. I'm using the data feed to construct an analysis spreadsheet for myself.

    The challenge I'm running into at the moment (I'm sure there will be more) is mapping Item ID's to Item Names. I could do the manual mapping, of course, but I'm a programmer so I hate manual stuff.

    Do you (or anyone) know where I can get an up-to-date extract that will give both Item ID's and Names?

    Thanks!

  3. #3
    Quote Originally Posted by thc1967 View Post
    This is insanely awesome. I'm using the data feed to construct an analysis spreadsheet for myself.

    The challenge I'm running into at the moment (I'm sure there will be more) is mapping Item ID's to Item Names. I could do the manual mapping, of course, but I'm a programmer so I hate manual stuff.

    Do you (or anyone) know where I can get an up-to-date extract that will give both Item ID's and Names?

    Thanks!
    Doesn't wowhead have an API for things like this? I swear I've seen mention of it or something similar a few times over the years.

  4. #4
    I've got the same question - I'll check out the wowhead API.

    EDIT: Erorus hard at work here - maybe we can follow his breadcrumb trail.
    http://www.wowhead.com/forums&topic=...owhead-api-etc

    EDIT2: Dead end, that's the old armory...

    EDIT3: Allakhazam has exactly what we're looking for - it just hasn't been updated since Wrath.
    http://wow.allakhazam.com/itemlist.xml
    Last edited by Stede; March 22nd, 2011 at 10:41 AM.
    Retired - I blame Kathroman for everything.

    (that's a joke, eh)

  5. #5
    Yeah, I poked around WoWHead but didn't find anything. I did find an export at ZAM but it doesn't have any Cataclysm data.

    It's not as simple as exporting item names with this XML feed, either, since I need ID's for stuff that isn't in the feed.

  6. #6
    Snodeath's Avatar
    Posts
    135
    Reputation
    5
    Tagged in
    20 Posts
    Add to this user's reputation
    I'll give it a shot. I am a little hesitant. I tend to break the development servers weekly at work...

  7. #7
    Idk if this helps you guys, but if you add &xml to the end of a wowhead url, you get some neat stuff.

    http://www.wowhead.com/item=52180&xml

    Too bad we can't grab all of those and thank yank out the stuff we need.... or can we?
    Retired - I blame Kathroman for everything.

    (that's a joke, eh)

  8. #8
    That's one way to do it. I'd have to call wowhead once per item that I need though. I have to believe they won't like that, and I don't really want to code that. There has to be a better way.

  9. #9
    Well, i know you're looking for stuff that isn' in the TUJ feeds, thc, but - if we could key off those, and link to the xml feeds from wowhead for each of those items, it might not be so bad.

    It would assign names to everything in TUJ's feed, would be relatively efficient, and each xml feed can't be more than 1-2kb. Times 6000 keeps us between 6 & 12 MB.

    EDIT: Found this site kinda informative.
    http://gamedev.stackexchange.com/que...ld-of-warcraft
    Last edited by Stede; March 22nd, 2011 at 11:13 AM.
    Retired - I blame Kathroman for everything.

    (that's a joke, eh)

  10. #10
    Kathroman's Avatar
    Posts
    5,452
    Reputation
    286
    Blog Entries
    20
    Tagged in
    2157 Posts
    Add to this user's reputation
    I have it working from the Wowhead xml feeds for a single item in a google docs spreadsheet, but I can't find an easy way to simulate a FOR loop...

    It would be easy enough to use PhP/MySQL to extract them, but you mentioned that you were using a spreadsheet, and I figure that most people here would be in the same boat. I'll keep looking
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler