Code:
gen str10 CBSA_temp = "" gen str200 Area = "" gen str10 temp = "" insheetjson CBSA_temp Area temp using "https://api.census.gov/data/2017/acs/acs1/profile?get=CBSA,NAME&for=metropolitan%20statistical%20area/micropolitan%20statistical%20area:*", aoa(1) columns("CBSA" "NAME" "metropolitan statistical area/micropolitan statistical area")
Code:
insheetjson CBSA_temp Area temp using "https://api.census.gov/data/2017/acs/acs1/profile?get=CBSA,NAME&for=metropolitan%20statistical%20area/micropolitan%20statistical%20area:*", showresponse
Code:
Response from server: [ [ "CBSA", "NAME", "metropolitan statistical area/micropolitan statistical area" ], [ "10140", "Aberdeen, WA Micro Area", "10140" ], [ "10180", "Abilene, TX Metro Area", "10180" ], ......
0 Response to A question on insheetjson - Keep getting "Invalid column name/selector" error message when using -insheetjson-
Post a Comment