If you just want to store the JSON, then expand it into a list when you want to view it, then yes that is possible. Essentially you need a Helper Table with numbered rows, temporarily write the JSON into the Helper Table, apply it to every row, then extract the items into rows and columns using a combination of Query JSON & Single Value columns.
Take a look at the “Miracle Method”. It describes the basic approach.
If you need more detailed instructions, then it would be useful if you could provide a sample of your JSON.