Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

XML parse tool error - Invalid character reference

nataliamiteva
8 - Asteroid

Hi everyone,

 

I am using a SOAP API and downloading different fields with mixed string/numbers data from it. A few of the fields have special characters in them and I keep getting the following error:

 

Invalid character reference at Line: x and Column: y at row # z

XML Error.png

 

Alteryx is bringing through all rows of data which don't have any of the 'invalid' characters in them but stops at the row number which does have an invalid character.

 

Any suggestions on what I can do to resolve this error?

 

Many thanks in advance!
Natalia

2 REPLIES 2
ImadZidan
12 - Quasar

Hello @nataliamiteva ,

 

What if you check ignore XML errors and continue option.

nataliamiteva
8 - Asteroid

Simple but effective solution! Thanks 

Labels
Top Solution Authors