ReportField¶

Field	NULL	Description
fieldId string (GUID)		The id of the field
fieldUniqueName string		Unique name for the field
originalName string		The original name of the field
fieldName string		The name of the field
fieldNameAlias string		The alias of the field
dataFieldType string		The data type
querySourceId string (GUID)	Y	The id of the query source
querySourceUniqueName string		Unique name for the query source
querySourceType string		Either “Table”, “View”, “Stored Procedure” or “Function”
sourceAlias string		The source alias
querySourceAlias string		The alias of the query source
relationshipId string (GUID)		The id of the relationship if applicable
visible boolean		Is the field visible
filterable boolean		Is the field filterable
reportId string (GUID)	Y	The id of the report of applicable
fieldFunctionExpression string		The expression for field function
expression string		The calculated expression
grandTotalExpression string		The grand total expression
grandTotalFormat string		Format for the grand total
subTotalExpression string		The sub total expression
subtotalFormat string		Format for the sub total
sort string		Either “Unsorted”, “Ascending” or “Descending”
autoSort boolean		Internal use: whether the field is automatically sorted
function string		The function
formatting object		A DataFormating object
functionDataType string		The result data type of the function
isCalculated boolean		Is this a calculated field
hasAggregatedFunction boolean		Whether this field uses aggregated function
invalidField integer		Invalid field setting
isCrossFilter boolean		Whether this instance is cross filter

{
   "fieldId" : "76139896-c2c3-432e-898a-2c2205bb2e35",
   "fieldName" : "Country",
   "fieldNameAlias" : "Country",
   "dataFieldType" : "Text",
   "querySourceId" : "1641cb37-b60c-42bc-b986-c51667e8037d",
   "querySourceType" : "Table",
   "sourceAlias" : "Suppliers",
   "relationshipId" : null,
   "visible" : true,
   "calculatedTree" : null,
   "schemaName" : "dbo",
   "querySourceName" : "Suppliers",
   "databaseName" : "Northwind",
   "isCalculated" : false
}