The NetSuite integration provides ready-made functions you can call when building mappings. They handle common lookups and conversions against your NetSuite account and your iPaaS.com data, such as resolving customers, products, locations, subsidiaries, payment methods, and currencies by ID or name, converting categories between the two systems, formatting price lists and custom fields, and validating invoices and gift certificates, so you do not have to write that logic yourself.

These functions are available anywhere you write a formula for the NetSuite integration:

The functions are grouped below by the area of the integration they support.

What it does: Returns the NetSuite customer ID for a given email address.

Signature: Task<string> GetCustomerIdByEmail(object emailAddress)

How to call it: await GetCustomerIdByEmail(emailAddress)

Returns: string. The NetSuite customer ID of the first match, or null when the email is blank or no customer matches.

When to use it: Use it in From iPaaS.com flows to resolve a NetSuite customer ID from an email address.

What it does: Searches NetSuite for a customer by email address and returns the matching customer records. It retries transient failures up to three times.

Signature: Task<object> GetCustomerByEmail(object emailAddress)

How to call it: await GetCustomerByEmail(emailAddress)

Returns: object. The NetSuite customer search result containing the matching customers.

When to use it: Use it when you need the full NetSuite customer record for an email address.

What it does: Returns either the email or the full name of a NetSuite customer matched by email address, based on the requested output field.

Signature: Task<string> GetCustomerDetailByEmailAsync(string email, string outputField)

How to call it: await GetCustomerDetailByEmailAsync(email, outputField)

Returns: string. The requested detail, or null when the customer is not found or the inputs are invalid.

When to use it: Use it to pull a customer's email or name dynamically from an email address.

What it does: Returns either the email or the full name of a NetSuite customer matched by internal ID, based on the requested output field.

Signature: Task<string> GetCustomerDetailByIdAsync(string Id, string outputField)

How to call it: await GetCustomerDetailByIdAsync(Id, outputField)

Returns: string. The requested detail, or null when the customer is not found or the inputs are invalid.

When to use it: Use it to pull a customer's email or name dynamically from a NetSuite internal ID.

What it does: Returns the email address of a NetSuite customer for a given customer (entity) ID.

Signature: Task<string> GetCustomerEmailByEntityId(object entityId)

How to call it: await GetCustomerEmailByEntityId(entityId)

Returns: string. The NetSuite customer's email, or null when the customer is not found or has no email.

When to use it: Use it in To iPaaS.com transaction flows to populate an email from the customer on a transaction.

What it does: Converts a NetSuite customer category, and optionally the customer's price group or price level, into iPaaS.com customer categories. Which pricing source is used follows your subscription's customer pricing-source setting. Categories that do not resolve in iPaaS.com are skipped.

Signature: Task<object> ConvertNetSuiteCategoryToiPaaS(object categories, CustomerPricingGroup GroupPricing = null, CustomPriceLevel PriceLevel = null, bool isForCompany = true)

How to call it: await ConvertNetSuiteCategoryToiPaaS(categories)

Returns: object. A list of iPaaS.com customer categories carrying the resolved category IDs.

When to use it: Use it in To iPaaS.com customer flows to map a NetSuite customer's category and pricing to iPaaS.com categories.

What it does: Returns the NetSuite customer category ID for the first iPaaS.com category name (in the provided list) that matches a category in NetSuite.

Signature: Task<string> GetCategoryIdByCategoryObj(object categoryObj)

How to call it: await GetCategoryIdByCategoryObj(categoryObj)

Returns: string. The NetSuite category ID of the first matching name, or null when none match.

When to use it: Use it in From iPaaS.com flows to resolve a NetSuite category ID from a customer's iPaaS.com categories.

What it does: Returns the NetSuite customer category records that match a given category name.

Signature: Task<object> GetCategoryListByName(object categoryName)

How to call it: await GetCategoryListByName(categoryName)

Returns: object. The NetSuite customer category search result.

When to use it: Use it to fetch NetSuite customer category records by name during customer mapping or validation.

What it does: Returns the number of iPaaS.com transactions for a given customer or company.

Signature: Task<int> TransactionCount(object customerOrCompanyId, bool isCompany = false)

How to call it: await TransactionCount(customerOrCompanyId)

Returns: int. The number of transactions, or 0 when the ID is blank or none are found.

When to use it: Use it when you need only the transaction count for a customer or company.

What it does: Returns the NetSuite product (or product variant) ID that maps to a given iPaaS.com product SKU, using the iPaaS.com mapping.

Signature: Task<string> GetNetSuiteProductIdBySku(object productSku)

