Skip to main content
June 26, 2024
Solved

REST API request time out

  • June 26, 2024
  • 3 replies
  • 0 views

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?


  

Best answer by tschilling

can you repost the URL without the port number?

3 replies

June 26, 2024

Have you tried taking the port number out?

AnsumAuthor
June 27, 2024

Removing the port returns 400 Bad syntax error

July 1, 2024

can you repost the URL without the port number?

AnsumAuthor
July 1, 2024

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
July 2, 2024

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!