REST Api

34 Topics

Orphan members - validation error required
Hello dear community members, Background: We have had situations with month end workflow load validation errors which were fixed with UD1 mass upload. Few UD1 members ended up in Orphans, as the Parent did not exist yet in OneStream at the members mass upload step. The validation error disappeared and the workflow was complete. However, this created an Out of Balance and it was difficult to retrieve the issue. Questions/potential solutions help required: Would it be possible for the month end Workflow load Validation error to ignore Orphan members and still get an error even when we create members and end up by mistake in Orphans. Is there a way to delete Orphan members with a BR? Is there a way to stop the Metadata builder xml file to create Orphans when a parent is missing from OneStream? Thank you in advance for any idea/suggestion/tip/hint.
Solved
IrinaDragusanu
3 days ago Place Workflow and Data Integration
58Views
0likes
11Comments
OneStream and D365 Integration
Hi everyone, I'm currently working on integrating OneStream with Dynamics 365 (D365) and would love to hear about your experiences. Specifically, I'm interested in knowing which connector you used for the integration. Did you opt for OData, Synapse Link, or another method? Any insights, tips, or recommendations would be greatly appreciated! Thanks in advance!
KristenB27501
19 days ago Place Workflow and Data Integration
56Views
1like
1Comment
NetSuite to OneStream Integration
Hello all, I need to verify and confirm the method of choice to set up an NS to OS 8.5 integration WITHOUT the SIC in play. Here is what I have uncovered thus far.... A SuiteAnalytics Connect is being considered via ODBC so OS can pull data from NS. I read a few things about this. One is that a BR would be set up in OS to call on a SuiteScript in NS initiate the data pull. Now, the missing piece is how to set up the connection in OS if there is no ODBC installed. Another thing is that SIC would not be needed. I also perused a blog that stated that Support can set up s direct connection to NS from OS, provided they have the NS info. Can anyone please confirm this approach? Rest API could be leveraged but looking for an alternative. Any input would be greatly appreciated. Thanks, Ed P
puente007
3 months ago Place Workflow and Data Integration
94Views
0likes
2Comments
RESTAPI - Only Supports Default Workspace Currently?
Just a heads-up for anyone using the REST API - this may save you some head-scratching! GetAdoDataSetForAdapter (5.2.0/Synchronous) and non-Default Workspaces There appears to be a problem with running GetAdoDataSetForAdapter if your DataAdapter is not in the Default Workspace. The Data Adapter returns an HTTP/200 in PostMan BUT the Response Body is null. It appears that the WorkspaceName parameter in the RequestBody has not yet been implemented in the RESTAPI. The RESTAPI documentation still referes to this parameter as being "reserved for future use" (but I assumed that this was a documetation bug as non-Default Workspaces have been out for a while in 7.4/8) API Version 7.2.0 and Workspaces In the Asynchronous APIs (7.2.0), there seems to be no way to specify the Workspace when you are generating the Application Session Token (SI), so you get the same problem with Data Adapters not in the Default Workspace. I proved this by moving my Data Adapters to the Default Workspace at which point they worked perfectly via the REST API whether via API-Version 5.2.0 or 7.2.0) UPDATE: Workspace has to be set to Shareable for this to work - all Ok now! (Wasn't in the REST API Guide) Steve
SteveK
5 months ago Place Workflow and Data Integration
40Views
1like
0Comments
Export data to Snowflake
Hello, We are looking to export data from OneStream to Snowflake using APIs. We are using OneStream's cloud hosted environment, and the authentication method is just a Reference Token. We are looking for more secured way for sending the data from OneStream to Snowflake. Let us know if there are any suggestions or alternatives for this data integration with more secured way of authentication. Thanks, Tharun.
tharunkumar04
6 months ago Place Workflow and Data Integration
150Views
1like
4Comments
EncryptText And DecryptText Replacement
Does anyone know what replaces the 2 utility commands below? I get a warning message that those commands are obsolete but it does not give any indication or hints of what the new commands are or what's currently available? BrApi.Utilities.EncryptText andBrApi.Utilities.DecryptText Any help is highly appreciated. Thanks, Jun
Solved
JunBinghay
6 months ago Place Workflow and Data Integration
46Views
0likes
1Comment
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
JoesefS
7 months ago Place Workflow and Data Integration
39Views
0likes
1Comment
REST 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.
Solved
hoaphan
7 months ago Place Workflow and Data Integration
9.6KViews
0likes
15Comments
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()
Solved
jeffvdt
10 months ago Place Workflow and Data Integration
833Views
0likes
6Comments
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,'
marisolbritton
11 months ago Place Workflow and Data Integration
465Views
0likes
3Comments