Forum Discussion

Ansum's avatar
Ansum
New Contributor
2 years ago
Solved

REST API request time out

Hi there,
We are trying to test data provider endpoints using Postman but they always fail with Error: connect ETIMEDOUT xx.xxx.xxx.xxx:50001.
I have read the documentation, manage to call Authentication API with Personal Access Token but no luck with other endpoints.
OneStream support has enabled calls in IIS and has no clue what's wrong.
For example:

POST "https://{OurBaseWebServer}:50001/onestreamapi/api/DataProvider/ GetAdoDataSetForSqlCommand?api-version=5.2.0"

Request Body:

{
"BaseWebServerUrl": "https://xxxxxxxxxxxxx/OneStreamWeb",
"ApplicationName": "OneStream Test",
"SqlQuery ": "SELECT * FROM Dim",
"DbLocation": "Application",
"ResultDataTableName": "ResultDataTableName",
"XFExternalConnectionName": "",
"CustomSubstVarsAsCommaSeparatedPairs": ""
}

Any idea?


  

REST Api

5 Replies

    • Ansum's avatar
      Ansum
      New Contributor
      2 years ago

      Removing the port returns 400 Bad syntax error

      • tschilling's avatar
        tschilling
        Contributor
        2 years ago

        can you repost the URL without the port number?

  • Ansum's avatar
    Ansum
    New Contributor
    2 years ago

    As mentioned,
    "https://{OurBaseWebServer}:50001/onestreamapi/api/DataProvider/GetAdoDataSetForSqlCommand?api-version=5.2.0" fails with timeout error
    "https://{OurBaseWebServer}/onestreamapi/api/DataProvider/GetAdoDataSetForSqlCommand?api-version=5.2.0" fails with 404 Not Found error

  • Ansum's avatar
    Ansum
    New Contributor
    2 years ago

    In the end I restarted from scratch and indeed removing the port number did the trick.
    Not sure why it is specified in the documentation on 5.2.0 endpoints.
    Thank you for your help!