backend/SQL_Agent/testApiDS.py

import requests
import json

# --- THE FIX IS HERE: Added /my-tenant ---
API_URL = "http://127.0.0.1:8000/api/v1/data-sources/my-tenant/list"
TENANT_ID = "e00225ae-e5c6-4a50-b633-801c824d7e19"

# Your JWT Token
JWT_TOKEN = (
    "eyJhbGciOiJIUzI1NiIsImtpZCI6IjRBblRaQWJMdFl4Z1hTVkwiLCJ0eXAiOiJKV1QifQ."
    "eyJpc3MiOiJodHRwczovL21iZGJucXliY2pmeXpvZHF3cHV6LnN1cGFiYXNlLmNvL2F1dGgvdjEiLCJzdWIiOiJkMmIzZGU0MS1kYzk5LTRjMzItOWE0Ni0xM2JiYTlmYzQ2YWQiLCJhdWQiOiJhdXRoZW50aWNhdGVkIiwiZXhwIjoxNzcwMzgxOTcwLCJpYXQiOjE3NzAzNzgzNzAsImVtYWlsIjoicmFuaWxtdWtlc2htai50cnNAZ21haWwuY29tIiwicGhvbmUiOiIiLCJhcHBfbWV0YWRhdGEiOnsicHJvdmlkZXIiOiJlbWFpbCIsInByb3ZpZGVycyI6WyJlbWFpbCJdfSwidXNlcl9tZXRhZGF0YSI6eyJhYm91dCI6IlJhbmlsIFRSUyIsImNvbXBhbnkiOiJSYW5pbCBUUlMiLCJkZXBhcnRtZW50IjoiUmFuaWwgVFJTIiwiZW1haWwiOiJyYW5pbG11a2VzaG1qLnRyc0BnbWFpbC5jb20iLCJlbWFpbF92ZXJpZmllZCI6dHJ1ZSwiZnVsbF9uYW1lIjoiUmFuaWwgVFJTIiwibG9jYXRpb24iOiJSYW5pbCBUUlMiLCJtb2JpbGUiOiI5ODc2NTQzMzIxIiwicGhvbmUiOiI5ODc2NTQzMzIxIiwicGhvbmVfdmVyaWZpZWQiOmZhbHNlLCJwbGFuIjoiU3RhcnRlciIsInJvbGUiOiJURU5BTlRfQURNSU4iLCJzdWIiOiJkMmIzZGU0MS1kYzk5LTRjMzItOWE0Ni0xM2JiYTlmYzQ2YWQiLCJ0ZW5hbnRfaWQiOiJlMDAyMjVhZS1lNWM2LTRhNTAtYjYzMy04MDFjODI0ZDdlMTkiLCJ0aXRsZSI6IlJhbmlsIFRSUyJ9LCJyb2xlIjoiYXV0aGVudGljYXRlZCIsImFhbCI6ImFhbDEiLCJhbXIiOlt7Im1ldGhvZCI6InBhc3N3b3JkIiwidGltZXN0YW1wIjoxNzY3Nzc5NDE4fV0sInNlc3Npb25faWQiOiJjMWI2NGEwNS0yZjM4LTQzM2UtYmJiMS03NzkwNmFhYzc1NDciLCJpc19hbm9ueW1vdXMiOmZhbHNlfQ."
    "Q6hxd15RXy86SX0i73NQ9fLlAeGJgRZtIOIX_UZaWVA"
)

def check_data_sources():
    print(f"Testing connectivity to: {API_URL}")
    print(f"Target Tenant ID: {TENANT_ID}")
    
    headers = {
        "Authorization": f"Bearer {JWT_TOKEN}",
        "Content-Type": "application/json"
    }

    try:
        response = requests.get(API_URL, headers=headers, timeout=10)
        
        print("\n" + "="*40)
        print(f"STATUS CODE: {response.status_code}")
        print("="*40)

        if response.status_code == 200:
            print("✅ SUCCESS! The API is reachable.")
            print(json.dumps(response.json(), indent=4))
        else:
            print("❌ REQUEST FAILED")
            print("Response:", response.text)

    except Exception as e:
        print(f"\n❌ UNEXPECTED ERROR: {e}")

if __name__ == "__main__":
    check_data_sources()