Retriving JSON data from API, need help

[Victor Martin Barroso]

Good evening. I am trying to retrieve JSON data from an API and convert it to .dta. But I am really lost. I am using the following code:

clear
ge str240 CTY_NAME=""
ge str240 CTY_CODE=""
ge str240 E_COMMODITY=""
ge str240 ALL_VAL_MO=""
ge str240 STATE=""
ge str240 COMM_LVL=""
ge str240 time=""



insheetjson using "https://api.census.gov/data/timeseries/intltrade/exports/statehs?get=CTY_NAME,CTY_CODE,E_COMMODITY,ALL_VAL_ MO&key=3dccf95b66aa8aa8df73c176d9db87e5c5f28d43&ST ATE=AL&COMM_LVL=HS2&time=2020-01", showresponse

insheetjson using "https://api.census.gov/data/timeseries/intltrade/exports/statehs?get=CTY_NAME,CTY_CODE,E_COMMODITY,ALL_VAL_ MO&key=3dccf95b66aa8aa8df73c176d9db87e5c5f28d43&ST ATE=AL&COMM_LVL=HS2&time=2020-01", col("CTY_NAME" "CTY_CODE" "E_COMMODITY" "ALL_VAL_MO" "STATE COMM_LVL" "time")

I get the following warning message:
Warning: Sheet appears to be an Array-of-Arrays, but option aoa() was not specified. This will cause your column selectors to silently fail.

The JSON from the url looks like: