https://community.qlik.com/t5/Connectivity-Data-Prep/Retrieving-api-web-siteusers-through-O365-SharePoint-Connector/m-p/1543702#M7484 <P>Hi</P><P>I've been looking at using the Web Connector for Office 365 SharePoint however when extracting data from a list rather than showing the users name it shows their code.</P><P>There is a<STRONG> _api/web/siteusers</STRONG> area which will, apparently, link those numbers to the corresponding person however there doesn't appear to be a way to pull this out or force the web connector to automatically use this lookup?</P><P>Does anyone have any ideas regarding this? Or whether there's an option I'm not seeing on the Web Connector for O365.</P><P>Thanks.</P> Wed, 15 Dec 2021 18:10:18 GMT Lora 2021-12-15T18:10:18Z https://community.qlik.com/t5/Connectivity-Data-Prep/Retrieving-api-web-siteusers-through-O365-SharePoint-Connector/m-p/1543702#M7484 <P>Hi</P><P>I've been looking at using the Web Connector for Office 365 SharePoint however when extracting data from a list rather than showing the users name it shows their code.</P><P>There is a<STRONG> _api/web/siteusers</STRONG> area which will, apparently, link those numbers to the corresponding person however there doesn't appear to be a way to pull this out or force the web connector to automatically use this lookup?</P><P>Does anyone have any ideas regarding this? Or whether there's an option I'm not seeing on the Web Connector for O365.</P><P>Thanks.</P> Wed, 15 Dec 2021 18:10:18 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Retrieving-api-web-siteusers-through-O365-SharePoint-Connector/m-p/1543702#M7484 Lora 2021-12-15T18:10:18Z