Bad Gateway Error (502) - it exceeds the list view threshold??

(0) Share

Report

Posted on by GianGian

With flow i scheduled 27 rest api call.

The URI is

_api/web/lists/getbytitle('listname')/items?$filter=ColumnName eq 'FilterValue'&$top=5000

Only 1 of 27 http requests gave me this error:

{
 "error": {
 "code": 502,
 "source": "flow-apim-europe-001-francecentral-01.azure-apim.net",
 "clientRequestId": "f6397a9d-aa13-4dfc-b048-3cda740a5260",
 "message": "BadGateway",
 "innerError": {
 "status": 502,
 "message": "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.\r\nclientRequestId: f6397a9d-aa13-4dfc-b048-3cda740a5260\r\nserviceRequestId: a221619f-80d0-a000-64a9-05482da35f5f",
 "source": "https://*****.sharepoint.com/sites/****/en/WM/GA/******/_api/web/lists/getbytitle('ListName')/items?$filter=SupplierName%20eq%20'FilterValue'&$top=5000",
 "errors": [
 "-2147024860",
 "Microsoft.SharePoint.SPQueryThrottledException"
 ]
 }
 }
}

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Rohit Sharma354 on at

Like (0)

Report

Hello,

This error indicates that get items action is timing out due to large number of items retrieved in a minute and throttling.

I can see that you are limiting the columns and record count. Please try doing the same using the get items settings "Limit columns by view" and top count.

This error can also occur when you have over 20,000 items in the SharePoint list; and for that error, a possible fix is to index all columns used in list view filters, you can index up to 20 columns or you can also try indexing only the first column in each list view.

Please follow the steps in the following link and let me know if this solves the situation: https://support.office.com/en-us/article/add-an-index-to-a-sharepoint-column-f3f00554-b7dc-44d1-a2ed-d477eac463b0

Hope this helps !

Was this reply helpful? Yes No

GianGian

33 on at

Like (0)

Report

Hi, thanks for your help.

I followed all of your steps.

Unfortunately it still not works.

I did the index of all columns and even reindexed the list

The issue involves only that specific supplier (name)

Pretty sure it's not an "issue for large number of items":

	Count of Items in the List
Supplier1	487
Supplier10	634
Supplier11	580
Supplier12	39
Supplier13	395
Supplier14	544
Supplier15	272
Supplier16	444
Supplier17	330
Supplier18	40
Supplier19	117
Supplier2	450
Supplier20	307
Supplier3	414
Supplier4 -ERROR	128
Supplier5	1
Supplier6	32
Supplier7	786
Supplier8	245
Supplier9	181
TOTAL	6426