Difference between revisions of "Tables For Data Automation"

Revision as of 09:15, 13 December 2016 (view source) SNC (Talk | contribs) (Created page with " <div class="imgGlyph24 imgIdea"></div> Instead of using the API to loop through and fetch many series for a given app (like mapping), use embeds (tables, latest values) You...")		Latest revision as of 06:55, 10 May 2017 (view source) SNC (Talk | contribs)
(8 intermediate revisions by the same user not shown)
Line 1:		Line 1:
−	<div class="imgGlyph24 imgIdea"></div> Instead of using the API to loop through and fetch many series for a given app (like mapping), use embeds (tables, latest values)	+	<div class="imgGlyph24 imgIdea"></div>&nbsp;Instead of using the [[DataZoa_API|API]] to loop through and fetch many series for a given app (like mapping, or HiCharts), you can just use [[Displays|displays]] ([[Table_Displays|tables]], [[LatestValues_Displays|latest values]])
−		+	<br>
−	You can create a table specifically for your app which contains all the data needed and then fetch just it.	+	Just create a table specifically for your app which contains all the data needed and then use AJAX to fetch it.
−		+	<br>
−	<div class="imgGlyph24 imgConcept"></div>Some Advantges:	+	<br>
−	* You can structure the row (series) labels to be easily identifiable (knockouts become available)	+	<div class="imgGlyph24 imgConcept"></div>&nbsp;Some Advantges:
−	* Fetch data for multiple series with a single fetch	+	* You can mark the row (series) labels to easily identify their data
−	* Embeds are server cached for speed which is tripped only when underling data actually changes	+	* Label [[Label_Knockouts|knockouts]] are available
−	* Use glname to access multiple datasets via a single table and multiple group lists	+	* Just one fetch for multiple series
−	* Use latest values to get current value, prior values and/or (%) changes	+	* The displays are server-cached for speed
−		+	* A GroupList parameter (<i>glname=...</i> on a table gives access to multiple datasets
−	<div class="imgGlyph24 imgDisambiguate"></div> Remember:	+	* A LatestValues display gives you current values, prior values and/or (%) changes
−	* Requires string (or jQuery) parsing of embed html (some classes to assist)	+	<br>
−	* Limit of 50 points of historical data per series for tables.	+	<div class="imgGlyph24 imgNote"></div>&nbsp;Remember:
−		+	* Use jQuery (or similar library) to parse the structured classes in the display and get the data values
−	[[Category:Advanced]][[Category:Displays]][[Category:Publishers]][[Category:Developers]]	+	* There is a limit of 50 points of historical data per series for tables.
		+	<br>
		+	[[Category:Advanced]][[Category:Displays]][[Category:Publishing]][[Category:Developers]][[Category:API]]

---

Latest revision as of 06:55, 10 May 2017

 Instead of using the API to loop through and fetch many series for a given app (like mapping, or HiCharts), you can just use displays (tables, latest values)

Just create a table specifically for your app which contains all the data needed and then use AJAX to fetch it.

 Some Advantges:

• You can mark the row (series) labels to easily identify their data
• Label knockouts are available
• Just one fetch for multiple series
• The displays are server-cached for speed
• A GroupList parameter (glname=... on a table gives access to multiple datasets
• A LatestValues display gives you current values, prior values and/or (%) changes

 Remember:

• Use jQuery (or similar library) to parse the structured classes in the display and get the data values
• There is a limit of 50 points of historical data per series for tables.