REST API Execute LogonAndReturnCookie
I am trying to determine if we are using any REST APIs. We were instructed to run a logonandreturncookie via Postman. https://documentation.onestream.com/1384528/Content/PDFs/REST_API_Implementation_Guide.pdf I followed the instructions in page 26 and ran into this error message: Error: Invalid character in header content ["Authorization"] I entered "{{webapi_access_token}}", similar to the screenshot in page 27. I hovered over the token and saw a message stating it's not defined. Where should I set up this variable or is there an issue with my params/body?
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!
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 PRESTAPI - 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
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.
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
