Hello,
Is it possible to filter on a field when loading data using the O365 Sharepoint web connector?
For example, I am trying to load from 'GetDataFeed', and only want data where the Modified field (date) is greater than a specific date. When inserting a WHERE statement or setting the filter under the 'WITH PROPERTIES', the filter either doesn't work or throws an error (Connector error: Could not parse SELECT statement.). What would be the correct syntax?
SELECT
Modified,
Editor_LookupValue,
VersionLabel,
TaskDueDate,
InvoiceAmount,
Approver,
InvoiceStatus,
InvoiceDate,
WorkOrder,
PONumber,
CostCenter,
FROM GetDataFeed
WITH PROPERTIES (
subSite='/sites/subSiteName',
dataFeed='$(i)',
maxResults='',
);