Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III

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

0 Replies