Skip to main content
To homepage To homepage
Question

TX Rest Dynamic value Endpoint query

J
Contributor
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 

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:

 

3 replies

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

Hi ​@juriaan.hensbroek 

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

J
Contributor
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...

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

Hi ​@juriaan.hensbroek 

I tried it out. I did not use a endpoint with a complicated name it is just one sentence.

I use Graph API and my Users endpoint to pull the id field.

This worked, the table in the store is also called Users, so it may be part of it.

Does the name have blank spaces instead of _ in any of the versions that exist of this table?

You are using table flattening as well, right?

Reply


Most helpful members this week

Terms and ConditionsCookie settings

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