提供"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.

我正在呼叫的URL:

/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返回的错误:

由于未建立索引，因此无法在过滤器或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列中添加索引.您可以在

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屋！