How to list wikidata items for which a P4 = Q130 ?

[hugolpz]

The readme's WIKIDATA, WIKIBASES section doesn't illustrate it. How do we create lists of items from Wikibase ?

I want this file and its 186 budies.

Should I run a SPARQL query ?

SELECT ?isoLabel ?audio ?audioLabel
WHERE {
  ?audio prop:P4 entity:Q130 .   # Filter: P4 language is Q130 zho  ;
  ?audio prop:P2 entity:Q2 .   # Filter: audios
  ?audio prop:P4 ?lang .
  ?lang  prop:P13 ?iso .
  # Add Labels
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } 
}
# Helper: Chinese writing zho: lili:Q130/wd:Q7850 ; Chinese mandarin cmn: lili:Q113/wd:Q9192

[kanasimi]

Yes. Please refer to https://kanasimi.github.io/wikiapi/Wikiapi.html#SPARQL

[hugolpz]

Nope. It did not solve my issue.

I did review that I have the lasted code this morning already.
Via npm list, then double checking by opening my local files into my text editor.
I confirmed visually that :

• my local directory has ./node_modules/wikiapi/ and ./node_modules/cejs/
• my local ./node_module/wikiapi/Wikiapi.js is similar to your latest github version and
• my local ./node_modules/cejs/application/net/wiki.js is similar to your latest github version

Are your testing .data() upon Lingualibre.org ?
My best guess is that Lingualibre.org is poorly configured, returns something like my api url is https://lingualibre.org/w/ (which is incorrect) to .data(), so it fails and fall back to wikidata.

Your code seems ok, since the fall back fetch the right data from wikidata.

[kanasimi]

Well... Here are my results.

get_API_parameters: 快取 lingualibreorg 的 API 模組資訊：模組路徑為 query+userinfo
get_API_parameters: 快取 lingualibreorg 的 API 模組資訊：模組路徑為 query+siteinfo
get_API_parameters: 快取 lingualibreorg 的 API 模組資訊：模組路徑為 query
setup_query_modules: 共有3種查詢模組：prop、list、meta
get_API_parameters: 快取 lingualibrewiki 的 API 模組資訊：模組路徑為 query+userinfo
get_API_parameters: 快取 lingualibrewiki 的 API 模組資訊：模組路徑為 query+siteinfo
Entity title: audio record - zho - Wang Cheng (Yug)

I just updated the npm of CeJS and wikiapi, please try again, thanks.

[hugolpz]

I believe it works ! Thank you !
Any idea what it was ?

