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?




SuzieH's avatar
SuzieH
Khoros Alumni (Retired)
4 years ago
Hey Jeff. Which version are you on now? I'll bring your question up to the team that worked on that last enhancement to the membership API. Let's see if they have some suggestions.
  • jeffshurtliff's avatar
    jeffshurtliff
    Boss
    4 years ago

    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!