TX Rest Dynamic value Endpoint query

Hi ​@juriaan.hensbroek 

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

​@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...

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?

Hi ​@juriaan.hensbroek do you have an update to Thomas’ questions above?

Hi Thomas,

Yes I use table flattening. The (flattened) table in which I retrieve the id's is called Trigion_01_RespondentList. I could select them from the dropdown menu. Also if I use a shorter name for the respondentlist table, without underscores, I get the same error.

Regards,

Juriaan

Hi ​@juriaan.hensbroek 

Do you still use the where clause, or is it only select id from Trigion_01_RespondentList that is your query?

Also I don’t use any new line commands it is just one row. I don’t know if it has issues with that.

It may read it as select idfrom Trigion_01_RespondentList if that is the case.

No where clause, no empty space after the query. Putting it on 1 line doesn't make a difference.

​@juriaan.hensbroek i had the same issue, but when i use the ‘From Endpoint Table’ option, it works as intended:
 

In this data source i use it to get members from Azure AD Groups

Hi ​@JogchumSiR , this works for me as well. This was my base version. In my improved version I'd like to filter upfront the userlist. For your example it could be all AD users from the Sales department. Just for example. That is why I'm trying to use the query function.

In my case the userlist is a list of all recipients we did sent an survey to. This same list has a boolean flag which shows which users responded. In my second API call I need to loop through all recipient id's which have responded to the survey.

Hi ​@juriaan.hensbroek 

In my setup I use the following endpoint path.

groups/{id}/members/microsoft.graph.user

I found that it would only return users and not other types with this added.

Perhaps that could be a workaround.

​@Thomas Lind this wouldn't work for me. The “responses” endpoint call seems correct, I only wish to filter the id's from endpoint 1 “respondentlist” upfront before making the “responses” endpoint call.