{"id":148335,"date":"2023-08-04T20:05:46","date_gmt":"2023-08-04T11:05:46","guid":{"rendered":"https:\/\/support.questetra.com\/?p=148335"},"modified":"2023-08-04T20:13:25","modified_gmt":"2023-08-04T11:13:25","slug":"microsoft365-user-id-get-by-email-202307","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/microsoft365-user-id-get-by-email-202307\/","title":{"rendered":"Microsoft365: \u30e6\u30fc\u30b6ID\u53d6\u5f97"},"content":{"rendered":"\n

Microsoft365 \u30e6\u30fc\u30b6ID \u53d6\u5f97<\/strong><\/h4>\n\n\n\n

Microsoft365 User ID Get<\/a><\/p>\n\n\n\n

\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u6307\u5b9a\u3057\u3066 Microsoft365 \u30e6\u30fc\u30b6\u306eID\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
conf_OAuth2<\/dt>
A: OAuth2 \u8a2d\u5b9a *<\/span><\/dd>\n
conf_email<\/dt>
B: \u30e6\u30fc\u30b6\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_userId<\/dt>
C: \u30e6\u30fc\u30b6ID(\u66f4\u65b0) *<\/span><\/dd>\n
conf_log<\/dt>
X: \u901a\u4fe1\u30ed\u30b0\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee (\u66f4\u65b0)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\n\n\/\/ Get Microsoft365 User ID via Microsoft Graph API v1.0 (ver. 202210)\n\/\/ (c) 2022, Questetra, Inc. (the MIT License)\n\n\/\/\/\/ == \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 \/ Config Retrieving ==\nconst oauth2  = configs.get( "conf_OAuth2" ) + "";\n\nconst email   = configs.get( "conf_email" ) + "";\n\nconst dataId_userId = configs.get( "conf_userId" );\nconst dataId_log    = configs.get( "conf_log" );\n\n\/\/engine.log("email:"+email);\n\n\/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\nlet accessLog = "";\nlet uri = "https:\/\/graph.microsoft.com\/v1.0\/users?$filter=startswith(mail,'" + email + "')";\nlet response = httpClient.begin()\n  .authSetting( oauth2 )\n  .get( uri );\naccessLog += "---GET request--- " + response.getStatusCode() + "\\n";\naccessLog += response.getResponseAsString() + "\\n";\n\n\n\/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\nconst status = response.getStatusCode();\n\nlet userId = "";\nif( status >= 300 ){\n  engine.log(accessLog);\n  throw `Failed in GET request. status: ${status}`;\n} else {\n  const jsonObj = JSON.parse( response.getResponseAsString() );\n  const values = jsonObj.value;\n  for (let i = 0; i < values.length; i++) {\n    let value = values[i];\n    if (value.mail == email) {\n      userId = value.id;\n      engine.setDataByNumber( dataId_userId, userId );\n    }\n  }\n}\nif (userId == "") {\n  throw `specified user None`;\n}\n\nif( dataId_log !== "" ){\n  engine.setDataByNumber( dataId_log, accessLog );\n}\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n