Skip to main content

SysTrack Mapping Functions

Reference for the SysTrack-specific functions you can use in Dynamic Formula mappings and mapping collection filters.

Overview

The SysTrack integration provides a ready-made function you can call when building mappings. It maps an iPaaS.com message to the matching SysTrack message, so you do not have to write that lookup yourself in a formula.

Where you can use these functions

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

  • Dynamic Formula mappings: where a destination field's value is produced by a formula rather than mapped directly from a source field.

  • Mapping collection filters: where a formula decides whether a record should be processed.

  • Error filters: a mapping collection's error filter, which sits alongside its collection filter. When the error filter's formula resolves to true, the transfer raises an error that is held in the Error Logs for review and is not retried automatically.

  • Translation collections: where a translation entry uses a formula as its source value.

How to use them

  • Call a function by name and pass the values it needs in parentheses, for example: await GetMessageExternalIdById(SourceMessageId).

  • Each function's signature shows its name, the parameters it accepts (with their types), and the type of value it returns. Use it as the reference for exactly how to call the function.

  • Function names and formula syntax are case-sensitive, so type each name exactly as shown. Whether the values a function matches are treated as case-sensitive varies by function, and is called out in the relevant parameter's description.

  • Every function that returns a Task is asynchronous and must be called with await, as shown in each How to call it example.

  • The function runs at sync time, against the data in your connected SysTrack account and your iPaaS.com subscription.

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

Messages

GetMessageExternalIdById

What it does: Looks up the SysTrack message linked to an iPaaS.com message and returns its SysTrack message ID.

Signature: Task<string> GetMessageExternalIdById(string iPaaSId)

How to call it: await GetMessageExternalIdById(iPaaSId)

Parameter

Type

Required

Default

Description

iPaaSId

string

Yes

N/A

The iPaaS.com message ID to look up.

Returns: string. The SysTrack message ID linked to the iPaaS.com message, or null if no linked message is found.

Example: Passing an iPaaS.com message ID returns the SysTrack message ID mapped to it.

When to use it: Use this when a mapping references a message by its iPaaS.com ID and you need the matching SysTrack message ID.

Related Documents

Did this answer your question?