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.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive