Rest API – threshold limit error for lookup columns

To get all fields internal names:

https://web.com/sites/sitename/_api/lists/getbytitle(‘List Title’)/fields

To get people or group internal names:

https://web.com/sites/sitename/_api/lists/getbytitle(‘List Title’)/items?$select=Title,ProjectLeads/Id&$expand=ProjectLeads/Id

If you get threshold limit error for lookup columns use “?$select=Title,Id”  at end if them url:                                                                                                                                                        var queryUrl = Url + “/_api/lists/getbytitle(‘Dynamic Briefs’)/items?$select=Title,Id”;

 

 

Advertisement