Add Actions or Other Blocks

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 MashZone NextGen 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 MashZone NextGen 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 MashZone NextGen license includes the MashZone NextGen Add-On for SharePoint and it has been configured by your MashZone NextGen 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.

See Add SharePoint Information Sources for instructions.

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 MashZone NextGen 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.