Best Of

I'm not sure of the question.

A dataset in Domo is identifiable from its ID number. Open the dataset in Data and look at the URL. There will be a number there. That's the unique id for the dataset. Programmatically could access that data and pass it over to Oracle.

For Domo "token" information look for the pages on developer.Domo.com to create a client id with secret key.

Accessing depends upon the method/language. Javascript, Python? Something like this in Javascript:

const axios = require('axios');
// Domo API credentials

const clientId = 'your_client_id';

const clientSecret = 'your_client_secret';
// Base URL for Domo API

const baseURL = 'https://api.domo.com';
// Function to authenticate and get access token

async function authenticateAndGetToken() {

try {

const response = await axios.post(${baseURL}/oauth/token, {

grant_type: 'client_credentials',

client_id: clientId,

client_secret: clientSecret

});

return response.data.access_token;

} catch (error) {

console.error('Error authenticating with Domo API:', error);

throw error;

}

}
// Call the function to authenticate and get token

authenticateAndGetToken()

.then(token => {

console.log('Access token:', token);

// Proceed to next steps (retrieve dataset and export)

})

.catch(err => console.error('Error getting access token:', err));

And export it in javascript with something like this:

// Function to export dataset data

async function exportDataset(datasetId, accessToken, format) {

try {

const response = await axios.get(${baseURL}/v1/datasets/${datasetId}/data?format=${format}, {

headers: {

Authorization: Bearer ${accessToken}

}

});

return response.data;

} catch (error) {

console.error('Error exporting dataset:', error);

throw error;

}

}
// Usage example: Replace your_dataset_id with the actual dataset ID

const datasetId = 'your_dataset_id';

const exportFormat = 'csv'; // or 'json'
// Call the function to export dataset data

authenticateAndGetToken()

.then(token => {

return exportDataset(datasetId, token, exportFormat);

})

.then(data => {

console.log('Exported dataset:', data);

// Process or save the exported data as needed

})

.catch(err => console.error('Error exporting dataset:', err));

Using Python:

import requests
Domo API credentials
client_id = 'your_client_id'

client_secret = 'your_client_secret'
Base URL for Domo API
base_url = 'https://api.domo.com'
Function to authenticate and get access token
def authenticate_and_get_token():

url = f'{base_url}/oauth/token'

headers = {

'Content-Type': 'application/json'

}

data = {

'grant_type': 'client_credentials',

'client_id': client_id,

'client_secret': client_secret

}

response = requests.post(url, headers=headers, json=data)

response_data = response.json()

return response_data['access_token']
Get access token
access_token = authenticate_and_get_token()

print('Access token:', access_token)

Retrieve details:

Function to retrieve dataset details
def get_dataset_details(dataset_id, access_token):

url = f'{base_url}/v1/datasets/{dataset_id}'

headers = {

'Authorization': f'Bearer {access_token}'

}

response = requests.get(url, headers=headers)

return response.json()
Example usage: Replace your_dataset_id with the actual dataset ID
dataset_id = 'your_dataset_id'

dataset_details = get_dataset_details(dataset_id, access_token)

print('Dataset details:', dataset_details)

Export for import in Oracle:

Function to export dataset data
def export_dataset(dataset_id, access_token, format='csv'):

url = f'{base_url}/v1/datasets/{dataset_id}/data?format={format}'

headers = {

'Authorization': f'Bearer {access_token}'

}

response = requests.get(url, headers=headers)

return response.json()
Example usage: Replace your_dataset_id with the actual dataset ID
exported_data = export_dataset(dataset_id, access_token)

print('Exported dataset:', exported_data)
Example of exporting to CSV file (optional)
import csv
csv_file = 'exported_data.csv'

with open(csv_file, 'w', newline='') as f:

writer = csv.writer(f)

for row in exported_data['rows']:

writer.writerow(row)
print(f'Exported data saved to {csv_file}')