Skip to main content
To homepage To homepage

Data Sources Q&A

Ask questions of about setting up data sources

140 Topics
D
Contributor
dan.beggsContributor
asked in RSD File Customization
Pass TimeXtender variable value to CData REST provider rsd file

We have a REST API that we are calling and setting up pagination on, so we are using an rsd file.  We need to pass a calculated date (milliseconds since 1970) to the API call.  I think we might need to reference a stored date of our last data extraction and then calculate the proper date to pass to the REST API.  I am thinking we might do that in TX, but I am unclear how we can then pass a TX variable value in to the rsd file so we can put it into the query string of the API call.  Any pointers that can be provided would be appreciated. Thanks!

2351
Thomas Lind
Community Manager
1 year ago
D
Contributor
dan.beggsContributor
asked in REST APIs
CData REST provider using API key

We have a new REST API data source that we are trying to connect to.  This data source takes only an API key through the Authorization: Bearer <api_token> request header.  I am using the CData ADO.NET Provider for REST 2019.  I have added the API URI and the custom header (bearer token), and even selected OAuth 2.0 and added a Callback URL of http://localhost:33333.  No matter what I do, it seems as though the API key is not being passed correctly.  The message I get in the response is "{"message":"Invalid Token"}" and "HTTP/1.1 401 Unauthorized".  I am able to connect to this data source using Postman with the Authorization: Bearer token.  Can anyone give advise on specific settings for using only an API key? Thanks, Dan

4139
D
Contributor
2 years ago
T
Starter
thyeStarter
asked in RSD File Customization
REST API request with paramaters (list) based on previous request

Although I'm following the steps explained on this page (https://legacysupport.timextender.com/hc/en-us/articles/360034695651-Connect-to-a-REST-API), I can't figure out what's going wrong.Situation: I have a REST API, with two endpoints: one for fetching all locations (locationId) and one for fetching all reviews per location. I need the locationId from the first request, iterate trough all locationId's and request the reviews per location.  First request is working perfectly, REST.json is loaded with all locations. For the second request, I've edited the RSD file, with an input parameter and filter (I know, the URL is mentioned twice, don't know which one is correct):Then I added a dynamic filter:However, no results. Does anyone know what I'm doing wrong? Can someone point me in the right direction? Thanks in advance!

25712
Thomas Lind
Community Manager
2 years ago
R
Contributor
r.depagterContributor
asked in RSD File Customization
REST API POST with custom body

Hi, To make sure my API will always function without manually changing the API token each period, I want to request the token and inject it into an API GET header. To do this, I need to know how to write the proper XML that can do the following: API URL: example.company.com/api/LoginRequired body: EMAIL: example@gmail.comPASSWORD: examplepassword123How do I write the poper XML inside a DSD file to request the token using the body parameters (not in the header), I cannot find the proper documentation. Thanks in advance!

2806
R
Contributor
2 years ago
R
Explorer
roland.peetersExplorer
asked in Oracle
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

I try to connect to an oracle database in TimeXtende and i get the error "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM".  I have no blanks in the datetime-fieldI have no date before 10-2-2010 and I have no dates after 22-11-2021I have several several datetime-fields like 5-3-2020 00:00:00Could the time being the problem ? How can i stil import alle records in TX ?     

4391
S
Contributor
3 years ago
J
Contributor
juriaan.hensbroekContributor
asked in RSD File Customization
Nested RSD REST API

I'm trying to get data from a REST api. The challenge is that the response is nested (JSON format).I did split up the seperate fields by editing the RSD file, adding something after the xPath...The result looks better than before but still all my answers are comma seperated in 1 field/row combination instead of 1 field 4 rows for example. It looks like this now:How can I make sure I only get 1 anwser per value per row? (So line 1, field q_position should be seperated to 4 rows with value 1,2,3 and 4)

2978
Thomas Lind
Community Manager
3 years ago
G
Starter
gaspard.duquesnoyStarter
asked in RSD File Customization
ODX REST api with incremental values

For a REST endpoint we need to load incremental, how can I set up incremental columns in ODX and pass this values in the RSD file?

1261
Thomas Lind
Community Manager
3 years ago
L
Starter
lpargiterStarter
asked in General
ApplicationIntent=ReadOnly

