Fetching data from Odata or RESTful API to SAP HANA cloud

Dear Community,

Could you please shed light on how to fetch Odata or data from RESTful API (e.g. JSON format) to SAP HANA cloud database? Is it possible without external helpers, or with little manual coding? For instance, when we create an http destination in BTP, would it be possible to use it to load data into Document Store, then convert the JSON files to tabular data?

Many thanks in advance for your insights!

Best regards,

Zhiyi Tang