Handling BOM in Json Response

VBA-tools / VBA-Web

VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web

http://vba-tools.github.io/VBA-Web/

MIT License

2.01k stars 494 forks source link

Open liveFreeOrCode opened 7 years ago

liveFreeOrCode commented 7 years ago

When trying to parse a JSON string from my Rest response, I get the following error:

ERROR - WebHelpers.ParseByFormat: 11000, An error occurred during parsing 10001: Error parsing JSON: ï»¿{"UnitPr

The 3 characters (the byte order mark) are not be properly removed. Is there something I'm missing in setting this up?

Thanks

timhall commented 6 years ago

Hmm, hadn't checked or tested that, I'll read up on it and see what can be done.