XML Parse Tool error when connecting to QuickBase

[cowannbell]

I have been using this process when connecting to QuickBase so that the Gallery can handle it but now I'm getting an error.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Quickbase-alteryx/m-p/1135186#...

The error I'm receiving is "Expecting entity name for reference at line:76 and column 86.  It doesn't matter what QuickBase or Table I connect to, I get the exact same error.

Any idea what I would be getting that?  We did just recently update our server and Designer.  Not sure if maybe that has anything to do with it.  We are on Version 2022.3.1.5.532 

[oyes2704]

Hi @cowannbell ,

could you please confirm which tool creates the error - Download or XML Parse? You can always save results of the download tool to CSV or other data formats and rerun for XML only. Also, if you would activate the Show all Macro Messages on the Workflow "Runtime" configuration you might get more information.

Also, are you able to run it from your desktop? Does the error occurs only on the server? Let's narrow it down from here.

Best,

Oly

[cowannbell]

The XML Parse gets the error.  I did show all Macro Messages but nothing new.

[oyes2704]

I understand it's sensitive data and you probably would not be able to share sample. I believe it's something in the query format that could be BLOB formats or else.. Please look at the results of the Download to confirm it's XML and not JSON and it looks in canonical format:

API_DoQuery – Quickbase Help

With XML Parse try to extract basic fields like root or specific fields and make sure it works before you run autodetect.

 XML Parse Tool (alteryx.com)

If you could possibly create some dummy data extract - would be definitely easier to help you. Or contact support please.

[apathetichell]

My experience with the xml tool has been less than stellar. I believe this could be a tool issue vs a user error. If you can check out where specifically you are seeing the error - it sounds like Alteryx isn't parsing an escape character (probably a < or a >) correctly and this is throwing off the XML.

[oyes2704]

Just another idea - try to parse the Download output with one of online tools like XML Parser Online (codebeautify.org)

[cowannbell]

Thanks, I tried this and when I downloaded the xml, I finally got the first error. Not sure how to correct it though.

error on line 51 at column 86: xmlParseEntityRef: no name

[apathetichell]

without a data sample it's hard to tell what the specific xml entry which is causing this error.