Skip to main content
Newcomer
Jun 26, 2024 5:09 PM UTC
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": "{OurBaseServerURL}/OneStreamWeb",
"ApplicationName": "OneStream Test",
"SqlQuery ": "SELECT * FROM Dim",
"DbLocation": "Application",
"ResultDataTableName": "ResultDataTableName",
"XFExternalConnectionName": "",
"CustomSubstVarsAsCommaSeparatedPairs": ""
}

Any idea?


  

Member
Jul 1, 2024 12:28 PM UTC

can you repost the URL without the port number?

5 replies

Member
Jun 26, 2024 5:13 PM UTC

Have you tried taking the port number out?

AnsumAuthor
Newcomer
Jun 27, 2024 12:11 PM UTC

Removing the port returns 400 Bad syntax error

Member
Jul 1, 2024 12:28 PM UTC

can you repost the URL without the port number?

AnsumAuthor
Newcomer
Jul 1, 2024 1:58 PM UTC

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

AnsumAuthor
Newcomer
Jul 2, 2024 1:13 PM UTC

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!