Hi Experts,
Can any one please help me on below issue.
I am trying to extract the data from SharePoint using Rest Connector.
But its not fetching all the records means its fetching the data up to July 19 2018 instead of November 23 2018.
Requirement:
Is there any way to load the records greater than July 19 2018 from the Modified Date field please help me o this.
My date field format is like below
the share point script is like below.
Load
@content_u2 as [Modified Date]
[_FK_Modified]
Resident MasterTable
where not IsNull([_FK_Modified]);
I have tried like below with share point url to fetch the data greater than 2018-07-19T12:55:16Z modified date but its not working
https://xxxxx/_api/web/lists/getbytitle('xDatabase')/items?@content_u2:gte:2018-07-19T12:55:16Z
Thanks in advance