NetSuite: Import Audiences
Importing your consumer data from Netsuite allows you to use your NetSuite users in Lytics audiences.
Integration Details
- Implementation Type: Server-side.
- Implementation Technique: SOAP API.
- Frequency: Batch.
- Resulting data: User profiles.
This integration utilizes the NetSuite APIs to import user data. Once the import is started the job will:
- Import all consumers to the
netsuite_consumersstream. - If configured to run continuously, continue to import any new consumers hourly.
Fields
The following fields are included in the default mapping of the netsuite_consumers stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
email unique id | NetSuite User ID | string | |
| internal_id | ns_internal_id unique id | NetSuite ID | string |
| company_name | company | Company Name | []string |
| first_name | first_name | First Name | string |
| last_name | last_name | Last Name | string |
| account | ns_account | NetSuite Account | string |
| default_address | ns_address | NetSuite Default Address | string |
| budget_approved | ns_budget_approved | NetSuite Budget Approved | string |
| created_time | ns_created_time | NetSuite Created Time | date |
| credit_hold_override | ns_credit_override | NetSuite Credit Override | string |
| email_preference | ns_email_preference | NetSuite Email Preference | string |
| email_transactions | ns_email_transactions | NetSuite Email Transactions | string |
| internal_id | ns_entity_id | NetSuite Entity ID | string |
| external_id | ns_external_id | NetSuite External ID | string |
| fax_transactions | ns_fax_transactions | NetSuite Fax Transactions | string |
| global_subscription_status | ns_global_subscription_status | NetSuite Global Subscription Status | string |
| inactive | ns_inactive | NetSuite Inactive | string |
| is_person | ns_is_person | NetSuite Is Person | string |
| login_access | ns_login_access | NetSuite Login Access | string |
| modified_time | ns_modified_time | NetSuite Modified Time | date |
| print_transactions | ns_print_transactions | NetSuite Print Transactions | string |
| role | ns_role | NetSuite Role | string |
| status | ns_status | NetSuite Status | string |
| subsidiary | ns_subsidiary | NetSuite Subsidiary | string |
| taxable | ns_taxable | NetSuite Taxable | string |
| terms | ns_terms | NetSuite Terms | string |
| unbilled_orders | ns_unbilled_orders | NetSuite Unbilled Orders | string |
| web_lead | ns_web_lead | NetSuite Web Lead | string |
Configuration
Follow these steps to set up and configure an Import of NetSuite in the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.
- Select NetSuite from the list of providers.
- Select the Import Audiences job type from the list.
- Select the Authorization you would like to use or create a new one.
- From the Import Since text input, input the latest date from which you want consumers to be imported. Please use the format
yyyy-mm-dd(e.g. 2019-03-27). - Select the Keep Updated checkbox to make the integration to run continuously.
- Click Start Import.