Error Filtering Non-Indexed Field in SharePoint List

[jsormaz]

When I try to filter on a non-indexed field, I get the following error:

Error Message: Field 'Title' cannot be referenced in filter or orderby as it is not indexed. Provide the 'Prefer: HonorNonIndexedQueriesWarningMayFailRandomly' header to allow this, but be warned that such queries may fail on large lists.

How can I provide the header as described? It is not feasible for me to index every field that I need to filter by. I do not have an issue of large lists.

I am filtering using the following method:
query = sharepoint_list.q().expand('fields').select('Title','id')
query.chain().on_list_field('Title').equals('filter value')
matching_items = sharepoint_list.get_items(query = query)

[jsormaz]

I was able to hack this together by replacing line:

response = self.con.get(url, params=params)

in sharepoint.py get_items()

with:
headers = {}
headers['Prefer'] = 'HonorNonIndexedQueriesWarningMayFailRandomly'

response = self.con.get(url, params=params, headers=headers)

however I would prefer a built in solution

[Slothfulwave612]

@alejcas Hi, hope you are in good health. I encountered a similar issue in one of my projects and had to download the repository to make the change manually. I noticed this hasn’t been updated in the O365 script. If it’s okay with you, I would like to make this change in the script and submit a pull request. Please let me know if that works for you—I’d be happy to help!

[alejcas]

@alejcas Hi, hope you are in good health. I encountered a similar issue in one of my projects and had to download the repository to make the change manually. I noticed this hasn’t been updated in the O365 script. If it’s okay with you, I would like to make this change in the script and submit a pull request. Please let me know if that works for you—I’d be happy to help!

It's perfectly fine. Just submit a PR.
Thanks