API data integration and REST connectivity

[jonpspri]

Priority: Phase 3 - Advanced Features
Roadmap Phase: v1.3.0

Description

Add REST API connectivity for data integration from external sources.

Tasks

• REST API connectivity with authentication
• JSON feeds and webhook support
• API session management with request history
• Core API operations: connect_api, fetch_data_from_api
• API tools: list_api_endpoints, describe_api_schema, export_to_api

Context

Expand DataBeak beyond file-based data sources to include live API data integration.

Implementation Notes

• Build APISession type for request history and authentication
• Support common authentication methods (API keys, OAuth, etc.)
• Implement data fetching from JSON APIs and webhooks
• Add schema discovery for API endpoints

Success Criteria

• Connect to and fetch data from REST APIs
• Handle authentication and rate limiting
• Convert API responses to DataFrame format
• Export data back to API endpoints