ehsan-dashboards/dashboards/check_10661311_fields.py

19 lines
493 B
Python

import requests
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 id, name, status, deleted_at, is_thrill, is_experience
FROM v_rooms
WHERE id = 10661311;
"""
res = s.post('https://metabase.ekeepa-dev.ir/api/dataset', json={
'database': 2,
'type': 'native',
'native': {'query': query_sql}
})
print(res.json()['data'])