JSON Variables

The VARIABLES sub-section is an additional JSON array attribute within section DATA_ACCESS which is a dynamic list of EDLs for all variables needed in the Excel reading/iteration process. The variables are mainly used for constructing the expressions in the Effect Block configuration (as it is shown in next wiki section) and secondly. Also variables can be used for more complex routing of data e.g. the same value can be used in several components of the Substance Record but changed on a single place when JSON configuration updates are needed.

"VARIABLES": {
	"Concentration_unit": {
		"ITERATION": "ABSOLUTE_LOCATION",                
                "COLUMN_INDEX": "B",
		"ROW_INDEX": 62
	},			
	"Experiments" : 2,			
	"TimeDesignations": {
                "IS_ARRAY": true,
                "TRIM_ARRAY": true,
                "ITERATION": "ABSOLUTE_LOCATION",
                "SHEET_INDEX": 1,
                "COLUMN_INDEX": "C",
                "COLUMN_INDICES": "3-20",
                "ROW_INDEX": 59
	},	
	"TimePoints": {
		"IS_ARRAY": true,
		"TRIM_ARRAY": true,
		"ITERATION": "ABSOLUTE_LOCATION",
		"SHEET_INDEX": 1,
		"COLUMN_INDEX": "C",
		"COLUMN_INDICES": "3-20",
		"ROW_INDEX": 60
	},
	"Concentrations": {
		"IS_ARRAY": true,
		"TRIM_ARRAY": true,
		"ITERATION": "ABSOLUTE_LOCATION",
		"SHEET_INDEX": 1,
		"COLUMN_INDEX": "C",
		"COLUMN_INDICES": "3-20",
		"ROW_INDEX": 63
	}
}

Variable mappings are defined via attribute VARIABLE_MAPPINGS to facilitate even more complex operations of the data import process.

"VARIABLE_MAPPINGS": [
	{
		"NAME": "TimeMapping",
		"KEYS_VARIABLE": "TimeDesignations",
		"VALUES_VARIABLE": "TimePoints"
	}
]

For example (see figure below) it is quite common in the IOM-nanoEHS templates that the exposure times within effects blocks to be designated as T1, T2, …, etc. while within the eNanoMapper database the real values should be imported. This is a typical case where variable mapping is applied in the JSON configuration.

Next: EDL Advanced