NetSuite Customer Company To iPaaS.com Mapping Documentation

An organization (company) customer can be captured from NetSuite into iPaaS.com. The integration records the company name, email, phone, fax, categories, and a range of NetSuite-specific attributes, and through its child collections the company's address and parent relationship. Individual (person) customers are captured separately by Add/Update NetSuite Customer TO iPaaS.com. Companies transfer on demand from the Manual Sync page or automatically on NetSuite company events.

ID Format

Manual Sync ID Format

Enter the NetSuite company's internal ID on the Manual Sync page.

External ID Format

iPaaS.com records the NetSuite internal ID as the external-ID link (the primary match for subsequent updates), and as a fallback match key on the iPaaS.com customer record.

Deleted Record Support

Inbound delete is driven by the external-ID link where a delete collection is enabled — a deletion in NetSuite removes the linked iPaaS.com company. It runs only when the corresponding NetSuite delete event and webhook scripts are in place.

Custom Field Support

A range of NetSuite-specific attributes — phone, mobile/home/alternate phone, alternate email, title, account number, URL, ship-complete, inactive flag, and subsidiary — are captured into iPaaS.com custom fields named NetSuite …. These are the capture side of the integration's round-trip convention: the same custom fields are read back on the Add/Update NetSuite Customer Company FROM iPaaS.com side. Add the matching iPaaS.com custom fields to retain these attributes.

Mapping Collection Status

Status: Enabled (a single Add/Update collection).
Trigger Events: company/created, company/updated. Enable inbound transfers in Inbound Data Flows and install the NetSuite-side webhook scripts (see NetSuite Connections and Settings). Manual Sync is always available.

Duplicate or Conflicting Mappings

Add/Update NetSuite Customer TO iPaaS.com — individual (person) customers.
Add/Update NetSuite Customer Company FROM iPaaS.com — writes companies to NetSuite (the reverse direction).

Collision handling

Matching uses the external-ID link (primary) and the captured NetSuite internal id (fallback). No iPaaS.com collision-handling method is configured for this collection.

Supported Child Collections

Add/Update NetSuite Customer Company Address TO iPaaS.com — the company's address.
Add/Update NetSuite Company Relationship TO iPaaS.com — the company's parent relationship.

System Caveats

NetSuite Caveats

Subsidiary filter. Only companies in the subsidiary named in the filter are captured (see Mappings). The shipped name is a placeholder.

Integration-Specific Caveats

"NetSuite …" round-trip convention. NetSuite-specific attributes are captured into the identically named custom fields read back by the FROM direction (see Custom Field Support).
Parent record is created for you. If the company belongs to a parent company or customer not yet in iPaaS.com, the integration creates that parent automatically as a prerequisite during capture (a failure blocks the company) — you do not pre-create it.
Customer pricing becomes iPaaS.com categories. A NetSuite company's pricing group and/or price level — the things that set the prices that company sees — are captured as iPaaS.com customer categories. The Customer Company Pricing Source setting, in the NetSuite subscription's Subscription Settings in iPaaS.com, controls which is used: PRICE_GROUP_ONLY (the default — pricing group only), PRICE_LEVEL_ONLY (price level only, with an optional Default Price Level fallback), GROUP_THEN_LEVEL (pricing group, else price level), or LEVEL_THEN_GROUP (price level, else pricing group). You do not need to pre-create these categories — the integration creates the matching iPaaS.com customer category automatically as a prerequisite during capture; they can also be bulk-loaded via Add/Update NetSuite Customer Pricing Group TO iPaaS.com.

Setup Requirements

Control Fields and Required Configuration

Subsidiary filter — placeholder. The capture filter is hardcoded to the subsidiary named Parent Company; replace it with your subsidiary (or broaden it) so the companies you intend to capture are not silently excluded.
Customer Company Pricing Source (and the optional Default Price Level fallback) — found in the NetSuite subscription's Subscription Settings in iPaaS.com. Controls whether a company's NetSuite pricing group, price level, or one-then-the-other becomes the iPaaS.com categories (PRICE_GROUP_ONLY default, PRICE_LEVEL_ONLY, GROUP_THEN_LEVEL, LEVEL_THEN_GROUP).
NetSuite … custom fields — create the iPaaS.com custom fields you want to retain.
Inbound Data Flows + webhook scripts — enable the NetSuite company events and install the webhook scripts for automatic capture.

