SharePoint list data using Graph API: Filter on any column doesn't work

Ignition
,
1

I am trying to fetch data from SharePoint URL for the first time. I have managed to get all the list data from sharePoint URL but when I try to apply filter on any column, I didn't get any expected data.
Can you please help in this case?
Here is the code part of code I am working on.

header = {'accept':'application/json','Authorization':'Bearer ' + LatestToken} 

#Below URL works. All data from sharePoint list fetched by passing Site ID and List ID.
rawResponse = client.get(https://graph.microsoft.com/v1.0/sites/+sharepointGUID +/lists/%7B + ListGUID + %7D/items?$expand=fields&$top=100,headers=header)
return rawResponse.json

#Here I added filter with encoded URL but it fetched only 200 records with any filter when there are about 8000 records with filter on sharepoint.
rawResponse = client.get(https://graph.microsoft.com/v1.0/sites/+sharepointGUID +/lists/%7B + ListGUID + %7D/items?$expand=fields&%24filter%3DstartsWith%28fields%2F + FilterField + %2C + FilterValue + %29,headers=header)
return rawResponse.json

I am not sure what I am missing here.

2

The startsWith only filters if filtervalue is a text, could it be you are trying to filter a number?

a default page size? its probably something you should ask on their forum instead of here.

simulate the request in postman or something and see what you get
(see if you get a @odata.nextLink in the reply, which would mean paging )

3

Hi @victordcq
Thank you for replying.
I am actually trying to filter a string not a number. As you suggested, I tried this in postman but getting same result. I think you are right. I should ask this query on sharePoint forum.

Thank you once again.

4

As an aside, you should really consider using the params argument to get() - it will automatically URL encode a key: value dictionary, so you don't need to worry about concatenation, URL escaping, etc.

5

Thank you for a thought @PGriffith.
I will try this way.