python - 将CKAN Data API加载到SSMS中(Load CKAN Data API into SSMS)

Question

Not very familiar with accessing APIs,

(对访问API不太熟悉，)

This dataset has the an API page below: https://data.gov.au/data/api/1/util/snippet/api_info.html?resource_id=cb7e4eb5-ed46-4c6c-97a0-4532f4479b7d#collapse-endpoints

(该数据集的API页面如下： https : //data.gov.au/data/api/1/util/snippet/api_info.html?resource_id=cb7e4eb5-ed46-4c6c-97a0-4532f4479b7d#collapse-endpoints)

This is what the dataet looks like: Company Report

(数据集如下所示： 公司报告)

Is it possible to use SSMS to connect to this table?

(是否可以使用SSMS连接到此表？)

On the page it says I can do SQL queries, So I wanted to do the following query

(在页面上说我可以执行SQL查询，所以我想执行以下查询)

SELECT * 
FROM "cb7e4eb5-ed46-4c6c-97a0-4532f4479b7d"
WHERE 'Date of Registration' > '01/11/2019'

So I use the following URL: https://data.gov.au/data/api/3/action/datastore_search_sql?sql=SELECT * from "cb7e4eb5-ed46-4c6c-97a0-4532f4479b7d" WHERE 'Date of Registration' > '01/11/2019'

(因此，我使用以下URL： https : //data.gov.au/data/api/3/action/datastore_search_sql?sql=SELECT * from“ cb7e4eb5-ed46-4c6c-97a0-4532f4479b7d”在“注册日期”> '01 / 11/2019')

Which converts to:

(转换为：)

https://data.gov.au/data/api/3/action/datastore_search_sql?sql=SELECT%20*%20from%20%22cb7e4eb5-ed46-4c6c-97a0-4532f4479b7d%22%20WHERE%20%27Date%20of%20Registration%27%20%3E%20%2701/11/2019%27

(https://data.gov.au/data/api/3/action/datastore_search_sql?sql=SELECT%20*%20from%20%22cb7e4eb5-ed46-4c6c-97a0-4532f4479b7d%22%20WHERE%20%27Date%20of ％20注册％27％20％3E％20％2701/11/2019％27)

I'm getting a bad gateway error: HTTP Error 502: Bad Gateway

(我收到了错误的网关错误：HTTP错误502：错误的网关)

  ask by Haki Red translate from so

Answer 1

等待大神答复