General Script Error in statement handling while fetching data from sharepoint by using inbuilt office 365 connector

konidena — Sun, 11 Feb 2024 10:59:53 GMT

Hi Team,

I have a sharepoint location. This location has multiple subfolders. Every week the business users used to update the subfolders with excel or csv files. I need to fetch the data from latest files. If the file is used once, it shouldn't be considered again for the reload.

I kept every subfolder path in inline load and used the below script to fetch the files details from each sharepoint folder and then saving them into a table . while doing this, I am getting the error "General Script Error in statement handling". It is not specifically coming at one location. everytime it is coming in different different sub folder.

Office365Connector_ListFolders:
Load * Inline
[
CustomFolder
QS_MSMART_UK/0_LocalData/Mapping
QS_MSMART_UK/0_LocalData/Configuration
QS_MSMART_UK/0_LocalData/05_03_Neurology_Patients/ROI_REBIF/Configuration
QS_MSMART_UK/0_LocalData/00_09_Local Channels
QS_MSMART_UK/0_LocalData/01_01_Oncology_Sales
QS_MSMART_UK/0_LocalData/01_01_Oncology_Sales/Average Selling Price
QS_MSMART_UK/0_LocalData/01_02_Oncology_MarketData/UK/Cash
QS_MSMART_UK/0_LocalData/01_02_Oncology_MarketData/UK/Units
QS_MSMART_UK/0_LocalData/01_02_Oncology_MarketData/ROI/Cash
QS_MSMART_UK/0_LocalData/01_02_Oncology_MarketData/ROI/Units
QS_MSMART_UK/0_LocalData/01_02_Oncology_MarketData/SSD for Iconnect
QS_MSMART_UK/0_LocalData/01_04_Oncology_Targets
QS_MSMART_UK/0_LocalData/01_04_Oncology_Targets/KAM_Targets
QS_MSMART_UK/0_LocalData/01_04_Oncology_Targets/OP_Targets
QS_MSMART_UK/0_LocalData/01_05_Oncology_RAS_Targets
QS_MSMART_UK/0_LocalData/01_06_Oncology_RAS_Actuals
QS_MSMART_UK/0_LocalData/01_07_Oncology_Potential
QS_MSMART_UK/0_LocalData/01_09_Oncology_Other_Data

];

LIB CONNECT TO 'Office_365_Sharepoint_Metadata';

For Each vFolderTmp in FieldValuelist('CustomFolder')

Office365Connector_ListFiles:

LOAD UniqueId as [ListFiles.UniqueId],

Name as [ListFiles.Name],

updated as [ListFiles.updated],

TimeCreated as [ListFiles.TimeCreated],

TimeLastModified as [ListFiles.TimeLastModified],

'$(vFolderTmp)' as CustomFileFolder

;

SELECT UniqueId,

Name,

updated,

TimeCreated,

TimeLastModified

FROM ListFiles

WITH PROPERTIES (

subSite='/sites/M-Smart_Application_Data/',

folder='/sites/M-Smart_Application_Data/Shared Documents/Prod.group.com/$(vFolderTmp)/',

maxResults='1000'

);

Let vFolderTmp='';

Next vFolderTmp;

Drop Table Office365Connector_ListFolders;

NoConcatenate

SP_File_ID:

Load

[ListFiles.Name] as File,

[ListFiles.UniqueId] as ListFiles_UniqueId,

[ListFiles.updated] as ListFiles_updated,

[ListFiles.TimeCreated] as ListFiles_TimeCreated,

[ListFiles.TimeLastModified] as ListFiles_TimeLastModified,

CustomFileFolder

Resident Office365Connector_ListFiles;

store SP_File_ID into [lib://APP_MSMART_UK_Confi/Local Datastore/1_Extract/SP_File_ID.qvd] (qvd);
Drop Table SP_File_ID;

Drop Table Office365Connector_ListFiles;

Please let me know what is the exact issue here. Syntactically the code is correct but i am not able to understand where exactly the issue is coming. Please help me here if any one has idea on this

Re: General Script Error in statement handling while fetching data from sharepoint by using inbuilt office 365 connector

Anil_Babu_Samineni — Fri, 16 Feb 2024 15:18:29 GMT

@konidena What it says when you use Debug mode? Is there any file that showing the error or ?

topic General Script Error in statement handling while fetching data from sharepoint by using inbuilt office 365 connector in Qlik Automate

General Script Error in statement handling while fetching data from sharepoint by using inbuilt office 365 connector

Re: General Script Error in statement handling while fetching data from sharepoint by using inbuilt office 365 connector