REST API request time out

[Ansum]

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": "{OurBaseServerURL}/OneStreamWeb",

"ApplicationName": "OneStream Test",

"SqlQuery ": "SELECT * FROM Dim",

"DbLocation": "Application",

"ResultDataTableName": "ResultDataTableName",

"XFExternalConnectionName": "",

"CustomSubstVarsAsCommaSeparatedPairs": ""

}

Any idea?


  

[tschilling]

Have you tried taking the port number out?

[Ansum]

Removing the port returns 400 Bad syntax error

[tschilling · Accepted solution]

can you repost the URL without the port number?

[Ansum]

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]

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!