Authentication

The integration authenticates to NetSuite using the connection configured for the integration; the webhook scripts that emit NetSuite events are documented in NetSuite Connections and Settings.

Integration Flow

A NetSuite company is captured — on demand from the Manual Sync page, or automatically on company/created / company/updated events when Inbound Data Flows and the webhook scripts are in place.
The subsidiary filter admits only companies in the configured subsidiary.
The integration creates or updates the iPaaS.com company (matched by external ID, then by the captured NetSuite id), capturing the NetSuite-specific attributes into the NetSuite … custom fields, and transfers the address and relationship children.

Mappings

The address and relationship children have no filter. The subsidiary value in the parent filter is a placeholder to replace.

Add/Update NetSuite Customer Company TO iPaaS.com

iPaaS.com data type: Customer Company

Mapping Filter

var subsidiaryId = await GetSubsidiaryIdByName("Parent Company"); 
if(subsidiaryId != null && Subsidiary_Id != null && Subsidiary_Id == subsidiaryId) 
    return true; 
else 
    return false;

Filter Description. Resolves the internal ID of a named subsidiary, then captures the company only when its subsidiary matches; all other companies are skipped. Placeholder value — replace during implementation: Parent Company is an example subsidiary name — replace it with your subsidiary so the companies you intend to capture are not silently excluded.

Captures a NetSuite company (organization) customer into iPaaS.com, storing NetSuite-specific attributes in iPaaS.com "NetSuite …" custom fields.

Mapping Type	Source Field (NetSuite)	Destination Field (iPaaS.com)	Description
Field	CompanyName	Name	Required. The company name captured from NetSuite; identifies the company in iPaaS.com.
Field	Email	EmailAddress	Recommended. The company's email; the key used to match companies between systems.
Field	Phone	PhoneNumber	Optional. The company's phone number captured from NetSuite.
Field	Fax	FaxNumber	Optional. The company's fax number captured from NetSuite (company-only).
Dynamic Formula	`await ConvertNetSuiteCategoryToiPaaS(Category, GroupPricing, PriceLevel)`	Categories	Optional. Converts the company's category, and optionally pricing group / price level, into iPaaS.com categories per the Customer Company Pricing Source setting.
Field	Phone	NetSuite Phone	Optional. Capture side of the round-trip; stores the phone in the iPaaS.com NetSuite Phone custom field.
Field	MobilePhone	NetSuite Mobile Phone	Optional. Captures the mobile phone into the NetSuite Mobile Phone custom field.
Field	HomePhone	NetSuite Home Phone	Optional. Captures the home phone into the NetSuite Home Phone custom field.
Field	AltPhone	NetSuite Alt Phone	Optional. Captures the alternate phone into the NetSuite Alt Phone custom field.
Field	AltEmail	NetSuite Alt Email	Optional. Captures the alternate email into the NetSuite Alt Email custom field.
Field	Title	NetSuite Title	Optional. Captures the title into the NetSuite Title custom field.
Field	AccountNumber	NetSuite Account Number	Optional. Captures the account number into the NetSuite Account Number custom field.
Field	Url	NetSuite URL	Optional. Captures the website URL into the NetSuite URL custom field.
Field	ShipComplete	NetSuite Ship Complete	Optional. Captures the "ship complete" preference into the NetSuite Ship Complete custom field.
Field	IsInactive	NetSuite Is Inactive	Optional. Captures whether the company is inactive into the NetSuite Is Inactive custom field.
Field	Subsidiary_Id	NetSuite Subsidiary	Optional. Captures the subsidiary into the NetSuite Subsidiary custom field; the FROM direction reads this same field, so a round-tripped company keeps its subsidiary.

Add/Update NetSuite Customer Company Address TO iPaaS.com

iPaaS.com data type: Customer Company Address

Captures the NetSuite company's address into iPaaS.com, storing NetSuite-specific attributes in "NetSuite …" custom fields.

