Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pawwy1415
Contributor II

Rest Connector help in qliksense

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

 

Modified Date format.png

 

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