MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified.

[krusk]

Hi all,

I need to send simple nested XML to a vendor, but am getting the following error:

INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified.

I am loading the POST call in my Invoice Page Template using MVT as follows:

<mvt:assign name="l.xml" value="'<?xml version=\"1.0\" encoding=\"utf-8\"?>' $ asciichar(10)" />
<mvt:assign name="l.xml" value="l.xml $ '<OrderID>' $ l.settings:order:id $ '</OrderID>' $ asciichar(10) "/>
<mvt:foreach iterator="item" array="order:groups">
  <mvt:assign name="l.xml" value="l.xml $ '<Item>' $ asciichar(10) "/>
  <mvt:assign name="l.xml" value="l.xml $ '<ItemID>' $ l.settings:item:code $ '</ItemID>' $ asciichar(10) "/>
    <mvt:assign name="l.xml" value="l.xml $ '</Item>' $ asciichar(10) "/>
</mvt:foreach>

<mvt:call action="'http://myvendorsapi.net/orders'" method="'POST'" fields="XML">
    <mvt:eval expr="s.callvalue" />
</mvt:call>

With multiple items, I am expecting it to send XML like this:

<post>
<orderaddr>
555 My Address
</orderaddr>
<orderemail>
[email protected]
</orderemail>
<item>
<ordercode>
RSC1
</ordercode>
</item>
<item>
<ordercode>
RSC2
</ordercode>
</item>
</post>


Please assist, I have hit a wall.

K.

[Bruce - PhosphorMedia]

Re: MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specifie

You might need to wrap the email with CDATA (and all other data from external sources like names, addresses, etc.

<![CDATA[[email protected]]]>

[krusk]

Re: MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specifie

Thanks Bruce,

I've tried it without the email and it still fails. Any clues?

K.

[krusk]

Re: MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specifie

Essentially, I am trying to resolve the same issue you were helping me with here:

http://extranet.miva.com/forums/showthread.php?117092-Iterate-through-order-and-create-nested-value-key-pairs-for-output-via-MVT-Call&p=438750#post438750

In that I need the solution to be in MVT.

Thanks!

K.

You might need to wrap the email with CDATA (and all other data from external sources like names, addresses, etc.

<![CDATA[[email protected]]]>

[Kent Multer]

Re: MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specifie

You can put an mvt:eval on the template, so that it will display the complete XML text on the page. That will give you a chance to look at it, and see exactly what XML your code is creating. Be sure to use an encodeentities() call, something like:

<mvt:eval expr="'<p> XML code: <br/> ' $ encodeentities(l.xml) $ ' </p>'" />

-- otherwise you won't see the code on your page.

Also, you can change the action URL, so that the XML request is made to a small test script running on your own site. This script can save the received XML into a text file: that gives you another way to verify what your code is creating.

Also, I would try using a global variable g.xml, or a settings variable l.settings:xml, instead of the straight local variable l.xml.

HTH --

[Bruce - PhosphorMedia]

Re: MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specifie

i think you also want XML has the method for the post...

[dcarver]

Re: MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specifie

Hi all,

I need to send simple nested XML to a vendor, but am getting the following error:

INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified.

I am loading the POST call in my Invoice Page Template using MVT as follows:

<mvt:assign name="l.xml" value="'<?xml version=\"1.0\" encoding=\"utf-8\"?>' $ asciichar(10)" />
<mvt:assign name="l.xml" value="l.xml $ '<OrderID>' $ l.settings:order:id $ '</OrderID>' $ asciichar(10) "/>
<mvt:foreach iterator="item" array="order:groups">
  <mvt:assign name="l.xml" value="l.xml $ '<Item>' $ asciichar(10) "/>
  <mvt:assign name="l.xml" value="l.xml $ '<ItemID>' $ l.settings:item:code $ '</ItemID>' $ asciichar(10) "/>
    <mvt:assign name="l.xml" value="l.xml $ '</Item>' $ asciichar(10) "/>
</mvt:foreach>

<mvt:call action="'http://myvendorsapi.net/orders'" method="'POST'" fields="XML">
    <mvt:eval expr="s.callvalue" />
</mvt:call>

With multiple items, I am expecting it to send XML like this:

<post>
<orderaddr>
555 My Address
</orderaddr>
<orderemail>
[email protected]
</orderemail>
<item>
<ordercode>
RSC1
</ordercode>
</item>
<item>
<ordercode>
RSC2
</ordercode>
</item>
</post>


Please assist, I have hit a wall.

K.

Hi krusk,


The issue is you need to have the fields parameter value wrapped in single quotes, otherwise it evaluates the current l.xml value as the variable name which returns blank. You should also prefix the fields value with "l." for "l.xml" which will give an ever so slight performance increase.


Let me know if you have any other questions.


Thanks

[krusk]

Re: MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specifie

Thanks David

[krusk]

Re: MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specifie

Thanks Kent. This is very helpful for debugging.

[krusk]

Re: MVT CALL - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specifie

Thanks Bruce. Using that allows me to declare the desired content-type.