Create a JSON API with Domo

Brodie_Sky

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.

GrantSmith

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?

MattTheGuru

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

GrantSmith

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?

Brodie_Sky

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.

GrantSmith

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.

MattTheGuru

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