...
When accessing ODATA, first test Microsoft Excel using the ODATA v4 endpoint. Connecting to ODATA may require your network administrators to allow the connection.
...
ODATA URL format:
ODATA v2: https://odata-<environment>.<customer>.moventus.com/odata/api2
ODATA v4: https://odata-<environment>.<customer>.moventus.com/odata/api4
ADVANCED Endpoint for custom queries created in Rego OData Extension object: https://odata-<environment>.<customer>.moventus.com/odata/ppmapi
...
When accessing the custom ODATA extension queries, please note the change in the URL to add /ppmapi. Please confirm your connectivity success to the standard ODATA tables before attempting to connect to the custom ODATA extension queries.
ADVANCED Endpoint for custom queries created in Rego OData Extension object: https://odata-<environment>.<customer>.moventus.com/odata/ppmapi
Example of the results available in a 3rd party ODATA client:
...
TROUBLESHOOTING
Connectivity:
When accessing ODATA, always test connectivity with Microsoft Excel to the ODATA v4 endpoint. If the connection works in Excel but not other tools, please contract the 3rd party developer for support of their tool. Rego technical troubleshooting support is provided exclusively for connections from Microsoft Excel to ODATA v4 as a baseline. Connecting to ODATA may require your network administrators to allow the connection through your VPN or firewall, contact your internal network team for connectivity support.
Caching:
ODATA connections are cached by Microsoft Excel and other products. When encountering authentication or other unexpected errors, clear the caches then recreate the connection. In Microsoft Excel, the cache of connections us under Data > Get Data > Data Source Settings. Delete cached connections and recreate the ODATA feed connection.
Errors:
“Unable to resolve the type name <TableName> to an EdmType”. This error indicates a problem connecting to the base endpoint. Always setup ODATA feed connections to connect to the base URL endpoint such as /api2, /api4, or /ppmapi. Do not configure ODATA feed URLs to connect directly to a table, such as /ppmapi/TableName. If you encounter the EdmType error, delete the cached connections in Microsoft Excel and recreate the connection using the base URL endpoint.