提供“allowthrottleablequeries"首选项以允许此操作 [英] Provide the 'allowthrottleablequeries' preference to allow this

问题描述

我使用 Microsoft Graph API 开发了一个 API.我遇到了以下问题.

I have developed an API using Microsoft Graph API. I am encountering below issue.

我正在调用的网址:

/v1.0/sites/root/lists/cb32cc85-5351-423d-b2ec-bb418c1d9c64/items?
$filter=fields/Created gt '2018-1-1T00:00:00'
&expand=fields
&$orderby=createdDateTime
&$top=10

API 返回错误:

字段 'Created' 不能在 filter 或 orderby 中被引用，因为它没有被索引.提供allowthrottleablequeries"首选项以允许此操作，但请注意此类查询在大型列表上可能会失败.

Field 'Created' cannot be referenced in filter or orderby as it is not indexed. Provide the 'allowthrottleablequeries' preference to allow this, but be warned that such queries may fail on large lists.

如何启用 allowthrottleablequeries 正如它所说的，我应该如何实现这一点?

How to enable allowthrottleablequeries as it says and how should I achieve this?

推荐答案

恐怕这不是一个非常清晰或有用的错误消息.据我所知，实际上没有办法启用 allowthrottleablequeries.

I'm afraid this isn't a very clear or useful error message. As far as I know, there isn't actually a way to enable allowthrottleablequeries.

当 SharePoint 列表变得太大而无法处理对非索引列进行筛选或排序时，就会发生这种情况.解决方法是向列表设置中的 created 列添加索引.您可以在 向 SharePoint 列添加索引.

This happens when a SharePoint list grows too large to handle filtering or sorting non-indexed columns. The fix is to add an index to the created column in your List Settings. You can find instructions on how to accomplish this in Add an index to a SharePoint column.

这篇关于提供“allowthrottleablequeries"首选项以允许此操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！