title: How to read a JSON file in Azure Databricks from Azure Data Lake Store
body: <p>I am using Azure Data Lake Store for storing simple JSON files with the following JSON:</p>
  
  <pre><code>{
    "email": "Usersemail@domain.com",
    "id": "823956724385"
  }
  </code></pre>
  
  <p>The json files name is <code>myJson1.json</code>. The Azure Data Lake Store is mounted successfully to Azure Databricks.</p>
  
  <p>I am able to load successfully the JSON file via </p>
  
  <pre><code>df = spark.read.option("multiline", "true").json(fi.path)
  </code></pre>
  
  <p><code>fi.path</code> is a <code>FileInfo</code> Object which is the <code>MyJson1.json</code> file from above.</p>
  
  <p>When i do </p>
  
  <pre><code>spark.read.option("multiline", "true").json(fi.path)
  df.show()` 
  </code></pre>
  
  <p>i get the JSON object printed out correctly (DataFrame) as</p>
  
  <pre><code>+---------------------+------------+
  |                email|          id|
  +---------------------+------------+
  |Usersemail@domain.com|823956724385|
  +---------------------+------------+
  </code></pre>
  
  <p>What i want to do is, to load the JSON file with <code>json.load(filename)</code>, to be able to work with the JSON object within Python.</p>
  
  <p>When i do </p>
  
  <pre><code>with open('adl://.../myJson1.json', 'r') as file:
    jsonObject0 = json.load(file)
  </code></pre>
  
  <p>then i get the following error</p>
  
  <blockquote>
    <p>[Errno 2] No such file or directory 'adl://.../myJson1.json'</p>
  </blockquote>
  
  <p>When i try (the mount point is correct, i can list the file and also with spark.read into a DataFrame)</p>
  
  <pre><code>    jsonObject = json.load("/mnt/adls/data/myJson1.json")
  </code></pre>
  
  <p>then i get the following error</p>
  
  <blockquote>
    <p>'str' object has no attribute 'read'</p>
  </blockquote>
  
  <p>I have no idea what to do else to get the JSON loaded. My goal is to read the JSON object and iterate through the keys and their values.</p>