Post large list (20,000 items) in HttpWebRequest

Question

I am uploading an Excel file to SQL DB. I am getting Remote Server returned an error Not Found 404 exception at following line

WebResponse response = request.GetResponse();

This is REST POST call & service is configured properly. Can anyone help ?I am not able to figure out anything from Exception.

The same code is working with less amount of data I mean 200 list count. Any help would be appreciated.

score 0 · Answer 1 · edited May 23 '17 at 11:58

0

It looks like C# imposes some restriction by default.

Here are some ways to modify this setting,

https://stackoverflow.com/a/12573344/3131696

edited May 23 '17 at 11:58

Community

1
1

answered Oct 25 '15 at 17:20

M22an

1,242
1
18
35

Thank you M22an. I checked my IIS settings. It is set it as : Maximum allowed content bytes 30000000 – Gyandeep Oct 25 '15 at 17:28

score 0 · Answer 2 · edited May 23 '17 at 10:27

0

While you are sending the request, you may want to check for MaxContentLength limit. Setting on config level just wont help, you need to set it at the code level where you are initializing the request.

Please refer this : Maximum request length exceeded

edited May 23 '17 at 10:27

Community

1
1

answered Oct 25 '15 at 21:56

Aj B

1
1

score 0 · Answer 3 · answered Oct 25 '15 at 22:30

Try this in your web.config

           <webHttpBinding>
              <binding maxBufferSize="2147483647" maxReceivedMessageSize="2147483647" maxBufferPoolSize="524288">
              <readerQuotas maxDepth="32" maxStringContentLength="2147483647" 
        maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647"  />
             </binding>
          </webHttpBinding>

Though these values above maximum so you may want to change them as per your requirement (to prevent Denial-of-Service attacks).

See this as well: webHttpBinding

Post large list (20,000 items) in HttpWebRequest

3 Answers3