How to create a TX Enhanced datasource

So i have sort of figured it out, but just for Basic Auth.
I have manged to create a Connection

 

I usually use CData and wirte RSD files.
Now, i dont know how to do it with TX Enhanced Drivers
When i do this above, i get this in my Data Selection for one table

 

I want somethig like this, which my RSD represents

 

I know that i dont use RSD files with Enhanced Drivers, but how do i get a cleaner structure?

Hi,

TimeXtender REST data source | Community has a lot of examples you can apply. I typically read the .rsd to get an understanding of what needs to be done for that source in general and then go through all the examples to collect what needs to be set up.

This doesnt look like its for on-prem solution
 

Hi,

it isn't directly but the TX Enhanced sources that are available for 20.10.x have almost the same possibilities.

Thank you ​@rory.smith 
I have done extracted some data from APIs with TX Enhanced drivers.
There is however an issue i am facing when i create a so called nested paths:

I was expecting to create a single table for SHA_Manedsrapport_Detaljer

To get UUID from SHA_Manedsrapport i did something like this:

 

I was expectiung to get one table but i got multiple. I suppose it depends on how JSON/XML is returened

Even if i turn a blind eye on these tables, how do i join them in ODX-view? There is no common key between them !

This is just one example

Hi,

you probably need to use the Table Builder to flatten the response in an appropriate way.

Let me rephrase.

How to hide all but one table that i have created with TableBuilder?

The only table I need is: SHA_ManedsRapport_Detaljer

Is there a way to hide other tables?

there is an option to only show flattened tables in the metadata.

Can you be a little more specific.

Where should I go? What should i choose?

Hi ​@aftabp 

See the yellow square from your image.

Check that to only show flattened tables. 

​@Thomas Lind 
I have extraced a couple of tables in the last two days.
A few of them are un-nested, while others are nested.
The issue above is with nested tables.When i am creating one, and check that box, my nested table is not visible in selection tree
 

If i dont check the box, i can see the table but with bunch of others:
 

Also, you see that table called Default TableName !
It’s actually called something else.
Why am i not able to change the name !

Hi ​@aftabp 

You need to create a Table flattening for all the nested tables you have, or they will not show.

Like is done in this guide.

You can also flatten the nested tables in the setup. Without flattening, it automatically splits out the nested parts into tables. You can merge more parts into one flattening, you don’t have to keep at the top level.

When you create a XSLT code it pulls in the name you give it and it becomes the name of the table. If you change the name part it has no effect. You need to change the name in the code.

In the XSLT it will say <DefaultTableName></DefaultTableName>. You need to change that part to give it a different name, it isn’t dynamic.

I have a Data Connection with 40 endpoints.
It takes a long time to build table structure - unlike it did with CData

Caching is to a folder C:\temp\ on the connection
 

No override of caching on endpoints
 

Perform exhaustive meta data scan is off:

 

 
Is it possible to build the table structures fast?