Skip to Content
-4

JSON From URL into SAP HANA Table

Nov 17, 2017 at 01:57 AM

124

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.

1

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.

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

1 Answer

ERALPER YILMAZ Nov 17, 2017 at 07:32 AM
0

Hello,

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

Venkat

0
1

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

0

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

0