webservice xml parsing error on memo field

[alan]

Hi Bruce,

Using C9.0, NT 8.11 and Xfiles 2.52.

I'm following your webinar on webservices and trying to serve a .tps file.  The file includes a memo field which appears to be generating an error because, when I change the field to a string, the error disappears. Here's the documentation Example response:

<dbInvData_response>
  <InvData>
    <INV_USERID>value</INV_USERID>
    <INV_TABLE>value</INV_TABLE>
    <INV_ITEMNUM>value</INV_ITEMNUM>
    <INV_FIELD>value</INV_FIELD>
    <INV_IMPORTED>value</INV_IMPORTED>
    <INV_INPUT><![CDATA[value]]></INV_INPUT> <-----Bruce, this is the memo field
  </InvData>

       ........

INV_INPUT is the memo field. When I test with a GET in the browser, I get the following error:

XML Parsing Error: not well-formed
Location: http://127.0.0.1:88/dbInvData?sFirmId=value&sCaseId=value&sPassword=value
Line Number 305, Column 25:    <INV_INPUT><![CDATA[

If I return a View instead of the table, the "![CDATA{" isn't in the example but I still get the XML Parsing Error.

Is there a problem with memo fields in the webservice templates or is it me? (or both

Alan

[Bruce]

Hi Alan,

Memo support added to 8.17

Cheers
Bruce