privateNote | Simple self destructing note site | Privacy library

I got some help and I wasn't sure if I should continue this in the original question or start a new one since technically it is a new question (I chose new but let me know what you guys prefer for next time).

I figured out how to parse the standard set of information into different columns. I'm having trouble getting the nested arrays to parse. It gives a runtime error 5 when it gets to that part of the code. The array under customfields needs to be parsed into columns but the estimate lines array contains part/pricing information that needs to be parsed into rows.

Here is the code I've written so far:

so due to the api key giving me issues i have to download json formatted data using vba and not power query. the api response, i would like to parse into a table or use power query to turn into a table.

The code i tried is not working. it gives me.... Runtime error 10001 "Expecting '""' or '''".... i'm sure it has something to do with "JSONConverter" code i downloaded and tried to use.this is the website that helped me figure out the code i wrote http://excelerator.solutions/2017/08/16/import-json-to-excel-using-vba/ .i'm open to scraping it if someone has a better way of doing it. lastly this is a decently big amount of data to put into one cell,do you recommend using a cell or some other way to hold data that will be parced?

this is a sample of the json file