OData Entity - Reporting | iTwin Platform

REST API Overview

Reference

Changelog

API Keys

Reporting

Download API definition:

OData Entity

GET https://api.bentley.com/insights/reporting/odata/{reportId}/{region}/{manifestId}/{entityType}

Lists the raw table data for a Report Entity.

Notes

This is an OData v4 compliant endpoint.

This endpoint should only be accessed using OData compliant libraries and tools such as Power BI.

Use of these endpoints directly is not prohibited, however we recommend understanding the OData protocols and conventions first.

Authentication

Requires Authorization header with one of schemes:

Valid API Key used as the password in Basic auth.
Valid Bearer token for scope itwin-platform.

Authorization

User must have insights_view permission(s) assigned at the Project level. iModel specific permissions may also be applied at the iModel level if iModel level permissions are enabled.

Alternatively the user should be an Organization Administrator for the Organization that owns a given Project or iModel.

An Organization Administrator must have at least one of the following roles assigned in User Management: Account Administrator, Co-Administrator, or CONNECT Services Administrator. For more information about User Management please visit our Bentley Communities Licensing, Cloud, and Web Services wiki page.

Rate limits

All iTwin Platform API operations have a rate limit. For more documentation on that visit Rate limits and quotas page.

Request

Request parameters

reportId

template

Yes

The Report Id.

region

template

Yes

NOTE: These parameters are not meant to be set manually. Instead use the URLs generated by the OData endpoint directly.

manifestId

template

Yes

NOTE: These parameters are not meant to be set manually. Instead use the URLs generated by the OData endpoint directly.

entityType

template

Yes

NOTE: These parameters are not meant to be set manually. Instead use the URLs generated by the OData endpoint directly.

Request headers

Authorization

Yes

OAuth access token with itwin-platform scope

Setting to application/vnd.bentley.itwin-platform.v1+json is recommended.

Response

Response 200 OK

Retrieved specified OData Entity successfully.

json

{
    "@odata.context": "https://api.bentley.com/insights/reporting/odata/b13596d1-a377-403b-a9b0-d1082b58a528/$metadata#EntityName",
    "value": [{
        "ECInstanceId": "0x20000003c47",
        "ECClassId": "ECClassId",
        "UserLabel": "UserLabel",
        "BBoxLow": "{\"x\":-0.022826467141817866,\"y\":-0.0898257099952467,\"z\":-0.44161943144956656}",
        "BBoxHigh": "{\"x\":0.28378143411477086,\"y\":0.19617697411669016,\"z\":0.5713601831727827}",
        "Code": "D-TERR-DNC",
        "CalculatedVolume": 3.4746110924076294,
        "CustomPrice": 10.851210441589027
    }],
    "@odata.nextLink": "https://api.bentley.com/insights/reporting/odata/b13596d1-a377-403b-a9b0-d1082b58a528/EUS/0a76cffd-7646-4dcb-877b-cb9e110f7f10/EntityName?sequence=1"
}

Response 401 Unauthorized

This response indicates that request lacks valid authentication credentials. Access token might not been provided, issued by the wrong issuer, does not have required scopes or request headers were malformed.

json

{
    "error": {
        "code": "HeaderNotFound",
        "message": "Header Authorization was not found in the request. Access denied."
    }
}

Response 404 Not Found

Specified Entity was not found.

json

{
    "error": {
        "code": "EntityNotFound",
        "message": "Requested Entity is not available."
    }
}

Response 429 Too many requests

This response indicates that the user has sent too many requests in a given amount of time.

json

{
    "error": {
        "code": "TooManyRequests",
        "message": "More requests were received than the subscription rate-limit allows."
    }
}

Response headers

retry-after

The number of requests exceeds the rate-limit for the client subscription.

Definitions

OData response

OData response.

TableSchema

@odata.context

Url

OData Schema

value

OData_Item[]

OData_Item

TableSchema

name

String

url

String

Error

Contains error information.

TableSchema

code

String

One of a server-defined set of error codes.

message

String

A human-readable representation of the error.

target

String

The target of the error.

Error Response

Gives details for an error that occurred while handling the request. Note that clients MUST NOT assume that every failed request will produce an object of this schema, or that all of the properties in the response will be non-null, as the error may have prevented this response from being constructed.

TableSchema

error

Error

Error information.