I list of all my Apps and their Streams, and all the users who are on those Streams. I am using two connections REST_app and REST_user. I am unable to find a common link between them. Is there a way to connect the two sources?
Its not possible with just those two endpoints. Users are not assigned to streams, they are granted access through security rules. So the only way to identify if a user has access to a certain stream is to evaluate those rules.
One option is to use one of the /qrs/systemrule/security/ endpoints but those can be very resource intensive if used on a large number of users and streams, so if you go this way then you should be a little careful so as not to overload the repository service. This endpoint is probably the one that would fit your needs the best:
