title: How to get, ("fields") to Work in VBA-JSON
body: <h2>Summary</h2>
  
  <p>I am trying to access the deep levels of nested JSON that comes back from the API that I am working with at the moment. Using <em><a href="https://github.com/VBA-tools/VBA-JSON" rel="nofollow noreferrer">VBA-JSON</a></em> through this process has been pretty easy, but I've ran into a little road block. For the most part, I've got this library to work properly, but I get an error anytime I try to grab an item that is nested in the JSON response (<em>further than 2 JSON levels</em>). I am going to submit this post, and then I'll go and gather some of the error codes that I am getting. Off the top of my head, I know that I get a <a href="https://msdn.microsoft.com/en-us/library/aa264979(v=vs.60).aspx" rel="nofollow noreferrer">Run-time error '13'</a> when I try to use the code below that doesn't work. I think (<em>could be wrong</em>) that I am smart enough to understand the type mismatch error, but I don't know how to fix it.</p>
  
  <h2>This Works</h2>
  
  <pre><code>For i = 1 To 20
      ActiveSheet.Cells(i + 1, 5) = Json("issues")(i)("key")
      ActiveSheet.Cells(i + 1, 6) = Json("issues")(i)("id")
  Next
  </code></pre>
  
  <h3>Doesn't Work</h3>
  
  <pre><code>For i = 1 To 20
      ActiveSheet.Cells(i + 1, 7) = Json("fields")(i)("summary")
  Next
  </code></pre>
  
  <h3>None of These Worked Either</h3>
  
  <pre><code>ActiveSheet.Cells(i + 1, 7) = Json("fields")(i)("summary")
  ActiveSheet.Cells(i + 1, 7) = Json("fields")("summary")
  ActiveSheet.Cells(i + 1, 7) = Json("issues")("fields")("summary")
  
  ActiveSheet.Cells(i + 1, 7) = Json("fields")("assignee")(i)("name")
  ActiveSheet.Cells(i + 1, 7) = Json("issues")("fields")("assignee")(i)("name")
  </code></pre>
  
  <h3>Updated with Some JSON</h3>
  
  <p>I edited the JSON that comes back for privacy reasons (<em>obviously</em>).</p>
  
  <pre><code>{
    "expand": "schema,names",
    "startAt": 0,
    "maxResults": 50,
    "total": 28,
    "issues": [ {
      "expand": "",
      "id": "94581",
      "self": "",
      "key": "",
      "fields": {
        , "assignee": {}
        , "status": {}
        , "votes": {}
        , "summary": ""
        ,
        , "issuetype": {}
        , "timespent": null,
      }
    }
    ,
    {}
    ,
    {}
    ,
    {}
    ]
  }
  </code></pre>
  
  <p>According to this data structure, my code should be looking at the right place, right?</p>
  
  <p>Thoughts? :)</p>
  
  <hr>
  
  <p><em>PS: Sorry if jargon is off, I'm a developer by hobby, not by job. :)</em></p>