New to Domo Developer
Hello, Experts,
Excuse me for being naive. I am a python developer and I am looking for a way to integrate data from an API that was built in the 16th century (sarcasm).
The API allows for GET/POST/UPDATE/DELETE via RESTful API libraries but the responses come back as XML (hence 16th century). How the data is structured is horrible, you have to iterate through an unknown amount of pages to get child data so you can then use that child data to relate to other endpoints.
As many of you know, in any programming language you could create logic that will allow you to grab data, transform it and then ship it to some sort of database or data store for you to consume. I am trying to avoid building an app to then have Domo pull in this data via a connector, however, it seems like that will not be the case.
What I have tried to do is create an advanced XML connection using basic HTTP authentication, which works, and pull the data in. However, since 100 records are displayed per page you have to query the request three times to get the child data I'm looking for. This is fine I would just create three separate data connectors.
However, when I need to relate that to other GET requests to bring down XML data for each ID (organization) I will need to do a separate request which in turn would be a new connection (right now that would be 230+ connections). As you can see this is not feasible, programmatically I would use a for loop to iterate through each response to pull data data as needed nightly and load to a database and then look to pump data up to Domo once I have it the way I want it.
My question before I go through developing a custom data connector in Domo is what I am trying to do possible? Can I code in Domo using Python or is it only JS?
Let me know your thoughts and do not hesitate to shoot questions my way. Thanks, folks!
-Isaiah Melendez
Comments
-
https://pypi.org/project/pydomo/
https://developer.domo.com/docs/dataset-api-reference/dataset
@imelendez you have a couple options.
1) use pydomo + request commands in a python library to develop a script that executes periodically (controlled locally on a VM or your desktop) that then pushes the data into domo via Domo's Dataset API (the pydomo library has that built in)
https://developer.domo.com/docs/custom-connectors/connector-dev-studio
2) build a custom app using javascript that would then be a 'normal connector' in the domo space. Depending on how familiar you are with Javascript, I think I'd go the second route just to have the confidence that Domo is handling all the automation.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive