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 you start modeling, download the Service Task Definition file and import it in advance.

In this page, you can check:

• Data Processing Involving Communication with the Outside of Workflow Platform
• Data Processing Closed within Workflow Platform

Related Manual

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

Addons except for "Service Task Definition"

• Options Definition is here
• Base PDF is here

Access to APIs of various cloud services, and data processing involving communication outside the workflow platform is automated on the server side.

	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, Convert Converts file in Google Drive and save as another MimeType file. 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: GFile, Export as Text Exports text information from a GFile in Google Drive. If a file other than a Google file (Docs / Slides) is specified, an error will occur (Please use File Download). 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 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. 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 Sheets: Master Table, Simple Xlookup Returns a value by referencing master data in Google Spreadsheets. Searches for the Lookup Value in array C, and if an exact match, returns the value in array D at the same index. C and D are defined in A1Notation. The length must be the same.
	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 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 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 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. Box: Copy File Copy the File and save it in the specified Folder 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
	Microsoft 365 OneDrive for Business Microsoft 365 OneDrive for Business: Upload File Upload files to the specified folder on OneDrive. Microsoft 365 OneDrive for Business: Create Folder Create a folder in the specified folder on OneDrive. Microsoft 365 OneDrive for Business: Copy File Creates a copy of a file into the specified folder on OneDrive. Microsoft 365 OneDrive for Business: Delete File / Folder Delete files and folders on OneDrive. You can delete multiple ones at once. When you delete multiple ones, you should write one Path on each line.
	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: 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 Message 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: Customer Object, Create Creates the Customer object on the payment platform Stripe. Once the object is created, subsequent card billing is possible. Token ID and the customer email etc are required. Realizes a billing environment that does not touch sensitive info. Stripe: Charge Object, Create Creates the Charge object on the payment platform Stripe to charge the Customer ID (cus_12345678901234) for any amount in any currency. If the charging process fails, Charge object is not created and error log such as expired_card is output. Stripe: Charge Object, Create with Transfer Amount Creates the Charge object with Transfer Amount to charge the Customer ID for any amount in any currency. Any Connected Account as the Transfer Destination, any Transfer Amount within the Charge amount are available. If fails, the object not created.
	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. 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 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. Questetra BPMS: Process, Kick HttpStartEvent by TSV Kicks HttpStartEvent with the specific line data of TSV. When assuming batch start using multiline TSV data, place it in a loop structure. LineIDs start at zero.
	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

