I have a service which returns an InfoTable with 3 columns, X data, Y data, and a column I want to filter the data on. I want to display the XY data on a time series chart based on a value that appears in the 3rd column. Is it best to use the Data Filter widget for this?
If so I'm not sure what to bind to the Query property of the Data Filter widget. Any guidance would be appreciated.
The Data Filter widget has an output of type QUERY, which you can use as an input to your Service. You'll need to modify your +Service +to use this input. There is an InfoTableFunction called +Query() +(available from the "Snippets" tab), which takes an info table and query as a parameter. This will allow you to filter your info table.
Keep in mind, you'll need to bind data into the Data Filter widget for it to know which fields it can use to construct your query.
If I want to create a seperate service to actually do the query, how do I tie the InfoTable output of the first service to the InfoTable input of the service that will perform the query? Do I need to create an InfoTable property for my Thing?
Sorry for the probably obvious question :)
You'll do that from the Mashup Builder by binding the output (All Data) from your first Service to the input of your query Service.