Service Task Definition (Addon-XML)

Once imported, modeling elements that are not built in as the standard will be added to the modeling palette and used.

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 * 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 a file into the Folder (supports Team Drives) Google Drive Files Get Download Drive-File and Add to file-type data (FileID via Link URL at Shareing settings Advanced) Google Drive: Create Permission Create Permissions in the specified files on Google Drive
	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 contents of a Table 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. 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 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
	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 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
	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 Stored the status of the Paypal Invoice ID specified by String type data item in 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. 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

	Converter Converter (Date to Japanese calendar text) * Converts a DATE / DATETIME data item to Japanese calendar text and stores it in a STRING 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. 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 from Select type data. Then, refer to the Select type data 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) Judging the Questetra User by the email address string stored in the string type data item and update the User type data 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”.
	Filter 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
	Organize / Update 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; 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. Delete Rows of TSV Remove the specified number of rows from the top from the tab-delimited text (TSV) stored in the String type Data Item
	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 Specific Line Reader Extract specified line from multi-line text 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 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. Line Counter Measure the number of lines in text 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. 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.
	Generator Random Number Generator (dynamic) A random number that does not exceed the number in the Data item selected config "A" (e.g.: 0 to 99) will be stored in the Data item selected in the config "B" Random Number Generator A random number that does not exceed the config "A" (e.g.: 0 to 99) will be stored in the Data item selected in the config "B" Random Password Generator Generates a password from the specified combination of character strings and stores it in a data item. It can be used for “Issuing new user account” of the information system. File Name Generator Stores a filename generated by concatenating prefix, item ID, date / time, and suffix in a data item
	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.
	Connector 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.
	Data Delete Data (Overwrite with Null) Deletes the data of the selected data item. 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.
	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 date time 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 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 process.

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”.