Data Sources Q&A

Hi,i want to retrieve ActivityEvents from PowerBI Admin using then TimeXtender REST API.configure the base URL as: https://api.powerbi.com/v1.0/myorg/admin/Endpoint configured as: activityevents?StartDateTime=%27{BDAT}%27&EndDateTime=%27{EDAT}%27&filter=Activity%20eq%20%27ViewReport%27{BDAT} and {EDAT} are populated using a SQL Query: DECLARE @i int = 0WHILE @i > -5BEGIN    select CONCAT(FORMAT(dateadd(day,@i,GETDATE()), 'yyyy-MM-dd'),'T00%3A05%3A00.000') as [BDAT],    CONCAT(FORMAT(dateadd(day,@i,GETDATE()), 'yyyy-MM-dd'),'T23%3A55%3A00.000') as [EDAT]    SET @i = @i - 1ENDi hoped it will loop for the past 5 days but unfortunately this doesn't work.Setting the BDAT 5 days in the past doesn't work either. Any ideas how to solve this?by the

We are migrating from CData data sources to the TimeXtender REST API data source.For Microsoft Graph API (used to retrieve calendars for multiple meeting rooms), the connection works correctly, but we are running into a major performance issue. While we retrieve the same amount of data.Performance comparison:Using CData:Ingest task: ~4 minutes Execute task per table: ~10 secondsUsing TimeXtender REST API data source:Ingest Full Load: 1.5 – 2 hours Execute task per table: 10–15 minutesWe have over 30 tables, so the execution time increases dramatically when using the TimeXtender REST API connector. Question:Are there any recommended ways to improve the performance of the TimeXtender REST API data source, both

We use the CData provider for CSV to ingest data from a https URL. The source system does not offer any other way to access the data. This works well. TimeXtender Classic with ODX.We're now looking into migrating away from CData (not trying to start a discussion about the reason...). The TimeXtender CSV provider (version 16.4.23.0) does not suport a https location, only local file/azure/s3/sharepoint/google/sftp/ftps. Is there some way to get this to work? The current workaround is to use the TimeXtender REST provider but that's quite a hassle to set up, especially when there are lots of columns involved. Also, it's really not a REST API with CSV response. It's a regular URL.

When I try pagination in the Enhanced datasource REST I only get 1 run, it stops after the first page.My Json result looks like this when I get to a page without a result:{    "data": [],    "status": "success"} How do I get my stopCondition to work in pagination?

Hello, We have a project that is on 20.10 (will upgrade to classic when it is released later this quarter).The customer has a source that is apache iceberg that we want to get data from but I can’t find any information regarding that for TimeXtender. Has anyone done this yet in TimeXtender, if it is even possible to ingest it?Thank you

Is there Swagger import support for the new TimeXtender REST data source?

Hi All,My current employer uses TimeXtender Desktop and two separate servers (dev/test + prod).The previous administrator installed the ODX server on the dev/test server. This causes issues when a datasource is modified, as it also affects the production environment.At my previous employer, we had an ODX server per environment: Dev ODX, Test ODX, and Prod ODX.My question is: what does the community recommend regarding having an ODX server on the dev/test environment?My ideas:Install the ODX Server on the production environment. Rename the VM.Thanks in advance for your help and input!Kind regards,Tim

Hi, I have server, database, username and password for postgreSQL DB.with pgAdmin no issue it connects immediatelly. (no additional settings)In TX I tried CData ADO.NET Provider for PostreSQL 2022 (tried 2018 also, same result)Set SSL False - got error no encryptionSet SSL True - [500] System error: server certificate verification failed. Connection aborted. should I need any additional configuration, maybe different provider, any ideas? thanks in advance,Jakub

Hi thereI have an issue which I’m not quite sure how I can solve in timextender.i have 2 tables, Vendor and Catalouge .. Vendor contains all the vendors and Catalouge is the productcataloge with information about the product. The only parameter I have that I can make the relationship on is VAT .. the problem is that many products have the same VAT and there is a multiple Vendors with the same VAT. I was looking into making a bridge table but Im not quite sure how I can do this automatically in Timextender. what’s the smartest solution to this?