How to call it: await GetNetSuiteProductIdBySku(productSku)

Returns: string. The mapped NetSuite product or variant ID, or null when the SKU is blank or has no mapping.

When to use it: Use it in From iPaaS.com transaction flows to resolve a line item's NetSuite item ID from its SKU.

What it does: Returns the NetSuite internal ID of the inventory item whose item ID matches the given value.

Signature: Task<string> GetNetSuiteInventoryItemIdByItemId(object itemId)

How to call it: await GetNetSuiteInventoryItemIdByItemId(itemId)

Returns: string. The NetSuite internal ID of the latest matching inventory item, or null when none matches.

When to use it: Use it to resolve a NetSuite inventory item's internal ID from its business item ID.

What it does: Converts a NetSuite product's categories into iPaaS.com product categories, using the iPaaS.com mapping. Categories without a mapping are skipped.

Signature: Task<object> ConvertNetSuiteProductCategoriesToiPaaS(object categories)

How to call it: await ConvertNetSuiteProductCategoriesToiPaaS(categories)

Returns: object. A list of iPaaS.com product categories carrying the mapped category IDs; an empty list when there is no input or no match.

When to use it: Use it in To iPaaS.com product flows to map a product's NetSuite categories to their iPaaS.com equivalents.

What it does: Returns the iPaaS.com product type for a given iPaaS.com product ID (for example Physical, Assembly Items, or Kit/Package Items).

Signature: Task<string> GetiPaaSProductType(string productId)

How to call it: await GetiPaaSProductType(productId)

Returns: string. The product type, or null when the product is not found or has no type.

When to use it: Use it in a mapping filter to include or exclude records based on the iPaaS.com product type.

What it does: Returns the iPaaS.com product type for a given product SKU.

Signature: Task<string> GetProductTypeBySku(string Sku)

How to call it: await GetProductTypeBySku(Sku)

Returns: string. The iPaaS.com product type, or null when the product is not found or has no type.

When to use it: Use it to determine how a product should be processed based on its type.

What it does: Returns the per-location inventory records for a NetSuite product, choosing the correct NetSuite item type based on the product type you pass.

Signature: Task<object> GetNetsuiteProductWithProductIdAndType(string Id, string Type)

How to call it: await GetNetsuiteProductWithProductIdAndType(Id, Type)

Returns: object. The product's per-location inventory records, or null when the product or type is not found.

When to use it: Use it in inventory availability or allocation logic that needs a product's stock levels by location.

What it does: Confirms a product has available inventory at a NetSuite location, matched by location name and product SKU, and returns the location ID when it does.

Signature: Task<object> CheckLocationQuantityByLocationNameAndProductBySku(string LocationName, string ProductSku)

How to call it: await CheckLocationQuantityByLocationNameAndProductBySku(LocationName, ProductSku)

Returns: object. The location ID when the product has available quantity at that location.

When to use it: Use it in fulfillment or availability checks. It raises an error when the location, product, or available quantity is missing.

What it does: Returns the NetSuite matrix option ID for a given option name.

Signature: Task<string> GetMatrixOptionIdByName(string name)

How to call it: await GetMatrixOptionIdByName(name)

Returns: string. The NetSuite matrix option ID, or null when no option matches.

When to use it: Use it in From iPaaS.com flows, including mapping filters, to confirm a product option exists in NetSuite before transferring.

What it does: Returns the NetSuite matrix option value ID for a given option name and value.

Signature: Task<string> GetMatrixOptionValueIdByValue(string name, string value)

How to call it: await GetMatrixOptionValueIdByValue(name, value)

Returns: string. The NetSuite matrix option value ID, or null when no matching value exists.

When to use it: Use it in From iPaaS.com flows, including mapping filters, to confirm a product option value exists in NetSuite before transferring.

What it does: Builds a delimited price-list string from a product's price levels, formatting each price entry with its price, sales type, sales code, item ID, price level name, unit, quantity, and date range. It uses the field and record separators from your subscription settings, and can filter and transform the entries.

Signature: Task<string> GetPriceList(List<ProductPriceLevelResponse> prices, string itemId, string unitName, string? salesType = "null", string? salesCode = "null", string? startDate = "null", string? endDate = "null", string? filterByPriceLevel = null, string? filterByCurrencyId = null, int? maxLength = null, bool? changeZeroQuantityToOne = false, bool? excludeZeroFromQuantityOneConflict = false)

How to call it: await GetPriceList(prices, itemId, unitName)

Returns: string. The formatted, delimited price-list string.

When to use it: Use it to produce a flat price-list value for a destination field that expects structured price data. It raises an error if the price levels or item ID are missing.

