M308: Import [User], [Organization] and Group Settings from Google Workspace

 

If you are using the Cloud based office suite Google Workspace it is cumbersome to manage all the Users in a similar way in both Google Workspace and Questetra. You can import Organizations, Users and Groups from Google Workspace via APIs and register them in bulk as [Organization], [User] and [Role] in Questetra.

1. Overview of Secure Intersystem Communication

a. OAuth

A mechanism where those who can log into two different systems can give permission for direct communication between those systems

• It consists of a system that requests communication, a system that responds, and one that manages the connection authentication
• It is also possible to cancel the permission later (according to the Settings on the responding system side)

2. Enable API access in Google Workspace in advance

1. Enable API access

On the (Security Settings) screen enable API access in advance

• To set up the Google Workspace side Administrator Privileges on Google Workspace are required

3. Request Registration Information from Questetra to Google Workspace

1. Set the connection destination Domain

Register your domain in the [Google Connectivity] settings menu (M309)

2a. Acquire the List of Organizations

Click [Confirm] in Import Organization List within the Organization List menu

2b. Acquire the List of Users

Click [Confirm] in Import Users within the User List menu

2c. Acquire the List of Groups

Click [Confirm] in Import Roles within the Role List menu

3. Add / Update / Mark for Deletion

Edit settings of the Questetra side based on the difference of information between both systems

R3080: Specification of Synchronization with Google Workspace
R3081: Collection From Other Sources
R3082: Sharing with user's consent
System Settings – User List
System Settings – Organizations List
System Settings – Role List
System Settings – Google Connectivity

• There is an upper limit to the number of records that can be registered in a batch
  • Users: 1000, Organizatin/Role: 300
• List candidates for addition, update or deletion based on the difference of information, then execute all or part of them
• One way data synchronization from Google Workspace to Questetra (Settings of the Google Workspace side never change)
• It is also possible to capture information from multiple domains by changing the domain and executing the operation multiple times
• To Delete Users marked for Deletion, Click [Delete User] on each User’s detail screen
• To Clear the domain connection settings leave the [Domain] field blank and save it

---

X. Blog Articles

• 2019-01-23: Settings when Calling REST API of Another Service from Questetra