ajSwiftJSONToMT function
Available since AlchemyJ v4.3 AlchemyJ Enterprise Edition
Description
The ajSwiftJSONToMT converts the JSON string to SWIFT MT message.
Syntax
ajSwiftJSONToMT(json_data, [run_condition],[run_by_function_point_only])
| Argument Name | Argument Type | Description |
|---|---|---|
| json_data (required) | Variant | The range of cells that contains the JSON 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: SWIFT MT message
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 |
|---|
| Json data cannot be empty. |