Get list of all project space that one user has access to, under the organization

Here is the pipeline design to get list of all workspace list that a user has access to.

user permission can be given in 3 ways

  1. individual user permission grant
  2. group permission
  3. admin permission

this pipeline will scan all workspace of that organization and it will also scan all group list of that organization and it will find out where are the user has access to.

as this scanning takes lots of time we need to cache the data somewhere. here we are using file storage in snaplogic for this cache operation. the file will be refreshed after each 1 hr interval.
we are using a scheduled task for this refreshing.the scheduled job pipeline is given at last.
here are some configuration details of the main pipeline.
this will try to read the data from local file storage first.
image
if local file does not exist it will go to get all group list:
image
then it will get group details for each group name.
at next step it will save the extracted data in a file for future use and will proceed for further processing.
here is the configuration of filter to get the workspace list where that mentiond user has access to.
image
parallelly for individual user permission
then the two result will be joined together to get the final result.

the scheduled task pipeline is:it will be scheduled at cron of 1 hour interval.

1 Like

Hi Krish - Thank you for posting these pipeline samples! We’d love to share your pipelines with other SnapLogic community members.

Would you please share your pipelines by submitting them here? Pipeline Pattern Submission Form

Once we have the SLP files from you, we can start posting them on the designated Patterns Catalog!

Thanks, Karen