---
agentTools:
  projectIndex: https://openasapp.readme.io/llms.txt
---

# /webServices/tunnel

Connect your apps to a custom external web service, including the possibility to return user-specific data.

Set the `spreadsheet URL` of your app to this URL to make the app load its Excel file from a custom web service of yours. Allows to build apps loading their data dynamically from a web service instead of a static Excel file.

The web service is invoked with an ordinary `HTTP GET` call and is expected to return a binary `XLSX` file.

The web service is provided with a `X-OAA-USER-IDENTITY` header containing a token which can be used with the [/webServices/validateUserIdentity](https://openasapp.readme.io/reference/webservices-validateuseridentity) endpoint to obtain information about the calling user's identity. Enables the web service to return user-specific data, enabling us to build apps presenting their users with their very own user-specific custom-tailored data.

[block:callout]
{
  "type": "info",
  "title": "Try it!",
  "body": "You can easily test your web service by invoking it with the *Try it* button in the right panel. Simply provide your user name and password when prompted and the tunnel will provide your web service with a corresponding `X-OAA-USER-IDENTITY` token."
}
[/block]

[block:callout]
{
  "type": "info",
  "title": "Looking for a way to test and debug your web services locally?",
  "body": "Have a look at [ngrok](https://ngrok.com) for tunneling requests to localhost!"
}
[/block]

# OpenAPI definition

```json
{
  "openapi": "3.1.0",
  "info": {
    "title": "Production (Basic Auth)",
    "version": "1.0"
  },
  "servers": [
    {
      "url": "https://api.openasapp.net"
    }
  ],
  "components": {
    "securitySchemes": {
      "sec0": {
        "type": "http",
        "scheme": "basic"
      }
    }
  },
  "security": [
    {
      "sec0": []
    }
  ],
  "paths": {
    "/v1/api/webServices/tunnel": {
      "get": {
        "summary": "/webServices/tunnel",
        "description": "Connect your apps to a custom external web service, including the possibility to return user-specific data.",
        "operationId": "webservices-tunnel",
        "parameters": [
          {
            "name": "webService",
            "in": "query",
            "description": "URL of a web service generating an Excel file",
            "required": true,
            "schema": {
              "type": "string"
            }
          }
        ],
        "deprecated": false
      }
    }
  },
  "x-readme": {
    "headers": [],
    "explorer-enabled": true,
    "proxy-enabled": true
  },
  "x-readme-fauxas": true,
  "_id": "59cb0dd807ce0c002618e686:59c33fc3c99a7d0010b4822c"
}
```