Menu

#665 Unable to fetch prices from TCGPlayer

Bug
open
1
2024-01-02
2020-06-27
Jack Duff
No

First of all, thanks for the great work on the assistant, it really changed my life! Made building decks way more fun! Thanks!!

Since a couple of days, i'm encountering a problem with the update of prices from tcgplayer.
I found a message left by a user named insaneidiot having the same problem as me.
https://sourceforge.net/p/mtgbrowser/discussion/837435/thread/4e364de22d/?limit=25#30cc

the log says something like this:

*!ENTRY com.reflexit.magiccards.core 4 0 2020-06-06 19:15:44.249
!MESSAGE Connection error on url http://partner.tcgplayer.com/x3/phl.asmx/p?v=3&pk=MGCASSTNT&s=Kaladesh&p=Workshop+Assistant: Connection error 301: Moved Permanently. Attempt 0

!ENTRY com.reflexit.magiccards.core 4 0 2020-06-06 19:15:44.250
!MESSAGE Connection error on url http://partner.tcgplayer.com/x3/phl.asmx/p?v=3&pk=MGCASSTNT&s=Kaladesh&p=Workshop+Assistant: Connection error 301: Moved Permanently. Giving up

insaneidiot pointed the fact those adreesses seems to works with https instead of http.
Any way to fix this?
Thanks a lot!

.log attached

1 Attachments

Discussion

  • Anonymous

    Anonymous - 2020-08-07

    Can confirm that this is still an issue. I beleive the issues is in ParseTcgPlayerPrices.class but i do not have enough knowledge of Java to compile the changes to make TCG price list work

     
  • Alena Laskavaia

    Alena Laskavaia - 2020-08-09

    It very complecated now you need an API token to get the prices, I got the token but now I have to find the time to implement it

     
  • Anonymous

    Anonymous - 2020-09-01

    Any update on this issue? Thanks for your hard work on this app.

     
  • Alena Laskavaia

    Alena Laskavaia - 2020-09-02

    Hosestly I am not sure what to do. I got API token but they make it completely unusable for open source project. The token experies after like 30 days and to generate new it require private key which I cannot hardcode in app because its open source! I am stuck

     
  • Jack Duff

    Jack Duff - 2020-09-23

    What about getting the prices from mtgjson.com?
    Is it something that can be done without too much work?

     
  • Alena Laskavaia

    Alena Laskavaia - 2020-09-23

    Do they actually have prices?

     
  • Jack Duff

    Jack Duff - 2020-09-23

    I think they do... it looks like they do...
    They say the prices are updated each day.
    I installed mtgdb.gui yesterday(it feels like cheating, sorry!), stayed awake until 2 am to know what i could get from it...
    You checked it? it's kind of weird...
    All I know, it's that it gets its data from mtgjson. I went to the website and checked a bit...
    That's where my knowledge stops. I have really no programming skills and it really looked like chinese to me...
    Sorry to bother you with that problem... the functionnality was so great when it came to make fair trades easy...

     
  • Alena Laskavaia

    Alena Laskavaia - 2020-09-23

    I checked quickly I did not see "price" field in the card, but it maybe diffrent API for that,
    I will check more when I have time, because basically I lost all card prices providers now,
    cardkindom is european site, they did the API token trick now too but when I try to get it I cannot even create an account there because Canada is not on list of counries that can have accounts!
    (only EU)

     
  • Jack Duff

    Jack Duff - 2020-09-23

    Seems to be a different file, allprices.json.
    seems to be kind of a graphic with multiple prices, with dates, so you can follow the price evolution of a card...

    {
    "<card uuid="">": {
    "<card format="">": { // Game format
    "<price id="" provider="">": { // Price provider
    "buylist": { // Provider buylist values
    "foil": { // Foil prices
    "<yyyy-mm-dd>": <float> // Date and price as value
    },
    "normal": { // Normal prices
    "<yyyy-mm-dd>": <float> // Date and price as value
    }
    },
    "retail": { // Provider retail values
    "foil": { // Foil prices
    "<yyyy-mm-dd>": <float> // Date and price as value
    },
    "normal": { // Normal prices
    "<yyyy-mm-dd>": <float> // Date and price as value
    }
    }
    },
    ... // More providers
    }
    },
    ... // More formats
    }</float></yyyy-mm-dd></float></yyyy-mm-dd></float></yyyy-mm-dd></float></yyyy-mm-dd></price></card></card>

    looks like that:
    "0001e0d0-2dcd-5640-aadc-a84765cf5fc9": {"paper": {"cardkingdom": {"buylist": {"normal": {"2020-06-22": 1.8, "2020-06-26": 2.0, "2020-06-28": 1.8, "2020-06-30": 1.3, "2020-07-01": 1.3, "2020-07-05": 1.3, "2020-07-06": 1.3, "2020-07-08": 1.3, "2020-07-09": 1.3, "2020-07-10": 1.3, "2020-07-11": 1.3, "2020-07-12": 1.3, "2020-07-13": 1.8, "2020-07-14": 1.3, "2020-07-15": 1.3, "2020-07-16": 1.8, "2020-07-17": 1.8, "2020-07-18": 1.8, "2020-07-19": 1.8, "2020-07-20": 1.3, "2020-07... etc...
    I was just able to open it with an online viewer.

     
  • Alena Laskavaia

    Alena Laskavaia - 2020-09-23

    cool. that would do. It is scraping cardkingdom it looks!

     
  • Jack Duff

    Jack Duff - 2020-09-24

    from tcgplayer, cardmarket and card kingdom...
    it really looks like a nice project! their card database is great too...
    I've never heard of it before yesterday... Glad I found it!

     
  • Anonymous

    Anonymous - 2021-01-29
    Post awaiting moderation.
  • BlueCurler

    BlueCurler - 2024-01-02

    Hi Jack, I did try to reach you without success. Are you still interested to try my Scryfall to Magic Assistant converter?

     

Anonymous
Anonymous

Add attachments
Cancel