topic Missing Text files from SharePoint List in QlikView https://community.qlik.com/t5/QlikView/Missing-Text-files-from-SharePoint-List/m-p/1324297#M841623 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial,helvetica,sans-serif;">Does anyone have any idea why I am not getting some free text fields from a SharePoint list?&nbsp; I used to get them, but they had a lot of extra characters in the data (Formatting code I'm sure).&nbsp; I think the List owner changed them from Rich Text to Plain text and now my load pulls back nothing.&nbsp; It doesn't error out and say it could find the column.&nbsp; </SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">What is interesting is that when I rebuild the connection using </SPAN></P><P><SPAN style="font-family: arial,helvetica,sans-serif;"><SPAN style="color: #000000;">&nbsp; "</SPAN><SPAN style="color: #000000; font-size: 10pt;"><A class="jive-link-external-small" href="https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=" rel="nofollow" target="_blank">https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=</A><SPAN>{40b2b116-3ae8-442b-8dec-ce68696f3268"&nbsp; I get every column except the ones in question.&nbsp; It's almost as if they have become invisible in the list.</SPAN></SPAN></SPAN></P><P><SPAN style="color: #000000; font-family: arial,helvetica,sans-serif; font-size: 10pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">Here's my from statement</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><SPAN style="color: #0000ff;">FROM</SPAN><SPAN> [</SPAN><A class="jive-link-external-small" href="https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=" rel="nofollow" target="_blank">https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=</A><SPAN>{40b2b116-3ae8-442b-8dec-ce68696f3268}] (</SPAN><SPAN style="color: #0000ff;">XmlSimple</SPAN>, <SPAN style="color: #0000ff;">Table</SPAN> <SPAN style="color: #0000ff;">is</SPAN> [xml/data/row]); </SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">Ideas?</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT brf10043 2020-11-25T16:16:04Z Missing Text files from SharePoint List https://community.qlik.com/t5/QlikView/Missing-Text-files-from-SharePoint-List/m-p/1324297#M841623 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial,helvetica,sans-serif;">Does anyone have any idea why I am not getting some free text fields from a SharePoint list?&nbsp; I used to get them, but they had a lot of extra characters in the data (Formatting code I'm sure).&nbsp; I think the List owner changed them from Rich Text to Plain text and now my load pulls back nothing.&nbsp; It doesn't error out and say it could find the column.&nbsp; </SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">What is interesting is that when I rebuild the connection using </SPAN></P><P><SPAN style="font-family: arial,helvetica,sans-serif;"><SPAN style="color: #000000;">&nbsp; "</SPAN><SPAN style="color: #000000; font-size: 10pt;"><A class="jive-link-external-small" href="https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=" rel="nofollow" target="_blank">https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=</A><SPAN>{40b2b116-3ae8-442b-8dec-ce68696f3268"&nbsp; I get every column except the ones in question.&nbsp; It's almost as if they have become invisible in the list.</SPAN></SPAN></SPAN></P><P><SPAN style="color: #000000; font-family: arial,helvetica,sans-serif; font-size: 10pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif;">Here's my from statement</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><SPAN style="color: #0000ff;">FROM</SPAN><SPAN> [</SPAN><A class="jive-link-external-small" href="https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=" rel="nofollow" target="_blank">https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=</A><SPAN>{40b2b116-3ae8-442b-8dec-ce68696f3268}] (</SPAN><SPAN style="color: #0000ff;">XmlSimple</SPAN>, <SPAN style="color: #0000ff;">Table</SPAN> <SPAN style="color: #0000ff;">is</SPAN> [xml/data/row]); </SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">Ideas?</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Missing-Text-files-from-SharePoint-List/m-p/1324297#M841623 brf10043 2020-11-25T16:16:04Z