topic Limit to Data with GetFileTablePreview? in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Limit-to-Data-with-GetFileTablePreview/m-p/42276#M645 <HTML><HEAD></HEAD><BODY><P>Is anyone familiar with the App Engine API function GetFileTablePreview?</P><P></P><P>I am using it to load the data from an external file. This works for the most part, but I noticed that for any given field with a long string it will only load 500 characters.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/198189_Capture.PNG" style="height: 277px; width: 620px;" /></P><P>Here is the result of a load with an "Lorem ipsum..." value, 1000 words long. In the array I only see 500 characters of the text (the screenshot doesn't show it all).</P><P></P><P>Is there any way to override this limitation? The function is called a "preview", so perhaps it isn't designed for full data loads. Is there a better way to get an external file with the App Engine API?</P><P></P><P>Jonathan</P></BODY></HTML> Mon, 02 Apr 2018 21:34:00 GMT jonvitale 2018-04-02T21:34:00Z Limit to Data with GetFileTablePreview? https://community.qlik.com/t5/Integration-Extension-APIs/Limit-to-Data-with-GetFileTablePreview/m-p/42276#M645 <HTML><HEAD></HEAD><BODY><P>Is anyone familiar with the App Engine API function GetFileTablePreview?</P><P></P><P>I am using it to load the data from an external file. This works for the most part, but I noticed that for any given field with a long string it will only load 500 characters.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/198189_Capture.PNG" style="height: 277px; width: 620px;" /></P><P>Here is the result of a load with an "Lorem ipsum..." value, 1000 words long. In the array I only see 500 characters of the text (the screenshot doesn't show it all).</P><P></P><P>Is there any way to override this limitation? The function is called a "preview", so perhaps it isn't designed for full data loads. Is there a better way to get an external file with the App Engine API?</P><P></P><P>Jonathan</P></BODY></HTML> Mon, 02 Apr 2018 21:34:00 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Limit-to-Data-with-GetFileTablePreview/m-p/42276#M645 jonvitale 2018-04-02T21:34:00Z