Parse json returned from button click action and open url

[lobell88]

Dear All,

I call SAP from QlikView: the user clicks a button, triggers a REST call to SAP, hands over an ID.

SAP looks up a related document for the ID and an ODATA service returns a json with a link to the archive, where the document is located.

The JSON contains the archive like so:

{

    "d": {

        "ArcDocId": "0050569FD7071FD184C44949D0034000",

        "Href": "https:PATH_OF_MY_FILE_DOWNLOAD",

        "__metadata": {

            "id": "XXXX",

            "type": "XXXX",

            "uri": "XXXXX"

        },

        "Ea": "",

        "Name": " -"

    }

How can I call the URL from the json when it is returned to me?

At present, my "finished" product ist my browser dislaying the jsoon to me, I need to take one more step and resolve and access the url. How?

Many thanks,

Bastian