TimeXtender Community

Recent activity
Help others
Categories

Roy VProblem Solver

helloI have an incremental table (with a mapping on a datawarehouse simple mode table) but the direct read transfer script generated is missing on certain semicolons (as you can see in the attached document, for example at line 70)This causes the deploy to fail with the message below.We are on timextender version 6766.1.

11 hours ago

Roy VProblem Solver

Prepare

Object reference not set to an instance of an object.

I am deploying a project to Snowflake.On a table I get the following error:Object reference not set to an instance of an object.As read in another ticket I did a ‘Save and reload' but unfortunately that did not solve the issue.It;s on deploying the data cleansing script however it does not show me the script in the deployment log, I only see the error message. Is there an easy way i can see what lookup column is causing the issue ?

7310

12 hours ago

dsvartzmanContributor

Prepare

Multiple ODX for different enviroments

Hi,I was wondering if it's possible to use multiple ODX instances for different enviroments (DEV/ACC/PRD).I know that at 20.10 you could only use a single ODX as after multiple enviroment transfer all mapping to ODX would be lost when using multiple ODX instances Is this still the case? Is this issue solved in next-gen?

6415

12 hours ago

Leo RogemanStarter

REST APIs

Paging and Dynamic value REST (Rest ODX)

Hello,We have a REST API where we use both Dynamic Value and Pagination (replace URL). The issue is that the paging works fine but only considers the first Dynamic Value and skips the rest. The final result then returns all pages for the first dynamic value and no rows for the rest. Further we also use Table Flattening as well as the Exhaustive Metadata Scan Option. How can we make it loop through all dynamic values as well as keeping the paging option? API request:https://{base_url}/{company_url} Paging:Replace URL with {nextLink} type XPath Dynamic Value query:SELECT company_url FROM [MDW_Dev].[SysTransform].[Company_information]

16519

13 hours ago

jarleContributor

RSD File Customization

rsd file definition for adding tables to Cdata QuickBooks Online data source

The Cdata data source for QuickBooks Online doesn’t have all the endpoints in the API available. For instance TaxPayments is missing. (https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/taxpayment)It is possible to add rsd-files to the file folder in order to get additional tables when synchronizing data. However, there is no sample rsd-file available, and no obvious way to generate schema file. I have tried to copy a rsd file from a REST connector, but then I get the error message when trying to preview: “The operation ‘jsonproviderGet’ could not be found”

447

3 days ago

Marius_dWVisitor

Legacy & Upgrades

How long is my version supported

Hi, I am using TX 20.10.45.64. Can you tell me when support for this version will end?

281

4 days ago

BennyContributor

REST APIs

REST connector can't handle empty return bodies

I have two particular use cases where I would like the TX REST connector to be able to handle nothing being returned. In one case I've configured the portal to do a PUT request. PUT's generally don't return any body. In a second case, the API is just configured to do this sometimes. We get ID's from another endpoint that we are then supposed to use dynamically like: endpoint/{ID}. The problem is that the source system can have phantom ID's, meaning that ID=13 doesn't really point anywhere. endpoint/13 then returns just a completely empty body. In both cases the problem seems to be that the connector can't handle this. We get back:Failed to execute endpoint 'xxx':Unexpected character encountered while parsing value: }. Path 'TX_Autogenerated_Element', line 1, position 28.Going of the error message, it would seem that the connector is assuming a json was returned and automatically starts trying to convert is somehow. I need to be able to handle these situations somehow, since I have no

489

5 days ago

mirjam.bleuminkStarter

RSD File Customization

Is it possible to use POST for a REST API?

I am using a REST API (CData source) to get source data. Since I need to include a CSR_NONCE value in the header (unique key value), the REST api is set up as a POST. Is it possible to specify that you want to do a POST rather than GET in a CData source?

1198

5 days ago

MaarsenStarter

Ingest

GA4 -- Multiple Properties

Hi, I'm currenty developing the GA4 connector in TimeXtender. With some other tips and tricks of other posts it was quite simple to create the connection. At this moment I have 7 different properties from where all data should be loaded. I've read multiple posts but haven't found a solution to extract data dynamically over a list of properties. Current setup:CData Connector -- Google Analytics In this connector I can filter on property ID. TimeXtender -- v6xxxx + ODX Creating managed Queries to filter the relevant data from [GlobalAccessObject]. But haven't found a property id in this list. I think that currently the only option is to create for each property one connection. Or has someone found another solution?

201

5 days ago

svaStarter

Ingest

Issue with Retrieving a Column with the Same Name as a SQL Function

Hi everyone,I'm facing an issue where one of the columns in my destination table has the same name as a SQL function, and because of this, I'm unable to retrieve it in a normal way. To work around this problem, I wanted to use the Query Table Tool to retrieve the column in a parameterized way.However, for this specific data source (which is a Generic ODBC Data Source), the Query Table Tool option is greyed out. I've noticed that the Query Table Tool is available for other data source types.Has anyone encountered this issue before?Thanks in advance!

506

5 days ago

Roy VProblem Solver

Prepare

Incorrect code generation for snowflake

11 hours ago

Leo RogemanStarter

REST APIs

Paging and Dynamic value REST (Rest ODX)

16519

13 hours ago

jarleContributor

RSD File Customization

rsd file definition for adding tables to Cdata QuickBooks Online data source

447

3 days ago

Marius_dWVisitor

Legacy & Upgrades

How long is my version supported

Hi, I am using TX 20.10.45.64. Can you tell me when support for this version will end?

281

4 days ago

BennyContributor

REST APIs

