{"id":185355,"date":"2026-05-29T14:27:19","date_gmt":"2026-05-29T05:27:19","guid":{"rendered":"https:\/\/support.questetra.com\/?p=185355"},"modified":"2026-06-22T14:23:14","modified_gmt":"2026-06-22T05:23:14","slug":"microsoft365-list-get-paging-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/microsoft365-list-get-paging-2026\/","title":{"rendered":"Microsoft365 List Get (for paging)"},"content":{"rendered":"\n

Microsoft365 List Get (for paging)<\/strong><\/h4>\n\n\n\n

Microsoft365 \u30ea\u30b9\u30c8\u53d6\u5f97\uff08\u30da\u30fc\u30b8\u30f3\u30b0\u6642\uff09<\/a><\/p>\n\n\n\n

Get Microsoft365 list data if there is a next page. Acquired data is append to a string multi-line data item.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
conf_OAuth2<\/dt>
A: OAuth 2.0 Setting *<\/span><\/dd>\n
conf_nextLink<\/dt>
B: next link URL from before *<\/span><\/dd>\n
conf_list<\/dt>
C: Data List (update) *<\/span><\/dd>\n
conf_keyName<\/dt>
D: Data Key Name *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_nextLink2<\/dt>
E: next link URL for after (update)<\/dd>\n
conf_log<\/dt>
X: Access Log (update)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\n\/\/ Get Microsoft365 Group Member List via Microsoft Graph API v1.0 (ver. 202211)\n\/\/ (c) 2022, Questetra, Inc. (the MIT License)\n\/\/\/\/ == \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 \/ Config Retrieving ==\nconst oauth2  = configs.getObject( \"conf_OAuth2\" );\nconst nextLink = engine.findDataByNumber(configs.get( \"conf_nextLink\" )) + \"\";\nconst keyName = configs.get( \"conf_keyName\" ) + \"\";\nconst dataId_list     = configs.get( \"conf_list\" );\nconst dataId_nextLink2 = configs.get( \"conf_nextLink2\" );\nconst dataId_log      = configs.get( \"conf_log\" );\n\/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\nlet accessLog = \"\";\nlet uri = nextLink;\nlet response = httpClient.begin()\n  .authSetting( oauth2 )\n  .get( uri );\naccessLog += \"---GET request--- \" + response.getStatusCode() + \"\\n\";\naccessLog += response.getResponseAsString() + \"\\n\";\n\/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\nconst status = response.getStatusCode();\nif( status >= 300 ){\n  engine.log(accessLog);\n  throw `Failed in DELETE request. status: ${status}`;\n} else {\n  const jsonObj = JSON.parse( response.getResponseAsString() );\n  const values = jsonObj.value;\n  \/\/\u65e2\u5b58\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\u3057\u3066\u8ffd\u8a18\n  let list = engine.findDataByNumber( dataId_list) + \"\";\n  for (let i = 0; i < values.length; i++) {\n    let value = values[i];\n\/\/    list += value.mail + \"\\n\";\n    list += value[keyName] + \"\\n\";\n  }\n  engine.setDataByNumber( dataId_list, list );\n  if( dataId_nextLink2 !== \"\" ){\n    engine.setDataByNumber( dataId_nextLink2, jsonObj['@odata.nextLink'] );\n  }\n}\nif( dataId_log !== \"\" ){\n  engine.setDataByNumber( dataId_log, accessLog );\n}\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n