NetSuite Profile Mappings for Department and Subsidiary Skip to main content
https://support.okta.com/help/answers?id=9060z000000jjowqac&refurl=http%3a%2f%2fsupport.okta.com%2fhelp%2fanswers
How satisfied are you with the Okta Help Center?
Thank you for your feedback!
How satisfied are you with the Okta Help Center?
1
2
3
4
5
Very Dissatisfied
Very satisfied
Enter content less than 200 characters.
Ask Search:
Louis BarbourLouis Barbour 

NetSuite Profile Mappings for Department and Subsidiary

We have an integration with NetSuite and MANY different Departments and Subsidiaries configured in NetSuite.

We would like for the Department and Subsidiary values to map to the user.department and user.nsSubsidiary (custom field that is populated from the users Company value in AD) fields in Okta.

When I attempt to set up this mapping in the profile manager, it throws an error about "invalid data type". I suspect this is because the data types for Department and Subsidiary coming from NetSuite are object and reference, and the data type for user.department and user.nsSubsidiary in Okta are both string.

Is there a way to make this work utilizing the Okta Expression Language, or perhaps another way to approach this mapping altogether?

We would really like to be able to map these two fields to existing user attributes as we could then essentially automate deployment of users to NetSuite. Right now we have to manually add each user, and unfortunately due to the layout of our organization, groups aren't of much help (we have a LOT of very small companies where a Subsidiary/Department consists of only one or two people, so we end up having nearly as many groups as employees, and group management becomes untenable).
Bogdan RaduBogdan Radu (Vendor Management)
Hello Louis ,

To reference an App user profile attribute, just specify the application variable and the attribute variable in that application’s App user profile. In specifying the application you can either name the specific application you’re referencing or use an implicit reference to an in-context application.
When you create an Okta expression, you can reference any attribute that lives on an Okta user profile or App user profile.
You can build an expression language by referring to users' attributes by following this link
https://developer.okta.com/reference/okta_expression_language/#referencing-user-attributes
If none of these options work for you , you can always open a ticket and our support engineers will assist you on this matter.

Kind regards,

Bogdan Radu
Support Engineer
Okta Customer Support