MSXML2.XMLHTTP60 - XML Request Parameters - DTD Is Prohibited Error

Hi,

I am sending a request using MSXML2.XMLHTTP60.

The Input parameters is a lengthy XML String which is generated by Excel.

The XML string when displayed in immediate window breaks at every 1024th character as it should.

I checked the string in an online XML Formatter and it is fine.

If I make the string in a cell (Using Concatenate & Call Values to generate XML) & pick it up from a cell, the Request returns the desired response.

But when I use it from a variable, I get DTD Is Prohibited Error.

I am certain, the linefeed at 1024th character is causing the problem.

Can anyone suggest a work around??

Posting your code might help. Without that, have you tried a simple Replace function?

Here you go.

Sheet with Codename shInputJSON has XML Parameters from Cell A1 to Cell A48.

Can't post the code for some reason, so here is the link -
https://justpaste.it/1f1wn

Perhaps the problem is that you do not resize when you offset. I would suggest trying

Please Login or Register  to view this content.

It does work.. Thank you so much for it..

However, I have still not understood why it works..

Can you clarify a bit if you have the time??

Cheers!

If you don't resize, you are including a blank cell in the array and therefore in the parameters array, so you end up with an errant space at the end when you join the array. It seems that causes the error.

Originally Posted by xlnitwit

If you don't resize, you are including a blank cell in the array and therefore in the parameters array, so you end up with an errant space at the end when you join the array. It seems that causes the error.

Hi,

Thank you for the reply. However, does that extra space make any difference, as the inputs parameters are XML Tags.

Also, I after testing a few times, I observed that after your solution I still get that error occasionally.

Did you try uncommenting this line

Please Login or Register  to view this content.

Does the error happen consistently with the same parameter set?

Yes..

It does happen with the same parameter set.

Then I think you need to debug what XML you are actually getting back.

Alright.. Thank you fir the help so far..

If I am able to get a solution I will post it here.

Thank you for the help..

Cheers!

Originally Posted by NeedForExcel

...Can't post the code for some reason, so here is the link - ....

Can't post the code because of things like this I expect...Dave..
<FNum _ <iKey
https://www.excelforum.com/tips-and-...rkarounds.html

( _ First 4 characters after a _ < _ )

https://imgur.com/6nghaXG