Data processing closed within the workflow platform, such as generating random numbers, counting the number of characters, and converting TSV data to Excel files, is automated on the server side.

	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.
	Duplicate Files, Duplicate Duplicates Files-type data. All files stored in Files-type data A is copied over Files-type data B. Table, Duplicate Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur.
	Converter 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: Table to TSV-String Converts Table-type data to TSV String. The string value of all cells in the Table-type data is copied over TSV string B. Cells with no input are regarded as empty strings. Converter: TSV-String to Table Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur. 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 (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. Converter: Quser to Email-String Converts Quser type data to Email string by referencing the latest information registered in the Workflow Platform. It is also possible to obtain “User ID”, “User Name”, “Main Organization”, “ID of Main Organization”, “Name of Main Organization”. 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”. You can refer to postal code master in input form settings such as “Select (Search Select box)”. 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”. 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. 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, 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”. String, Decode using Master Table Converts ID string to Label string with referring “Choice Master” shared within the workflow platform. If there is no matching ID, it is converted to an empty string.
	Filter 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 String, Filter Out by Text Filters out TSV lines by any search text (Exclude Filter). Only lines that DO NOT contain the search text in the specified column are output. If OR search with multiple texts, specify them as a comma-separated list such as “USA,U.S.,United States”. TSV String, Filter by Numeric Filters TSV strings using a numeric range. Only the rows where the specified numeric column is included in the numeric range are output. If you want to OR multiple ranges, specify them in comma separated form like “-100<36.4,37.5<100”. TSV String, Filter by Date Filters TSV strings using a date range. Only the rows where the specified date column is included in the date range are output. If OR multiple ranges, specify in comma separated like “2020-01-01<2020-01-07,2020-01-21<2020-01-27”. TSV String, Filter by Datetime Filters TSV strings using a Datetime range. Only the rows where the specified Datetime column is included in the Datetime range are output. If OR multiple ranges, like “2020-01-01 00:00<2020-01-07 23:59,2020-01-21 00:00<2020-01-27 23:59”. Multiline String, Get Specific Line Gets a specific line of a multi-line string. The line ID specification starts with 0. 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.
	Add/Remove String, Batch Replace Fullwidth Numbers with Halfwidth Numbers Replaces all full-width numbers with half-width numbers. Numbers from “０” to “９” are to be replaced. Symbols and letters are NOT replaced. The replacement count is output to the log. String, Batch Replace Halfwidth Numbers with Fullwidth Numbers Replaces all half-width numbers with full-width numbers. Numbers from “0” to “9” are to be replaced. Symbols and letters are NOT replaced. The replacement count is output to the log. String, Replace All Replaces all the search strings by the replacement string. All matches are case sensitive. For example, it is possible to completely replace the string “XXXX-XX-XX” in the template text with “2020-05-11”. 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; 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; 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.
	Extract String, Get Number of Words Gets the number of words in the text. Words separated by spaces (including tabs, double-byte spaces, and line breaks) are counted. The number of words counted, including commas and periods as delimiters, can also be obtained. String, Get Number of Characters Gets the number of characters in the text. Consecutive blanks (including tabs and double-byte spaces) are counted as one character. The number of characters that do not count linefeed codes and blanks can also be obtained. 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. String, Extract Substring Extracts N characters from the beginning. If negative, N characters (absolute value) are extracted from the end. When the length of the original string is shorter than N, returns the original. To be padded to N, set the pad string. String, Get MD5-Hash Calculates the MD5 digest. The MD5 hash algorithm is applied against the source data to generate a unique 128-bit hash value: sequence of 32 hexadecimal digits. This checksum algorithm is a commonly used function for validating data integrity. 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. Single Value from a JSON object using JSONPath Extracts an arbitrary value from the JSON text stored in a String type Data Item and sets it to another String type Data Item or Numeric type Data Item. It can be used for e.g. extracting necessary data from JSON received by Webhook feature. JsonPath is used to specify the value. 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 MoneyForward Journal, Create Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records. Fiscal Month-Day String, Create Creates a date ID for fiscal year sorting. The first day of the first month of the fiscal year will be “101”. The 25th day of the last month is “1225”. If the fiscal year starts in Jan, the string will be the same as the calendar format “Mdd”. My-Number String, Test Check Digit Determines whether a My-Number string is valid. If valid, OK is logged. If invalid, the processing is abended to control with Error Boundary Event. My-Number is a 12-digit ID issued to all citizens and residents of Japan, including foreigners. Corporate-Number String, Test Check Digit Determines whether a Corporate-Number string is valid. If valid, OK is logged. If invalid, the processing is abended to control with Error Boundary Event. The numbers are 13-digit IDs assigned to companies and other organizations registered in Japan. 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.
	Compare Two Datetimes, Calculate Duration Calculates the duration between datetime A and B to output as numerical value (days), numerical value (hours), numerical value (minutes), or string value (h:mm). If B is the past time, a minus sign will be added. Date type also available. Diff (Table and Table) Confirm difference information of two table type data items line by line Two Tsv Strings, Compare Numeric Cells Compares numeric column strings in TSV-A and TSV-B, and lists the amount of change from A to B. If there is no string that matches the key column of A, it will not be listed. If there are multiple matches, it will be compared with the key above. Two Tsv Strings, Extract Cell-Matched Lines Extracts B lines that DO exist in A-Cell with comparing the specific column of TSV-A and the specific column of TSV-B. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned. Two Tsv Strings, Extract Cell-Mismatched Lines Extracts B lines that DO NOT exist in A-Cell with comparing the specific column of TSV-A and the specific column of TSV-B. If A and B match exactly, an empty string is returned. If they are completely different, all lines in B are returned.
	Delete any data-type, Delete Deletes data of any data type. By overwriting with a null value, all input values in the data item will be deleted.
	Act+Misc 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 Open Chat, Post Posts to Open Chat (Enterprise Social in Questetra BPMS) with PID like “#p123” from the workflow engine standpoint. Posts will only be displayed on the participant timelines. Note that any BPMS user can search in their timeline, unlike Workflow Data. Master Table, Update Creates a new master file (OptionsXML) by referring to the master table on Workflow Platform. A new ID-Label will be added to the first line. Rows with the same ID are deleted. For automation, place [Service Task (Choices Update)] downstream. Master Table, Backup Backups the master information shared in the Workflow Platform with saving as an Options-XML file. If the specified master name does not exist, an error will occur. To save as a different name, specify the backup file name. Master Table, List All Options as TSV String Includes the master table on Workflow Platform as a string property of the process. The IDs and Labels are concatenated into TSV (Tab-Separated Values) and stored into Multiline-String type. Master Table, Create by TSV String Creates a new master file (OptionsXML) by referring to TSV String. The specified column data are set as Master IDs, and the others are set as Master Labels. For automation, place [Service Task (Choices Update)] downstream. Master Table, Update to Delete Options Deletes unnecessary Options and Creates a new master file (OptionsXML) by referring to the master table on Workflow Platform. No error occurs even if the deletion ID does not exist. For automation, place [Service Task (Choices Update)] downstream.