yug@yug-k401ub:~/Documents/DragonsBot$ npm list
dragons-bot@0.0.1 /home/yug/Documents/DragonsBot
├── cejs@4.5.4 (git+ssh://git@github.com/kanasimi/cejs.git#2d3901a1fa3ff8858eaf808ed89f3ea8692c37a2)
├── node-fetch@2.6.7
├── npm-check-updates@16.0.5
└── wikiapi@1.19.3 (git+ssh://git@github.com/kanasimi/wikiapi.git#73257ab378539560066dbfcd135a224c42be5fb1)

ug@yug-k401ub:~/Documents/DragonsBot$ node test.js 
{
  API_URL: 'https://lingualibre.org/api.php',
  data_API_URL: 'https://lingualibre.org/api.php',
  SPARQL_API_URL: 'https://lingualibre.org/bigdata/namespace/wdq/sparql',
  user_name: 'Dragons Bot@Dragons_Bot',
  password: 'msofmj1eidsmmjvkccg7bvdv317evckb'
}
get_API_parameters: Cache information about the API modules of lingualibreorg: module path=query+userinfo 
get_API_parameters: Cache information about the API modules of lingualibreorg: module path=query+siteinfo 
get_API_parameters: Cache information about the API modules of lingualibreorg: module path=query 
setup_query_modules: Found 3 query modules: prop, list, meta 
wiki_API_page: Does not exist: [[User talk:Dragons Bot/Stop]] 
wiki_API.check_stop: The emergency stop page was not found ([[User talk:Dragons Bot/Stop]]). The operation will proceed as usual. 
Testing .edit() on [[User:Yug]] to prove Lingualibre.org bot login works.
get_API_parameters: Cache information about the API modules of lingualibreorg: module path=edit 
get_API_parameters: Cache information about the API modules of lingualibrewiki: module path=query+userinfo 
get_API_parameters: Cache information about the API modules of lingualibrewiki: module path=query+siteinfo 
Entity title: audio record - zho - Wang Cheng (Yug)

---

yug@yug-k401ub:~/Documents/DragonsBot$ node test.js 
{
  API_URL: 'https://lingualibre.org/api.php',
  data_API_URL: 'https://lingualibre.org/api.php',
  SPARQL_API_URL: 'https://lingualibre.org/bigdata/namespace/wdq/sparql',
  user_name: 'Dragons Bot@Dragons_Bot',
  password: 'msofmj1eidsmmjvkccg7bvdv317evckb'
}
get_API_parameters: Cache information about the API modules of lingualibreorg: module path=query+userinfo 
get_API_parameters: Cache information about the API modules of lingualibreorg: module path=query+siteinfo 
get_API_parameters: Cache information about the API modules of lingualibreorg: module path=query 
setup_query_modules: Found 3 query modules: prop, list, meta 
wiki_API_page: Does not exist: [[User talk:Dragons Bot/Stop]] 
wiki_API.check_stop: The emergency stop page was not found ([[User talk:Dragons Bot/Stop]]). The operation will proceed as usual. 
Testing .edit() on [[User:Yug]] to prove Lingualibre.org bot login works.
get_API_parameters: Cache information about the API modules of lingualibreorg: module path=edit 
wiki_API.prototype.next: 剩餘 1 action(s)
wiki_API.prototype.next: 剩餘 2 action(s)
get_namespace: Invalid namespace: [https://lingualibre.org/api.php] @ namespace list https://lingualibre.org/api.php
get_namespace: Invalid namespace: [lingualibre] @ namespace list lingualibre
get_namespace: Invalid namespace: [lingualibre] @ namespace list lingualibre
wiki_API.login: 準備登入 [Dragons Bot@Dragons_Bot]。
wiki_API_query: action: https://lingualibre.org/api.php,[object Object]
[1/2] [assert] = [user]
[2/2] [maxlag] = [5]
[1/4] [assert] = [user]
[2/4] [maxlag] = [5]
[3/4] [format] = [json]
[4/4] [utf8] = [1]
normalize_URL_to_fetch: Fetching URL: {object} [https://lingualibre.org/api.php?assert=user&maxlag=5&format=json&utf8=1] 
[1/4] [assert] = [user]
[2/4] [maxlag] = [5]
[3/4] [format] = [json]
[4/4] [utf8] = [1]
[1/4] [assert] = [user]
[2/4] [maxlag] = [5]
[3/4] [format] = [json]
[4/4] [utf8] = [1]
get_URL_node: Add timeout 1 min: [https://lingualibre.org/api.php?assert=user&maxlag=5&format=json&utf8=1] 
setup_data_session: Setup 宿主 host session.
setup_data_session: run callback: function() {
                                // console.trace(_this);
                                // console.trace(_this.data_session);
                                // next[1] : callback of set_data
                                _this.next(next[1]);
                        }
get_URL_node: HTTP status code: 200 https://lingualibre.org/api.php?assert=user&maxlag=5&format=json&utf8=1 
get_URL_node: end(): https://lingualibre.org/api.php?assert=user&maxlag=5&format=json&utf8=1
wiki_API_query: action: https://lingualibre.org/api.php,[object Object]
[1/4] [action] = [query]
[2/4] [meta] = [tokens]
[3/4] [type] = [login]
[4/4] [maxlag] = [5]
[1/6] [action] = [query]
[2/6] [meta] = [tokens]
[3/6] [type] = [login]
[4/6] [maxlag] = [5]
[5/6] [format] = [json]
[6/6] [utf8] = [1]
normalize_URL_to_fetch: Fetching URL: {object} [https://lingualibre.org/api.php?action=query&meta=tokens&type=login&maxlag=5&format=json&utf8=1] 
[1/6] [action] = [query]
[2/6] [meta] = [tokens]
[3/6] [type] = [login]
[4/6] [maxlag] = [5]
[5/6] [format] = [json]
[6/6] [utf8] = [1]
[1/6] [action] = [query]
[2/6] [meta] = [tokens]
[3/6] [type] = [login]
[4/6] [maxlag] = [5]
[5/6] [format] = [json]
[6/6] [utf8] = [1]
get_URL_node: Add timeout 1 min: [https://lingualibre.org/api.php?action=query&meta=tokens&type=login&maxlag=5&format=json&utf8=1] 
get_URL_node: HTTP status code: 200 https://lingualibre.org/api.php?action=query&meta=tokens&type=login&maxlag=5&format=json&utf8=1 
get_URL_node: end(): https://lingualibre.org/api.php?action=query&meta=tokens&type=login&maxlag=5&format=json&utf8=1
wiki_API_query: action: https://lingualibre.org/api.php,[object Object]
[1/2] [action] = [login]
[2/2] [maxlag] = [5]
[1/4] [action] = [login]
[2/4] [maxlag] = [5]
[3/4] [format] = [json]
[4/4] [utf8] = [1]
normalize_URL_to_fetch: Fetching URL: {object} [https://lingualibre.org/api.php?action=login&maxlag=5&format=json&utf8=1] 
[1/4] [action] = [login]
[2/4] [maxlag] = [5]
[3/4] [format] = [json]
[4/4] [utf8] = [1]
[1/4] [action] = [login]
[2/4] [maxlag] = [5]
[3/4] [format] = [json]
[4/4] [utf8] = [1]
get_URL_node: Add timeout 1 min: [https://lingualibre.org/api.php?action=login&maxlag=5&format=json&utf8=1] 
get_URL_node: HTTP status code: 200 https://lingualibre.org/api.php?action=login&maxlag=5&format=json&utf8=1 
get_URL_node: end(): https://lingualibre.org/api.php?action=login&maxlag=5&format=json&utf8=1
wiki_API.prototype.get_token: Try to get the csrftoken ...
wiki_API_query: action: https://lingualibre.org/api.php,action=query&meta=tokens&type=csrf
[1/3] [action] = [query]
[2/3] [meta] = [tokens]
[3/3] [type] = [csrf]
[1/4] [action] = [query]
[2/4] [meta] = [tokens]
[3/4] [type] = [csrf]
[4/4] [maxlag] = [5]
[1/6] [action] = [query]
[2/6] [meta] = [tokens]
[3/6] [type] = [csrf]
[4/6] [maxlag] = [5]
[5/6] [format] = [json]
[6/6] [utf8] = [1]
normalize_URL_to_fetch: Fetching URL: {object} [https://lingualibre.org/api.php?action=query&meta=tokens&type=csrf&maxlag=5&format=json&utf8=1] 
[1/6] [action] = [query]
[2/6] [meta] = [tokens]
[3/6] [type] = [csrf]
[4/6] [maxlag] = [5]
[5/6] [format] = [json]
[6/6] [utf8] = [1]
[1/6] [action] = [query]
[2/6] [meta] = [tokens]
[3/6] [type] = [csrf]
[4/6] [maxlag] = [5]
[5/6] [format] = [json]
[6/6] [utf8] = [1]
get_URL_node: Add timeout 1 min: [https://lingualibre.org/api.php?action=query&meta=tokens&type=csrf&maxlag=5&format=json&utf8=1] 
get_URL_node: HTTP status code: 200 https://lingualibre.org/api.php?action=query&meta=tokens&type=csrf&maxlag=5&format=json&utf8=1 
get_URL_node: end(): https://lingualibre.org/api.php?action=query&meta=tokens&type=csrf&maxlag=5&format=json&utf8=1
wiki_API.prototype.token: csrftoken: 3919bc69c635152fffd7ea4403d9b1716302b1a6+\
wiki_API.prototype.next: 剩餘 3 action(s)
wiki_API.prototype.next: 剩餘 3 action(s)
It is now initializing. Push function into queue: function() {
                                // console.trace(_this);
                                // console.trace(_this.data_session);
                                // next[1] : callback of set_data
                                _this.next(next[1]);
                        }
wiki_API.prototype.next: 剩餘 2 action(s)
need_get_API_parameters: Will execute caller later after get API parameters of [query+userinfo]...
wiki_API_query: action: ,[object Object]
[1/3] [action] = [paraminfo]
[2/3] [modules] = [query+userinfo]
[3/3] [maxlag] = [5]
[1/5] [action] = [paraminfo]
[2/5] [modules] = [query+userinfo]
[3/5] [maxlag] = [5]
[4/5] [format] = [json]
[5/5] [utf8] = [1]
normalize_URL_to_fetch: Fetching URL: {object} [https://lingualibre.org/api.php?action=paraminfo&modules=query%2Buserinfo&maxlag=5&format=json&utf8=1] 
[1/5] [action] = [paraminfo]
[2/5] [modules] = [query+userinfo]
[3/5] [maxlag] = [5]
[4/5] [format] = [json]
[5/5] [utf8] = [1]
[1/5] [action] = [paraminfo]
[2/5] [modules] = [query+userinfo]
[3/5] [maxlag] = [5]
[4/5] [format] = [json]
[5/5] [utf8] = [1]
get_URL_node: Add timeout 1 min: [https://lingualibre.org/api.php?action=paraminfo&modules=query%2Buserinfo&maxlag=5&format=json&utf8=1] 
get_URL_node: HTTP status code: 200 https://lingualibre.org/api.php?action=paraminfo&modules=query%2Buserinfo&maxlag=5&format=json&utf8=1 
get_URL_node: end(): https://lingualibre.org/api.php?action=paraminfo&modules=query%2Buserinfo&maxlag=5&format=json&utf8=1
get_namespace: Invalid namespace: [lingualibre] @ namespace list lingualibre
get_API_parameters: Cache information about the API modules of lingualibrewiki: module path=query+userinfo 
[2/2] [uiprop] = [rights|blockinfo|centralids]
wiki_API_query: action: https://lingualibre.org/api.php,
[1/1] [maxlag] = [5]
[1/3] [maxlag] = [5]
[2/3] [format] = [json]
[3/3] [utf8] = [1]
normalize_URL_to_fetch: Fetching URL: {object} [https://lingualibre.org/api.php?maxlag=5&format=json&utf8=1] 
[1/3] [maxlag] = [5]
[2/3] [format] = [json]
[3/3] [utf8] = [1]
[1/3] [maxlag] = [5]
[2/3] [format] = [json]
[3/3] [utf8] = [1]
get_URL_node: Add timeout 1 min: [https://lingualibre.org/api.php?maxlag=5&format=json&utf8=1] 
get_URL_node: HTTP status code: 200 https://lingualibre.org/api.php?maxlag=5&format=json&utf8=1 
get_URL_node: end(): https://lingualibre.org/api.php?maxlag=5&format=json&utf8=1
wiki_API.login: 已登入 [Dragons Bot@Dragons_Bot]。自動執行 .next()，處理餘下的工作。
wiki_API.prototype.next: 剩餘 1 action(s)
need_get_API_parameters: Will execute caller later after get API parameters of [query+siteinfo]...
wiki_API_query: action: ,[object Object]
[1/3] [action] = [paraminfo]
[2/3] [modules] = [query+siteinfo]
[3/3] [maxlag] = [5]
[1/5] [action] = [paraminfo]
[2/5] [modules] = [query+siteinfo]
[3/5] [maxlag] = [5]
[4/5] [format] = [json]
[5/5] [utf8] = [1]
normalize_URL_to_fetch: Fetching URL: {object} [https://lingualibre.org/api.php?action=paraminfo&modules=query%2Bsiteinfo&maxlag=5&format=json&utf8=1] 
[1/5] [action] = [paraminfo]
[2/5] [modules] = [query+siteinfo]
[3/5] [maxlag] = [5]
[4/5] [format] = [json]
[5/5] [utf8] = [1]
[1/5] [action] = [paraminfo]
[2/5] [modules] = [query+siteinfo]
[3/5] [maxlag] = [5]
[4/5] [format] = [json]
[5/5] [utf8] = [1]
get_URL_node: Add timeout 1 min: [https://lingualibre.org/api.php?action=paraminfo&modules=query%2Bsiteinfo&maxlag=5&format=json&utf8=1] 
wiki_API.prototype.next: The queue is empty.
get_URL_node: HTTP status code: 200 https://lingualibre.org/api.php?action=paraminfo&modules=query%2Bsiteinfo&maxlag=5&format=json&utf8=1 
get_URL_node: end(): https://lingualibre.org/api.php?action=paraminfo&modules=query%2Bsiteinfo&maxlag=5&format=json&utf8=1
get_namespace: Invalid namespace: [lingualibre] @ namespace list lingualibre
get_API_parameters: Cache information about the API modules of lingualibrewiki: module path=query+siteinfo 
wiki_API_query: action: [object Object]
[1/4] [action] = [query]
[2/4] [meta] = [siteinfo]
[3/4] [siprop] = [general|namespaces|namespacealiases|specialpagealiases|magicwords|functionhooks|variables|interwikimap|languagevariants|restrictions|uploaddialog|skins|rightsinfo|extensiontags|protocols|fileextensions]
[4/4] [maxlag] = [5]
[1/6] [action] = [query]
[2/6] [meta] = [siteinfo]
[3/6] [siprop] = [general|namespaces|namespacealiases|specialpagealiases|magicwords|functionhooks|variables|interwikimap|languagevariants|restrictions|uploaddialog|skins|rightsinfo|extensiontags|protocols|fileextensions]
[4/6] [maxlag] = [5]
[5/6] [format] = [json]
[6/6] [utf8] = [1]
normalize_URL_to_fetch: Fetching URL: {object} [https://lingualibre.org/api.php?action=query&meta=siteinfo&siprop=general%7Cnamespaces%7Cnamespacealiases%7Cspecialpagealiases%7Cmagicwords%7Cfunctionhooks%7Cvariables%7Cinterwikimap%7Clanguagevariants%7Crestrictions%7Cuploaddialog%7Cskins%7Crightsinfo%7Cextensiontags%7Cprotocols%7Cfileextensions&maxlag=5&format=json&utf8=1] 
[1/6] [action] = [query]
[2/6] [meta] = [siteinfo]
[3/6] [siprop] = [general|namespaces|namespacealiases|specialpagealiases|magicwords|functionhooks|variables|interwikimap|languagevariants|restrictions|uploaddialog|skins|rightsinfo|extensiontags|protocols|fileextensions]
[4/6] [maxlag] = [5]
[5/6] [format] = [json]
[6/6] [utf8] = [1]
[1/6] [action] = [query]
[2/6] [meta] = [siteinfo]
[3/6] [siprop] = [general|namespaces|namespacealiases|specialpagealiases|magicwords|functionhooks|variables|interwikimap|languagevariants|restrictions|uploaddialog|skins|rightsinfo|extensiontags|protocols|fileextensions]
[4/6] [maxlag] = [5]
[5/6] [format] = [json]
[6/6] [utf8] = [1]
get_URL_node: Add timeout 1 min: [https://lingualibre.org/api.php?action=query&meta=siteinfo&siprop=general%7Cnamespaces%7Cnamespacealiases%7Cspecialpagealiases%7Cmagicwords%7Cfunctionhooks%7Cvariables%7Cinterwikimap%7Clanguagevariants%7Crestrictions%7Cuploaddialog%7Cskins%7Crightsinfo%7Cextensiontags%7Cprotocols%7Cfileextensions&maxlag=5&format=json&utf8=1] 
get_URL_node: HTTP status code: 200 https://lingualibre.org/api.php?action=query&meta=siteinfo&siprop=general%7Cnamespaces%7Cnamespacealiases%7Cspecialpagealiases%7Cmagicwords%7Cfunctionhooks%7Cvariables%7Cinterwikimap%7Clanguagevariants%7Crestrictions%7Cuploaddialog%7Cskins%7Crightsinfo%7Cextensiontags%7Cprotocols%7Cfileextensions&maxlag=5&format=json&utf8=1 
get_URL_node: end(): https://lingualibre.org/api.php?action=query&meta=siteinfo&siprop=general%7Cnamespaces%7Cnamespacealiases%7Cspecialpagealiases%7Cmagicwords%7Cfunctionhooks%7Cvariables%7Cinterwikimap%7Clanguagevariants%7Crestrictions%7Cuploaddialog%7Cskins%7Crightsinfo%7Cextensiontags%7Cprotocols%7Cfileextensions&maxlag=5&format=json&utf8=1
get_namespace: Invalid namespace: [lingualibre] @ namespace list lingualibre
initialization_complete: lingualibrewiki: 初始化程序登錄完畢。添加之前登錄的 0 個程序
wiki_API.prototype.next: 剩餘 1 action(s)
wiki_API.prototype.next: 剩餘 1 action(s)
wikidata_entity: action: [ids=Q1841]
wiki_API_query: action: https://lingualibre.org/api.php,action=wbgetentities&ids=Q1841
[1/2] [action] = [wbgetentities]
[2/2] [ids] = [Q1841]
[1/3] [action] = [wbgetentities]
[2/3] [ids] = [Q1841]
[3/3] [maxlag] = [5]
[1/5] [action] = [wbgetentities]
[2/5] [ids] = [Q1841]
[3/5] [maxlag] = [5]
[4/5] [format] = [json]
[5/5] [utf8] = [1]
normalize_URL_to_fetch: Fetching URL: {object} [https://lingualibre.org/api.php?action=wbgetentities&ids=Q1841&maxlag=5&format=json&utf8=1] 
[1/5] [action] = [wbgetentities]
[2/5] [ids] = [Q1841]
[3/5] [maxlag] = [5]
[4/5] [format] = [json]
[5/5] [utf8] = [1]
[1/5] [action] = [wbgetentities]
[2/5] [ids] = [Q1841]
[3/5] [maxlag] = [5]
[4/5] [format] = [json]
[5/5] [utf8] = [1]
get_URL_node: Add timeout 1 min: [https://lingualibre.org/api.php?action=wbgetentities&ids=Q1841&maxlag=5&format=json&utf8=1] 
wiki_API.prototype.next: The queue is empty.
get_URL_node: HTTP status code: 200 https://lingualibre.org/api.php?action=wbgetentities&ids=Q1841&maxlag=5&format=json&utf8=1 
get_URL_node: end(): https://lingualibre.org/api.php?action=wbgetentities&ids=Q1841&maxlag=5&format=json&utf8=1
wiki_API.prototype.next: The queue is empty.
Entity title: audio record - zho - Wang Cheng (Yug)

[kanasimi]

Yes, this log seems to have the same results as mine. I still think this is due to the fact that we may be using a different version. However, it seems to be ok now.

[hugolpz]

I'm not sure what happened, I checked my wikiapi and cejs were the latest github versions early on here, and there. By:

• rm ./node_modules/ -rf
• npm install
• npm list
• opening my local files and carefully comparing them to your latest commits to github to confirm match

But code was still failing.

For the record, the last time and when it worked :

• you published on npm.org
• I ran npm install --save ; npm update --save 🤷🏼‍♂️

Anyway, thank you for publishing that new version 🌄 💛