connector business rule
Hi All, I think i have a very simple requirement but i cant seem to get it to work. I just want the API to make use of the entity which the user is currently using in the workflow. The code i now have is as following Dim sURL As String = "xxx" Dim pkWFunitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si) Dim sYear As String = TimeDimHelper.GetYearFromId(pkWFunitPk.TimeKey).ToString Dim sPeriod As String = TimeDimHelper.GetSubComponentsFromId(pkWFunitPk.TimeKey).Month.ToString Dim sAPIKey As String = "xxx" Dim sYearPeriodParam As String = String.Format("?yearPeriod={0}{1}", sYear, sPeriod) Dim sEntities As String = "&company=244" 'Dim sEntityParam As String = String.Format("&company=[{0}]", sEntities) Dim sJson As String = String.Empty '---------------------------------------------------------------------------------------------------- 'Execute HTTP Request Using client As New HttpClient client.DefaultRequestHeaders.Add("Client_Secret", sAPIKey) 'Send the GET request Dim response As HttpResponseMessage = client.GetAsync(String.Format("{0}{1}{2}", sURL, sYearPeriodParam, sEntities)).Result response.EnsureSuccessStatusCode()Solved687Views0likes6CommentsAPI 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,'415Views0likes3CommentsUnexpected 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.510Views0likes4CommentsREST 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. Indu368Views0likes3CommentsREST 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.616Views0likes5CommentsREST API USE
Hello OneStream Community, I'm working on how to implement a REST API in OS, but i'm not sure to understand all the steps, i've already read the documentation and i've found it very hard to understand, can anyone please explain how can we implement it in OS what are the steps to follow, i started by downloading and installing POSTMAN for the tests but i don't know what should do i do after, please any help will be much appreciated. I'm also woundering if there any data management that should be used for this Thanks and merry christmas.9KViews0likes10CommentsREST 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 ?Solved5KViews0likes11CommentsExecuting DM Step using RESTAPI
Hi, I'm trying to execute DM Step using Rest API using below URL and Body Text but I'm getting an error with error code 400 and with the message unsupported API version. Can you please let me know what could ne the issue? Thanks for your help! URL:https://servername/onestreamapi/api/DataManagement/ExecuteStep?api-version=8.2.2 Body Text:; { "BaseWebServerUrl": [https://servername/onestreamweb], "ApplicationName":[Consol], "DataManagementGroupName": [DataCopy], "StepName": [Test_Copy], "CustomSubstVarsAsCommaSeparatedPairs": [""l } Error Message: Request Status: 400 Bad Request Result: Non-200 response code received: 400 URI 'https://servername/onestreamapi/api/DataManagement/ExecuteStep' does not support the API version '8.2.2'.","code":"UnsupportedApiVersion","traceId":"00-a6552d7760a854272b00c71c0b9fc82f-b8030eb56b2b0a75-00"}Solved1.1KViews0likes4Comments