Forum Discussion

jeffshurtliff's avatar
jeffshurtliff
Boss
4 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
    4 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?




jeffshurtliff's avatar
jeffshurtliff
Boss

Thanks SuzieH!!  We are running 20.10 (20.10-release r2011170331).

SuzieH's avatar
SuzieH
Khoros Alumni (Retired)
4 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?




  • jeffshurtliff's avatar
    jeffshurtliff
    Boss
    4 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!

    • SuzieH's avatar
      SuzieH
      Khoros Alumni (Retired)
      4 years ago

      Please let me know how it goes. I'm guessing you're not the only one looking for functionality like this.