Bookmark and Share Share   

Add Actions or Other Blocks

Blocks that are not Presto mashables or mashups appear in the Blocks Tab. Most of these additional blocks are actions that you can use to change results or provide dynamic inputs to the mashup. Some additional blocks also allow you to use information sources from sources other than Presto, such as web sites or SharePoint.

In most cases to use an action block, you add the block to the canvas, connect one or more other blocks as input to the action and then set additional properties for the action block.

Wires has a set of built-in actions and other blocks including:

Core
Data Transformation
  • CSVGenerator: to convert results to a CSV (comma-separated values) format used in spreadsheets and some databases. See Format Results as CSV.

  • DataDecorator: to convert, format or transform just the data in results from another block. This action block allows you to apply one or several functions to data. See Decorate or Transform Data.

  • Mapper: to change the structure, organization or data of results to match a known structure. This maps the two structures. See Map Results to Known Structures. Presto administrators should also see Adding XML Schemas to the Wires Mapper Block.

  • Transformer: to change the structure, organization or data of results to a structure you define. See Transform Results.

Database

Database: to run one SQL statement for any datasource that your Presto administrator has configured.

You can use this block to query a database, run a stored procedure or insert, update or delete records. See Run a SQL Statement.

Math
  • Average: to calculate the average value of one field in a set of repeating items. See Average Results.

  • Counter: to count the number of items in a set of repeating items. See Count Results.

SharePoint

Blocks for SharePoint are only available only if the Mashup Sites for SharePoint Add-On is installed and configured by your Presto administrator. These blocks allow you to add items from SharePoint as direct information sources for a specific mashup without registering them as mashables.

  • SPList: to add a SharePoint List directly as an information source in a mashup.

  • SPSearch: to add the results of a SharePoint search directly as an information source in a mashup. Searches allow you to filter results from a SharePoint service, such as an RSS feed.

  • SPView: to add a specific view for a SharePoint List directly as an information source in a mashup.

See Add SharePoint Information Sources for instructions.

Utility
  • Aggregate:performs basic statistics for repeating items that are grouped based on one or more key fields. See Aggregate Statistics. See also Group Results.

  • DateBuilder: to select a date and apply one of several date formats. See Build Dates.

  • NamespaceStripper: to remove all namespaces from a result. See Strip Namespaces.

  • StringBuilder: to build a string of text from extracted values, input fields or other dynamic data. See Build Strings.

  • URLBuilder: to build a URL from extracted values, input fields or other dynamic data, typically for use with Direct Invoke. See Build URLs.

Presto administrators or developers can also add custom blocks to Wires. Contact your Presto Administrator for information on working with custom action blocks.See Adding Custom Blocks to Presto Wires Using Macros for more information.