search

scryfall / google-sheets

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

Issue with refreshing data #20

Open ianw11 opened 9 months ago

ianw11 commented 9 months ago

I have a spreadsheet with about 250 individual card queries (searching specifically by set code and collector number).

What I just noticed was that opening the spreadsheet doesn't update some of the values. For instance, I added the SLD 1433 (Mycosynth Golem) soon after receiving it and at the time there was only nonfoil pricing available. Today on Scryfall there's only foil pricing available (and this is what I observed in the json response). However, the spreadsheet did not update to remove the nonfoil price and add the new foil price. It just left the old value and never updated. I noticed the same thing with other cards, even ones that didn't need to change from nonfoil to foil.

Example. Imagine that the box between the card name and the $20 price was filled in (nonfoil) and the $20 price was empty (foil). =SCRYFALL("set=" & A131 & " cn=" & B131, "name prices.usd prices.usd_foil prices.usd_etched lang id") mycosynth

Deleting the B column (1433) and re-entering it properly updated. I did this for many other rows and they all finally updated with proper values. I'm wondering if there's something I can do to avoid having to manually go through every row.

ianw11 commented 9 months ago

I also noticed some issues with the Angels secret lair deck, where "PAGL" got replaced with "PLST" and now a few cards (like PLST Vanquisher's Banner) aren't connecting through