1. Business Intelligence Connector
  2. Business Intelligence Connector Advanced Functions
  3. Viewing Your OData Resource Data in a Web Browser

Viewing Your OData Resource Data in a Web Browser

Note:

The functionality described in this topic requires the following feature and role permission. For more information about the features enabled for your OpenAir account or about your role permissions, contact your account administrator.

  • Feature: Business Intelligence Connector

  • Role permission: Publish reports

The published resource data in your OpenAir OData feed is available as a JSON string. JSON (JavaScript Object Notation) is a lightweight data-interchange format which is self-describing and easy to understand.

You can enter the URL to your OData resource in the address bar of your browser and read your published OpenAir resource data in your web browser.

To view your OData resource data in a web browser:

  1. Enter the URL for the OData resource you want to access. The Authentication required popup window appears.

    Note:

    For more information about OData resources URLs, see Your OData Feed URL and Connection Details. For example, to access the data for the published report with resource name report54, use the following URL:

    https://<account-domain>/odata/v4/reports/report54

  2. Enter your OData feed User name and your OpenAir password, then click Log in.

    Note:

    Remember, your OData feed user name contains your OpenAir Company ID and User ID, separated by a back slash: <CompanyID>\<UserID>

    Example of an authentication popup window on a web browser

  3. Your data appears as a JSON string in your browser. For more information about the JSON object and its properties, see OData Response.

    Tip:

    You can use a browser extension to change the way your browser displays the JSON string. Instead of displaying the JSON string as plain text, your browser will display the JSON in a way that is much easier to read. Search for “JSON viewer” browser extensions. Refer to your browser documentation for information about adding browser extensions.

    Data in JSON format as shown using a JSON viewer browser extension.

    If a published report is refreshed while you are reading or paging through the published report in your browser, the OData feed returns a 410 Gone HTTP status error with the message "Report has been republished. You need to reload the report.".

    410 Gone HTTP error shown in a browser when a published report is refreshed while the browser retrieves the published report.

Related Topics: