API_ImportFromCSV XML parsing error on latin characters

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
Hello 

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

  • 488 Points 250 badge 2x thumb

Posted 5 months ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 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