On SharePoint 2013 On Premise, I need rest api filter where I can search some numbers in list starts with. Since records are around 100,000 I can not display all. Hence need a kind of search function.
You can use the filter on column something like given below:
var endpointUri = appwebUrl + "/_api/web/lists/getbytitle('listName')/items?$select=*&$filter=startswith(Title,'value')";
Is it a numberfield or a textfield?
If its a numberfield why not create a filter that compares a number greater than the numberfield?
Something like this:
/_api/web/lists/getbytitle('list')/items?$filter=[Numberfield] ge 123000
Where ge is Greater than or equal.
You can try something like below:
e.g. To get item with the number
/_api/web/lists/getbytitle('testCRUD')/items?$select=*&$filter=(numberfield ge '444') and (numberfield le '444')