Mapping Type	Source Field (NetSuite)	Destination Field (iPaaS.com)	Description
Field	Addr1	Address1	Recommended. The first address line captured from NetSuite.
Field	Addr2	Address2	Optional. The second address line.
Field	Addr3	Address3	Optional. The third address line.
Field	City	City	Recommended. The city.
Field	State	Region	Recommended. The state/region.
Field	Country_RefName	Country	Recommended. The country.
Field	Zip	PostalCode	Recommended. The postal/ZIP code.
Field	AddrPhone	PhoneNumber	Optional. The address phone number.
Field	IsPrimaryBilling	IsPrimaryBilling	Recommended. Whether this is the primary billing address.
Field	IsPrimaryShipping	IsPrimaryShipping	Recommended. Whether this is the primary shipping address.
Static	`true`	PreventDuplicate	Control. Tells iPaaS.com to avoid creating a duplicate address row on repeated syncs; keep `true`.
Dynamic Formula	`Parent.CompanyName`	Company	Optional. The company name on the address, from the parent company.
Dynamic Formula	`if (Addressee != null){ ...first name from Addressee }`	FirstName	Optional. The recipient first name, extracted from the NetSuite addressee.
Dynamic Formula	`if (Addressee != null){ ...last name from Addressee }`	LastName	Optional. The recipient last name, extracted from the addressee.
Field	Addressee	NetSuite Addressee	Optional. Captures the addressee into the NetSuite Addressee custom field.
Field	Attention	NetSuite Address Attention	Optional. Captures the attention line into the NetSuite Address Attention custom field.
Field	AddrText	NetSuite Address Text	Optional. Captures the full formatted address text into the NetSuite Address Text custom field.
Field	ExternalId	NetSuite Address ExternalId	Optional. Captures the address external ID into the NetSuite Address ExternalId custom field.
Field	Override	NetSuite Override	Optional. Captures the address override flag into the NetSuite Override custom field.

Add/Update NetSuite Company Relationship TO iPaaS.com

iPaaS.com data type: Company Relationship

Captures a NetSuite company's parent relationship (the customer or company it is related to) into iPaaS.com.

Mapping Type	Source Field (NetSuite)	Destination Field (iPaaS.com)	Description
Dynamic Formula	`var customerId = await GetSpaceportIdAsync(Id.Split("\|")[0]...)`	RelatedToId	Required. Identifies the related parent customer or company in iPaaS.com, resolved from the related NetSuite record; the related record must already exist in iPaaS.com to be linked.
Dynamic Formula	`IsPerson ? "Parent Customer" : "Parent Company"`	Type	Recommended. The relationship type — Parent Customer when the related record is an individual, Parent Company when it is a company.
Static	`true`	IsPrimary	Control. Marks this as the primary relationship.

Error Handling

Company skipped by the subsidiary filter — a company in a non-matching subsidiary is silently skipped. Resolution: if expected companies are missing, update the subsidiary in the filter.
Relationship not linked — RelatedToId resolves only to a parent record that already exists in iPaaS.com. Resolution: ensure the related record has been captured first.

Testing & Validation

Test Scenarios

Capture a company. Manually sync a NetSuite company (in the configured subsidiary) and confirm the iPaaS.com company is created with name, email, phone/fax, and the NetSuite … attributes.
Update. Re-sync and confirm the existing iPaaS.com company is updated.
Subsidiary filter. Confirm a company in another subsidiary is skipped, then captured after updating the filter.
Address + relationship. Confirm the address and parent relationship children transfer.
Round-trip. Confirm the NetSuite … custom fields are populated for a subsequent FROM-iPaaS sync.

Validation Checklist

The subsidiary filter names your subsidiary (not the Parent Company placeholder).
The Customer Company Pricing Source setting is configured for how categories should resolve.
The NetSuite … custom fields exist in iPaaS.com to retain the attributes.
Inbound Data Flows and the NetSuite webhook scripts are in place for automatic capture.

Additional Notes

Round-trip with the FROM direction. The NetSuite … custom fields populated here are read back by Add/Update NetSuite Customer Company FROM iPaaS.com.
Individual (person) customers are documented separately under Add/Update NetSuite Customer TO iPaaS.com.
Known limitations affecting customers will be collected in NetSuite Known Limitations.