API XML Parsing Error

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I'm facing problems with special characters (e.g. German umlauts ö,ä,ü) when trying to import data using API importFromCSV():
com.intuit.quickbase.util.QuickBaseException: XML Parsing Error. not well-formed (invalid token) at line 9 column 80 (which is byte 972)
Photo of Michael Heese

Michael Heese

  • 80 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 28,234 Points 20k badge 2x thumb
Why don't you isolate the problem by shortening the XML body to the smallest content that yields the same error and post that minimal XML through a pastie service (eg pastebin.com)?
Photo of Michael Heese

Michael Heese

  • 80 Points 75 badge 2x thumb

We are calling the importFromCSV() method in Java and just pass a comma separated list of values.

So if one of the value contains such an Special character the API call fails.

It seems the error occurs in QuickBase class in method xmlFromString(qdbResp).