1. http://code.google.com/apis/visualization/documentation/reference.html#GadgetHelper
   • Method: createQueryFromPrefs(prefs)
   • Return Value: google.visualization.Query
   • Description: Static. Create a new instance of google.visualization.Query and set its properties according to values from the gadget preferences. The type of parameter prefs is _IG_Prefs
     1. Preference _table_query_url is used to set the Query data source URL.
     2. Preference _table_query_refresh_interval is used to set the Query refresh interval (in seconds).
2. Don't know

google.visualization.Query.setResponse({
    version: '0.6',
    status: 'ok',
    sig: '202289222',
    table: {
        cols: [{
            id: 'A',
            label: 'Name',
            type: 'string',
            pattern: ''
        },
        {
            id: 'B',
            label: 'Value',
            type: 'number',
            pattern: '#0.###############'
        }],
        rows: [{
            c: [{
                v: 'One'
            },
            {
                v: 1.0,
                f: '1'
            }]
        },
        {
            c: [{
                v: 'Ten'
            },
            {
                v: 10.0,
                f: '10'
            }]
        }]
    }
});

( pretty printed by http://jsbeautifier.org/ )

google.visualization.Query

Represents a query that is sent to a data source.

Constructor

google.visualization.Query(dataSourceUrl, opt_options)

Parameters

dataSourceUrl

[Required, String] URL to send the query to. The data source should expose this URL in some way; for example, to get the dataSourceUrl from a Google Spreadsheet, do the following:

1. In your spreadsheet, select the range of cells.
2. Select 'Insert' and then 'Gadget' from the menu.
3. Open the gadget's menu by clicking on the top-right selector.
4. Select menu option 'Get data source URL'.