Create a JSON API with Domo
Has anyone had any success in using Domo to build an API for external system to connect to receive structured JSON data?
The JSON writeback connector KIND OF handles the PUSH component, but it is severely limited by its 100 row output limitation.
And for GET requests, it seems the Domo API outputs data in its own format and there is no way to control the structure of this output.
Has anyone maybe used some kind of custom scripting within Domo to build an API server of sorts?
Any feedback welcome.
Best Answers
-
You can leverage Domo's built in APIs to get data out of the system. You can reference
.Is there a specific format you need besides an array of rows that Domo's Data API provides?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@Brodie_Sky what you may be hoping to accomplish can be done with what is called a "serverless function".
If you just create a simple server somewhere else you can restructure the data to be in that format, but no you cannot request the data to be directly sent from the Domo API in a specific way like you can do with something like GraphQL.** Was this post helpful? Click 💡/💖/👍/😊 below. **
** If it solved your problem. Accept it as a solution! ✔️ **
Or do you need more help? https://calendly.com/matthew-kastner/15-minute-chat
Did I help you out? Feedback is priceless and will help me more than you know.Write a review!0
Answers
-
You can leverage Domo's built in APIs to get data out of the system. You can reference
.Is there a specific format you need besides an array of rows that Domo's Data API provides?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I'd like to specifically control the structure of the JSON output.
For instance, a format like this:From what I can see and from what I've been told by the Domo consultants we are working with, there is no way to control the output from the Domo API to achieve a structure like this. I want to be sure we are not missing something.
0 -
A list of dictionaries is how the Domo Data API returns the data so you should be able to get that format from the API.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@Brodie_Sky what you may be hoping to accomplish can be done with what is called a "serverless function".
If you just create a simple server somewhere else you can restructure the data to be in that format, but no you cannot request the data to be directly sent from the Domo API in a specific way like you can do with something like GraphQL.** Was this post helpful? Click 💡/💖/👍/😊 below. **
** If it solved your problem. Accept it as a solution! ✔️ **
Or do you need more help? https://calendly.com/matthew-kastner/15-minute-chat
Did I help you out? Feedback is priceless and will help me more than you know.Write a review!0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive