Schema Extension and Custom Attributes

The Oracle NetSuite system supports the ability to extend the schema through attribute mapping. You can add additional attributes and custom entity fields to your entity records to gather information specific to your business needs. Custom entity fields can be added to existing and custom sub tabs on the entry forms you use to enter entity records in your Oracle NetSuite account.

Additional Attributes

You can add additional fields from the Oracle NetSuite managed system to your entity records to gather information specific to your business needs. Oracle NetSuite supports the Read operation of additional attributes by configuring the attribute XPath in Attribute Mapping and adding the attribute to account schema.

Support of Additional Attributes

To support the additional attributes from IdentityIQ:

1. Add the additional attributes name in the schema by clicking Add attribute button.

2. The XPath entry will look like:

   Schema Atrributes	Navigation Path (XML XPath) / Custom Attribute
   GENDER	listEmp:gender

Note
The XPath must be given by considering /record as the root element in the XML response.

For example, this is the SOAP response for employee:

<soapenv:Envelope
    xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Header>
        <platformMsgs:documentInfo
            xmlns:platformMsgs="urn:messages_2019_1.platform.webservices.netsuite.com">
            <platformMsgs:nsId>WEBSERVICES_TSTDRV942460_0920202136479827402549852_32553d3a7</platformMsgs:nsId>
        </platformMsgs:documentInfo>
    </soapenv:Header>
    <soapenv:Body>
        <getResponse
            xmlns="urn:messages_2019_1.platform.webservices.netsuite.com">
            <readResponse>
                <platformCore:status isSuccess="true"
                    xmlns:platformCore="urn:core_2019_1.platform.webservices.netsuite.com"/>
                    <record internalId="901077" xsi:type="listEmp:Employee"
                        xmlns:listEmp="urn:employees_2019_1.lists.webservices.netsuite.com">
                        <listEmp:entityId>Testing XPath</listEmp:entityId>
                        <listEmp:firstName>Testing</listEmp:firstName>
                        <listEmp:lastName>XPath</listEmp:lastName>
                        <listEmp:isInactive>false</listEmp:isInactive>
                        <listEmp:lastModifiedDate>2021-09-20T00:46:59.000-07:00</listEmp:lastModifiedDate>
                        <listEmp:gender>_omitted</listEmp:gender>
                    </record>
                </readResponse>
            </getResponse>
        </soapenv:Body>
    </soapenv:Envelope>

Custom Attributes

IdentityIQ for Oracle NetSuite ERP supports the ability to read and write custom attributes.

The following Oracle NetSuite Custom field types are supported in IdentityIQ:

• Checkbox

• Date

• Free-Form Text

• Email Address

• Phone Number

• Hyperlink

Support of Custom Attributes

Perform the following to support the custom attributes from IdentityIQ:

Add the custom attribute label (case sensitive) into the Attribute Mapping field by selecting the Add attribute button. You can find custom attribute labels by going to Customization > Lists, Records, & Fields > Entity Fields on the Oracle NetSuite managed system: