complete REST API noob here, and first time on stackoverflow.
My problem is: I currently have a long English-Japanese character vocabulary list. I am also studying Mandarin Chinese and already know Cantonese. For each entry that currently contains 1) the Japanese character and 2) English, I want to add 3) Mandarin Chinese pronunciation and 4) Cantonese Chinese pronunciation.
I thought I could try the Wikimedia API to pull requests from wiktionary.org and populate my list. For example, in Cell 1A, I have Japanese, in Cell 1B I have English... I want Cell 1C to search for "1A" on Wiktionary and print what it finds under "Mandarin pronunciation" (pinyin) and then Cell 1D to the same for Cantonese pronunciation.
I tried to follow these instructions on importing JSON into a Google spreadsheet, created a Google spreadsheet, installed the script which enabled the ImportJSON("API_URL", "query", "options") functionality. Alas I have had no luck with the URL "wikipedia.org/w/api.php?". I've played with the Wikimedia API sandbox, tried to read through the instructions, but the documentation doesn't seem to provide instructions for something as simple as "search for term 'X', spit out the data contained in field 'Y'".
Is what I am trying to do possible, or is this just a crazy idea?
