请问doris可以支持api作为数据源吗

[Aresd1286729639]

如果想要实现这个功能，需要有多大改动

[morningman]

Hi there, thanks for your question.

Currently, Apache Doris supports accessing API data sources via the HTTP Table-Valued Function (TVF)(https://doris.apache.org/docs/4.x/sql-manual/sql-functions/table-valued-functions/http). This feature allows you to query HTTP-based data directly.

Regarding the implementation effort, you can refer to the relevant PRs (#57242) that introduced this feature for technical details and development guidance. If you have specific requirements or improvements in mind, we would greatly appreciate your contributions!

[Aresd1286729639]

Hello, if I want to access the OAuth2 API just like accessing a MySQL table and support federated queries between MySQL and the API, can Doris support this? If modification is needed, how much change is required?

[morningman]

You can refer to the PR mentioned in the previous comment to understand the general implementation workflow. Building OAuth2 support on top of the existing HTTP TVF should be relatively straightforward.