Reputation: 225
I'm having a JSON file in the Azure Blob Storage. My aim is to read the contents of the JSON file using a Web Activity and pass the response to the body of the next Web Activity.
At the moment, the JSON file in the Blob storage is having couple of rows, and the pipeline is running successfully, achieving the goal.
My question is: Is there a limitation to the Web Activity to read only n number of rows from a file? Like, I mean, we know that the limitation of a Lookup Activity is that, it can only read 5000 rows. Is there any similar sort of limitation while reading using a Web Activity?
What if, JSON file in the Blob storage is having 500000 or even more number of rows? Will the Web Activity be able to read all the rows from the JSON file?
Thanks in advance :)
Upvotes: 0
Views: 967
Reputation: 11625
Please see the documentation for Web Activity and notice the note at the top:
Note
The maximum supported output response payload size is 4 MB.
I would recommend you vote for this feature request or here.
Upvotes: 1