调用rest api时Web活动抛出超限错误 [英] Web activity throws overlimit error when calling rest api

问题描述

我的 ADF 管道有一个查找活动，它使用 sql 查询从表中获取数据，并将其传递给将 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?

提前致谢.

推荐答案

如您所见，Web 活动有 1 分钟的超时限制.另外，基于上面的错误执行输出的长度超过限制(目前大约1M).，web Activity也有1MB的输出大小限制.

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.

如果他们无能为力，我为您提供了一种解决方法，您可以使用 ForEach Activity.也许你需要为你的休息 api 使用 paging query 并每次返回有限数量的数据.然后循环查询你的数据，直到返回数据的数量低于阈值.

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