{"api_version":"2.0","authentication":{"header_format":"Authorization: Bearer <token>","login_endpoint":"/login","type":"JWT Bearer Token"},"endpoints":[{"endpoint":"/","function":"index","methods":["GET"]},{"endpoint":"/add/<table_name>","function":"add_record","methods":["POST"]},{"endpoint":"/admin","function":"admin_dashboard","methods":["GET"]},{"endpoint":"/admin/","function":"admin_dashboard","methods":["GET"]},{"endpoint":"/api/admin/download-hubs","function":"list_download_hubs_admin","methods":["GET"]},{"endpoint":"/api/admin/download-hubs","function":"create_download_hub","methods":["POST"]},{"endpoint":"/api/admin/download-hubs/<string:hub_id>","function":"update_download_hub","methods":["PUT"]},{"endpoint":"/api/admin/download-hubs/<string:hub_id>","function":"delete_download_hub","methods":["DELETE"]},{"endpoint":"/api/admin/zip-config","function":"get_zip_config","methods":["GET"]},{"endpoint":"/api/admin/zip-config","function":"update_zip_config","methods":["PUT"]},{"endpoint":"/api/docs","function":"api_documentation","methods":["GET"]},{"endpoint":"/api/download-hubs","function":"list_download_hubs_for_user","methods":["GET"]},{"endpoint":"/api/download-hubs/<string:hub_id>/download","function":"download_hub_file","methods":["GET"]},{"endpoint":"/api/permissions","function":"get_permissions","methods":["GET"]},{"endpoint":"/api/permissions","function":"update_permissions","methods":["PUT"]},{"endpoint":"/api/permissions/table/<table_name>","function":"check_table_permission","methods":["GET"]},{"endpoint":"/api/tables","function":"list_tables","methods":["GET"]},{"endpoint":"/api/tables","function":"add_table","methods":["POST"]},{"endpoint":"/api/tables/<string:table_name>","function":"get_table_info","methods":["GET"]},{"endpoint":"/api/tables/<string:table_name>","function":"update_table","methods":["PUT"]},{"endpoint":"/api/tables/<string:table_name>","function":"delete_table","methods":["DELETE"]},{"endpoint":"/api/users","function":"list_users","methods":["GET"]},{"endpoint":"/api/users/<int:user_id>","function":"delete_user","methods":["DELETE"]},{"endpoint":"/api/users/<int:user_id>/expiry","function":"update_user_expiry","methods":["PUT"]},{"endpoint":"/api/users/<int:user_id>/role","function":"update_user_role","methods":["PUT"]},{"endpoint":"/api/users/<int:user_id>/toggle-active","function":"toggle_user_active","methods":["PUT"]},{"endpoint":"/api/zip/head/create","function":"create_head_zip","methods":["POST"]},{"endpoint":"/api/zip/head/status","function":"get_head_zip_status","methods":["GET"]},{"endpoint":"/api/zip/options","function":"get_zip_options","methods":["GET"]},{"endpoint":"/apidocs/","function":"flasgger.apidocs","methods":["GET"]},{"endpoint":"/apidocs/index.html","function":"flasgger.<lambda>","methods":["GET"]},{"endpoint":"/apispec_1.json","function":"flasgger.apispec_1","methods":["GET"]},{"endpoint":"/check-version","function":"check_version","methods":["POST"]},{"endpoint":"/delete/<table_name>/<Stt>","function":"delete_record","methods":["DELETE"]},{"endpoint":"/download-hub","function":"download_hub_page","methods":["GET"]},{"endpoint":"/download-hub/","function":"download_hub_page","methods":["GET"]},{"endpoint":"/download/<folderName>/<stt>/<key>","function":"download_zip","methods":["GET"]},{"endpoint":"/download/browser","function":"download_browser","methods":["GET"]},{"endpoint":"/download/head","function":"download_head","methods":["POST"]},{"endpoint":"/download/headfolder","function":"download_folder","methods":["GET"]},{"endpoint":"/download/update","function":"download_update","methods":["GET"]},{"endpoint":"/flasgger_static/<path:filename>","function":"flasgger.static","methods":["GET"]},{"endpoint":"/getdatas","function":"get_datas","methods":["GET"]},{"endpoint":"/getdatasfromfile/<filename>","function":"get_datas_fromefile","methods":["GET"]},{"endpoint":"/getdatastatus/<table_name>/<status>","function":"get_data_status","methods":["GET"]},{"endpoint":"/getdatastt/<table_name>/<Sttacc>","function":"get_data_stt","methods":["GET"]},{"endpoint":"/health","function":"health_check","methods":["GET"]},{"endpoint":"/login","function":"login","methods":["GET","POST"]},{"endpoint":"/metrics","function":"metrics","methods":["GET"]},{"endpoint":"/oauth2-redirect.html","function":"flasgger.oauth_redirect","methods":["GET"]},{"endpoint":"/register","function":"register","methods":["POST"]},{"endpoint":"/register","function":"register_page","methods":["GET"]},{"endpoint":"/register/","function":"register_page","methods":["GET"]},{"endpoint":"/status","function":"server_status","methods":["GET"]},{"endpoint":"/test","function":"test999","methods":["GET"]},{"endpoint":"/update-data-multi/<table_name>/<column>/<value_old>/<value_new>","function":"update_data_multi","methods":["GET"]},{"endpoint":"/update-data/<table_name>/<column>/<Stt>","function":"update_data","methods":["PUT"]},{"endpoint":"/update-status/<table_name>/<Stt>","function":"update_status","methods":["PUT"]},{"endpoint":"/update/<table_name>/<Stt>","function":"update_record","methods":["PUT"]},{"endpoint":"/user/change-password","function":"change_password","methods":["PUT"]},{"endpoint":"/user/me","function":"get_current_user","methods":["GET"]}],"examples":{"get_data":{"description":"Get record by Stt number","headers":{"Authorization":"Bearer <token>"},"method":"GET","url":"/getdatastt/<table_name>/<Stt>"},"login":{"body":{"password":"your_password","username":"your_username"},"method":"POST","response":{"access_token":"jwt_token_here"},"url":"/login"}},"server_info":{"description":"RESTful API for MySQL database operations with JWT authentication","name":"MySQL API Server","uptime_seconds":92239},"useful_endpoints":{"health_check":"GET /health - Check if server is running (no auth)","login":"POST /login - Get JWT token","permissions":"GET /api/permissions - View table permissions (requires auth)","status":"GET /status - Detailed server status (requires auth)","user_download_hub":"GET /download-hub - User download portal","user_download_hubs_api":"GET /api/download-hubs - List active hubs for authenticated users"}}