Is it possible to configure the default SQL connector Database Type "SQL Data Source" to use the Connection String property "ApplicationIntent=ReadOnly".   It does not appear to honor this setting as Timextender connects to the primary, not the read only replica.   We are confident in our Server side configuration as timextender is the only app we are having an issue with where an app does not connect to the read only replica when the connection property exists.  Is there another method for us to do this? Thanks, Luke

9174
JTreadwell
Employee
3 years ago
A
Starter
a.rijkensStarter
asked in ODBC
Use of ODBC

Hello, one of our customers is considering the use of TimeXtender but their IT department is not supporting ODBC. Is it possible to discover (metadata analysis) and transfer data from new datasources (SQL, Oracle, etc.) without the use of ODBC? Or can all be done using the ODX server?

1022
A
Starter
3 years ago
M
Starter
Madelon Jansen | VictaStarter
asked in RSD File Customization
Rest - HTTP Response Headers

How can I access the HTTP Response Headers when retrieving data from the CData Rest Connector? I need to read values from it to set up pagination in the .rsd file. In my case it contains the current page, records per page and total number of records.

625
Thomas Lind
Community Manager
4 years ago
E
Starter
eks_guasStarter
asked in General
cdata for dynamics 365 for operation not able to refresh.

I am working on a environment with TimExtender and Dynamics 365 for Operation.  First I must clear out ClientSecret and ClientAuthentication key before I can Authorize to d365.  After that i put in those keys and the session is started.  After a while the sessions is closed and I have to Authenticate myself all over again to be able to extract data form d365.   exept from logfiles> 2020-08-13T09.00.37.158+02:00 0 [Connection: 158] Executed connect: Error: AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. 2020-08-13T09.00.37.160+02:00 0 AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. ffo190j.xaat ffo190j.nna.C(ra , String )at ffo190j.nna.q(String , String , String , Boolean , Boolean , Boolean , BmB , BmB , BmB )at ffo190j.nnI

1438
E
Starter
4 years ago
S
Starter
sturla.winger.svendsenStarter
asked in RSD File Customization
How to connect to REST/API endpoint with dynamic date input?

Hi, I need to extract data from an API which take dates as input values, [from date] and [to date]. And I need to extract data from this API each day. Is it possible to pass dynamic dates to the API connection based on todays date? I can't figure out how to do this.   cheers, Sturla

2424
Thomas Lind
Community Manager
4 years ago
M
Starter
marius.gundersenStarter
asked in Oracle
Oracle DB - ORA-01830 - datefilter

Hi,I am trying to import data from a Oracle db and need a datefilter to limit the amount of data extracted, for instance last 7 days.Version: Discovery Hub 19.2.9.64Everything works fine when I test the SQL in Oracle, but when I put it into TX this error occurs every time:ORA-01830: date format picture ends before converting entire input stringDetails:ORA-01830: date format picture ends before converting entire input string ...Module: OraOLEDBSystem.Data.OleDb.OleDbExceptionat System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)at TimeXtender.DataManager.StepTransferSSISExecute.BulkCopySource(Boolean

935
M
Explorer
5 years ago
R
Starter
r.miltenburgStarter
asked in Oracle
ORA-01861

'ORA-01861 Literal does not match format strings' I keep getting this error when I want te deploy and execute my table. I tried the troubleshoot option: delete the table by using the SQL Server Cleanup Tool, but this doesn't seems to work in my case. The field that gets the error is my Regestration Date with data type 'DATE'. This field also contains dates before 1753-1-1 (I guess typos). I've added a data selection rule and then I get the ORA error. You guys got a solution for this problem?

1061
W
Contributor
6 years ago
S
Starter
sigurdur.jonssonStarter
asked in SAP
SAP Theobald connector

 Need to connect to someone with the experience of using Theobald connector in TX.  Seems like the only connection options I get are Z_XTRACT_IS_TABLE and Z_XTRACT_IS_TABLE_COMPRESSION, which implies that TX is only using the Xtract_IS_Table connector.What if I want to use other Theobald connectors, such as Xtract_IS_OHS, Xtract_IS_BW_Loader or Xtract_IS_Report?

2251
J
Contributor
6 years ago

Badge winners

  • Certified Solutions Architect
    Dikshahas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    brett.taylorhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    RobvdBrinkhas earned the badge Certified Solutions Architect
  • Ingest Expert
    aftabphas earned the badge Ingest Expert
  • Certified Solutions Architect
    Leo Rogemanhas earned the badge Certified Solutions Architect
Show all badges
Terms and ConditionsCookie settings