Add Automatic Processing Process (Addon)

Once imported, modeling elements that are not built-in as the standard will be added to the modeling palette and used. Before start modeling, download the Service Task Definition file and import it in advance.

Related Manual

• M415: Adding an Auto-Step to be Used for Business Process Definition

Get "Addons" other than "Service Task Definition" from the link at the end of the page.

Data Processing Involving Communication with the Outside of Workflow App

Processing such as adding appointments to Google Calendar, collecting business partners from Salesforce in bulk, and sharing information with other departments in Slack is automated on the server-side.

	Google Calendar Google Calendar: Insert Event * Insert an event to Google Calendar. Google Calendar events list Accessing to Google Calendar and retrieves a list of events (schedules) registered during the specified time period. In combination with Workflow, it will be possible to get schedule of next week collectively, and notify (announce) them by email.
	Google Drive Google Drive: Create Folder * Create a new folder in the specified folder on Google Drive. Google Drive: Delete File / Folder * Delete files or folders on Google Drive.You can delete multiple files or folders at once.When you delete multiple ones,you should write one file/folder ID on each line. Google Drive: Search Folder * Search for the folder with the specific name, directly under the specified folder on Google Drive. Google Drive Files Copy Creates a copy of the specified file in the Drive. Supports both Google Doc files and common files. File ID can be obtained from URI etc. (If Folder-ID not specified, the file will inherit any discoverable parents of the source file.) Google Drive: File; Download Downloads the specified file in the Drive to the Workflow Data Item. If a Google File (Docs / Sheets / Slides, etc.) is specified, an error will occur (Please use File Export). The File ID can be obtained from the sharing settings screen. Google Drive: GFile; Export as PDF Exports the specified file in the Drive to the Workflow Data Item in PDF format. If a file other than a Google file (Docs / Sheets / Slides etc.) is specified, an error will occur (Please use File Download). File ID can be obtained from URI. Google Drive: GFile; Export as Microsoft-Office Exports the specified file in the Drive to the Workflow Data Item in Microsoft format: docx, xlsx, or pptx. If a file other than a Google file (Docs / Sheets / Slides etc.) is specified, an error will occur. File ID can be obtained from URI. Google Drive: Create Permission Create Permissions in the specified files on Google Drive
	Google Document Google Docs: Document; Replace All Text Replaces all instances of text matching the specified string with replace text. The search is case sensitive. The number of replacements is output as a log. In many cases, the automated step “Google Drive: File; Copy” is placed upstream.
	Google Sheets Google Sheets: Download Choice Data * Download Choice data in specified 2 columns from Google Sheet. Google Sheets: Append New Row * Adds new cells after the last row with data in a sheet, inserting new rows into the sheet if necessary. New Record to Google Sheets (TSV) Adds the TSV data in String type data item to the end of a Google Spreadsheets and stores its communication log in the Data Item. If there exists no sheet, adds one automatically. New Record to Google Sheets (Table) Adds values in a Table-type Data Item to the bottom line of a specified Spreadsheet and stores its communication log in the Data Item. Google Spreadsheets Cell Value Update Updates the target cell on the target sheet of the specified Google Sheets with the value of the specified Data Item. The communication log is stored in the String-type Data Item. Sum of cells in a Google Spreadsheet Stores the sum of specified range of a Google Sheets into a Numeric-type Data Item, and stores its communication log in a String-type Data Item. Comma removal version corresponds to the case where the decimal separator “,” is mixed. Get Google Sheets Values as TSV Convert values on Google Sheets into TSV
	Google Slide Google Slides: Page; Duplicate Duplicates the specified slide and inserts it on the next page. If no slide is specified, the last slide is duplicated. Google Slides: Page; Generate PNG Image Generates an image of the specified page in the presentation with generating a URL to the image which has a lifetime of 30 minutes. Note that if the presentation sharing settings are changed, access to the images may be lost. Google Slides: Page; Refresh All Chart Refreshes all embedded charts in the specified slide by replacing them with the latest version from Google Sheets. Google Slides: Page; Replace All String Replaces all instances of text matching the specified string with replace text. The search is case sensitive.
	Google Groups Google Group members retrieve Retrieves Google Group members (email address) list. By checking group members (ML members) on a regular basis, ML management becomes easier. It also helps to prevent e-mail transmission to unnecessary members or to prevent lefting out proper members from information sharing. Google Group member add Add a member (email address) to Google Group. You can create an newsletter subscriber list (ML) distributed for the requester for material document, or register to group at the same time when adding a new employee account. Google Group Member Deletion Deletes members (email address) from Google Group. It is possible to respond to email newsletter delivery cancellation, or to delete automatically from the group when employees move or leave the company
	Google Analytics Accesses to Google Analytics and get Ranking report (PV / Referrer / Domain). it is possible to specify duration and filter criteria, so you can get regular reports without having to sign in to Google Analytics. Google Analytics reports (PV ranking) Google Analytics reports (Domain ranking) Google Analytics reports (Referrer ranking)
	Google Cloud Print Prints the file specified by File-type Data Item with the specified printer, and stores its communication log in a String-type Data Item Submit Print Job via GCP Service Submit Print Jobs via Google Cloud Print Service
	Google Fit Google Fit: Dataset; Aggregate Step Count Aggregates data of Step Count and Distance (meters) in Google Fit. Multiple data sets from multiple sources (including manual input) can be aggregated. Note that the results of simultaneous measurement with multiple devices are all added up.
	Salesforce Salesforce Order Create Registers new order information in Salesforce specifying the Client and order details. Stores Order ID and communication logs into String-type Data Item. Batch to Get Accounts from Salesforce Stores business partner’s ID and Name inside Salesforce respectively into Data Items, and stores its communication log in a String-type Data Item.
	Box Box: Upload File * Upload files to the specified folder on Box. Box: Create Folder * Create a new folder in the specified folder on Box. Box: Delete Folder * Delete folders on Box. You can delete multiple folders at once. When you delete multiple ones, you should write one folder ID on each line. Box: Search Folder * Search for the folder in the specified folder on Box Box: Create Shared Link to Folder * Create a URL to download the specified folder on Box Box File Upload (Password / Expiration) Uploads (one) file which set in File-type Data Item into "box" and obtain its URL for publication. At the same time, it sets and expiration date. It is recommended to set "Max number of files" of the File-type Data Item where the file to be uploaded as 1. Create Box Webhook(folder) Create a Box webhook to check events on the folder. In advance,you have to configure the OAuth2. Parsing Box Webhook JSON Parse the JSON object sent by a webhook on Box. Delete Box Webhook Delete the Box webhook. In advance,you have to configure the OAuth2.
	Dropbox Upload to Dropbox Uploads the file specified by File-type Data Item to the specified directory of box, and stores its communication log in a String-type Data Item
	kintone kintone Batch acquisition of Two rows data Stores the value of the field code of two columns of the specified kintone application into a Data Item respectively, and stores its communication log in a String-type Data Item.
	Slack Slack: Post Chat (Bots) * Send a message to Slack with Bots. Slack: Post Chat (Incoming Webhook) * Send a message to Slack with Incoming Webhook. Slack: Upload File (Bots) * Upload files to Slack with Bots. Slack: Chat Post Ephemeral Sends an ephemeral message, which is visible only to the assigned user in a specific public channel, private channel, or private conversation. The user should be in the channel specified. SLACK USER is ID of the user who will receive the message.
	LINE Post message through LINE Notify Post message to your LINE Group through LINE Notify. In advance you have to get a personal access token. When get the one, choose where messages are sent.
	Hangouts Chat Hangouts Chat Post Message Post a message which is specified in “text” to Hangouts Chat
	Microsoft Teams Microsoft Teams Post Message Posts a message specifying its title and text body to Microsoft Teams
	ChatWork ChatWork Add Message Add a message to the specified chat room of ChatWork
	Typetalk Typetalk Post Messag Post a message specified with “text” on Typetalk Typetalk Post Message (use API token) Post a message as a bot to the topic specified by URL
	Sendgrid Sendgrid: Send Bulk Emails Send a mail from SendGrid.
	Backlog Backlog Add Issue Adds an Issue based on its Project ID, Summary, Type ID, etc., and stores the communication log into Data Item respectively.
	PayPal PayPal Invoicing Create (JPY) Generates Paypal invoice automatically from the setting item information, and stores Paypal Invoice ID in a String-type Data Item PayPal Invoicing Create (USD) Generates Paypal invoice automatically from the setting item information, and stores Paypal Invoice ID in a String-type Data Item PayPal Invoicing Status Stores the status of the Paypal Invoice ID specified by String-type Data Item into a String-type Data Item, and if having been paid, stores the payment date and time and the amount in a Data Item PayPal Invoicing Send Sends an invoice with the Paypal Invoice ID specified by String-type Data Item via email, and stores the status in a String-type Data Item
	Stripe Stripe Charge to Customer ID From Customer ID, charge amount, currency code etc. stores Charge ID, last 4 digits of credit card number, status of registration process, communication log respectively into Data Items as billing record Stripe Customer ID Create from Token Registers a customer in Stripe by using the ID which tokenized credit card information. Customer ID used for billing, last 4 digits of the credit card, status of registration processing, and communication log are stored in Data Item. Card Info to Stripe (MM/YY edition) Registers customer’s settlement information to Stripe and stores the Customer ID and the last 4 digits of credit card number to be used for billing, the status of registration processing, and the communication log into the Data Items respectively Card Info to Stripe Registers customer’s settlement information to Stripe and stores the Customer ID and the last 4 digits of credit card number to be used for billing, the status of registration processing, and the communication log into the Data Items respectively
	WordPress.Com WordPress.Com: Posts New Creates a post as a draft. Content is stored as a draft HTML of POST type. If you want to dynamically change the WORDPRESS DOMAIN using the EL expression, set Scope to “global”. Wordpress.Com: Media New Uploads new pieces of media. If you want to dynamically change the WORDPRESS DOMAIN of the upload destination using the EL expression, set Scope to “global”. WordPress.Com: Stats Views Gets a post’s views. By specifying WORDPRESS-DOMAIN and POST’ID, the cumulative number of page views is stored.
	Zendesk Support Zendesk Ticket Update Update a specified Zendesk ticket
	Twilio Twilio FAX Send Sends the PDF file specified by the URL as a fax.
	Corporate Number Houjin-Bango Corporate Info Retrieve Access the National Tax Agency corporate number Web-API v3 and obtain the business name, address and reading data corresponding to the corporate number (13 digit number). “Application ID” from the National Tax Agency (free) needed
	Questetra Questetra Role Membership Add System Administrator Authority and User Manager Authority required 1. Get Secret: https://{YOUR}.questetra.net/Admin/OAuth2/Client/list 2. Config [OAuth 2.0 Setting] Questetra Role Membership Delete Deletes a member from Questetra’s “Role” and stores the communication log in a String-type Data Item. Questetra Org Membership Add System Administrator Authority and User Manager Authority required 1. Get Secret: https://{YOUR}.questetra.net/Admin/OAuth2/Client/list 2. Config [OAuth 2.0 Setting] Questetra Org Membership Delete System Administrator Authority and User Manager Authority required 1. Get Secret: https://{YOUR}.questetra.net/Admin/OAuth2/Client/list 2. Config [OAuth 2.0 Setting] Check the user is in the organization If the specified user is the leader of the specified organization, this task returns “L”. If he or she is one of the its members,it returns “M”. If he or she doesn’t belong to it, it returns nothing. Post to OpenChat (Questetra's Enterprise Social) Messages that all users can search and view will be posted to OpenChat. Since posted on the workflow engine's standpoint, there is no concept of followers. It is displayed in the timeline of the participants as "#p1234".
	Misc (Any Website): File Download * Downloads a file and adds to File-type Data Item. The GET request to the URL is thrown and the response is saved as a file. NHK Program Search Stores program information matching the keyword specified in String-type Data Item into a String-type Data Item, and stores its communication log in a String-type Data Item

