You can translate the question and the replies:

Joining Census data with Azure dataverse data

Hi All, This is probably mainly to get pointed in the right direction. Here's the problem. I would like to be able to geocode addresses as they appear in the Address table. My idea is 1) Create a base view for the REST API from the census. The census one takes parameters in the url. IHere's the link, for reference. https://geocoding.geo.census.gov/geocoder/Geocoding_Services_API.pdf). I think that can be done, but I"m not sure if I need VQL for that. 2) Join that view with the Address table in the dataverse. There seem to be a variety of ways to do that. - Create another base view and create a derived view. - Put a trigger on the Address table and query the Denodo view when changes occur to the Address table. - Other things that I haven't thought of. What I would like to end up with is a live geocoding system to replace our current daily updates. I would be interested in any tips on using API base views with parameters (first time for me) or any general comments on whether this is the best approach to joining these resources with Denodo.
user
02-08-2021 15:22:04 -0400

2 Answers

Hi, I would start by bringing in the API as a data source. For a walk through of how to work with web API’s, please check out the [Import a REST Web Services using Virtual DataPort](https://www.youtube.com/watch?v=QgydTfkt-84) video. Also please checkout either the [JSON Sources](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources) and [XML Sources](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/xml_sources/xml_sources) sections for more information on how to work with XML and JSON. I would use a join in this situation especially if the base view of the Azure data source has columns that match the parameters for the API. In this situation, I can use the column values as input variables to make calls to the API. For more information on joins in Denodo please check out the section [Creating Join Views](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/creating_join_views/creating_join_views) in the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
 Edited on: 04-08-2021 18:42:30 -0400
Thank you. I'll give those a look.
user
04-08-2021 13:11:12 -0400
You must sign in to add an answer. If you do not have an account, you can register here