Mashups in Presto Wires : Creating Mashups in Wires : Add Actions or Other Blocks
Add Actions or Other Blocks
 
Aggregate Statistics
Add Input Fields Directly to Block Properties
Average Results
Count Results
Format Results as CSV
Decorate or Transform Data
Build Dates
Create a Document for Input
Adapt Results as a SharePoint External Content Type
Extract Partial Results
Filter Results
Filtering Techniques
Group Results
Add Input Parameters
Join Results
Map Results to Known Structures
Merge Results
Merge SharePoint Lists
Strip Namespaces
Run Several Blocks Simultaneously
Pivot Data
Analyze Datasets with RAQL Queries
Select Fields
Add an Item to a SharePoint List
Run a SQL Statement
Build Strings
Sort Results
Transform Results
Built-in Functions for Decorator, Mapper and Transformer Blocks
Build URLs
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, databases 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
* Direct Invoke: to add information sources from the Internet or other URLs. See Add a Web Information Source with DirectInvoke.
* Document: to build a well-formed document as input to a single property for another block. Common examples are for complex input parameters or headers for mashables or other mashups. See Create a Document for Input.
* Extract: to extract one field, several fields or one or more repeating items from a result. The extracted results can be used as input to another block or as the final result for the mashup. See Extract Partial Results.
* Filter: to select specific items in a result based on one or more conditions. See Filter Results and Filtering Techniques.
* Group: groups repeating items based on the unique values of one or more fields. This can also optionally calculate basic statistics for groups. See Group Results. See also Aggregate Statistics.
* Input: to provide dynamic input fields for other blocks. See Add Input Parameters or Add Input Fields Directly to Block Properties.
* Join: to combine the repeating items from two blocks based on a relationship. This relationship in the join condition. See Join Results.
* Loop: to add a mashable or mashup and run it in a loop for multiple results. See Add a Mashup or Mashable in a Loop.
* Merge: to combine several results that all have the same structure. See Merge Results.
* Parallel: to run two or more mashables or mashups at the same time (in parallel), generally to improve performance. For more information, see Run Several Blocks Simultaneously.
* RAQL: to work with and analyze large datasets using Presto Analytics and the Real-Time Analytics Query Language (RAQL). See Analyze Datasets with RAQL Queries.
* Select: to select only specific fields in every repeating item in a result. See Select Fields.
* Sort: to sort repeating items in a result based on a field. See Sort Results.
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.
* 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 only function properly if your Presto license includes the Presto Add-On for SharePoint and it has been configured by your Presto administrator.
*You can get information for a mashup from SharePoint Lists or SharePoint search results using the following blocks:
* SP List: to add a SharePoint List, or a specific view for a SharePoint List as an information source in a mashup.
* SP Search: to add the results of a simple 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.
* SP FAST Search: to add the results of an advanced SharePoint search using the FQL query language as an information source in a mashup.
* External Content Type Adapter: allows a mashup to act as an external data source for SharePoint Lists. Adding this block to a mashup is required to allow SharePoint users to define the mashup as an external content type.
Note:  
This block makes mashup compatible with the Microsoft Business Connectivity Service (BCS).
Lists based on external content types allow SharePoint to retrieve dynamic information from 'external sources' such as mashups, and thus many Presto mashables.
* Merge SharePoint Lists: allows you to merge the information from two or more SharePoint Lists.
* Add Item to a SharePoint List: allows you to add an item to an existing SharePoint List and get either the full results for the List including the new item or detailed results for the item just added. .
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.
Copyright © 2013-2015 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback