The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago
Solved

OnPrem and RestApi : Help for the config

Hi there!

I am trying to use Postman to run a DM job sequence. 
I test the DM job locally and it works fine with no parameter.
I am using Azure SSO to log on the server.
I can retrieve a token from microsoft for my tenant ID using : 
https://login.microsoftonline.com/bec456-my-t3n4nt-id-e2aba/oauth2/v2.0/token (In green in the printscreen)

On my second RestApi call, I use the token I retrieved and I drop the token under Authorization > Bearer Token in Postman.
Because I need to run a sequence the URL is : https://aiqos.io:50001/onestreamapi/api/DataManagement/ExecuteSequence?api-version=5.2.0 
and the body is :

{
"BaseWebServerUrl": "https://aiqos.io:50001/onestreamweb",
"ApplicationName": "GolfStreamV65",
"SequenceName": "RestApi",
"CustomSubstVarsAsCommaSeparatedPairs": ""
}

I also created an admin user in OneStream that matches the Application (client) ID found in Azure. (In red in the printscreen)
The on the back end in the server config, I added the OS Werb Api Cliend ID and the Web Api App Custom Scopes. (in red and yellow)

When I run the RestApi for the DM Sequence, I get an error 500.
I have no clue on what I am missing after reading few times the doc. I used to make it work for previous OS versions...
I see that the api is reaching the  windows server , but nothing in the OneStream logs...
Thanks for your help.

Infrastructure
  • NicolasArgente's avatar
    NicolasArgente
    2 years ago

    OK, I managed to make it work. I redid everything from scratch and it worked. Dont ask me why 🙂

10 Replies

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

    OK, I managed to make it work. I redid everything from scratch and it worked. Dont ask me why 🙂

    • DanielWillis's avatar
      DanielWillis
      Valued Contributor
      2 years ago

      Argh, gotta hate that. A mixture of wth this sucks and I don't care it works at last I'm never looking back.

       

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    Edited: subvars is indeed a single string.  pbbbb. 🙂
    Couple of quick things to try:
    add the proper case and  trailing slash to the basewebserverurl, and use an empty object for subvars instead of an empty string.:  

    {
"BaseWebServerUrl": "https://aiqos.io:50001/OneStreamWeb/",
"ApplicationName": "GolfStreamV65",
"SequenceName": "RestApi",
"CustomSubstVarsAsCommaSeparatedPairs": ""
}

     

    • DanielWillis's avatar
      DanielWillis
      Valued Contributor
      2 years ago

      I leave off the OneStreamWeb, so would have:

      "BaseWebServerUrl": "https://aiqos.io:50001/",
      • NicolasArgente's avatar
        NicolasArgente
        Valued Contributor
        2 years ago

        Thanks DanielWillis  !
        I also tried that but it is not working. 
        I am on OS v8.1 by the way. 
        Can you check on your side the username I put in OS? Did I made a mistake...? 

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

    Hi RobbSalzmann Thanks for your help, but it does not change anything. Still getting the 500 errors. Remember that the call is received by the windows server but OS not.