Metadata Automation
Hi there, I'm looking to automate dimension uploads in that I want the dimension to be "replaced" with the new one that I am loading. I want to reduce the burden of having to add or remove members from dimension and just automate that process. How can this be done and where should I start? Thank you in advance, Joesef
API broke after Upgrade to 8.2.2
Hello! We are using the OS API to pull data to ADF using data connectors and cube views. This has been working fine until we upgraded to 8.2.2 a few weeks ago. Here's the error I'm getting in ADF. Our URL actually didn't change. Has anyone seen this or know how to fix it? THANKS IN ADVANCE! Operation on target Copy Actuals from HTTP Endpoint failed: ErrorCode=HttpRequestFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with client error, status code 400 BadRequest, please check your activity settings. If you configured a baseUrl that includes path, please make sure it ends with '/'. Request URL: https://xxx.onestreamcloud.com/onestreamapi/api/DataProvider/GetAdoDataSetForAdapter?api-version=5.2.0/.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (400) Bad Request.,Source=System,'
Unexpected error in REST API: Unable to create database connection. There is no open application
I'm trying to run cubeviews by way of the REST api onVersion: 8.2.2.16127 We use PAT tokens for a native onestream user. Suddenly I started receiving meaningless errors about a day ago like so: "An error occurred returning data for 'Cube View RPT_SVC_PbopHierarchyBase', Please check the Error Log for more details. Unable to create database connection. There is no open application" Does anyone know what this means? Is it a bug? Any help would be appreciated.REST API data push into OneStream. How can we create a custom response back to the calling system
Another system on the network is pushing data into OneStream using a REST API. OneStream has a DataManagement group and a step to absorb this data. Is there a way we can pass back a custom response to the calling system? Thank You for all your help in advance. InduREST api and breaking changes for authentication in v8
We have been using the onestream REST api for a couple years now. In the past we had been using Open-ID-connect (OIDC) to authenticate against an Azure AD ("Entra") directory, and then generate reports from cubeviews or data adapters. During our current upgrade to v8, we started receiving lots of mixed messages from onestream employees about whether OpenID is still supported. I'm assuming that the OS support team knows what they are talking about, but it seems to contradict the docs in substantial ways. Moreover, it contradicts common sense. What they are telling me is that in the "hosted" version of Onestream v8 on Azure, we are NO LONGER allowed to use OIDC to authenticate a service principal (app registration) and connect to the REST api. Instead, they are saying that a new engineering team at onestream (called "OIS" team?) have rebuilt the authentication layers and they removed OIDC support in favor of PAT tokens. Supposedly the PAT tokens are the only way to use the REST api in onestream going forward. This seems to be a massive step backwards - we lose our ability to connect with a normal service principal from Entra ID, and we must start using a custom login that originates in onestream (one that will not have consistent governance as various other services that are managed by our security team.) NOTE: The docs talk a lot about both OIDC *and* PAT tokens, so it seems like both are allowable.... Whenever the terms are contrasted or are used in close proximity to each other, the docs will say that customers "may use" PAT tokens. They never say we "must use" PAT tokens. Can anyone provide some more color to help customers understand this change? It feels like a regression. I suspect it may not have been intentional. In my opinion, these PAT tokens aren't appropriate for the back-end service integrations, and we would rather continue using our old service principals originating in Entra ID. Any additional information would be very much appreciated.REST API Endpoint to extract data from cube view
Is there a way to extract data from a cubeview with the OneStream REST API? I've tried using the "DataProvider/GetAdoDataSetForCubeViewCommand?api-version=5.2.0" endpoint from the doc via Python - however when I try to print the result from the response, it doesn't contain data, only metadata ( i.e 'Title', 'HeaderLeftLabel1' etc as seen in the screenshot below) Im trying to see the numerical values within the cells. Can this be done ?
