import requests import json creds = {'username': 'Fallahi.hamed@gmail.com', 'password': 'r5kivS&JR4d2BfUaS95xCDY^NxX*'} s = requests.Session() r = s.post('https://metabase.ekeepa-dev.ir/api/session', json=creds) query_sql = "SELECT * FROM rooms WHERE id = 10661311" res = s.post('https://metabase.ekeepa-dev.ir/api/dataset', json={ 'database': 2, 'type': 'native', 'native': {'query': query_sql} }) data = res.json() print("Error:", data.get('error')) if 'data' in data: cols = [c['name'] for c in data['data']['cols']] rows = data['data']['rows'] print("Cols count:", len(cols)) print("Rows count:", len(rows)) if rows: row_dict = dict(zip(cols, rows[0])) for k, v in row_dict.items(): print(f"{k}: {v}")