The Revel integration provides a set of ready-made functions you can call when building mappings. They handle common conversions and lookups for Revel, such as translating category URIs and IDs between Revel and iPaaS.com, looking up a product SKU, establishment, role, or employee PIN, describing a payment type, and formatting dates for Revel, so you don't have to write that logic yourself.

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

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

Use these when converting product and category values between Revel and iPaaS.com during mapping.

What it does: Converts a list of Revel category URIs into iPaaS.com category IDs, returned as the objects the API expects. Categories that cannot be mapped are skipped.

Signature: List<IPaaSApi.Model.Product.GenericRequest> ConvertCategoriesToSpaceportIds(List<string> categories)

How to call it: ConvertCategoriesToSpaceportIds(categories)

Returns: List<IPaaSApi.Model.Product.GenericRequest>. A list of objects, each carrying a mapped iPaaS.com category ID.

Example: ConvertCategoriesToSpaceportIds(new List<string> { "/categories/123", "/categories/456" }) returns the objects for the matching iPaaS.com category IDs.

When to use it: When mapping Revel product categories to their iPaaS.com category IDs during a transfer into iPaaS.com.

What it does: Converts a list of iPaaS.com category assignments into Revel category URIs. Assignments without a Revel mapping are skipped.

Signature: Task<List<string>> ConvertIPaaSCategoriesToRevelAsync(object iPaaSCategories)

How to call it: await ConvertIPaaSCategoriesToRevelAsync(iPaaSCategories)

Returns: List<string>. The Revel category URIs for the mapped categories (for example "/products/ProductCategory/789/"), or nothing if there is nothing to convert.

Example: await ConvertIPaaSCategoriesToRevelAsync(iPaaSCategories) returns the Revel category URIs for the supplied iPaaS.com categories.

When to use it: When mapping iPaaS.com product categories out to Revel during a transfer from iPaaS.com.

What it does: Reads the SKU of a Revel product from its product URL. Returns an empty string if the product is not found, or nothing if the URL is empty or invalid.

Signature: Task<string> GetProductSkuAsync(string productUrl)

How to call it: await GetProductSkuAsync(productUrl)

Returns: string. The Revel product SKU, an empty string if the product is not found, or nothing if the URL is empty or invalid.

Example: await GetProductSkuAsync("/products/12345/") returns the SKU of Revel product 12345.

When to use it: When mapping a Revel product reference and you have the product URL but need its SKU.

What it does: Looks up a list of iPaaS.com alternate IDs and returns the product SKUs that match. IDs with no match are skipped.

Signature: List<string> GetAlternateIds(List<string> ipaasAltIds)

How to call it: GetAlternateIds(ipaasAltIds)

Returns: List<string>. The product SKUs for the alternate IDs that could be resolved.

Example: GetAlternateIds(new List<string> { "abc123", "xyz789" }) returns the SKUs for the alternate IDs that match.

When to use it: When you need the product SKUs for a set of iPaaS.com alternate IDs during mapping.

What it does: Looks up a Revel product category by name within an establishment and returns the matching category ID. Returns nothing if no category matches.

Signature: Task<long?> ProductCategoryFromName(string name, string establishment)

How to call it: await ProductCategoryFromName(name, establishment)

Returns: long?. The Revel product category ID, or nothing if no category matches.

Example: await ProductCategoryFromName("Beverages", "/establishment/123/") returns the ID of the "Beverages" category in establishment 123.

When to use it: When mapping a product category name to its Revel category ID.

Use these to turn a Revel payment type ID into a readable description.

What it does: Converts a Revel payment type ID into its payment description. Returns nothing if the ID is not recognized or not provided.

Signature: string PaymentDescriptionFromPaymentType(int? paymentType)

How to call it: PaymentDescriptionFromPaymentType(paymentType)

Returns: string. The payment description (for example "Credit"), or nothing if the ID is not recognized.

Example: PaymentDescriptionFromPaymentType(2) returns "Credit".

When to use it: When mapping a Revel payment type to its full description.

What it does: Converts a Revel payment type ID into a simplified payment category, grouping the detailed types (for example the credit types become "CreditCard"). Returns nothing if the ID is not recognized or not provided.

Signature: string SimplifiedPaymentDescriptionFromPaymentType(int? paymentType)

How to call it: SimplifiedPaymentDescriptionFromPaymentType(paymentType)

Returns: string. The simplified payment category (for example "CreditCard", "Cash", or "Other"), or nothing if the ID is not recognized.

Example: SimplifiedPaymentDescriptionFromPaymentType(5) returns "CreditCard".

When to use it: When mapping a Revel payment type to a broad category for reporting or display.

Use these to resolve Revel establishment, role, and employee references during mapping.

What it does: Looks up a Revel establishment by its site number and returns the establishment ID. Returns nothing if no establishment matches.

Signature: Task<long?> GetEstablishmentIdFromSiteNumber(string siteNumber)

How to call it: await GetEstablishmentIdFromSiteNumber(siteNumber)

Returns: long?. The Revel establishment ID, or nothing if no establishment matches.

Example: await GetEstablishmentIdFromSiteNumber("1001") returns the ID of the establishment with site number 1001.

When to use it: When mapping an establishment by its site number to its Revel establishment ID.

What it does: Looks up a Revel role by name and returns the role ID. The match is not case-sensitive. Returns nothing if no role matches.

Signature: Task<long?> RoleIdFromName(string roleName)

How to call it: await RoleIdFromName(roleName)

Returns: long?. The Revel role ID, or nothing if no role matches.

Example: await RoleIdFromName("Admin") returns the ID of the "Admin" role.

When to use it: When mapping a role name to its Revel role ID.

What it does: Reads a Revel employee's PIN from the employee ID. Returns nothing if the employee is not found.

Signature: Task<string> EmployeePINFromId(string employeeId)

How to call it: await EmployeePINFromId(employeeId)

Returns: string. The Revel employee's PIN, or nothing if the employee is not found.

Example: await EmployeePINFromId("/resources/Employee/1383/") returns the PIN of employee 1383.

When to use it: When mapping an employee reference and you need the employee's Revel PIN.

General-purpose helpers you can use while building any Revel mapping.

What it does: Extracts the numeric ID from the last segment of a URI. Returns nothing if the last segment is not a number.

Signature: int? ExtractIdFromUri(string resourceUri)

How to call it: ExtractIdFromUri(resourceUri)

Returns: int?. The numeric ID from the last segment, or nothing if it is not a number.

Example: ExtractIdFromUri("/resources/product/789/") returns 789.

When to use it: When you have a Revel resource URI and need the numeric ID from its last segment.

What it does: Formats a date/time value as the ISO 8601 string Revel expects, without milliseconds or a timezone offset. Returns nothing if the value is empty.

Signature: string ConvertToRevelDateTimeFormat(object input)

How to call it: ConvertToRevelDateTimeFormat(input)

Returns: string. The date/time formatted as yyyy-MM-ddTHH:mm:ss, or nothing if the value is empty.

Example: ConvertToRevelDateTimeFormat(input) returns a value such as "2025-04-08T14:23:45".

When to use it: When mapping a date/time value into a Revel field that requires the ISO 8601 format.