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/:
{“id”:“14acfa60-c0e1-47fb-8f80-ca0831bf3b52”,“class”:“us_equity”,“exchange”:“ARCA”,“symbol”:“UVXY”,“name”:"",“status”:“active”,“tradable”:true,“marginable”:true,“shortable”:false,“easy_to_borrow”:false}
…and insert/update to an Access table with the same columns:
|id|class|exchange|symbol|status|
|14acfa60-c0e1-47fb-8f80-ca0831bf3b52|us_equity|ARCA|UVXY|active|