Query Sheet Aggregate
This node is used do aggregate data queries on a column from a public Google Sheet. The aggregate query will be either
max- The minimum/maximum value of the specfied column.
unique- An Array containing all unique values in the column.
count- The number of entries in total of that column. Empty cells will not be counted.
?> Note that the Google Sheet need to be made public for Noodl to be able to access it.
Results from the Aggregate Query
Note the the type of the Result output is dependent on which aggregate query that is run. For
count Result will be a Number. For
unique it will be an Array.
Document Id and Sheet Name
You refer to the document through its id. You find the id in the URL of the Google Sheet.
You also have to specify the Sheet Name. You find the Sheet names in the Google Document at the bottom of the sheet.
A filter can be added to the query, meaning the aggregate will only be calculated based on the filtered rows. It can be a combination of various filter operators (
exists, etc) depending on the type of the column. Multiple filters can be combined using
OR. A the values to filter against can be set dynamic by making the filter use an
Input rateher than a static value. This will create an input on the node that you can connect.
Controlling when queries are performed
Do signal is unconnected, the Query will automatically be run when the Query Sheet Aggregate node is created and whenever any of its inputs change. By connecting the
Do signal, the Query will only be run when
Do is triggered.
|Document Id||The id of the Google Sheets document. You can find it in the URL of the sheet.|
|Sheet Name||The name of the sheet where to capture the data in the Google Sheet.|
|Column||The name of the column in the Google Sheet to run the aggreagate query on.|
|Aggregate||Can be one of the following values: |
|Filter||Each filter that is set up to controlled by an input will show up as an input on the node.|
|Do||This signal will trigger the query to be executed. If the signal is not connected, the query will automatically be triggered when instanciated and when any of its inputs changes.|
|Result||The result of the aggregate query. It's either a Number or an Array depending on what aggregation query that that was performed (see |
|Error||A textual description of the latest error, when the |
|Success||This signal is sent when a Query was successfully performed.|
|Failure||This signal is sent when a Query failed for some reason. The |