Forum Discussion

jeffshurtliff's avatar
jeffshurtliff
Boss
5 years ago

Obtain group membership roles for a user across multiple group hubs?

Does any know how best to retrieve the group membership roles for a user across multiple group hubs without making a dozen or more separate API calls? I am able to confirm membership when querying f...
  • SuzieH's avatar
    SuzieH
    5 years ago

    HI jeffshurtliff. Unfortunately, I couldn't come back with a magical solution ğŸ˜•. The team said that we don't currently support node.id IN() and user.id =  together in the same WHERE clause for queries to the roles collection. (I'll have to clarify this in the API docs. I didn't think of your use case when I was writing the examples.) 

    An endpoint might be the way to go. Is the /batch endpoint something that could make the task more efficient/performant?




SuzieH's avatar
SuzieH
Khoros Alumni (Retired)

HI jeffshurtliff. Unfortunately, I couldn't come back with a magical solution ğŸ˜•. The team said that we don't currently support node.id IN() and user.id =  together in the same WHERE clause for queries to the roles collection. (I'll have to clarify this in the API docs. I didn't think of your use case when I was writing the examples.) 

An endpoint might be the way to go. Is the /batch endpoint something that could make the task more efficient/performant?




jeffshurtliff's avatar
jeffshurtliff
Boss
5 years ago

Hey SuzieH, no worries at all, thanks so much for looking into this for me!  I hadn't thought about using the /batch endpoint for something like this, so that is a great idea and I'll give it a try for sure!

Thanks again!