search

scryfall / google-sheets

Custom =SCRYFALL() function for Google Sheets
69 stars 12 forks source link

Pricing data info returns empty #17

Open gnall opened 1 year ago

gnall commented 1 year ago

https://scryfall.com/card/iko/162/kogla-the-titan-ape

!'Kogla, the Titan Ape' returns the result https://scryfall.com/card/iko/162/kogla-the-titan-ape

I get an empty result when I try to get the pricing data. It works for other cards, but certain ones return an empty string.

In my case it's empty for these 2:

Kogla, the Titan Ape Stoneforge Mystic

Here's my google sheets, Look for the neon pink squares for the 3 cards listed above. https://docs.google.com/spreadsheets/d/1po2M-WYUFiK040g5wustrGt1ptpH1DesTOgfgZhAMrE/edit?usp=sharing

My first guess is that you're not ignoring "Treasure Chest" & "Magic Online promos" printings of the cards and it's seeing an empty string and treating that as the lowest value. Might need some type checking there to make sure it doesn't treat empty strings as the lowest price.

I also opened a Scryfall support ticket incase it's an issue on the API side of things.

Thanks for your help!

gnall commented 1 year ago

Update: If I remove the sort by "price" in the query. Then I get results. But still not behaving as intended.