How to pull data in DOMO from an API endpoint

Hi,
We have a usecase where we want to pull calculated values (and not persisted database values) by an external system into DOMO. The calculated value is not persisted in the external SQL system and DOMO cannot do the calculation using raw data. Eg. we want to pull effective price of items where the prices are a complex calculation handled by this external system.
In our case, this external system exposes an endpoint to return calculated values.
Does DOMO has a connector which can pull data from an API endpoint?
Are there any other design patterns to consider?
Thanks
Best Answers
-
Hi @PD ,
If the calculation is a field in the API, then Domo can pull it. So yeah I'd do all your complex calculations upstream and then pull in that field into Domo using the JSON API connector.
Let me know if that makes sense
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
There's several different JSON connectors you can use to connect to the API depending on your authentication method (assuming your endpoint uses JSON). These KB articles may be helpful for your use case.
Basic JSON
JSON Connector with Custom Parsing
JSON Advanced Connector:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi @PD
If you have a complex requirements & an external system not listed as connector in Domo and nothing works, then I suggest you try Jupyter Workspace. It has super flexibility with python in terms of fetching data, transformation and you can do anything you want.
Thanks!
0
Answers
-
Hi @PD ,
If the calculation is a field in the API, then Domo can pull it. So yeah I'd do all your complex calculations upstream and then pull in that field into Domo using the JSON API connector.
Let me know if that makes sense
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
Thanks @DashboardDude . Can you give me an example of a connector or an approach to do this?
0 -
There's several different JSON connectors you can use to connect to the API depending on your authentication method (assuming your endpoint uses JSON). These KB articles may be helpful for your use case.
Basic JSON
JSON Connector with Custom Parsing
JSON Advanced Connector:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi @PD
If you have a complex requirements & an external system not listed as connector in Domo and nothing works, then I suggest you try Jupyter Workspace. It has super flexibility with python in terms of fetching data, transformation and you can do anything you want.
Thanks!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive