Can't connect to the API - HTTP 404 error shown

Officially Answered

Follow

New post

Jonathan Levy

• January 11, 2018 15:31

Hi,

 

Using Power BI or Excel I get the following error whilst trying to get data from the API. Any ideas?

 

DataSource.NotFound: OData: Request failed (404): The remote server returned an error: (404) Not Found. (Not Found)
Details:
DataSourceKind=OData
DataSourcePath=https://**************.timehub.7pace.com/api/odata/TimeExport(startDate='01/01/2018',endDate='01/10/2018',populateTopParentColumns=null,groupTimeByDateByUser=null,includeBillable=null)
Url=https://**************.timehub.7pace.com/api/odata/TimeExport(startDate='01/01/2018',endDate='01/10/2018',populateTopParentColumns=null,groupTimeByDateByUser=null,includeBillable=null)?api-version=2.1

0

• 

  Permanently deleted user

  • January 11, 2018 15:40

  Hi Jonathan,

  Can you check if providing date in format YYYY-MM-DD helps? Try also providing additional parameters explicitly. See sample below:

  https://***.timehub.7pace.com/api/odata/TimeExport(StartDate='2017-11-01',EndDate='2017-11-30',PopulateTopParentColumns=false,GroupTimeByDateByUser=false,IncludeBillable=false)?api-version=2.1

   

  Maxim

  0

  Comment actions Permalink
• 

  Jonathan Levy

  • January 11, 2018 15:42

  Hi Maxim,

  Amazing! That worked. Thank you.

  0

  Comment actions Permalink
• 

  Permanently deleted user

  • January 11, 2018 15:44

  You are very welcome!

  Maxim

  0

  Comment actions Permalink

Please sign in to leave a comment.