Get summary of wikipedia articles
Get the summary of a wikipedia article.
Specifically, it is the part of the article that is listed at the top of the article.
URL
https://api.excelapi.org/wikipedia/summary2
Configuration
| Configuration | Required | Description |
|---|---|---|
| word | ✔ | Specify the word that corresponds to the title part of wikipedia. URL encoding is required for Japanese and other languages. |
| lang | Specify the language code. If not specified, the default is JP (Japan). | |
| mode | Specifies the formatting method of the article. If not specified, the default is simple. full: Outputs all of the summary. simple: Remove parentheses and output only the first sentence. |
Example
=WEBSERVICE("https://api.excelapi.org/wikipedia/summary2?word="&ENCODEURL(A2))
Example (Compare mode)
C2：simple (デフォルト)
=WEBSERVICE("https://api.excelapi.org/wikipedia/summary2?word="&ENCODEURL(A2)&"&mode=simple")
C3：full
=WEBSERVICE("https://api.excelapi.org/wikipedia/summary2?word="&ENCODEURL(A2)&"&mode=full")
Example (Compare lang)
C2：
=WEBSERVICE("https://api.excelapi.org/wikipedia/summary2?word="&ENCODEURL(A2)&"&lang="&B2)
info
If there are multiple articles for the term you are searching, an ambiguous page may be returned.