Skip to main content
Version: 1

Utility Flows

info

Video: Utility Flows

Overview​

Utility Flows in Plinqx are essentially standard Salesforce Autolaunched flows designed for specific functions in the context of data mapping and transformation. They play a crucial role in enhancing the data transformation capabilities within Plinqx by providing additional flexibility and functionality.

Purposes of Utility Flows​

Utility Flows can be employed for the following purposes:

  1. Transforming Input Data:

    They can take input data, transform it as required, and pass back the output data to be used in Data Mapping.

  2. Database Lookup and Logic Application:

    Utility Flows can also be used to lookup data in the Salesforce database, perform logic operations on it, and return the output data for use in Data Mapping. This is particularly useful when referential data is stored on the Salesforce platform.

Parameters of Utility Flows​

Utility Flows must contain the following parameters:

  1. valueIn (Input):

    • Type: String, Number, Collection, Date, DateTime, Boolean, Decimal

    • Description: The value from the data mapping engine from the Source is passed into this parameter.

  2. valueOut (Output):

    • Type: String, Number, Collection, Date, DateTime, Boolean, Decimal

    • Description: The Data Mapping engine retrieves this value from the flow and writes it to the destination object attribute.

Important Note​

  • The output type of the utility flow determines the element type in the JSON. For instance, if a string is passed into the utility flow as the valueIn parameter and valueOut is an integer, the value written to the destination JSON will be an integer.

Example Scenario: Transforming a String Value to Integer Value​

Flow Setup:

  • An assignment in the utility flow writes the transformed value into the valueOut parameter.

  • A formula field named toNumberValue in the flow is used to transform a string value to a Number (Integer) value.

Conclusion​

Utility Flows in Plinqx provide a powerful means to augment data transformation processes within Salesforce. By leveraging these flows, you can perform complex transformations and logic operations, ensuring that your data mappings are both versatile and accurate. This functionality enhances the overall capability of Plinqx in handling diverse data integration scenarios.