Element Details: Json+Data
 Back


Available in: Logi Info Source code name: JsonDataIntroduced in: v10.0.455

JsonData runs a DataLayer of any type and returns the results in JSON format. This can provide browser-side components, such as JQuery components, to use and display data provided in JSON by making a RESTful web service call.

JsonData can also work with server-side components.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
JsonHumanReadable
True
False
When True, JSON data inserted into the report is output with CRLFs and spaces making it easier to read with the browser’s View Source feature. This is primarily a debugging feature. The Default is “False”.
JsonOutput
Inline
File
The JSON data can be included in the report either “inline” or as a Javascript file. The default is “Inline”.
JsonStyle
RowsToValueArrays
RowsToObjects
ColumnsToPropertyArrays
RowsToObjects serializes rows into an array of objects. Each object represents a data row and the objects have a property for each column. var data = [ {"Year" : "2010", "TotalSales" : 12540}, {"Year" : "2011", "TotalSales" : 21450} ] ColumnsToPropertyArrays serializes the data into a single object. Each column is a property with all the row values contained in an array. var data = { "Year" : ["2010", "2011"], "TotalSales" : [12540, 21450] } RowsToValueArrays serializes the data into a single array with a child array for each row in the data. Each value in the array represents a column in the data. var data = [ ["2010", 12540], [‘2011’, 21450] ]
JsonVarName
UserDefined
Exclude
(Required) The JSON data may be assigned to a JavaScript variable. JsonVarName sets the JavaScript variable name. For Data Definitions, where the desired output is a JSON object, set JsonVarName to "Exclude". Exclude is not allowed in Report definitions.
SecurityRightID
UserDefined
When entered, access to this element can be controlled with Logi security. Supply the ID of a right defined in the applications settings’ Security element. Only users that have a right in the SecurityRightID will be able to see the element. Note that when rights come from RightFromRole elements under Security/UserRights, and this element's SecurityRightID does NOT match any of the Right IDs defined in the Settings definition, then the user DOES have access. But when Right IDs are instead derived from RightsFromDataLayer or RightsFromRoles elements, and the user DOES NOT have a matching Right, then the user DOES NOT have access. You can enter multiple right IDs, separated by commas. In this case, the user sees the element if he has any one of the Rights.



PARENT ELEMENTS

Click element to drill down for more information.

Data Include Script Include Script File


CHILD ELEMENTS

Click element to drill down for more information.

DataLayer.Bookmarks
DataLayer.Cached
DataLayer.CSV
DataLayer.Definition List
DataLayer.Directory
DataLayer.Excel
DataLayer.Fixed Format File
DataLayer.Google App
DataLayer.Google Spreadsheet
DataLayer.JSON
DataLayer.LDAP
DataLayer.Linked
DataLayer.Mongo Find
DataLayer.Mongo Map Reduce
DataLayer.Mongo Run Command
DataLayer.Plugin
DataLayer.REST
DataLayer.Scheduler
DataLayer.SP
DataLayer.SQL
DataLayer.Static
DataLayer.Twitter
DataLayer.Web Feed
DataLayer.Web Scraper
DataLayer.Web Service
DataLayer.XML
Json Column


 Back to top


 Chart Debug