JSON From URL into SAP HANA Table

[former_member407075]

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

[lbreddemann]

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.

[former_member135528]

Hello Floks,

I do have the same requirement. can someone help me on how can get the URL JSON output data into sap hana in columnar table format.

Regards,

VaraPrasad.

[eralper_yilmaz]

Hello,

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

[former_member407075]

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

Thanks

Venkat

[draschke]

search for JSON_QUERY

https://open.sap.com/files/afc84048-e59f-4df9-8ea6-b6a04596187e

[former_member407075]

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

[eralper_yilmaz]

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