Register
Page 6 of 9 First ... 45678 ... Last
Results 51 to 60 of 88
  1. #51
    Gumdrops's Avatar
    Posts
    722
    Reputation
    35
    Tagged in
    183 Posts
    Add to this user's reputation
    There's no such thing as Realm Average Daily Sold, there's not enough data to provide that.

  2. #52
    Quote Originally Posted by Gumdrops View Post
    There's no such thing as Realm Average Daily Sold, there's not enough data to provide that.
    Thanks for the info.

    I was afraid that was the answer.

    This used to be a valuable tool at Wowuction. I understand that they probably used an algorithm to make it a best guess but it was usually pretty accurate to assist in setting up my crafting groups and determining how many to make/post.

  3. #53
    ichebu's Avatar
    Posts
    17
    Reputation
    0
    Tagged in
    9 Posts
    Add to this user's reputation
    I was hoping to use this for caged battle pets, what would be the api url I need to import?
    All of this is just my opinion, do whatever the **** you wanna do

  4. #54
    Sapu94's Avatar
    Posts
    7,114
    Reputation
    345
    Blog Entries
    25
    Tagged in
    1928 Posts
    Add to this user's reputation
    There is currently no API for battlepets.


    Follow me and TSM on Twitter for important updates, news, and giveaways!
    TSM Website | /r/woweconomy & TSM Discord | Go Premium | TSM FAQ

    "A good programmer is someone who always looks both ways before crossing a one-way street."

  5. #55
    Hello,

    New member here. I've read through most if not all of the guides and watched some videos as well. Currently I'm watching a video that's a bit old but it walks you through importing AH data into a google sheet. It's about 2 years old so I'm sure a lot has changed since then. I made sure I used the new api information from the post here to start.

    I have a few questions, but I think my first is going to be this. Is there a way to use the desktop addon to import my AH data into a google sheet rather than downloading a CSV file whenever I want it updated? I'm assuming that functionality is probably one of the reasons the desktop app was created, but I can't seem to find documentation/guides on how to utilize the addon for this purpose.

    Any help would be appreciated.

  6. #56
    Gumdrops's Avatar
    Posts
    722
    Reputation
    35
    Tagged in
    183 Posts
    Add to this user's reputation
    Check out this thread on using TSM APIs and spreadsheets: https://www.reddit.com/r/woweconomy/...s_by_fetching/

  7. #57
    TSM API broken.
    RegionSaleAvg,RegionAvgDailySold,RegionSaleRate return 0,0,0 instead of real values.

  8. #58
    Gumdrops's Avatar
    Posts
    722
    Reputation
    35
    Tagged in
    183 Posts
    Add to this user's reputation
    This is being investigated.

  9. #59
    Gumdrops's Avatar
    Posts
    722
    Reputation
    35
    Tagged in
    183 Posts
    Add to this user's reputation
    We've recently made some changes to the way the TSM Web API functions to hopefully make it more accessible.

    Previously, each endpoint provided all of the following fields in its response:

    Code:
    [
      {
        "Id": 0,
        "Name": "string",
        "Level": 0,
        "Class": "string",
        "SubClass": "string",
        "VendorBuy": 0,
        "VendorSell": 0,
        "MarketValue": 0,
        "MinBuyout": 0,
        "Quantity": 0,
        "NumAuctions": 0,
        "HistoricalPrice": 0,
        "RegionMarketAvg": 0,
        "RegionMinBuyoutAvg": 0,
        "RegionQuantity": 0,
        "RegionHistoricalPrice": 0,
        "RegionSaleAvg": 0,
        "RegionAvgDailySold": 0,
        "RegionSaleRate": 0
      }
    ]
    This would cause some issues in some applications, such as Google Sheets, because the data was simply too large. Now you can actually specify which fields you would like returned at the end of your query.

    Let's look at the /item/{region}/{realm} endpoint in Google Sheets as an example.


    By default, and when no fields are specified then all fields are returned:

    Code:
    http://api.tradeskillmaster.com/v1/item/{region}/{realm}?format=csv&apiKey=<SNIP>
    This would return an error that the resource being imported is too large.


    If you're only interested in the Item ID, Name, MinBuyout and MarketValue for example, you can now add those specific case-sensitive fields separated by commas at the end of your query:

    Code:
    http://api.tradeskillmaster.com/v1/item/{region}/{realm}?format=csv&apiKey=<SNIP>&fields=Id,Name,MinBuyout,MarketValue
    This will return the specified fields in your spreadsheet ready for a VLOOKUP.


    If you're unfamilar with the TSM Web API I wrote up a brief introduction on our support knowledgebase: http://support.tradeskillmaster.com/...Public+Web+API

    These changes and more technical information can be found in the TSM API Documentation: http://api.tradeskillmaster.com/docs/

  10. #60
    I've got this working in google sheets now thanks to the changes made! If anyone needs help. Don't hesitate to send me a private message or post here and I'd be more than happy to help out.

 

 

Similar Threads

  1. [BETA] TSM Web APIs
    By Sapu94 in forum TradeSkillMaster Website & Desktop Application
    Replies: 63
    Last Post: February 28th, 2016, 01:31 PM
  2. [RFC] Public TSM APIs
    By Sapu94 in forum TradeSkillMaster Website & Desktop Application
    Replies: 12
    Last Post: August 28th, 2014, 09:55 PM
  3. TradeSkillMaster 2.0 Public Beta
    By Sapu94 in forum General TradeSkillMaster Discussion
    Replies: 261
    Last Post: August 8th, 2013, 10:09 PM
  4. KR, TW, CN auction house APIs now open apparently
    By ihsw in forum Archive (General)
    Replies: 0
    Last Post: December 18th, 2012, 11:12 AM