Skip to main content
Question

TX Rest Dynamic value Endpoint query


Forum|alt.badge.img

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 

https://support.timextender.com/data-sources-112/timextender-rest-data-source-1660#Dynamic+value+from+endpoint+table

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:

 

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • April 10, 2025

Hi ​@juriaan.hensbroek 

Does it behave differently if it is without a where clause?


Forum|alt.badge.img

@Thomas Lind No it's the same (No such table error). I tried several things like:

FROM [Trigion_01_RespondentList]

FROM [Trigion_01_RespondentList].[Trigion_01_RespondentList]

FROM [REST].[Trigion_01_RespondentList]

All with and without square brackets...


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings