2.2.2.4. afsTable

Entity: afsTable

The afsTable entity is used for grouping data as a table, which can either be a (customized) codelist or a freely definable table using the tableColumn and tableRow entityTypes. See the example below for such a self-defined table: the table is given a name (tableName), after which the rows and columns of the table are defined by means of tableRow and tableColumn. For columns it is possible to set a data type via columnDataType.

Example usage

In this example, we define a table named “Tabel kenmerken motorvoertuig” with three columns. Each column is defined with an instance of the entityType tableColumn as you can see below, defining the respective column names as “make”, ”model” and “fuel”. The rows are then defined per row, two in this example.

{
"afsTable": [
		{
			"entityType": "customTable",
			"tableName": "Tabel kenmerken motorvoertuig",
			"afsTable": [
				{
			             "entityType": "tableColumn",
			             "columnName": "make",
			             "columnDataType": "string"
				},
				{
			             "entityType": "tableColumn",
			             "columnName": "model",
			             "columnDataType": "string"
				},
				{
			             "entityType": "tableColumn",
			             "columnName": "fuel",
			             "columnDataType": "string"
				},
				{
			             "entityType": "tableRow",
			             "sequenceNumber": 1,
			             "rowValues": ["Mazda", "CX3", "B"]
				},
				{
			             "entityType": "tableRow",
			             "sequenceNumber": 2,
			             "rowValues": ["Volvo", "V40", "B"]
				}
			]
		}
	]
}

The message above translates to the following table:

Entity types

The most recent overview of entity types is available in AFD 2.0 Online. More documentation on the use of SIVI AFS is available in chapter Where to find elements of SIVI AFS