Can you store the file in /config/www? Then you could use a rest sensor grabbing https://yourURL/local/filename.xml and it does convert xml to json.
I do this in my EPG automations:
EPG (Electronic Program Guide) … who wants it in HA? - Share your Projects! / Dashboards & Frontend - Home Assistant Community (home-assistant.io)