I need to connect some new REST API's to our TX environment. These API's where easy to configure in Postman, but is now a challenge in TX. In Postman it's possible to use a “pre-script” (java) to create some variables, concatenate them and then hash. This is the script:const method = 'GET';const urlPath = '/app/openapi/v1/device/deviceOpenIds';const secret = 'MY_SECRET';const timestamp = Date.now().toString();const signature = CryptoJS.HmacSHA256(method + timestamp + urlPath, secret).toString(CryptoJS.enc.Hex);pm.environment.set('timestamp', timestamp);pm.environment.set('signature', signature);This signature is used in the header for authentication for the GET call. The API provider gives a python or java script to make the HmacSHA256 hash, but I cannot use that directly in TX.What is a good way to approach this in TimeXtender? 

I am trying to setup a connection to a MySQL Database. It works just fine in MySQL workbench. It works just fine in ODBC Data Source AdministratorTimextender throws me this error:ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedBut this is what it looks like in the portal: Am I missing something really obvious here?

I’m using TimeXtender REST Data Source v10.2.0.0 with two endpoints: A static endpoint that returns a list of IDs. A dynamic endpoint that retrieves additional data for those IDs. The problem is that not all IDs from the first endpoint exist in the second. When the dynamic endpoint tries a ‘non-existent ID’, the API returns a 500 server error, stopping the data transfer.This is an external API, so I have no control over it. From what I can see, the datasource provider doesn’t offer error handling (like try/catch or “skip if failed”).I could create a curated list of valid IDs, but there are thousands of IDs that can change at any time, making this impractical. I could also ask the API provider to return empty JSONs instead of errors, but I’d prefer to handle it on my side.Any advice?

In what version of Timextender is the existing Easy Connect provider replaced by the new TNS provider? We are running the older classic version 20.10.52.64   

I'm trying to connect to MongoDB and load data  into Timextender I have a ODBC driver setup, and test connection works. In Timextender I have ODBC Generic Data setup, and test connection works and to Synchronize Data Source works as well.But when I try to execute the data transfer from MongoDB into Timextender then I get an error.  

I'm using dynamic values function in the TX REST connector 9.1.0.0. I use id's from another endpoint to loop through in my second endpoint path. This works well when I use “From Endpoint Table” but now I want to add a filter to only get the id's with a flag “hasresponse=true”.I've read the page but I still get an error with my Endpoint query. “No such table” the error message says. I've tried several things like adding a schema. But all with the same response. Is there something wrong with my syntax?Error: 

