Formatter Node
- Yashna Chhatwal (Unlicensed)
Formatter node JSON Object for resource Number:
{
"id": 76486057,
"typeOf": "formatter",
"parentId": 76681284,
"rootId": 76250695,
"workspaceSlug": "montecarlo",
"authenticationId": null,
"title": null,
"paused": true,
"versionCode": "77676@1.0.0",
"resorceSlug": "number_line_item",
"params": {
"transform": "number.spreadsheet_formula",
"inputs": "{{76681284##output##Customer Price[]##Line Item Price}} - {{76681284##output##Customer Price[]##Line Items Discount Amount}} + 20"
},
"meta": {
"parammap": {
"transform": "Spreadsheet-Style Formula"
},
"selectedGives": {
"76681284##output##Customer Price[]##Line Item Price": "Output Customer Price Line Item Price",
"76681284##output##Customer Price[]##Line Items Discount Amount": "Output Customer Price Line Items Discount Amount"
}
},
"createdById": null,
"is_template": false,
"createdAt": "2020-01-22T12:55:40+00:00",
"updatedAt": "2020-03-24T06:18:11+00:00"
}
Params object for Number(Spreedsheet style formula):
Field Name | Business Purpose | Field type (with size) |
|---|---|---|
transform | Type of operation to be performed on Formatter type-Number | Enum[ |
input | formula with the same syntax found in popular spreadsheet applications | String |
Formatter Node JSON object for resource Util (Line Itemizer):
{
"id": 76681284,
"typeOf": "formatter",
"parentId": 76250695,
"rootId": 76250695,
"workspaceSlug": "montecarlo",
"authenticationId": null,
"title": null,
"paused": true,
"versionCode": "77676@1.0.0",
"resorceSlug": "util_line_item",
"params": {
"transform": "util.line_itemizer",
"inputs": "Customer Price",
"my_dict": {
"Line Item Price": "{{76250695##line_items[]##price}}",
"Line Items Discount Amount": "{{76250695##line_items[]##total_discount}}",
"Line Items Tax Rate": "{{76250695##line_items[]##tax_lines[]##rate}}",
"Line Items Tax Amount": "{{76250695##line_items[]##tax_lines[]##price}}"
},
"subtotal_toggle": "true",
"decimals": "2"
},
"meta": {
"parammap": {
"transform": "Line Itemizer (Create/Append/Prepend)"
},
"selectedGives": {
"76250695##line_items[]##price": "Line Items Price",
"76250695##line_items[]##total_discount": "Line Items Total Discount",
"76250695##line_items[]##tax_lines[]##rate": "Line Items Tax Lines Rate",
"76250695##line_items[]##tax_lines[]##price": "Line Items Tax Lines Price"
}
},
"is_template": false,
"createdAt": "2020-01-22T12:55:40+00:00",
"updatedAt": "2020-03-24T06:18:11+00:00"
}Params Object for Formatter (Line Itemizer):
Field Name | Business Purpose | Field type (with size) |
|---|---|---|
transform | Type of operation to be performed on Formatter type-Util | Enum[ |
input | Name of line item | String |
my_discts | Keys-value pairs to be transformed, where key is the label and value is the field selected from output of above nodes | Object |
Formatter Node JSON object for resource Date/Time(Add/Subtract):
{
"id": 91258968,
"typeOf": "formatter",
"parentId": 76681284,
"rootId": 76250695,
"workspaceSlug": "montecarlo",
"authenticationId": null,
"title": null,
"paused": true,
"versionCode": "77676@1.0.0",
"resorceSlug": "datetime_line_item",
"params": {
"transform": "date.manipulate",
"inputs": "{{76250695##created_at}}",
"expression": "+8 hours -10 minute"
},
"meta": {
"parammap": {
"transform": "Add/Subtract Time",
},
"selectedGives": {
"76250695##created_at": "Created At"
}
},
"isTemplate": false,
"createdAt": "2020-01-20T05:13:04+00:00",
"updatedAt": "2020-02-07T13:14:06+00:00"
}Params Object for Formatter -Date:
Field Name | Business Purpose | Field type (with size) |
|---|---|---|
transform | Type of operation to be performed on Formatter type-Date | Enum[ |
input | Field to be manipulated | String |
expression | amount of time you would like to add or subtract to the date | String |
resourceSlug | transform |
|---|---|
datetime_line_item | date.manipulate |
util_line_item | util.line_itemizer |
number_line_item | number.spreadsheet_formula |