What it does: Returns the iPaaS.com location ID that maps to a given NetSuite location ID, using the iPaaS.com mapping for your subscription.

Signature: Task<string> GetiPaaSLocationId(object locationId)

How to call it: await GetiPaaSLocationId(locationId)

Returns: string. The matching iPaaS.com location ID, or null when the input is blank or has no mapping.

When to use it: Use it in To iPaaS.com flows, including the Product Inventory filter, to resolve the iPaaS.com location for a NetSuite location.

What it does: Returns the NetSuite location ID for the first location whose name contains the given text (a partial, case-insensitive match).

Signature: Task<string> GetLocationIdByLocationName(string locationName)

How to call it: await GetLocationIdByLocationName(locationName)

Returns: string. The matching NetSuite location ID, or an empty string when none matches.

When to use it: Use it to resolve a NetSuite location ID from a location name, including when the exact name may vary.

What it does: Confirms that a location belongs to the same subsidiary as an employee and, when it does and the name matches, returns the location name.

Signature: Task<string> GetLocationNameByEmployeeId(string location, string EmployeeId, bool isthrow = false)

How to call it: await GetLocationNameByEmployeeId(location, EmployeeId)

Returns: string. The location name when it is valid for the employee's subsidiary, otherwise null (or an error when isthrow is true).

When to use it: Use it to validate that a location is allowed for an employee's subsidiary before assigning it.

What it does: Confirms that a location belongs to the same subsidiary as an employee and, when it does, returns the location ID.

Signature: Task<string> GetLocationIdByEmployeeId(string locationId, string EmployeeId, bool isthrow = false)

How to call it: await GetLocationIdByEmployeeId(locationId, EmployeeId)

Returns: string. The location ID when it is valid for the employee's subsidiary, otherwise null (or an error when isthrow is true).

When to use it: Use it to validate that a location is allowed for an employee's subsidiary before assigning it.

What it does: Returns the NetSuite location record for a given location ID.

Signature: Task<Location> GetLocationBYId(string locationId)

How to call it: await GetLocationBYId(locationId)

Returns: Location. The NetSuite location record, or null when no location matches.

When to use it: Use it to fetch a location's full record, for example to read its subsidiary or parent.

What it does: Returns the NetSuite subsidiary ID for a given subsidiary name.

Signature: Task<string> GetSubsidiaryIdByName(object subsidiaryName = null)

How to call it: await GetSubsidiaryIdByName(subsidiaryName)

Returns: string. The NetSuite subsidiary ID of the first match, or null when none matches.

When to use it: Use it to resolve a subsidiary ID from its name. When the name does not exist, the transfer continues without a subsidiary value.

What it does: Returns the NetSuite subsidiary ID for a given subsidiary name, using an exact match.

Signature: Task<string> GetSubsidiaryIdBySubsidiaryName(string subsidiaryName)

How to call it: await GetSubsidiaryIdBySubsidiaryName(subsidiaryName)

Returns: string. The NetSuite subsidiary ID, or an empty string when none matches.

When to use it: Use it to resolve a subsidiary's internal ID from its name when referencing or creating subsidiary-scoped records.

What it does: Returns the NetSuite subsidiary ID associated with a given location ID.

Signature: Task<string> GetSubsidiaryIdByLocationId(string locationId)

How to call it: await GetSubsidiaryIdByLocationId(locationId)

Returns: string. The NetSuite subsidiary ID, or an empty string when none is found.

When to use it: Use it to resolve the subsidiary for a location.

What it does: Returns a delimited string of NetSuite subsidiary IDs for a list of subsidiary names. Names that do not exist are skipped.

Signature: Task<string> GetMultipleSubsidiaryIdByNames(object subsidiaryNames = null, string delimeter = ",")

How to call it: await GetMultipleSubsidiaryIdByNames(subsidiaryNames)

Returns: string. The delimiter-separated subsidiary IDs for the names that exist, or null when none match.

When to use it: Use it to resolve several subsidiary IDs from their names into one delimited value.

What it does: Returns a NetSuite subsidiary object populated with the IDs of the subsidiaries that match the given names. Names that do not exist are skipped.

Signature: Task<CommonLinkItemClass> GetSubsidiariesByNames(List<string> subsidiaryNames)

How to call it: await GetSubsidiariesByNames(subsidiaryNames)

Returns: CommonLinkItemClass. A subsidiary object carrying the matching subsidiary IDs, or null when none match.

When to use it: Use it in From iPaaS.com flows to build a Subsidiary field value from a list of subsidiary names.

