Unable to pull information for the rear side of a double-faced card #29
Description
I've set up a Sheet to track information for my commanders. I'm using the Scryfall function to pull color identities and oracle texts.
For the life of me, I cannot figure out how to pull the oracle text for the reverse side of a double-faced card. For example, pulling information for Kefka, Court Mage // Kefka, Ruler of Ruin only displays the oracle text for Kefka, Court Mage.
Putting just the front side name only gives information for the front side. Putting the rear side name only gives information for the front side. Putting both names separated by slashes (e.g. Kefka, Court Mage // Kefka, Ruler of Ruin, as is standard for cards like this on Scryfall) only gives information from the front side.
Below are some example I tried with the search being =SCRYFALL([Card Name],"color_identity, oracle_text")/. As can be seen, they all give just the front side.
As the image shows, this is also true for split cards, with Alive // Well only showing the information for Alive.
I peaked at some of the API information for how card information is stored, but I'm savvy enough there to figure it out.