{"id":159649,"date":"2024-04-15T16:13:06","date_gmt":"2024-04-15T07:13:06","guid":{"rendered":"https:\/\/support.questetra.com\/?p=159649"},"modified":"2024-04-15T16:13:08","modified_gmt":"2024-04-15T07:13:08","slug":"service-task-microsoft-lists-listitem-get","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-microsoft-lists-listitem-get\/","title":{"rendered":"Microsoft Lists: Get List Item"},"content":{"rendered":"\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"58\" data-attachment-id=\"113160\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/how-to-use-timer-start-event\/attachment\/advanced-banner-new-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"advanced-banner-new-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en-1024x58.png?resize=1024%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-113160\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=768%2C44&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading has-background\" style=\"background-color:#ccffcc;margin-top:var(--wp--preset--spacing--30);margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><strong>Microsoft Lists: Get List Item<\/strong><\/h4>\n\n\n\n<p class=\"has-text-align-right has-background has-small-font-size mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#ccffcc;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--30);padding-bottom:0;padding-left:var(--wp--preset--spacing--30)\"><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-microsoft-lists-listitem-get\/\">Microsoft Lists: \u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0\u53d6\u5f97<\/a><\/p>\n\n\n\n<p class=\"has-background mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#f0fff0;margin-top:0;margin-right:0;margin-bottom:var(--wp--preset--spacing--60);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--40)\">This item gets values of a list item on Microsoft Lists.<\/p>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title\">Basic Configs<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\"><\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">Step Name<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\"><\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">Note<\/dd>\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<figure class=\"wp-block-image alignright has-custom-border is-style-default\"><img decoding=\"async\" src=\"data:image;base64,\n        iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAABFlJREFUWEfF\n        l3tsU3UUx7\/nrqVlbPiAZbjhhhLCdAYXxKBolKi49VZ0+KiKYbgIoa1mwbJuREKCJurWLghlrh1O\n        EFgwARPjY+0GkqB\/CD7+mDMb8lhSjchkKDKY69b1HtLbdbCtt\/dmML1\/3dyex+c8fud3SvifH9Lq\n        v6Fw881hXeRxgJcw406AbiHiDFmfcZaBLoDaCTigj6R8tarF8bcW26oAHz5Znd4fEd4C82tEpNNi\n        lJkHAfIMsuHNskBZTzIdRQAGk090rwShCqBMLY5HyzBzF0GosPrXNRKIE9lQBKgT3U4CqkFQzVJS\n        OAYzwWFvcm7RBLDvuX0p53qDO4ioZDxRK+kwsGV6am65Zb8lcrXMmOjqzO61BLx3PZ3HbTHw+uhM\n        jADwiTVLJJKaCSRMDABLBEG0NZW3xO0PA+xcvMkYmpIaTNZwt86fhQfXPAqQelv8e74Xn1V+PDYO\n        xpm+8ymzHUccfdEfhy15Rdd6EL2rFHnOgttQuKEY39QewO+tv8piUkQCS1eam4SYOSLC895S7Hyh\n        NqG5q0sha0SPnFd0\/0FEMxJpxJ0frPoCwe9OaapOyW4bdpd4E8syzlj95dnRoykD1Jmq7yNBOJJI\n        OnteDpa+bcHJwx043fabJudRoUWrH8EOi0dRniXpfnug8mgMwOyuIqAykXTRxmLcNHMaLp7tgaAT\n        kJmXhdM\/jQRhSQIJI\/t2ZkEuthdvVgYAqu1NzvUxANF1mIgeTiRt2rgMnd+ewIlD7TBOnYxnt65A\n        Y+l21Uy8vPdVfLT8fWUA5q\/t\/orFcYBfiGjufwxw3O6vyJMBvKLrHxDdoASQNS8H4dAAhBQBxvTJ\n        6L8UUs2AIc0I39IaZTnmCzZ\/xY1DGXCHiGBQAgj+0IljzW1Iy0hHsetFTSVYscuKPSt9mgGCRMjV\n        BrAcjaX1qhlQA2DmKyWoE91HibBQCUCfOgndJ7swKc2IOQ\/lod3fqgqQby5AwzNbtTWhV3T7QFij\n        BGBIN+Kv4DnojXrc\/sAcHD\/UkRQg77F89F\/qVx5EselXb\/M7rXIP+ERXERMFtJ2CkqQlKNzwFGbc\n        kY29qxsQ7htQBCVmk9Vf0SwDeEweg55CfyY6CdE5EPy+E8da2lTnQHRoZc7NUnXOjJ7pU3ozLPs3\n        DQxfRkrT8O6n78V8y0JEwhH5ktEZdAiHwrHIovdQ1AID0YtooLcfn6zdkzTyITV5CkbfhwE8Js9U\n        HYVOEVFs052gh5m7DTqe\/crnlRdHAMgDyVxTyJD8E7mQCCwUWf3lB+Pxjdks1PaCa0mM6koWN+4V\n        XR+AaNW1OBujO3TsRn9X3K28pup1IMF9PdZyMMpsAWfC9Sjpcud9wr0MjG0AsseVDeYgBHLYvnR+\n        qqSvul3W31OvlzIvvARQGYAC1YywfDhbQVw7LXXWrtH\/AzSXIBGxx\/ROhp50ZgYWALiLiPKH5kEH\n        g38m4McwDzaVBd7o1pox1QxoNTReucsdycEwUqG3yAAAAABJRU5ErkJggg==\n    \" alt=\"Auto Step icon\" class=\"has-border-color has-ast-global-color-4-border-color\" style=\"border-width:0.5em\"\/><\/figure>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title\">Configs for this Auto Step<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_OAuth2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C1: OAuth2 Setting<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_SiteUrl<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C2: SharePoint Site URL<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ListTitle<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C3: List Title<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ListItemId<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C4: List Item ID<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnName1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-K1: Lists Field Name of Column 1<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnValue1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-V1: Data item to save value of Column 1<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnName2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-K2: Lists Field Name of Column 2<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnValue2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-V2: Data item to save value of Column 2<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnName3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-K3: Lists Field Name of Column 3<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnValue3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-V3: Data item to save value of Column 3<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnName4<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-K4: Lists Field Name of Column 4<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnValue4<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-V4: Data item to save value of Column 4<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnName5<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-K5: Lists Field Name of Column 5<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnValue5<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-V5: Data item to save value of Column 5<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnName6<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-K6: Lists Field Name of Column 6<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnValue6<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-V6: Data item to save value of Column 6<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnName7<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-K7: Lists Field Name of Column 7<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_ColumnValue7<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-V7: Data item to save value of Column 7<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Notes<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The SharePoint Site URL is the part before&nbsp;<code>\/Lists<\/code>&nbsp;of the List URL\n<ul class=\"wp-block-list\">\n<li>When the List is in My lists, it looks like&nbsp;<code>https:\/\/{sub-domain}-my.sharepoint.com\/personal\/{user-identifier}_{domain}_onmicrosoft_com<\/code><\/li>\n\n\n\n<li>When the List is in a SharePoint site, it looks like&nbsp;<code>https:\/\/{sub-domain}.sharepoint.com\/sites\/{site-identifier}<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>There are some ways to get field names of the columns :\n<ul class=\"wp-block-list\">\n<li>When you export CSV with schema of the List, the field names are shown in&nbsp;<code>Name<\/code>&nbsp;property of each column\u2019s schema<\/li>\n\n\n\n<li>When you sort the the List by a column on WebUI, the field name of the column is included in the URL in the form of&nbsp;<code>sortField={fieldName}<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>As to each data type on Questetra BPM Suite, the supported <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/list-and-library-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Lists column types<\/a> which can be saved are shown in the following table:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Data type on Questetra BPM Suite<\/th><th>Supported column types on Microsoft Lists<\/th><\/tr><\/thead><tbody><tr><td>String (multiple lines)<\/td><td>Single line of text, Multiple lines of text, Number, Yes\/No, Date and time, Choice, Currency<\/td><\/tr><tr><td>String (single line)<\/td><td>Single line of text, Number, Yes\/No, Date and time, Choice (when multiple selections are disabled), Currency<\/td><\/tr><tr><td>Numeric<\/td><td>Number, Currency<\/td><\/tr><tr><td>Select (Radio Button, Select Box, Search Select Box)<\/td><td>Yes\/No, Choice (when multiple selections are disabled)<br>* The value of the column will be saved as a choice whose choice ID is identical with it<\/td><\/tr><tr><td>Select (Check Box)<\/td><td>Choice (when multiple selections are enabled)<br>* The values of the column will be saved as choices whose choice IDs are identical with them<\/td><\/tr><tr><td>Date, Datetime<\/td><td>Date and time<br>* The date and time displayed on Microsoft Lists is based on the timezone setting of the SharePoint Site (which is different from the timezone setting of your Microsoft 365 account)<br>* If the timezone setting of the SharePoint Site is different from that of Questetra BPM Suite, there will be a difference in the displayed date and time<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Capture<\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full has-custom-border is-style-rounded is-style-rounded--1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1340\" height=\"1452\" data-attachment-id=\"159650\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/markdown-basic\/attachment\/microsoft-lists-listitem-get_capture_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/microsoft-lists-listitem-get_capture_en.png?fit=1340%2C1452&amp;ssl=1\" data-orig-size=\"1340,1452\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"microsoft-lists-listitem-get_capture_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/microsoft-lists-listitem-get_capture_en.png?fit=581%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/microsoft-lists-listitem-get_capture_en.png?resize=1340%2C1452&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-159650\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/microsoft-lists-listitem-get_capture_en.png?w=1340&amp;ssl=1 1340w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/microsoft-lists-listitem-get_capture_en.png?resize=291%2C315&amp;ssl=1 291w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/microsoft-lists-listitem-get_capture_en.png?resize=581%2C630&amp;ssl=1 581w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/microsoft-lists-listitem-get_capture_en.png?resize=768%2C832&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">See Also<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/intermediate-error-catch-event-boundary-type\/\" target=\"_blank\" rel=\"noreferrer noopener\">Intermediate Error Catch Event (Boundary Type)<\/a><\/li>\n<\/ul>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details><summary class=\"wp-block-coblocks-accordion-item__title\">Script (click to open)<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<ul class=\"wp-block-list\">\n<li>An XML file that contains the code below is available to download\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/raw.githubusercontent.com\/Questetra\/Addon-XML\/release-2024-02-08\/microsoft-lists-listitem-get.xml\" target=\"_blank\" rel=\"noreferrer noopener\">microsoft-lists-listitem-get.xml<\/a> (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>If you are using Professional, you can modify the contents of this file and use it as your own add-on auto step<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\/\/ OAuth2 config sample at [OAuth 2.0 Setting]\n\/\/ - Authorization Endpoint URL: https:\/\/login.microsoftonline.com\/{your-tenant-id}\/oauth2\/v2.0\/authorize\n\/\/ - Token Endpoint URL: https:\/\/login.microsoftonline.com\/{your-tenant-id}\/oauth2\/v2.0\/token\n\/\/ - Scope: https:\/\/graph.microsoft.com\/Sites.ReadWrite.All offline_access\n\/\/ - Consumer Key: (Get by Microsoft Azure Active Directory)\n\/\/ - Consumer Secret: (Get by Microsoft Azure Active Directory)\n\nconst GRAPH_URI = &#39;https:\/\/graph.microsoft.com\/v1.0\/&#39;;\n\nconst COLUMN_NUM = 7; \/\/ \u6271\u3048\u308b\u5217\u306e\u6570\n\nconst main = () =&gt; {\n    \/\/\/\/ == \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 \/ Config Retrieving ==\n    const oauth2 = configs.getObject(&#39;conf_OAuth2&#39;);\n    const siteUrl = retrieveSiteUrl();\n    const listTitle = configs.get(&#39;conf_ListTitle&#39;);\n    const listItemId = retrieveListItemId();\n    const {columnNames, columnDefs} = retrieveColumnNamesAndDataDefs();\n\n    \/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\n    const siteId = getSiteIdByUrl(oauth2, siteUrl);\n    checkColumns(oauth2, siteId, listTitle, columnNames, columnDefs);\n    const listItem = getListItem(oauth2, siteId, listTitle, listItemId, columnNames);\n\n    \/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\n    saveData(listItem, columnNames, columnDefs);\n};\n\n\/**\n * \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u304b\u3089\u30b5\u30a4\u30c8\u306e URL \u3092\u53d6\u5f97\u3059\u308b\n * @returns {String} \u30b5\u30a4\u30c8\u306e URL\n *\/\nconst retrieveSiteUrl = () =&gt; {\n    let siteUrl = configs.get(&#39;conf_SiteUrl&#39;);\n    \/\/ \u672b\u5c3e\u306b\u30b9\u30e9\u30c3\u30b7\u30e5\u304c\u3042\u308b\u5834\u5408\u3001\u524a\u9664\n    if (siteUrl.endsWith(&#39;\/&#39;)) {\n        siteUrl = siteUrl.slice(0, -1);\n    }\n    return siteUrl;\n};\n\n\/**\n * \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u304b\u3089\u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0 ID \u3092\u53d6\u5f97\u3059\u308b\n * @returns {String} \u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0 ID\n *\/\nconst retrieveListItemId = () =&gt; {\n    const dataDef = configs.getObject(&#39;conf_ListItemId&#39;);\n    if (dataDef.matchDataType(&#39;SELECT_SINGLE&#39;)) { \/\/ \u9078\u629e\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u5834\u5408\n        const select = engine.findData(dataDef);\n        if (select === null || select.size() === 0) { \/\/ \u672a\u9078\u629e\n            throw new Error(&#39;List Item ID is not selected.&#39;);\n        }\n        return select.get(0).getValue();\n    }\n    \/\/ \u6587\u5b57\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u5834\u5408\n    const value = engine.findData(dataDef);\n    if (value === null) {\n        throw new Error(&#39;List Item ID is blank.&#39;);\n    }\n    return value;\n};\n\n\/**\n * \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u304b\u3089\u5217\u306e\u540d\u524d\u3001\u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u53d6\u5f97\u3059\u308b\n * \u4ee5\u4e0b\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\n * - \u540d\u524d\u3001\u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u7247\u65b9\u3060\u3051\u304c\u6307\u5b9a\u3055\u308c\u3066\u3044\u308b\u5217\u304c\u3042\u308b\n * - \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u3072\u3068\u3064\u3082\u6307\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\n * - \u5024\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u91cd\u8907\u3057\u3066\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\n * @returns {Object} result\n * @returns {Array&lt;String&gt;} result.columnNames  \u5217\u306e\u540d\u524d\n * @returns {Array&lt;ProcessDataDefinitionView&gt;} result.columnDefs  \u5217\u306e\u5024\u306e\u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\n *\/\nconst retrieveColumnNamesAndDataDefs = () =&gt; {\n    const columnNames = [];\n    const columnDefs = [];\n    const dataItemNumSet = new Set(); \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u91cd\u8907\u78ba\u8a8d\u7528\n    for (let i = 0; i &lt; COLUMN_NUM; i++) {\n        const columnName = configs.get(`conf_ColumnName${i + 1}`);\n        const columnDef = configs.getObject(`conf_ColumnValue${i + 1}`);\n        if (columnName === &#39;&#39; && columnDef === null) {\n            continue;\n        } else if (columnName !== &#39;&#39; && columnDef !== null) {\n            const dataItemNum = columnDef.getNumber();\n            if (dataItemNumSet.has(dataItemNum)) { \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u756a\u53f7\u304c\u91cd\u8907\u3057\u3066\u3044\u308c\u3070\u30a8\u30e9\u30fc\n                throw new Error(&#39;The same data item is set multiple times.&#39;);\n            }\n            dataItemNumSet.add(dataItemNum); \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u91cd\u8907\u78ba\u8a8d\u7528\n            columnNames.push(columnName);\n            columnDefs.push(columnDef);\n        } else {\n            throw new Error(`Field name and data item for Column ${i + 1} must be specified at the same time.`);\n        }\n    }\n    if (columnDefs.length === 0) {\n        throw new Error(&#39;No data item to save the result.&#39;);\n    }\n    return {columnNames, columnDefs};\n};\n\n\/**\n * \u30b5\u30a4\u30c8\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3001siteId \u3092\u8fd4\u3059\n * API\u306e\u4ed5\u69d8: https:\/\/docs.microsoft.com\/ja-jp\/onedrive\/developer\/rest-api\/api\/shares_get?view=odsp-graph-online\n * @param {AuthSettingWrapper} oauth2  OAuth2 \u8a2d\u5b9a\u60c5\u5831\n * @param {String} siteUrl  SharePoint \u30b5\u30a4\u30c8\u306e URL\n * @returns {String} siteId\n *\/\nconst getSiteIdByUrl = (oauth2, siteUrl) =&gt; {\n    \/\/ encoding sharing URL\n    const encodedSharingUrl = encodeSharingUrl(siteUrl);\n\n    \/\/ preparing for API Request\n    const response = httpClient.begin()\n        .authSetting(oauth2)\n        .queryParam(&#39;select&#39;, &#39;id&#39;)\n        .get(`${GRAPH_URI}shares\/${encodedSharingUrl}\/site`);\n    const status = response.getStatusCode();\n    const responseStr = response.getResponseAsString();\n    if (status !== 200) {\n        engine.log(responseStr);\n        throw new Error(`Failed to get site info. status: ${status}`);\n    }\n    return JSON.parse(responseStr).id;\n};\n\n\/**\n * \u5171\u6709URL\u3092 unpadded base64url \u5f62\u5f0f\u306b\u30a8\u30f3\u30b3\u30fc\u30c9\u3059\u308b\n * @param {String} sharingUrl  \u5171\u6709URL\n * @returns {String} encodedSharingUrl  \u30a8\u30f3\u30b3\u30fc\u30c9\u3055\u308c\u305f\u5171\u6709URL\n *\/\nconst encodeSharingUrl = (sharingUrl) =&gt; {\n    let encodedSharingUrl = base64.encodeToUrlSafeString(sharingUrl);\n    while (encodedSharingUrl.slice(-1) === &#39;=&#39;) {\n        encodedSharingUrl = encodedSharingUrl.slice(0, -1);\n    }\n    return `u!${encodedSharingUrl}`;\n};\n\n\/**\n * \u30ea\u30b9\u30c8\u306e\u5217\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3001\u6307\u5b9a\u3057\u305f\u540d\u524d\u306e\u5217\u306e\u5b58\u5728\u3092\u78ba\u8a8d\u3059\u308b\n * \u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0\u53d6\u5f97\u306e API \u3067\u306f\u5024\u304c\u7a7a\u306e\u5217\u306f\u30d7\u30ed\u30d1\u30c6\u30a3\u81ea\u4f53\u304c\u8fd4\u3089\u306a\u3044\u305f\u3081\u3001\u4e8b\u524d\u306b\u5217\u306e\u5b58\u5728\u3092\u78ba\u8a8d\u3057\u3066\u304a\u304f\n * @param {AuthSettingWrapper} oauth2  OAuth2 \u8a2d\u5b9a\u60c5\u5831\n * @param {String} siteId  SharePoint \u30b5\u30a4\u30c8\u306e ID\n * @param {String} listTitle  \u30ea\u30b9\u30c8\u306e\u540d\u524d\n * @param {Array&lt;String&gt;} columnNames  \u5217\u306e\u540d\u524d\n * @param {Array&lt;ProcessDataDefinitionView&gt;} columnDefs  \u5217\u306e\u5024\u306e\u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\n *\/\nconst checkColumns = (oauth2, siteId, listTitle, columnNames, columnDefs) =&gt; {\n    const url = `${GRAPH_URI}sites\/${encodeURIComponent(siteId)}\/lists\/${encodeURIComponent(listTitle)}\/columns`;\n    const response = httpClient.begin()\n        .authSetting(oauth2)\n        .queryParam(&#39;$select&#39;, &#39;name&#39;)\n        \/\/ $filter, $search, $top \u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u52b9\u304b\u306a\u3044\n        .get(url);\n    const status = response.getStatusCode();\n    const responseStr = response.getResponseAsString();\n    if (status !== 200) {\n        engine.log(responseStr);\n        throw new Error(`Failed to get columns. status: ${status}`);\n    }\n    const columns = JSON.parse(responseStr).value;\n    columnNames.forEach(columnName =&gt; {\n        const column = columns.find((column) =&gt; column.name === columnName);\n        if (column === undefined) {\n            throw new Error(`Column &#39;${columnName}&#39; not found.`);\n        }\n    });\n};\n\n\/**\n * \u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0\u3092\u53d6\u5f97\u3057\u3001JSON\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8fd4\u3059\n * @param {AuthSettingWrapper} oauth2  OAuth2 \u8a2d\u5b9a\u60c5\u5831\n * @param {String} siteId  SharePoint \u30b5\u30a4\u30c8\u306e ID\n * @param {String} listTitle  \u30ea\u30b9\u30c8\u306e\u540d\u524d\n * @param {String} listItemId  \u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0 ID\n * @param {Array&lt;String&gt;} columnNames  \u5217\u306e\u540d\u524d\n * @returns {Object} \u53d6\u5f97\u3057\u305f\u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0\n *\/\nconst getListItem = (oauth2, siteId, listTitle, listItemId, columnNames) =&gt; {\n    const url = `${GRAPH_URI}sites\/${encodeURIComponent(siteId)}\/lists\/${encodeURIComponent(listTitle)}\/items\/${encodeURIComponent(listItemId)}`;\n    const response = httpClient.begin()\n        .authSetting(oauth2)\n        .queryParam(&#39;$select&#39;, &#39;id&#39;) \/\/ \u4e0d\u8981\u306a\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u9664\u5916\u3059\u308b\u305f\u3081\u306b\u6307\u5b9a\n        .queryParam(&#39;$expand&#39;, `fields($select=${columnNames.join(&#39;,&#39;)})`)\n        .get(url);\n    const status = response.getStatusCode();\n    const responseStr = response.getResponseAsString();\n    if (status !== 200) {\n        engine.log(responseStr);\n        throw new Error(`Failed to get list item. status: ${status}`);\n    }\n    const listItem = JSON.parse(responseStr);\n    return listItem;\n};\n\n\/**\n * \u30c7\u30fc\u30bf\u9805\u76ee\u3078\u306e\u4fdd\u5b58\n * @param {Object} listItem \u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0\n * @param {Array&lt;String&gt;} columnNames \u5217\u306e\u540d\u524d\n * @param {Array&lt;ProcessDataDefinitionView&gt;} columnDefs \u5217\u306e\u5024\u306e\u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\n *\/\nconst saveData = (listItem, columnNames, columnDefs) =&gt; {\n    columnNames.forEach((columnName, i) =&gt; {\n        convertAndSetData(columnDefs[i], listItem.fields[columnName], columnName);\n    });\n};\n\n\/**\n  * \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u578b\u306b\u3057\u305f\u304c\u3063\u3066\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3057\u3001\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3059\u308b\n  * \u5909\u63db\u3067\u304d\u306a\u3044\u5024\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u306b\u3059\u308b\n  * @param {ProcessDataDefinitionView} dataDef \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\n  * @param {Object} columnValue \u5217\u306e\u5024\n  * @param {String} columnName \u5217\u306e\u540d\u524d\uff08\u30a8\u30e9\u30fc\u51fa\u529b\u7528\uff09\n  *\/\nfunction convertAndSetData(dataDef, columnValue, columnName) {\n    if (columnValue === undefined || columnValue === null) {\n        engine.setData(dataDef, null);\n        return;\n    }\n    \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u578b\u3054\u3068\u306b\u3001\u5217\u306e\u5024\u3092\u5909\u63db\u3057\u3066\u4fdd\u5b58\u3059\u308b\n    if (dataDef.matchDataType(&#39;STRING&#39;)) {\n        try {\n            \/\/ TEXTFIELD \u306b\u6539\u884c\u3092\u542b\u3080\u6587\u5b57\u5217\u3092\u4fdd\u5b58\u3057\u3088\u3046\u3068\u3057\u305f\u5834\u5408\u306e\u30a8\u30e9\u30fc\u306f\u3001QBPMS \u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u306b\u4efb\u305b\u308b\n            engine.setData(dataDef, stringifyColumnValue(columnValue));\n        } catch (e) { \/\/ \u5217\u306e\u5024\u304c\u89e3\u91c8\u3067\u304d\u306a\u3044\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u5834\u5408\u306a\u3069\n            throw new Error(`Column &#39;${columnName}&#39; cannot be saved to Text type data item. ${e.message}`);\n        }\n    } else if (dataDef.matchDataType(&#39;DECIMAL&#39;)) {\n        const supportedValueTypes = [&#39;string&#39;, &#39;number&#39;];\n        if (!supportedValueTypes.includes(typeof columnValue)) {\n            throw new Error(`Column &#39;${columnName}&#39; cannot be saved to Numeric type data item. The returned value is neither a string nor a number.`);\n        }\n        try {\n            engine.setData(dataDef, new java.math.BigDecimal(columnValue));\n        } catch (e) {\n            throw new Error(`Column &#39;${columnName}&#39; cannot be saved to Numeric type data item. Failed to convert to BigDecimal.`);\n        }\n    } else if (dataDef.matchDataType(&#39;SELECT&#39;)) {\n        const items = new java.util.ArrayList();\n        try {\n            if (Array.isArray(columnValue)) { \/\/ \u8907\u6570\u9078\u629e\u306e\u5834\u5408\n                convertMultipleValuesToStringArray(columnValue).forEach((value) =&gt; {\n                    items.add(value);\n                });\n            } else { \/\/ \u5358\u4e00\u9078\u629e\u306e\u5834\u5408\n                items.add(convertSingleValueToString(columnValue));\n            }\n            \/\/ \u4e00\u81f4\u3059\u308b\u9078\u629e\u80a2 ID \u304c\u306a\u3044\u5834\u5408\u3001SELECT_SINGLE \u306b\u8907\u6570\u9078\u629e\u3092\u4fdd\u5b58\u3057\u3088\u3046\u3068\u3057\u305f\u5834\u5408\u306e\u30a8\u30e9\u30fc\u306f\u3001QBPMS \u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u306b\u4efb\u305b\u308b\n            engine.setData(dataDef, items);\n        } catch (e) {\n            throw new Error(`Column &#39;${columnName}&#39; cannot be saved to Select type data item. ${e.message}`);\n        }\n    } else if (dataDef.matchDataType(&#39;DATETIME&#39;)) {\n        if (typeof columnValue !== &#39;string&#39;) {\n            throw new Error(`Column &#39;${columnName}&#39; cannot be saved to Datetime type data item. The returned value is not a string.`);\n        }\n        try {\n            engine.setData(dataDef, dateFormatter.parse(&quot;yyyy-MM-dd&#39;T&#39;HH:mm:ssX&quot;, columnValue));\n        } catch (e) {\n            throw new Error(`Column &#39;${columnName}&#39; cannot be saved to Datetime type data item. The returned value is not a datetime-format string.`);\n        }\n    } else if (dataDef.matchDataType(&#39;DATE&#39;)) {\n        if (typeof columnValue !== &#39;string&#39;) {\n            throw new Error(`Column &#39;${columnName}&#39; cannot be saved to Date type data item. The returned value is not a string.`);\n        }\n        try {\n            const millisec = dateFormatter.parse(&quot;yyyy-MM-dd&#39;T&#39;HH:mm:ssX&quot;, columnValue).getFirstTimeInDate().getTime();\n            engine.setData(dataDef, new com.questetra.bpms.util.AddableDate(millisec));\n        } catch (e) {\n            throw new Error(`Column &#39;${columnName}&#39; cannot be saved to Date type data item. The returned value is not a datetime-format string.`);\n        }\n    }\n}\n\n\/**\n * \u5217\u306e\u5024\u3092\u6587\u5b57\u5217\u306b\u5909\u63db\u3059\u308b\n * \u5217\u306e\u5024\u304c\u914d\u5217\u306e\u5834\u5408\u3001\u6539\u884c\u533a\u5207\u308a\u306e\u6587\u5b57\u5217\u306b\u5909\u63db\u3059\u308b\n * \u6587\u5b57\u5217\u5316\u306b\u5931\u6557\u3057\u305f\u5834\u5408\u306f\u30a8\u30e9\u30fc\n * @param {Object} columnValue \u5217\u306e\u5024\n * @returns {String} \u6587\u5b57\u5217\u5316\u3057\u305f\u5217\u306e\u5024\n *\/\nconst stringifyColumnValue = (columnValue) =&gt; {\n    if (Array.isArray(columnValue)) {\n        return convertMultipleValuesToStringArray(columnValue).join(&#39;\\n&#39;);\n    }\n    return convertSingleValueToString(columnValue);\n};\n\n\/**\n * \u5217\u306e\u5024\u3092\u3001\u6587\u5b57\u5217\u306e\u914d\u5217\u306b\u5909\u63db\u3059\u308b\uff08\u5024\u304c\u914d\u5217\u306e\u5834\u5408\uff09\n * \u6587\u5b57\u5217\u5316\u306b\u5931\u6557\u3057\u305f\u5834\u5408\u306f\u30a8\u30e9\u30fc\n * @param {Array} array \u5217\u306e\u5024\n * @returns {Array&lt;String&gt;} \u6587\u5b57\u5217\u5316\u3057\u305f\u5217\u306e\u5024\n *\/\nconst convertMultipleValuesToStringArray = (array) =&gt; {\n    return array.map(value =&gt; {\n        return convertSingleValueToString(value);\n    });\n};\n\n\/**\n * \u5217\u306e\u5024\u3092\u3001\u6587\u5b57\u5217\u306b\u5909\u63db\u3059\u308b\uff08\u5024\u304c\u914d\u5217\u3067\u306a\u3044\u5834\u5408\uff09\n * \u6587\u5b57\u5217\u5316\u306b\u5931\u6557\u3057\u305f\u5834\u5408\u306f\u30a8\u30e9\u30fc\n * @param {Object} value \u5217\u306e\u5024\n * @returns {String} \u6587\u5b57\u5217\u5316\u3057\u305f\u5217\u306e\u5024\n *\/\nconst convertSingleValueToString = (value) =&gt; {\n    const supportedPrimitiveTypes = [&#39;string&#39;, &#39;number&#39;, &#39;boolean&#39;];\n    if (supportedPrimitiveTypes.includes(typeof value)) {\n        return value.toString();\n    }\n    \/\/ \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u5834\u5408\u306a\u3069\u3001\u89e3\u91c8\u3067\u304d\u306a\u3044\u5834\u5408\u306f\u30a8\u30e9\u30fc\n    throw new Error(&#39;Failed to convert an object to a string.&#39;);\n};\n\n    <\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This item gets values of a list item on Microsoft Lists.<\/p>\n","protected":false},"author":17,"featured_media":159808,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[551],"tags":[3160],"class_list":["post-159649","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bpmn-icons","tag-microsoft-365"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Shiho Tatsumi","author_link":"https:\/\/support.questetra.com\/en\/author\/tatsumi48c607ec82\/"},"uagb_comment_info":0,"uagb_excerpt":"This item gets values of a list item on Microsoft Lists.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-FwZ","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":161424,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-microsoft-lists-listitem-delete\/","url_meta":{"origin":159649,"position":0},"title":"Microsoft Lists: Delete List Item","author":"Shiho Tatsumi","date":"2024-08-20","format":false,"excerpt":"This item deletes list items on Microsoft Lists. You can delete multiple list items at once. When you delete multiple ones, you should write one list item ID on each line.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":161392,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-microsoft-lists-listitem-add\/","url_meta":{"origin":159649,"position":1},"title":"Microsoft Lists: Add List Item","author":"Shiho Tatsumi","date":"2024-08-20","format":false,"excerpt":"This item adds a new list item to the specified list on Microsoft Lists.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":161411,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-microsoft-lists-listitem-update\/","url_meta":{"origin":159649,"position":2},"title":"Microsoft Lists: Update List Item","author":"Shiho Tatsumi","date":"2024-08-20","format":false,"excerpt":"This item updates values of a list item on Microsoft Lists.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":161432,"url":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-microsoft-lists-listitem-delete\/","url_meta":{"origin":159649,"position":3},"title":"Microsoft Lists: \u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0\u524a\u9664","author":"Shiho Tatsumi","date":"2024-08-20","format":false,"excerpt":"\u3053\u306e\u5de5\u7a0b\u306f\u3001Microsoft Lists \u306e\u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0\u3092\u524a\u9664\u3057\u307e\u3059\u3002\u4e00\u5ea6\u306b\u8907\u6570\u306e\u524a\u9664\u304c\u53ef\u80fd\u3067\u3059\u3002\u8907\u6570\u524a\u9664\u3059\u308b\u5834\u5408\u3001\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u3067\u306f 1 \u884c\u306b\u3064\u304d 1 \u3064\u305a\u3064\u30ea\u30b9\u30c8\u30a2\u30a4\u30c6\u30e0 ID \u3092\u66f8\u304f\u3088\u3046\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","rel":"","context":"In &quot;BPMN\u30a2\u30a4\u30b3\u30f3&quot;","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76145,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/message-start-event-email\/","url_meta":{"origin":159649,"position":4},"title":"Message Start Event (email)","author":"Hirotaka NISHI","date":"2019-04-05","format":false,"excerpt":"Starts a new process automatically by receiving an email. Capable of storing the address of the received email, subject, text body, and file attachment as Data Items.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-message-start-event-email-1200x675.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-message-start-event-email-1200x675.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-message-start-event-email-1200x675.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-message-start-event-email-1200x675.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-message-start-event-email-1200x675.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":159489,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-microsoft-lists-listitem-search\/","url_meta":{"origin":159649,"position":5},"title":"Microsoft Lists: Search List Items","author":"Shiho Tatsumi","date":"2024-04-15","format":false,"excerpt":"This item searches list items in the specified list on Microsoft Lists.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/bpmn-icon-service-task-ms-lists-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/159649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=159649"}],"version-history":[{"count":7,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/159649\/revisions"}],"predecessor-version":[{"id":159910,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/159649\/revisions\/159910"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/159808"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=159649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=159649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=159649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}