Data import

Queries and mappings

The Omada Aha! connectivity package provides the following mappings:

Users - Accounts

Parameters:

Parameter	Value
URL	users
Collection	users

Mappings:

Destination	Operator	Source
Unique ID	Map	id
Account Name	Map	email
Display Name	Map	name
Status	Expression	(enabled == true) ? "Active" : "Disabled"
Valid from	Map	created_at
Distinguished name	Map	id
licensed	Expression	paid_seat ? "Yes" : "No"
administrator	Expression	administrator ? "Yes" : "No"

Products (workspace) – Viewer Permission – Resources

Parameters:

Parameter	Value
URL	products
Collection	products

Mappings:

Destination	Operator	Source
Business key	Expression	id+"-Viewer"
Security resource business key	Expression	id+"-Viewer"
Name	Expression	name + " - Viewer"
Category	Constant	Permission
Type	Expression	product_line ? "Aha Company" : "Aha Workspace"
Short Name	Expression	id+"-Viewer"
Description	Map	reference_prefix
ahapermission	Constant	Viewer

Products (workspace) – Reviewer Permission – Resources

Parameters:

Parameter	Value
URL	products
Collection	products

Mappings:

Destination	Operator	Source
Business key	Expression	id+"-Reviewer"
Security resource business key	Expression	id+"-Reviewer"
Name	Expression	name + " - Reviewer"
Category	Constant	Permission
Type	Expression	product_line ? "Aha Company" : "Aha Workspace"
Short Name	Expression	id+"-Reviewer"
Description	Map	reference_prefix
ahapermission	Constant	Reviewer

Products (workspace) – Contributor Permission – Resources

Parameters:

Parameter	Value
URL	products
Collection	products

Mappings:

Destination	Operator	Source
Business key	Expression	id+"-Contributor"
Security resource business key	Expression	id+"-Contributor"
Name	Expression	name + " - Contributor"
Category	Constant	Permission
Type	Expression	product_line ? "Aha Company" : "Aha Workspace"
Short Name	Expression	id+"-Contributor"
Description	Map	reference_prefix
ahapermission	Constant	Contributor

Products (workspace) – Owner Permission – Resources

Parameters:

Parameter	Value
URL	products
Collection	products

Mappings:

Destination	Operator	Source
Business key	Expression	id+"-Owner"
Security resource business key	Expression	id+"-Owner"
Name	Expression	name + " - Owner"
Category	Constant	Permission
Type	Expression	product_line ? "Aha Company" : "Aha Workspace"
Short Name	Expression	id+"-Owner"
Description	Map	reference_prefix
ahapermission	Constant	product_owner

Administrator – Account Admin Permission – Resources

Parameters:

Parameter	Value
URL	users
Collection	users
Distinct	Yes

Mappings:

Destination	Operator	Source
Business key	Expression	administrator_roles_administer_account == false ? "administer_account" : "administer_account"
Security resource business key	Expression	administrator_roles_administer_account == false ? "administer_account" : "administer_account"
Name	Expression	administrator_roles_administer_account == false ? "administer_account" : "administer_account"
Category	Constant	Permission
Type	Constant	Aha Administrator Role

Administrator – Billing Admin Permission – Resources

Parameters:

Parameter	Value
URL	users
Collection	users
Distinct	Yes

Mappings:

Destination	Operator	Source
Business key	Expression	administrator_roles_administer_billing == false ? "administer_billing" : "administer_billing"
Security resource business key	Expression	administrator_roles_administer_billing == false ? "administer_billing" : "administer_billing"
Name	Expression	administrator_roles_administer_billing == false ? "administer_billing" : "administer_billing"
Category	Constant	Permission
Type	Constant	Aha Administrator Role

Administrator – Configuration Admin Permission – Resources

Parameters:

Parameter	Value
URL	users
Collection	users
Distinct	Yes

Mappings:

Destination	Operator	Source
Business key	Expression	administrator_roles_administer_configuration == false ? "administer_configuration" : "administer_configuration"
Security resource business key	Expression	administrator_roles_administer_configuration == false ? "administer_configuration" : "administer_configuration"
Name	Expression	administrator_roles_administer_configuration == false ? "administer_configuration" : "administer_configuration"
Category	Constant	Permission
Type	Constant	Aha Administrator Role

Product (workspace) – Administer Account Permission - Assignments

Parameters:

Parameter	Value
URL	users
Collection	users
Filter	administrator_roles_administer_account == true

Mappings:

Destination	Operator	Source
Resource business key	Expression	administrator_roles_administer_account == true ? "administer_account" : null
Account – business key	Map	id

Product (workspace) – Administer Billing Permission - Assignments

Parameters:

Parameter	Value
URL	users
Collection	users
Filter	administrator_roles_administer_billing == true

Mappings:

Destination	Operator	Source
Resource business key	Expression	administrator_roles_administer_billing == true ? "administer_billing" : null
Account – business key	Map	id

Product (workspace) – Administer Configuration Permission - Assignments

Parameters:

Parameter	Value
URL	users
Collection	users
Filter	administrator_roles_administer_configuration == true

Mappings:

Destination	Operator	Source
Resource business key	Expression	administrator_roles_administer_configuration == true ? "administer_configuration" : null
Account – business key	Map	id

Product and Roles (Permission) - Assignments

Parameters:

Parameter	Value
URL	users
Collection	users
Nested URL	users/{PARENT_id}/product_roles
Nested URL Collection	product_roles

Mappings:

Destination	Operator	Source
Resource business key	Expression	product_id+"-"+role_description
Account – business key	Map	PARENT_id
Description	Map	product_name
Permission level	Map	role_description

Advanced configuration

You can optionally use the per_page parameter to change the number of records returned in each page (up to a maximum of 200). The default is 30 records per page if the parameter is not set.

Field	Value
Paging mechanism	URL parameters
URL parameters	page={pageIndex}&per_page=50
Starting index	1
Total field	pagination_total_records

Account rules

The ownership rule – the account owner is set to the identity where the Email value of the identity matches the Name value of the account.

Field	Value
Type	Identity lookup
Join reason	Exact Match
Account attribute	Name
Identity attribute	Email

The classification rule – if an identity with the account attribute Identity join reason equals Exact Match, the account type is set to Email.

Field	Value
Account type	Personal
Scope attribute	Identity join reason
Scope operator	Equals
Scope value	Exact Match