anyone pulling statistics from STatCan (Canada Statistics) ?
They have some APIs but I cannot get them to work with Domo... I am hoping someone else has already invented the wheel.
https://www.statcan.gc.ca/eng/developers
Comments
-
Hi @WHM,
While I don't know if someone has already created a connector, or a way to connect to their API (We can leave that to the rest of the community to answer), I do know there are users who are pulling in this data via the File Upload connector or Via Workbench using Canada Stat's Delta File. https://www.statcan.gc.ca/eng/developers/df
It looks like it's just a large compilation of the data for the day. It does require a bit of manual work to download the file of course, but it will get it in DOMO for you.
0 -
Thanks @Jarvis !
I downloaded some of their entire datasets but I need an automated way to get the data into Domo. The zip files are just a pain. They seem to provide almost enough information. I got some of the APIs to return data but I could not find all the information about their dataset needed to loop through and get all the data. The answer may be to pull the whole thing as a zipped CSV and then load updates. You get the product id but not the vector or not the coordinate. There is probably some combination of steps to get the information about the datasets then pull in the changes but I have spent hours reading their web page and have not found it yet.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive