Http error 406 when calling reporting API

Officially Answered

Follow

New post

Cédric Noureau

• July 11, 2018 11:38

Hi,

 

I'm trying to use the reporting API Odata endpoint from Excel.

I'm getting a http 406 error :

Response 406.0 from Timetracker server.

CorrelationId=3f7841b6-1e50-40a5-9aae-078f006f227d
AbsoluteUri=https://s-tfstimetracker-01p:8090/api/Syst%C3%A8me%20d%E2%80%99information/odata/TimeEntryExport?api-version=2.1

I use integrated Windows authentication.

I also tried to access the Odata endpoint from my browser and i get the same error.

The request headers sent are :

1. Accept:
   text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
2. Accept-Encoding:
   gzip, deflate, br
3. Accept-Language:
   fr-FR,fr;q=0.9,en-US;q=0.8,en;q=0.7
4. Cache-Control:
   max-age=0
5. Connection:
   keep-alive
6. Host:
   s-tfstimetracker-01p:8090
7. Upgrade-Insecure-Requests:
   1
8. User-Agent:
   Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36

The response headers received are :

1. api-deprecated-versions:
   1.0, 2.0
2. api-supported-versions:
   2.1
3. Cache-Control:
   no-cache
4. Content-Length:
   0
5. Date:
   Wed, 11 Jul 2018 11:36:08 GMT
6. Expires:
   -1
7. Persistent-Auth:
   true
8. Pragma:
   no-cache
9. Server:
   Microsoft-IIS/10.0
10. X-AspNet-Version:
    4.0.30319
11. X-Powered-By:
    ASP.NET

I don't see where the problem may be so your help will be appreciated :)

0

• 

  7pace tech support

  • July 11, 2018 12:25
  • Edited

  Hi!

  Thank you for your message and my apologies for the issues you are experiencing.

  It is a known issue, it is presented in the latest versions of Excel and Power BI and it was already reported to Microsoft.

  Here is a related topic in Power BI 

  As a workaround, you could use the Advanced Query Editor in Excel:

  Enter the function invocation by hand from looking at the function definition within the Excel advanced query editor view e.g.

  Replace Odata url with correct one (without query like "api-version"="2.1")

  ---

  let
  Source = OData.Feed("Timetracker Odata url address", null, [Query=[#"api-version"="2.1"]]),
  #"TimeExport_function (startDate as text, endDate as text, populateTopParentColumns as nullable logical, groupTimeByDateByUser as nullable logical, includeBillable as nullable logical) as table" = Source{[Name="TimeExport",Signature="function (startDate as text, endDate as text, populateTopParentColumns as nullable logical, groupTimeByDateByUser as nullable logical, includeBillable as nullable logical) as table"]}[Data],
  #"Invoked FunctionTimeExport_function (startDate as text, endDate as text, populateTopParentColumns as nullable logical, groupTimeByDateByUser as nullable logical, includeBillable as nullable logical) as table1" = #"TimeExport_function (startDate as text, endDate as text, populateTopParentColumns as nullable logical, groupTimeByDateByUser as nullable logical, includeBillable as nullable logical) as table"("2018-01-01", "2018-12-31", null, null, null)
  in
  #"Invoked FunctionTimeExport_function (startDate as text, endDate as text, populateTopParentColumns as nullable logical, groupTimeByDateByUser as nullable logical, includeBillable as nullable logical) as table1"

  ----

  Let me know if this can help you.

  Kind regards,

  Andarth

  1

  Comment actions Permalink
• 

  Cédric Noureau

  • July 11, 2018 12:22

  Hi again,

  Thank you for your quick answer !

  It works with the workaround you provided.

  Many thanks !

   

  Regards,

  Cédric

  0

  Comment actions Permalink

Please sign in to leave a comment.