Skip to Content

JSON From URL into SAP HANA Table

Nov 17, 2017 at 01:57 AM


avatar image

Hi All

I'm trying read the data from a URL in JSON Format and load into SAP HANA Table..

Any suggestions as how to go about this

Thanks in advance

Venkat G

10 |10000 characters needed characters left characters exceeded

Ok, just as anyone else in the community, you are expected to not simply drop your requirement and have others do your work.

Instead, explain what you have tried so far, what problems you have and show the code you have.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

ERALPER YILMAZ Nov 17, 2017 at 07:32 AM


With HANA 2.0 you have the option of using JSON_QUERY to parse json data into tabular format

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Hi -Can you please me to some sort of documentation please




Thanks to pointing out that ..I need to read it from an URL and load into table to use JSON_QUERY..I'm having problems getting into the database


Maybe you can call URL on the application level and fetch JSON data, then pass it as string parameter value into a stored procedure. There you can execute JSON_QUERY commands for parsing and processing resultant data