Hi, I’m trying to connect to a API using Timextender REST version 7.1.0.0 but my result is only one row of data. In Postman I get much more data. It might be because the API returns JSONL and TX tries to handle it as JSON. I’m trying to convert it to Text but it still doesn’t work.  Earlier I managed to complete the goal in Power Query even with pagination.  Now I’ve hit a brick wall and I need your help to proceed. My result in ODX:  My result in Postman:Here’s my connection profile:{  "Name": "MixPanel",  "Description": "",  "Provider": {

Hi,I got this structure(see below) from my rest api and I need to add order_id into each line of order_line. How can I flatten out order_lines with the order_id? I have tryed different  ways, but when I have two order lines only one get the right order_id value…. Order/Orderlinesbest regards,Bjørn A.

Hi,We're observing strange behavior with the new enhanced REST data source provider.When we do the call on this endpoint in the old connector or in Postman, we get a return of 197 records. This is a single payload, 1 page, with fully filled rows, including a populated PK field.Now, when we do the same call with the enhanced REST data source provider we receive 589 records. 392 of these have null values on all records except for one field, a descriptive but not otherwise important. Importantly the PK field of these records is also null.Now we have two questions: Why is the new REST provider delivering more records than other providers/tools? How can we effectively filter out these records in the actual call? As it seems we are now only able to successfully filter out these almost empty records at the DSA.Best, Luuk 

Hello,I'm trying to load data from an Odoo system that only exposes an XML-RPC API (no REST or SOAP). I want to bring this data into TimeXtender Portal, but I’m working under a few constraints: I do not have TimeXtender Premium, so I can't use custom scripts or PowerShell. I don’t want to introduce any external tools like Python wrappers or middleware. I can successfully call the XML-RPC API in Postman and retrieve data. I'm looking for a way to either automate or streamline this process without Premium features or external software. I’ve considered the XML data source, but it seems incompatible with XML-RPC since it doesn’t support HTTP POST or dynamic method calls.Has anyone found a way to work with XML-RPC APIs in TimeXtender under these limitations, or automated a file-based import process from tools like Postman?Any suggestions or workarounds would be appreciated.Let me know if you w

Dear All, We have a “Dynamics Business Central (NAV)” data source with multiple adapters (multiple ERPs). We recently needed to “synchronize” the object to get the last BC evolution (new fields, ...). Unfortunately, the “Display name” of some tables/fields changed. 😒 Ex:-“Lot”“Lot No_ Information” table is now named “Lot No. Information” -“Demand Forecast”“Production Forecast Entry” table is now named “Demand Forecast Entry” Our default was to use “Display Name” (instead of Database Name) in the data selection and staging deployment. Our main concern is our significant number of sql views associated to these selected tables/fields with “hardcoded” name. We know that is recommended to use parameters to avoid problem with renaming but we didn’t implement the params in this case missing time and practicality with the

Hello,We have a case in TimeXtender Classic where we need to read more than 256 Columns from the Excel connector.My understanding is that the underlying driver does support it, but by default it will only Return the first 256 Columns, and thus that is all we see when reading objects from the DataSource.Does anyone know if there is a way to expose more columns beyond the 256 already shown?ThanksTim

Hi,I've got a couple of installations with customers using CDATA for AD/Entra integration, with the upgrade I found an article to advise moving them to REST.I am however a bit lost on how to connect a REST API to Entra, and I couldn't find good documentation to fill it in.Could someone assist us for a moment or maybe point us toward more complete documentation specifically on using the Enhanced Data Source to connect to Entra?  Thanks in advance, Jan DD

Hi,We are using a REST data source with dynamic values to fetch data for approximately 12,000 records, where each record corresponds to an individual API call.Occasionally, we encounter issues with the API provider where some calls return a 400 error. Unfortunately, it’s unpredictable which dynamic values will cause these errors.Currently, it appears that the TimeXtender REST data source stops processing upon encountering a 400 error, resulting in a "Completed with errors" status.Is there a way to configure the REST data source to continue processing the remaining dynamic values, skipping over those that result in a 400 error? Ideally, it would also log the calls that failed for review. Best regards,Pontus

Hi,I'd like to make a new data source connection using REST to connect with our Azure storage table.Thus far I have managed to get the connection setup, however pagination remains a issue.When testing our connection and following the steps in the debug logging file I see that when a table has a next: "x-ms-continuation-NextPartitionKey” and "x-ms-continuation-NextRowKey” it will return this in the header (not the body). But if the table doesn't have this it will stop since the "x-ms-continuation-NextPartitionKey” header was not found.As I am applying these pagination parameters as query parameter I need to be able to solve this issue.Is there maybe a way to apply a default value to these variables (manipulating query doesn't work as the variable itself already won't be found) or some way to dynamically replace a URL? Example table with no NextPartition/rowkey:

Is it possible to add the dynamic values used in a nested call to a table flattening.In this particular case the first call gets the list of documents and feed the id as a dynamic value to the 2nd call. The response doesn't include any reference to the document and without the id we cannot link the details to a document. I've tried to add it as a static node (name: Document_ID  value {id})but that only results in errors.