What it does: Returns a delimited string of subsidiary names from a NetSuite subsidiary object.

Signature: Task<string> GetSubsidiaryNames(object subsidiaryObj = null, string delimeter = ",")

How to call it: await GetSubsidiaryNames(subsidiaryObj)

Returns: string. The delimiter-separated subsidiary names.

When to use it: Use it in To iPaaS.com flows to preserve a record's subsidiary names in an iPaaS.com custom field.

What it does: Returns the NetSuite subsidiary records for a given name, or all subsidiaries when no name is provided. It retries transient failures up to three times.

Signature: Task<object> GetSubsidiaryListByName(object subsidiaryName = null)

How to call it: await GetSubsidiaryListByName(subsidiaryName)

Returns: object. The NetSuite subsidiary search result.

When to use it: Use it to fetch subsidiary records by name, or all subsidiaries. Fetching all can return a large dataset in accounts with many subsidiaries.

What it does: Returns the full NetSuite subsidiary detail records for a list of subsidiary names, searching by name and then fetching each match's full record. Names that do not resolve are skipped.

Signature: Task<object> GetSubsidiaryListByNames(List<string> subsidiaryNames = null)

How to call it: await GetSubsidiaryListByNames(subsidiaryNames)

Returns: object. The list of full NetSuite subsidiary records, or null when no names are provided.

When to use it: Use it to resolve several subsidiaries by name and get their complete records in one call.

What it does: Returns the NetSuite account ID for a given account name.

Signature: Task<string> GetAccountIdByAccountName(string AccountName)

How to call it: await GetAccountIdByAccountName(AccountName)

Returns: string. The NetSuite account ID, or an empty string when none matches.

When to use it: Use it to resolve a NetSuite account ID from its name.

What it does: Returns the name of a NetSuite payment method for a given payment method ID.

Signature: Task<string> GetPaymentMethodById(object paymentMethodId)

How to call it: await GetPaymentMethodById(paymentMethodId)

Returns: string. The payment method name, or null when the ID is not provided or not found.

When to use it: Use it in To iPaaS.com transaction-payment flows to resolve a payment method name from its NetSuite ID.

What it does: Returns the NetSuite payment method ID for a given payment method name.

Signature: Task<string> GetPaymentMethodIdByName(object paymentMethodName)

How to call it: await GetPaymentMethodIdByName(paymentMethodName)

Returns: string. The NetSuite payment method ID, or null when the name is not provided or not found.

When to use it: Use it in From iPaaS.com transaction-payment flows to resolve a payment method ID from its name.

What it does: Returns the NetSuite payment method ID for a given payment method name (online or offline).

Signature: Task<string> GetPaymentMethodId(object paymentMethod)

How to call it: await GetPaymentMethodId(paymentMethod)

Returns: string. The NetSuite payment method ID, or null when none matches.

When to use it: Use it to resolve any payment method's ID from its name.

What it does: Returns the NetSuite payment method ID for a given name only when that payment method is offline.

Signature: Task<string> GetOfflinePaymentMethodId(object paymentMethod)

How to call it: await GetOfflinePaymentMethodId(paymentMethod)

Returns: string. The NetSuite payment method ID when the method is offline, or null when it is not found or is online.

When to use it: Use it when you need to act only on offline payment methods (for example cash or ACH).

What it does: Returns the NetSuite currency ID for a given currency code (symbol).

Signature: Task<string> GetCurrencyIdByCode(object currencyCode)

How to call it: await GetCurrencyIdByCode(currencyCode)

Returns: string. The NetSuite currency ID, or null when no currency matches.

When to use it: Use it to resolve a NetSuite currency ID from a currency code in financial flows.

What it does: Validates that a transaction date falls within an accounting (posting) period and returns the date formatted as yyyy-MM-dd. It raises an error when the date is after the period's end date.

Signature: Task<string> CheckPostingGroupByTransactionDate(object transactionDate, string accountingperiodId)

How to call it: await CheckPostingGroupByTransactionDate(transactionDate, accountingperiodId)

Returns: string. The validated transaction date formatted as yyyy-MM-dd.

When to use it: Use it to ensure a transaction posts within a valid posting period. It raises an error when the date is beyond the period's end.

What it does: Returns whether all invoice lines match a line on the original sales order with the same quantity.

Signature: Task<bool> ValidateInvoiceLineItemsAsync(object invoiceLines, string orderId)

How to call it: await ValidateInvoiceLineItemsAsync(invoiceLines, orderId)

Returns: bool. True when every invoice line matches an order line with the same quantity; otherwise false.

When to use it: Use it to confirm invoice lines are consistent with the original order before transferring the invoice.

