Skip to main content
To homepage To homepage
Solved

Dynamic query parameter not working in TX REST connector

  • December 11, 2025
  • 3 replies
  • 38 views
R
Starter

Hi,

 

I am trying to conect to an endpoint using a dynamic query parameter from a simple SQL query:

 

SELECT 
      [CODE_ID] as codeId

  FROM [dsa].[Products]

I use {codeId} as value in the query parameter.

 

When deploying, I get the following error: Format of the initialization string does not conform to specification starting at index 0. 

 

When I hard-code the codeId, it works. Using this query does not work. There are around 600 codeId's in the query. Even when i limit it to 2 id's, it gives me the same error.

 

My API documentation does not mention anything about extra parameters. Also, the logs do not give me much more information, other than the error I mentioned.

 

Anyone has experience with this error and has a possible solution?

 

Kind regards,

René
 

Best answer by renevdvlugt

Update:

 

Mistake from my side: I did not specify the server in de connection string of the SQL query.

Had to find that out myself, since the error did not really push me into that direction ;-) 

3 replies

R
Starter
  • renevdvlugt
  • Author
  • Starter
  • Answer
  • December 11, 2025

Update:

 

Mistake from my side: I did not specify the server in de connection string of the SQL query.

Had to find that out myself, since the error did not really push me into that direction ;-) 

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • December 12, 2025

Hi ​@renevdvlugt 

Good point about it not helping with the error message. I will pass it on.

Did you use the Debug Log option when troubleshooting this issue?

It may have shown the error more clearly.

I do explain it in my guide.

https://support.timextender.com/data-sources-112/timextender-rest-data-source-1660#Dynamic+values

R
Starter
  • renevdvlugt
  • Author
  • Starter
  • December 12, 2025

Hi ​@renevdvlugt 

Good point about it not helping with the error message. I will pass it on.

Did you use the Debug Log option when troubleshooting this issue?

It may have shown the error more clearly.

I do explain it in my guide.

https://support.timextender.com/data-sources-112/timextender-rest-data-source-1660#Dynamic+values

Hi Thomas, thanks for your reply. The log file did not give me any information regarding the connection, so it did not help me in this case.
When looking further into the guide you send, I noticed that I forgot to enter the server. So the guide is complete.

Terms and ConditionsCookie settingsAccessibility statement