Create a JSON API with Domo

Brodie_Sky
Brodie_Sky Member
in APIs & Domo Developer

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.

Tagged:

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can leverage Domo's built in APIs to get data out of the system. You can reference https://developer.domo.com/portal/3989acf1bafff-import-and-export-data#export-data .

    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!**
  • MattTheGuru
    MattTheGuru Contributor
    Answer ✓

    @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!

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can leverage Domo's built in APIs to get data out of the system. You can reference https://developer.domo.com/portal/3989acf1bafff-import-and-export-data#export-data .

    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!**
  • Brodie_Sky
    Brodie_Sky Member

    I'd like to specifically control the structure of the JSON output.

    For instance, a format like this:

    image.png

    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.

  • GrantSmith
    GrantSmith Coach

    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!**
  • MattTheGuru
    MattTheGuru Contributor
    Answer ✓

    @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!

Categories