ajSwiftMTToJSON function
Available since AlchemyJ v4.3 AlchemyJ Enterprise Edition
Description
The ajSwiftMTToJSON converts the SWIFT MT message to JSON string.
Syntax
ajSwiftMTToJSON(fin_text, [run_condition],[run_by_function_point_only])
Argument Name | Argument Type | Description |
---|---|---|
fin_text (required) | Variant | The range of cells that contains the MT string. The range of cells can span across multiple rows and columns. The cell values will be concatenated into one string from left to right and top to bottom. |
run_condition (optional) | Boolean | The function will run when the value is TRUE. Otherwise will not run. The default value is TRUE. |
run_by_function_point_only (optional) | Boolean | If it equals FALSE, the function can be executed through ‘Excel Calculation’ (can be either Automatic or Manual, Calculate Now or Calculate Sheet) or Preview Function Point. If it equals TRUE, the function can be executed with Preview Function Point (AlchemyJ ribbon \ Preview Function Point) only. The default value is TRUE. |
The function will return:
1) Return Value: JSON String
2) Return Type: Single Value / Multiple values (array formula)
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type. Besides, system will raise error for below scenario(s).
Error Scenario |
---|
FIN text cannot be empty. |