What it does: Returns whether an invoice total equals the original order total, read from a specified custom field on the NetSuite order.

Signature: Task<bool> VerifyOrderTotalEqualsInvoiceAsync(object invoiceTotal, string orderId, string customFieldName)

How to call it: await VerifyOrderTotalEqualsInvoiceAsync(invoiceTotal, orderId, customFieldName)

Returns: bool. True when the totals are equal; otherwise false.

When to use it: Use it to confirm an invoice total matches its order total before transferring the invoice.

What it does: Returns the NetSuite internal ID of the gift certificate item that matches a given SKU.

Signature: Task<long?> GetGiftCertificateIdBySkuAsync(string sku)

How to call it: await GetGiftCertificateIdBySkuAsync(sku)

Returns: long?. The NetSuite internal ID of the gift certificate item, or null when the SKU is blank or none matches.

When to use it: Use it when a flow needs to reference a gift certificate item by its SKU.

What it does: Returns the NetSuite gift certificate ID for a given iPaaS.com gift card ID, using the iPaaS.com mapping first and falling back to matching by gift card number in NetSuite.

Signature: Task<string> ValidateNetSuiteGiftCertificateAsync(string iPaaSGiftCardId)

How to call it: await ValidateNetSuiteGiftCertificateAsync(iPaaSGiftCardId)

Returns: string. The NetSuite gift certificate ID, or null when the input is blank or none matches.

When to use it: Use it to validate a gift card payment during order processing by mapping it to a NetSuite gift certificate.

What it does: Returns the value of a named field from a custom fields object. For a nested field, it returns the requested subfield, or the refName when no subfield is given.

Signature: object GetCustomValue(object customFieldsObject, string fieldName, string? subField = null)

How to call it: GetCustomValue(customFieldsObject, fieldName)

Returns: object. The field's value (or the subfield or refName for a nested field), or null when the field is not found.

When to use it: Use it to extract a flat or nested value from a custom fields object.

What it does: Returns the value of a named field from a custom fields object, matched case-insensitively. For a nested field, it returns the requested subfield (joining a list of refName values with commas), or the refName when no subfield is given.

Signature: object GetCustomValueObject(object customFieldsObject, string fieldName, string? subField = null)

How to call it: GetCustomValueObject(customFieldsObject, fieldName)

Returns: object. The field's value, subfield, or a comma-joined list of refName values; null when the field is not found.

When to use it: Use it to extract values from custom fields whose structure may vary, including arrays of referenced records.

What it does: Returns the string value of a named field from a custom fields object. It returns null when the field is missing or its value is not a string. Matching on the field name is case-sensitive.

Signature: object GetValueFromCustomField(object customFieldObj, object textFieldName)

How to call it: GetValueFromCustomField(customFieldObj, textFieldName)

Returns: object. The field's string value, or null when the field is not found or its value is not a string.

When to use it: Use it to pull a single string custom field value into a destination field.

What it does: Returns the custom fields as a name and value dictionary, skipping empty fields, any field whose name contains list_, and the subscribeprofile field.

Signature: object GetPropertiesFromCustomFields(object customFieldObj)

How to call it: GetPropertiesFromCustomFields(customFieldObj)

Returns: object. A dictionary of the valid custom field names and values, or null when the input is empty or all fields are filtered out.

When to use it: Use it in From iPaaS.com flows to flatten a record's custom fields into a name and value dictionary for mapping.

What it does: Returns the iPaaS.com custom field value assigned to a specific record, for a given collection type, field name, and record ID.

Signature: Task<string> GetiPaaSCustomFieldValueAsync(string mappingCollectionType, string fieldName, object recordId)

How to call it: await GetiPaaSCustomFieldValueAsync(mappingCollectionType, fieldName, recordId)

Returns: string. The custom field value, or null when the record or field is not found or has no value.

When to use it: Use it to read a custom field value for a specific iPaaS.com record.

What it does: Parses a delimited string of ID and reference-name pairs into a structured NetSuite custom field value. For a Multi-Select field it returns a collection of entries; for a List/Record field it returns only the first entry.

Signature: Task<object> FormatCustomFields(string fieldType, string idAndRefName, string recordDelimiter = ",")

How to call it: await FormatCustomFields(fieldType, idAndRefName)

Returns: object. The structured custom field value, or null when the input is empty or has no valid entries.

Example: with fieldType Multi-Select, an idAndRefName of 123|ABC,456|DEF produces a collection of two entries (IDs 123 and 456).

When to use it: Use it to turn concatenated ID and reference-name pairs into the structure a NetSuite custom field expects.