Service Task Definition

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

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 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 Calendar: Insert Event Insert an event to Google Calendar.
	Google Drive Google Drive Simple Uploads Upload Files Less than 5 MB, and Update Metadata. File IDs are Comma-separated List if Multiple (supports Team Drives) 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) Deleting File on Google Drive 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. Creating Folder on Google Drive Create a new folder in the specified folder on Google Drive Creating Permissions on Google Drive Create Permissions in the specified files on Google Drive
	Google Sheets Google Spreadsheets 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 Spreadshee 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 Google Sheets Append Cells 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. Get Google Sheets Values as TSV Convert values on Google Sheets into TSV Batch to Get Two Column Values from Google Sheet Stores the value in two columns of the specified Google Sheets into a data item, and stores its communication log in a String type data item
	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 delete 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 Upload to Box 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 [box] upload file and set 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. Parse 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 Batch to Get Two Column Values from kintone 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: Chat Post Sends a message to a channel. SLACK CHANNEL can be an encoded ID, or a name for channel, private group, or IM channel to send message to. 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. Slack: Files Upload Uploads files. If you want to share files, specify a comma separated list of channel names or IDs in SLACK CHANNELs.
	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 I 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
	Zendesk Support Zendesk Support Update Ticket Update a specified Zendesk ticket
	Twilio Sending FAX by Twilio 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 Ad 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 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 HTTP Files Get Download via HTTP and Add to file-type data

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 onverter (Date to Japanese Era String) onverts a Date type data item to Japanese calendar 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. 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.
	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 Add Column to Tsv Adding a character string to the end of each row of the tab delimited text (TSV) and stores it as a new TSV in a String type Data Item. Change Order of Tsv Sorting the columns of the TSV in the order as indicated 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 Generate Digest-HTML Generates HTML code. The Addon-XML file for Questetra BPMS is parsed and information such as summary, last-modified, config etc. is extracted according to the locale (XML escape is not decoded). After that, simple HTML code for WordPress is 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 Generato 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 Minites 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 Slip TSV from Invoice Data Generate transfer slip TSV (tab-separated-values) from sales amount, sales date, due date. The case of sales division is also supported. In order to generate a file for the accounting system, please place a converter such as "TSV to Excel-CSV FILE".