DriveWorks Pro 22

SppConvertTableToJson

Rule

SppConvertTableToJson(DWCalcOrderDetails)

Converts the calculation table named OrderDetails to a JSON Object.

A single JSON object is outputted due to the table only having 1 row.

Data

Calculation table named OrderDetails.

Result - Convert to JSON Object

Due to the table being a single row, the output is a JSON object:

{
	"Name": "Scissor Lift 47421",
	"Description": "571mm wide, 478mm high, SWL 1000 kg.",
	"Price": 1469.56,
	"Created": "2025-03-10T11:53:21.2108447+00:00"
}

Rule

SppConvertTableToJson(DWCalcBillOfMaterials)

Converts the calculation table named BillOfMaterials to a JSON Array.

A JSON array is outputted due to the table having more than 1 row.

Data

Calculation table named BillOfMaterials

Result - Convert to JSON Array

Due to the table being multiple rows, the output is a JSON array:

[
    {
        "Part ID": "MAH-RH-1161-596",
        "Description": "Mahogany panel right hand (1161 high x 596 deep)",
        "Qty": 1.0
    },
    {
        "Part ID": "HG762RT",
        "Description": "Double folded recessed standard hinge",
        "Qty": 4.0
    }
]

Rule

SppConvertTableToJson(DWCalcUserPermissions)

Converts the calculation table named UserPermissions, which includes a nested table within a cell, to a JSON Object with Children.

Data

Calculation table named UserPermissions.

Calculation table named UserPermissionsAdministrator.

Result - JSON Object with Children

{
	"Permission": "Administrator",
	"Users": [
		{
			"Login": "justo@aol.couk"
		},
		{
			"Login": "id.blandit.at@protonmail.edu"
		}
	]
}

Rule

SppConvertTableToJson(DWCalcContacts, TRUE)

Converts the calculation table named Contacts, which includes text formatted as JSON within cells, to a JSON Object with Children.

Data

Calculation Table named Contacts.

Result - JSON Object with Children

[
	{
		"Name": "Jamie Bishop",
		"Addresses": [
			{
				"Address Line 1": "56 Argyll Road",
				"Address Line 2": null,
				"City": "LLANDDEW",
				"ZIP / Postal Code": "LD3 1SL",
				"Country": "UK"
			},
			{
				"Address Line 1": "77 Fordham Rd",
				"Address Line 2": null,
				"City": "HADLEIGH",
				"ZIP / Postal Code": "IP7 1JD",
				"Country": "UK"
			}
		]
	},
	{
		"Name": "Abby Welch",
		"Addresses": {
			"Name": "Jamie Bishop",
			"Addresses": [
				{
					"Address Line 1": "93 Newmarket Road",
					"Addres Line 2": null,
					"City": "HAWSTEAD",
					"ZIP / Postal Code": "IP29 7YD",
					"Country": "UK"
				},
				{
					"Address Line 1": "38 Broad Street",
					"Addres Line 2": null,
					"City": "LOWER SHIPLAKE",
					"ZIP / Postal Code": "RG9 5PX",
					"Country": "UK"
				}
			]
		}
	}
]

SppConvertJsonToTable

Set Calculation Table Row Count