Had a similar case and solved it with ADLFS (https://github.com/fsspec/adlfs)

It allows filesystem-like operations to azure blob storage.

Also the error "#1 Json Decoder Error Expecting Value: line 1 column 1 (char 0)" Can be due to UTF-8 BOM encoding bytes at the start of the JSON (in my case this was the issue, had to enforce encoding - utf-8-sig.