API_ImportFromCSV XML parsing error on latin characters

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress

Whenever I use the API_ImportFromCSV to import records, it crashes on a certain row that contains the latin character ''Á" . When I open the spreadsheet using a plain text editor, this character is appear as <0x8d> which seems like it would crash the XML parsing. 

I've trying adding <?xml version="1.0" encoding="utf8"> into my script, but it does not work. 

Anyone have any suggestions of how I may fix solve this? 

Thank you 
Photo of Paul Trimor

Paul Trimor

  • 538 Points 500 badge 2x thumb

Posted 1 year ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
I am curious what the source of the text is (a teletype terminal?) because x8d is the "reverse line feed" character. I would remove the character before calling API_ImportFromCSV