Extract/Export metadata information of entire DOMO App/Dashboard in Json/XML etc file format

ravi_kapoor

I created an entire App/Dashboard end to end having lots of widgets including texts, images, layout, text, cards for visualising a particular dataset which I have created say using Database Connector/File upload

What I want to extract/export the entire Dashboard metadata out of DOMO in some file format being it in Json/XML etc.

For example metadata about the cards imported, the connector metadata details like hostname, username, password, sql query used to fetch the data from connector/table name from which data is fetched.

Metadata information about the entire layout say no of tabs, colour/text/headers used in the button etc.

Can you please tell me is there any way say REST Apis calls as I can see a few are there to export/extract the end to end dashboard page content?

ArborRose

Hopefully I can provide enough to get your started. If I were using Python, I would start with authenticating with the Domo API. Get a client id and secret id through the developer portal.

import requests
Replace with your actual client ID and secret
client_id = 'YOUR_CLIENT_ID'

client_secret = 'YOUR_CLIENT_SECRET'
Get an access token
auth_url = 'https://api.domo.com/oauth/token'

auth_response = requests.post(auth_url, data={

'grant_type': 'client_credentials',

'scope': 'data user'

}, auth=(client_id, client_secret))
access_token = auth_response.json()['access_token']

Retrieve dashboard metadata something like this:

Replace with your actual dashboard ID
dashboard_id = 'YOUR_DASHBOARD_ID'

dashboard_url = f'https://api.domo.com/v1/pages/{dashboard_id}'
headers = {

'Authorization': f'Bearer {access_token}'

}
dashboard_response = requests.get(dashboard_url, headers=headers)

dashboard_metadata = dashboard_response.json()

And card metadata something like this:

cards_metadata = []
for card in dashboard_metadata['cards']:

card_id = card['id']

card_url = f'https://api.domo.com/v1/cards/{card_id}'

card_response = requests.get(card_url, headers=headers)

card_metadata = card_response.json()

cards_metadata.append(card_metadata)

And dataset metadata something like this:

datasets_metadata = []
for card in cards_metadata:

for dataset in card['datasources']:

dataset_id = dataset['dataSourceId']

dataset_url = f'https://api.domo.com/v1/datasets/{dataset_id}'

dataset_response = requests.get(dataset_url, headers=headers)

dataset_metadata = dataset_response.json()

datasets_metadata.append(dataset_metadata)

And collect the metadata in JSON or XML format something like this:

import json
Export to JSON
with open('dashboard_metadata.json', 'w') as json_file:

json.dump({

'dashboard': dashboard_metadata,

'cards': cards_metadata,

'datasets': datasets_metadata

}, json_file, indent=4)
If you need XML, you can convert JSON to XML using a library like dicttoxml
from dicttoxml import dicttoxml
xml_data = dicttoxml({

'dashboard': dashboard_metadata,

'cards': cards_metadata,

'datasets': datasets_metadata

})
with open('dashboard_metadata.xml', 'wb') as xml_file:

xml_file.write(xml_data)