Data Processing Closed within Workflow App

Processing such as generating random numbers, counting the number of characters, converting the TSV data to an Excel file, etc. is automated on the server side

	C1.Generator Number, Generate Random Generates a random number. When a token reaches this automated step, a numerical value within the specified range is generated each time. The decimal part is rounded down toward 0 according to the workflow data definition. String, Generate Password Generates a random string. When a token reaches this automated step, a string of the specified length is generated each time. Complex rules such as mixed symbols or non-use of specific characters (I and l) are also supported. “Add New User” etc.
	R1.Calculator Days Calculator Calculate the number of elapsed days from the two specified dates and store it in a Data Item Minutes Calculator Calculates the elapsed time (minutes) from the two specified Datetime-types and stores it in the Data Item Accumulated Hours Calculator Calculates the elapsed time from the specified two date times and adds it as cumulative time to the Data Item Character (Letter) Counter Counts the number of characters in a text and store it in a Data Item. It can be used, for example, counting the number characters in original sentences in the translation work, or checking the received manuscript data. Multiline String, Get Number of Lines Gets the number of lines of text. The number of lines that do not count the trailing newline codes can also be stored. Hash Calculator (SHA256) Generating hash value (SHA256 method) of a string and stores it in a String-type Data Item. Hash Calculator (MD5) Generating hash value (MD5 method) of a string and stores it in a String-type Data Item. Generate Transfer Slip Regarding to the down payment for long-term service, stores sales transfer slip data for the number of months of contract into a Data Item Journal-TSV Create Creates the Journal-Slip TSV. The transfer slip TSV of the sales is generated based on the Invoice data. To generate a file that can be imported into the accounting system, place a converter such as “TSV to Excel-CSV FILE” in the downstream Step. TSV String; Add N to Number Column Generates a new TSV with adding N to each number in the number column. Calculation results are added at the end of the line. Available at discounted price table etc. Removes whitespace from both ends of a string. TSV String; Multiply N by Number Column Generates a new TSV with multiplying N by each number in the number column. Calculation results are rounded off and added at the end of the line. Available for tax calculation etc. Removes whitespace from both ends of a string. TSV String; Sum of Number Column Calculates the sum of values in numeric column. If non-numeric data is mixed in the specified column, the record is regarded as zero and not added. TSV String, Create Cross Tab for Numerical Sum Creates a crosstab (pivot table) for numeric fields in TSV data. For example, the “Amount” in the order history (TSV) is aggregated on two axes, “Responsible” and “Product”. The fields for X-axis and Y-axis aggregation are specified by TSV field ID.
	R2.Get Diff (Table and Table) Confirm difference information of two Table-type Data Items line by line Single Value from a JSON object using JSONPath Obtains the specified values from JSON text data and stores them as workflow data Multiline String, Get Specific Line Gets a specific line of a multi-line string. The line ID specification starts with 0. Multiline String, Filter by Text Filters multiple-line string with any search text. Only lines that contain the search text are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as “USA, U.S., United States”. TSV String, Filter by Text Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as “USA,U.S.,United States”. TSV Filtering by Date Filter a row in a tab-delimited text (TSV) stored in a String-type Data Items by date range and save. TSV Filtering by Number Filter the rows on tab-delimited text (TSV) stored in String-type Data Item by a range of numbers and save it Extract Value from Query String Extracts the value of the specified parameter from the serialized query-string (e.g. "a=123&b=456") and stores it as workflow data Questetra BPMS: Process, Extract as TSV Extracts process data as single-line TSV string. Items are specified in CSV format such as “0,2,3”. Tab code and line feed code are automatically deleted. Discussion type, Table type, Guide-Panel type cannot be extracted (Warning Log). Questetra BPMS: Process, Batch Extract as TSV Extracts process data as a multi-line TSV string from date-filtered processes. Items are specified in CSV format such as “string:0,date:2,select:3”. Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported. Questetra BPMS: Process, List All File URLs Lists the download URLs for the files stored as workflow data of Questetra BPM Suite. If two files are attached, output two lines of text. This is useful for browser extensions and email text attachment. Questetra-Addon-XML Extract Configs Extracts the configs of the automatic step. The Addon-XML file (for Questetra BPMS automatic task) is parsed and information such as summary, last-modified, config etc. are extracted (XML escape is not decoded). And simple HTML code is generated. Questetra-Model-XML Extract Definition Extracts the definition summary of Business Process. Process-data-definitions (“number”, “data-type”, “name”) and Node (“number”, “name”, “nodeType”) are extracted from Model-XML file in QAR archive. TSV and/or HTML for WordPress are generated.
	U1.Processing TSV String; Add Static Value to All Lines Adds the new string cell to the end of all rows. If there are space characters or line feed characters at the beginning and end of the TSV, they will be deleted beforehand. If the number of tab separators does not match, an error will occur. TSV String; Add Prefix to Column Generates a new TSV with concatenating the prefix Str to all cells in the column. The concatenated strings are added at the end of the line. Available at categorization etc. Removes whitespace from both ends of a string. TSV String, Sort by Text Sorts TSV lines in the order of the character code of the specified column. If the column value for each line is Jan Feb March, the text is sorted in the order of “line that contains Feb”, “line that contains Jan” and “line that contains March”. TSV String, Sort by Numeric Sorts TSV text in the numerical order of the specified column. If each column values are “123 jpy”, “1,234 jpy”, and “12 jpy”, they are sorted in the order of “line including 12 jpy“, “line including 123 jpy“, “line including 1,234 jpy“. TSV String; Add Suffix to Column Generates a new TSV with concatenating the suffix Str to all cells in the column. The concatenated strings are added at the end of the line. Available for name honorifics or currency units etc. Removes whitespace from both ends of a string. TSV String; Re-order Columns Extracts a new TSV string re-arranged by a column ID list from TSV string. ID repetition in the list is also possible. It can be used to narrow down necessary information or conform to the format. Removes whitespace from both ends of a string. Multiline String; Delete Header Lines Deletes the header lines of a multiline string, like CSV text or TSV text. Note that blank characters at the end or beginning of string data are deleted in advance. If singleline text, an empty string will be returned. Multiline String; Delete Footer Lines Deletes the Footer lines of a multiline string, like legacy Banking Formats or legacy EDI Data. Note that blank characters at the end or beginning of string data are deleted in advance. If singleline text, an empty string will be returned. Questetra BPMS: Process, Concat All Strings Concatenates all string type data. Searches and joins string data and title strings stored as workflow data of Questetra BPM Suite. A line break is added between each data. It is used for checking the existence of keywords.
	U2.Converter Converter (Date to Japanese calendar text) * Converts a DATE / DATETIME data item to Japanese calendar text and stores it in a String-type Data Item. Converter (TextFile to String) Converts the text file to a string. All lines of the file are extracted and stored in String-type Data Item. It is also possible to save the number of file lines. Converter (Options to Table) Convert IDs-Labels (values-displays) defined in Options XML (M319) to Table-type Data Item (2 columns). Converter (Table to Options)Convert IDs-Labels defined in Table data to two String-type Data Items. (In order to base registration as Options XML, refer to two String-type Data Items from Select-type Data Item. Then, refer to the Select-type Data Item from [Service Task (Choices Update)].) Converter (Table to Excel-CSV FILE) Stores the values in a Table-type Data Item into a File-type Data Item as an Excel compatible CSV. Converter (Table to Excel-CSV FILE) sjis Stores the values in a Table-type Data Item into a File-type Data Item as an Excel compatible CSV. Converter (Table to TSV) Converts the value of a Table-type Data Item to the tab delimited format (TSV) and stores it in a String-type Data Item Converter (TSV to Excel-CSV FILE) A tab delimited text (TSV) stored in a String-type Data Item is saved as an Excel compatible CSV file in a File-type Data Item. Converter (TSV to Excel-CSV FILE) sjis A tab delimited text (TSV) stored in a String-type Data Item is saved as an Excel compatible CSV file in a File-type Data Item. Converter (Tsv to Table) Parses a tab delimited text (TSV) stored in a String-type Data Item, and stores it in a Table-type Data Item. Converter (Email-Str to Quser) Converts string-type data (email string) to Quser-type data. If it does not match any registered address, the user type data item will not be updated. When multiline string, it is judged in order from the first line until it matches. item. Converter (Quser to ID, Name, Email) Stores the UID, Name, and Email of a User-type Data Item A in a String-type Data Item selected at B, C, D respectively. Converter (JapanZipCsv to JapanZipXml) Generates a postal code master. The zip data “KEN_ALL.CSV” (120k lines) of Japan Post is converted to “Japan-Zip.xml”. Converter (ZENGIN to MizuhoCSV) Generates a general transfer file for Mizuho Bank. The file of “ZENGIN format” defined by the Japanese Bankers Association is converted to the file for “Mizuho Business Web” service. Each line consists of “Customer Code 1” and “payment amount”. Data Duplicator (Files) Duplicate the file of File-type Data Item: A to File-type Data Item: B. Data Duplicator (Table) Duplicates all data stored in Table-type Data Items to other Table-type Data Item.
	D1.Delete data Delete Data (Overwrite with Null) Deletes the data in the selected Data Item.
	X1.Process startup Connector for TSV Bulk Start Launching the Start event specified by each line data of tab delimited format data (TSV) and stores the communication log.
	X2.Send mail Email a Excel-CSV (Table) Excel-CSV Email Attachment (Table) Email a Excel-CSV (Table) sjis Converting the values in a Table-type Data Item to an Excel CSV file (TSV), and sends it as email attachment.

Addons except for "Service Task Definition"

	Options Definition Master file of Select-type Data Items. Once imported, it eliminates the need to manually set candidate lists upon defining candidates for Select-type Data Items since referring to the master becomes available.
	Base PDF PDF form in Service Task (PDF generation). Once imported, you can use the function of document form generation in “PDF auto-generation”.