调用rest api时，Web活动引发了超限错误 [英] Web activity throws overlimit error when calling rest api

问题描述

我的ADF管道有一个查找活动，该活动使用sql查询从表中获取数据，并将其传递到Web活动，该活动将JSON发布到API(Azure应用程序服务).当查询获得1000行时，它可以正常工作，但是当我尝试超过5000行时，网络活动将返回错误.

My ADF pipeline has a lookup activity which uses a sql query to get data from a table and passes it to a web activity which posts the JSON to an API (azure app service). When the query gets 1000 rows it works fine but when I try over 5000 rows the web activity returns the error.

"errorCode": "2001",
"message": "The length of execution ouput is over limit (around 1M currently). ",
"failureType": "UserError",

当我使用邮递员将5000行记录发布到API时，效果很好.知道这个错误是什么意思以及如何解决吗?

When I post the 5000 rows to the API using postman it works fine. Any idea what this error means and how to resolve it?

谢谢.

推荐答案

您发现，网络活动超时限制为1分钟.另外，基于上述错误The length of execution output is over limit (around 1M currently).，Web活动的输出大小限制也为1 MB.

As you found, web activity has times out limitation for 1 minute. Also, based on the above error The length of execution output is over limit (around 1M currently)., web activity also has output size limitation for 1 MB.

您可以找到限制规则此处，如果您要求联系支持部门.

You could find the limitation rules here and some of the them could be adjusted if you ask for Contact Support.

如果他们无能为力，我为您提供了一种解决方法，您可以使用

If nothing they can do,I provide you with a workaround that you could use ForEach Activity. Maybe you need to use paging query for your rest api and return a limited number of the data each time. Then query your data in loop until the number of return data is lower than threshold value.

这篇关于调用rest api时，Web活动引发了超限错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！