REST connector can't handle empty return bodies

489

5 days ago

MaarsenStarter

Ingest

GA4 -- Multiple Properties

201

5 days ago

BernarddbTimeXtender Xpert

Ingest

Different output query tool vs transfer in the odx TX SQL connector (Classic)

We are experiencing a small issue with one of the connectors while using managed queries. When I use the query tool, we are utilizing the SQL endpoint from a Fabric Lakehouse to retrieve the data into the ODX. When I query the DBO table, I receive 12 records. For example, when running this query:SELECT [SinkCreatedOn], [SinkModifiedOn], [omoperatingunitnumber], [modifieddatetime], [modifiedby], [createddatetime], [createdby], [dataareaid], [recid], [tableid], [createdon], [modifiedon], [IsDelete] FROM dbo.[omoperatingunit] I also get 12 records. However, when we transfer this managed query, we only receive 11 records. This issue has occurred with multiple tables. We are not applying any filters to this dataset.Do you have any idea why this might be happening? Manually excluding or including all the columns is not manageable on the scale we are working with, so we rely on writing managed queries.

avanrijnContributor

Dear Sir,I am trying to set up a CData Json datasource connection with TimeXtender.This is my connectionstring:Auth Scheme=OAuth;Data Model=Document;Initiate OAuth=REFRESH;OAuth Access Token URL=https://pilot.binnenbeter.nl/api/v2/login/venray;OAuth Grant Type=PASSWORD;OAuth Refresh Token URL=https://pilot.binnenbeter.nl/api/v2/login/venray;Row Scan Depth=100;User=api@venray.nlI am able to get the bearer Token with Postman with this:url: https://pilot.binnenbeter.nl/api/v2/login/venrayJSON Body:{ "id": "", "language": "en", "data": { "resourceType": "AUTH", "item": { "loginName": api@venray.nl, "password": "password", "module": "API" } }This is the documentation I used for the connectionstring:PasswordFinally there also is an Password method. It is similar to the others, in that it requires an Access Token URL and an Refresh Token URL, the difference is that it uses an User and Password instead of client and secret. Notice that these fields are

14414

19 days ago

BennyContributor

Ingest

Failed to read metadata from XmlDocument for endpoint X with transformation 'T' Input string was not in a correct format.

The sync of my ODX datasource returns the following error. The datasource is a REST API endpoint of the form URL/{foreign_ID}, where foreign_id is a dynamic value that comes from a different endpoint within the same data source. The option "Perform exhaustive meta data scan” is enabled. The error returned is this:Failed to read metadata from XmlDocument for endpoint X with transformation 'T'Input string was not in a correct format.There is no further information. The sync does work when I replace foreign_ID by a fixed value. The endpoint contains a field that has a lot of values that look like integers, but some values contain letters. Since the above error message is the most verbose info I’ve got, I assumed that's probably the cause. However this conflicts with my understanding of what an “exhaustive meta data scan” should do. Any help is appreciated.

729

21 days ago

rory.smithTimeXtender Xpert

REST APIs

Get value of parent node instead of expanding to children

I am trying to achieve something complex in the TX REST connector using table flattening.I have the following JSON response: [ { "id": 1, "submitted": "2024-06-26T12:11:42+02:00", "answers": [ { "question": { "id": 3, "label": "How do you evaluate this?", "type": "SINGLE" }, "answer": 9 }, { "question": { "id": 4, "label": "How do you rate the following elements?", "type": "MATRIX_SINGLE_CHOICE" }, "answer": [ { "ids": [ 55 ], "labels": [ "Drinks" ], "value": [ "Good" ] },

600

4 months ago

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

Ingest

228 topics
1241 Replies

Prepare

222 topics
1001 Replies

Deliver

65 topics
260 Replies

Jobs & Executions

115 topics
497 Replies

TimeXtender Portal Q&A

Ask questions about the TimeXtender Portal

General

35 topics
156 Replies

Data Sources Q&A

Ask questions of about setting up data sources

General

51 topics
258 Replies

REST APIs

34 topics
231 Replies

RSD File Customization

23 topics
163 Replies

SAP

8 topics
28 Replies

Oracle

8 topics
43 Replies

ODBC

7 topics
46 Replies

General Q&A

Ask general questions

General

31 topics
112 Replies

Interoperability with other Platforms & Tools

9 topics
38 Replies

Legacy & Upgrades

62 topics
231 Replies

Security & Compliance

5 topics
16 Replies

Infrastructure & Networking

8 topics
29 Replies

XPilot

0 topics
0 Replies

Learn & Share

Share tips and best practices, show what you've created and inspire others

Success Stories

4 topics
4 Replies

Tips, Tricks and Best Practices

18 topics
44 Replies

TimeXtender Tuesdays

29 topics
40 Replies

Community Announcements

Everything you need to know about this community

Getting started in the community

8 topics
5 Replies

Company Announcements

15 topics
25 Replies

Exmon

General

6 topics
18 Replies

Community Statistics

1,408: Topics
4,743: Replies
985: Members

Awarded Badges widget

devin.tiemenshas earned the badge Prepare Expert
KCMThas earned the badge Innovator
dennishanssenhas earned the badge Certified Solutions Architect
Roy Vhas earned the badge Prepare Expert
rvgfoxhas earned the badge Deliver Expert

Show all badges

Leaderboard

Show full leaderboard

Ask Questions. Find Answers. Fast.

Download the latest version of TimeXtender Data Integration

Featured topics

The latest & greatest from the community

Community Statistics

Awarded Badges widget

Leaderboard

Need more help?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded