Skip to main content
To homepage To homepage
Solved

Connecting TimeXtender to Topdesk doesn't show all tables

rbrandsma
Starter
Forum|alt.badge.img

A customer I am working with is trying to connect Topdesk to TimeXtender through an OData feed. A connection is made, but not all tables are available for ingestion.

When the customer changes the connection url to connect to just 1 table, TimeXtender has no issues connecting to it and retrieving the data from that 1 table. 

To test if this there maybe was a setting in Topdesk that was missed we tried to connect from Power Query using the original url. This connection also worked perfectly, showing around 290 tables.

How can we get TimeXtender to retreive the same amount of tables from Topdesk?

Feed URL: https://<customer>.topdesk.net/services/reporting/v2/odata

OAuth version: 2.0

Provider: Managed ADO.NET

Provider version: 24.0.8963.0

OData version: AUTO

Attached a screenshot of the output of a query to the datasource in TimeXtender ODX

 

Best answer by Thomas Lind

Hi @rbrandsma 

Such a change is in development. Meaning the ability to use the OData endpoint to get many setups and mixing it with specific endpoints that doesn’t show from the normal list. I am not sure when it will be released though, but I assume it is on its way.

Also our TX REST provider can make as many endpoints in one data source as you want, but I can see how it would be a lot of work if the OData context would need to be made as individual endpoints.

View original
Did this topic help you find an answer to your question?

5 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1035 replies
  • October 7, 2024

Hi @rbrandsma 

What version of TimeXtender are you working on?

Normally, you will be shown the supposed tables by connecting to the main OData endpoint with Postman.

What do you see if you do the same?

Do you know any specific endpoints?

A REST data source can connect to this endpoint and that is usually a way to get the specific data you want.

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @rbrandsma could you please provide an update on the above questions?

rbrandsma
Starter
Forum|alt.badge.img
  • rbrandsma
  • Author
  • Starter
  • 2 replies
  • October 10, 2024

@Thomas Lind

TimeXtender version: 6645.1

ODX version: 6618.1

Connection with Postman to the Odata feed:

 

Connection with Postman to a specific endpoint:
 


A REST API towards a specific endpoint also works, but they will need multiple endpoints from Topdesk and don't want to create a new datasource for each specific endpoint. 

 

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1035 replies
  • Answer
  • October 15, 2024

Hi @rbrandsma 

Such a change is in development. Meaning the ability to use the OData endpoint to get many setups and mixing it with specific endpoints that doesn’t show from the normal list. I am not sure when it will be released though, but I assume it is on its way.

Also our TX REST provider can make as many endpoints in one data source as you want, but I can see how it would be a lot of work if the OData context would need to be made as individual endpoints.

rbrandsma
1 person likes this
  • rbrandsma
    rbrandsma
rbrandsma
Starter
Forum|alt.badge.img
  • rbrandsma
  • Author
  • Starter
  • 2 replies
  • October 15, 2024

Hi @Thomas Lind 

Thanks for the answer! Will take this back to my customer and dive into the REST API for Topdesk

 

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings