Building Superset REST API Connector with Bearer Token Authentication

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

User seeks guidance on implementing a Superset REST API connector in Airbyte that utilizes bearer token authentication, including a Python code snippet for reference.


Question

Hello guys i am trying to build the superset rest api as a connector, it has bearer token authentication where it will get the bearer token through username and password and attaching python code for the reference . how can i achieve this through ui in airbyte. can anyone please guide me on this just an idea on how to achieve this or any simple solution
import requests
import json

def get_dataset_data(dataset_id):
base_url = “base_url”

# 1. Login to get token
login_url = f"{base_url}/api/v1/security/login"
login_data = {
    "username": "username",
    "password": "password",
    "provider": "db"
}

session = requests.Session()
login_response = <http://session.post|session.post>(login_url, json=login_data)
token = login_response.json().get('access_token')

# 2. Setup headers
headers = {
    'Authorization': f'Bearer {token}',
    'Content-Type': 'application/json'
}

# 3. Simple query payload for all data from dataset
# 2. Modified payload with required query parameters
payload = {
    "datasource": {
        "id": dataset_id,
        "type": "table"
    },
    "force": False,
    "queries": [{
        "columns": ["created_at"],  # Select all columns
        # "metrics": ["count(*)"],  # At least one metric is usually required
        "row_limit": 1000,
        "filters": [],
        "orderby": []
    }]
}

# 4. Make the request
response = <http://requests.post|requests.post>(
    f"{base_url}/api/v1/chart/data",
    headers=headers,
    json=payload
)

print("Response:", json.dumps(response.json(), indent=2))
return response.json()

Usage

dataset_id = 60 # Replace with your actual dataset ID
result = get_dataset_data(dataset_id)
Can anyone help me with this


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

['superset', 'rest-api', 'bearer-token', 'authentication', 'airbyte-connector']