Skip to Content
-4

JSON From URL into SAP HANA Table

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

Add comment
10|10000 characters needed 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.

  • 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.

  • Get RSS Feed

1 Answer

  • Nov 17, 2017 at 07:32 AM

    Hello,

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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