You can translate the question and the replies:

Making an API call to a external data set

I want to read data from the US Census Bureau public data set files. The data is available (for free) via an API call to their site. I would like to use Denodo to access that data via the API. How do I do this? Example Call: api.census.gov/data/2015/acs1/cprofile?get=CP05_2015_001E&for=state:*&key=... Ideally "US Census Bureau" (api.census.gov/data) would be the data source and each API call to a dataset would be a Base View (api.census.gov/data/2015/acs1/cprofile?get=CP05_2015_001E) Any help here to understand this will be appreciated.
user
21-07-2017 02:06:09 -0400
code

1 Answer

Hi, I tried the same and I was able to call the data set. Please follow the steps below. 1. Create a new JSON datasource and select the Data Route as “HTTP Client” 2. Select HTTP Method as “GET”, give the URL and save the datasource. You can also create the datasource by using an interpolation variable in the URL in the following way: a. "api.census.gov/data/2015/acs1/cprofile?get=**@{profile_input}**&for=state:*&key=". By doing that, you must fill the variable "profile_input" when executing the created base view. 3. Create a baseview and do a Flatten operation on top of the base view. 4. Now when you execute the flattened view you will be able to see the data set. To know more about JSON data sources, please read [“JSON Sources”](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/json_sources#json-sources) of the Virtual DataPort Administration Guide. Hope this helps.
Denodo Team
24-07-2017 09:25:19 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here