Convert API JSON to Access table

I’ve been reading through quite a few old threads elsewhere about converting and/or parsing JSON in Access or VBA, but none of them seem to work all the way. I wouldn’t think this is that hard, but it’s stumped me. All I want to do is take the JSON response body, say for /assets/:


…and insert/update to an Access table with the same columns: