QBXML using we connector not working for special characters.

pkm · ‎December 23, 2021

Hi All,

Here we have the log of the QBXML.

https://dbqb.claritycrm.com/listener/QuickBooksWebConnector/Support.aspx?id=cda7f342-bb35-42f9-92ba-...

<?xml version="1.0"?><?qbxml version="13.0"?><QBXML><QBXMLMsgsRq onError="continueOnError"><SalesOrderAddRq requestID="cda7f342bb3542f992badad4332c4db7.1.salesorder:add.1"><SalesOrderAdd><CustomerRef><ListID>8000003C-1640154527</ListID></CustomerRef><TxnDate>2021-12-22</TxnDate><RefNumber>S00015</RefNumber><BillAddress><Addr1>Ukpeagvik Iñupiat Corporation-Anchorage</Addr1><Addr2>Swan Tim</Addr2><City></City><State></State><PostalCode></PostalCode><Country></Country></BillAddress><ShipAddress><Addr1>Ukpeagvik Iñupiat Corporation-Anchorage</Addr1><Addr2>Swan Tim</Addr2><City></City><State></State><PostalCode></PostalCode><Country></Country></ShipAddress><Memo></Memo><SalesOrderLineAdd><ItemRef><ListID>80000011-1603082870</ListID></ItemRef><Desc>Description of Sales Biku</Desc><Quantity>1.0000</Quantity><Rate>660.0000</Rate><Amount>660.00</Amount><Other1>1</Other1></SalesOrderLineAdd><SalesOrderLineAdd><ItemRef><ListID>80000012-1603083022</ListID></ItemRef><Desc>New Biku</Desc><Quantity>1.0000</Quantity><Rate>110.0000</Rate><Amount>110.00</Amount><Other1>2</Other1></SalesOrderLineAdd></SalesOrderAdd></SalesOrderAddRq></QBXMLMsgsRq></QBXML>

The XML is not processed by QB as because, the line

<Addr1>Ukpeagvik Iñupiat Corporation-Anchorage</Addr1>

has a special charecter "ñ".

Please suggest!

Thanks!

Best Regards

Projjwal

Giovann_G · ‎December 23, 2021

Hello, pkm.

I can share information on how to handle special characters using a connector in QuickBooks Desktop.

QuickBooks detected an error since the special character "ñ" is entered incorrectly. QBXML doesn't accept accents and non-US/non-ASCII characters. The HTML character for "ñ" is ñ.To fix this, you can manually encode it or consult with your IT person for further assistance.

I'll be sharing this article for your reference: Set up QuickBooks Web Connector. Here you can find helpful information to completely set up and manage an app.

In addition, check out this resource to learn how to fix an issue with Web Connector: Fix common Web Connector errors in QuickBooks Desktop.

Let me know if you need further assistance with the QBXML connector. We're always here to help you.

pkm · ‎August 24, 2022

Well there can be millions of such possibilities this is just one. So the suggestion provided is not feasible for a multinational company working with various customers overseas.

How many such characters shall we handle there are endless limits to the list.

Thanks!

Topics

Training

Community

Resources

QBXML using we connector not working for special characters.

QBXML using we connector not working for special characters.

QBXML using we connector not working for special characters.

Need to get in touch?