Redash

接入教程

1. 在Redash设置中生成API密钥
2. 使用API密钥进行身份验证
3. 调用查询接口执行SQL查询
4. 通过仪表板API获取或更新面板
5. 使用Webhook接收查询结果通知
6. 自动化定期数据报告流程

使用Python获取查询结果

python

import requests

base_url = "https://api.example.com"
api_key = "YOUR_API_KEY"
query_id = 123

headers = {
    "Authorization": f"Key {api_key}",
    "Content-Type": "application/json"
}

# 获取查询结果
response = requests.get(f"{base_url}/api/queries/{query_id}/results", headers=headers)
if response.status_code == 200:
    data = response.json()
    print("Query results fetched successfully.")
else:
    print(f"Failed to fetch results: {response.status_code}")

使用PHP执行Redash查询

php

<?php
$base_url = 'https://api.example.com';
$api_key = 'YOUR_API_KEY';
$query_id = 123;

$headers = [
    'Authorization: Key ' . $api_key,
    'Content-Type: application/json'
];

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $base_url . '/api/queries/' . $query_id . '/results');
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$response = curl_exec($ch);
$http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);

if ($http_code == 200) {
    $data = json_decode($response, true);
    echo "Query results fetched successfully.\n";
} else {
    echo "Failed to fetch results: " . $http_code . "\n";
}
?>

使用JavaScript获取仪表板详情

javascript

const baseUrl = 'https://api.example.com';
const apiKey = 'YOUR_API_KEY';
const dashboardId = 456;

const headers = {
    'Authorization': `Key ${apiKey}`,
    'Content-Type': 'application/json'
};

fetch(`${baseUrl}/api/dashboards/${dashboardId}`, {
    method: 'GET',
    headers: headers
})
.then(response => {
    if (!response.ok) {
        throw new Error(`HTTP error! status: ${response.status}`);
    }
    return response.json();
})
.then(data => {
    console.log('Dashboard details fetched successfully.', data);
})
.catch(error => {
    console.error('Failed to fetch dashboard:', error);
});

常见问题

如何获取API密钥？

登录Redash平台后，进入个人设置页面，在API密钥部分可以生成或查看您的API密钥。请妥善保管，不要泄露给他人。

API请求频率是否有限制？

是的，Redash API通常设有速率限制以保护服务稳定性。具体限制取决于您的Redash实例配置，建议查阅官方文档或联系管理员了解详情。

API支持哪些数据格式？

Redash API主要支持JSON格式进行请求和响应。在请求头中设置'Content-Type: application/json'以确保正确通信。