XML Connections
You can use XML data binding if you want to display data in your content. Data can be altered any time through an XML sheet so you won't have to edit your content each time data changes.
You can connect an XML and use its data by following this guide:
You can use your own XML file or a simple Google Spreadsheet to create an XML connection. This is an example of an XML Spreadsheet.
First, your document has to be published through these steps: File->Publish On Web-> Select: Entire Document and Web Page -> click Publish
Get back to the spreadsheet editor interface and copy the ID from the URL. (Text highlighted with red)
https://docs.google.com/spreadsheets/d/1BVqnifu16QgYuaOPBUcTeCD0ZvJoPT-YvBuvc1Kez8Y/edit#gid=0
Then replace the "Your_ID_Comes_Here" text with your ID in this URL:
https://spreadsheets.google.com/feeds/list/Your_ID_Comes_Here/1/public/values
You will use this URL in the next steps.
On the Administrator page, under the Datasources menu, add a new datasource.
Note that only users with SuperAdmin role can access this menu!
Give your datasource a name, which will be displayed in the Datapicker.
Select the client who will use the datasource in its contents.
Add the XML file's URL or the URL that we created in the first step.
Save your datasource.
You can use data binding on widgets where there is an option for a Datapicker.
The following widgets contain a data binding option:
Dynamic charts can only be used with data binding:
For this example I chose the Table dynamic chart widget.
In the data picker, select your datasource.
After the selection, the column names will be displayed. Choose the columns you want to display on your content.
You can set the columns' width (in pixels), text and background color, the label (the column's name), alignment, and the type of data, which can be Text or Image.
The columns can be dragged up and down. This will allow you to set the order the columns will be shown.
If you want to use another page other than the first one, you will need to use this method:
- Main Sheet: https://spreadsheets.google.com/feeds/list/YourSpreadSheetIDcomesHere/od6/public/values
- Sheet1: https://spreadsheets.google.com/feeds/list/YourSpreadSheetIDcomesHere/1/public/values
- Sheet2: https://spreadsheets.google.com/feeds/list/YourISpreadSheetDcomesHere/2/public/values
- Sheet3: https://spreadsheets.google.com/feeds/list/YourISpreadSheetDcomesHere/3/public/values
When you create your spreadsheet, the Main Sheet will always be the default sheet created by the software.
If you are using sheet numbers to identify your sheets in the URL, the numbers will follow the order of the sheet pages in your spreadsheet.