Add-on Auto-Steps

 

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 *You can see the relevant auto-processing Tasks here Google Drive: File, Copy Creates a copy of a file in Google Drive. It supports saving as an arbitrary name. Note that the name of the file is not necessarily unique within a folder Google Drive: File, Convert Converts any file in Google Drive to another MimeType file and save as a new one. Supports not only Google files but also common files. Converting image files (JPEG, PNG, GIF, PDF) to “Google Docs” will perform OCR text extraction Google Drive: File, Download Imports any file in Google Drive as Workflow data. It is also possible to change the file name when importing the file. If a Google file (Docs/Sheets/Slides, etc.) is specified, an error will occur (use GFile Export addon instead) Google Drive: GFile, Export as PDF Stores Google file as Workflow data with converting to a PDF file. It is also possible to change the file name. If a file other than a Google file (Docs/Sheets/Slides, etc.) is specified, an error will occur Google Drive: GFile, Export as MS-Office Stores Google file as Workflow data with converting to an MS-Office file. It is also possible to change the file name. If a file other than a Google file (Docs/Sheets/Slides, etc.) is specified, an error will occur Google Drive: GFile, Export as Text Stores Google file as Workflow data with converting to a Text file. It is also possible to change the file name. If a file other than a Google file (Docs/Slides) is specified, an error will occur Google Drive: File Permissions, Add AnyoneWithLink Creates AnyoneWithLink permission (a Reader permission to anyone who has the link) to the file. Viewers who are notified of the link do not need to sign in to their Google account Google Drive: File Permissions, Remove AnyoneWithLink Deletes AnyoneWithLink permission (a Reader permission to anyone who has the link) from the file. There is no change in the other permissions for the file Google Drive: File Permissions, Add Reader Creates a Reader permission. A Google account email address is required. It is also possible to retain the Permission ID Google Drive: File Permissions, Remove Reader Deletes a Reader permission. The permissionId is required Google Drive: Create Shared Link Creates Permissions in the specified files and/or folders on Google Drive. An error occurs when a specified file/folder is already shared
	Google Document Google Docs: Document, Replace All Replaces all instances of text matching the FindWhat string with the ReplaceWith string in a case-sensitive way. It is also possible to replace multiple replacement patterns at once. If you are using a template file, you will often need to duplicate and replace the file in the upstream step
	Google Sheets *You can see the relevant auto-processing Tasks here Google Sheets: Sheet, Append TSV Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier “d” as Datetime, and column ID with an identifier “n” as Numeric; eg “0,2d,5n” Google Sheets: Spreadsheets Value, Update Overwrites a cell of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formated, the value “12-24” will be converted to “12/24/2021”. Or, “’12-31” will be updated as the string “12-31”. Google Sheets: ValueRanges, Sum Sums the numeric data in a specified range. Cells that cannot be recognized as numbers are considered zero. It also supports simultaneous calculation of two ranges. For example, you can sum debits and credits at the same time Google Sheets: ValueRanges, Export as TSV Stores a specified rectangular range of data as a TSV String. Empty cells are regarded as an empty string. Exporting two ranges at the same time is also supported. For example, the heading line and the 10th and subsequent lines can be exported at the same time Google Sheets: Two ValueRanges, Xlookup Reference Converts stringB to stringC, referring to the two areas. Searches lookup_string in range B, and if an exact match, returns the corresponding string in range C. If no match, an empty string is returned. The search is executed in order from the top Google Sheets: Spreadsheets, Add Sheet Adds a new sheet to the end of the spreadsheet. If the specified sheet name already exists, this Automated Task will end with an error. If needed, SheetId can also be specified Google Sheets: Sheet Row, Update with Singleline TSV Updates a Google Sheet with a single line of TSV data. Searches for an A-Column cell that exactly matches the first value of the TSV and overwrite only the first occurrence. The values will be parsed as if they were entered manually by the user. If no matching line exists, it will be appended at the end Google Sheets: Find Row Number By Specified Value Finds the row number that contains a specified value in the target column of a Google Sheet Google Sheets: Row Range, Delete Deletes rows in the specified range. Existing cells will be shifted upward. Both the start and end rows are specified by zero-based index. For example, “startIndex: 0, endIndex: 1” means only the first line. (End index is exclusive)
	Google Slides Google Slides: Page, Duplicate Duplicates the specified slide page and inserts it on the next page. If no page is specified, the last page will be duplicated. It is used when you want to start by duplicating a template page, such as creating a header image or a summary report Google Slides: Page, Replace Strings Replaces all instances of text matching the Search string with the Replace string. The search is case sensitive. For example, you can model a Workflow that automatically replaces the title in the template page Google Slides: Page, Refresh Charts Refreshes all embedded Google Sheets charts in the specified slide by replacing them with the latest version of the chart from Google Sheets. For example, you can build a system to automatically update the “sales summary” aggregated in Google Sheets Google Slides: Page, Export as PNG Stores a PNG image file as Workflow data with converting the specified slide. Or gets the download URL to the PNG image which has a lifetime of 30 minutes. For example, it is used in the business process of the Sales Report by email with PNG image Google Slides: Get Slide Page ID Stores page object IDs of the specified slide.
	Google Groups Google Groups: Members, List Retrieves a list of all members' email addresses (2000 addresses at a maximum) in a Google Groupe. It is also possible to narrow down to email addresses of the members with the OWNER role or MANAGER role as well as those of GROUP email Google Groups: Members, Insert Adds an email address to the specified group which is created in Google Groups. Adding the email address to multiple groups at once is also possible. You can automate the operations for a personnel change Google Groups: Members, Delete Removes an email address from the specified group which is created in Google Groups. Removing the email address from multiple groups at once is also possible. You can automate the operations for a personnel change
	Google Calendar *You can see the relevant auto-processing Tasks here Google Calendar Get events list(schedules) Accesses to Google Calendar and retrieves a list of events (schedules) registered in the specified period. Combining this Task with Workflows will make it possible to get the next week’s schedule, and notify (announce) it by email
	Google Chat Google Chat: Space, Create Message Posts a message in a Google Chat Space. Bold decoration (with asterisks) and Inline-code decoration (with backticks) are also applied as they are. It is also possible to attach some Process Data in card format
	Google Analytics Google Analytics Reports (Referrer ranking) Creates Ranking report about Referrer. Aggregating it with a specified duration and filter criteria is also possible Google Analytics: Reports, Pageviews by Hostname-PagePath Reports the page popularity in the specified period in ranking format. It is also possible to check the details of the number of page views, the number of sessions and initiations can also be viewed in TSV format. filtersExpression is also available Google Analytics: GA4 Report, PageViews by Hostname-PagePath Reports the page popularity in the specified period in ranking format. The number of screen page views, sessions, engaged sessions and active users for each page are aggregated in TSV format. Dimension Filter “inListFilter” is also available Google Analytics: GA4 Report, Create Custom Create a TSV report for any Metric from Google Analytics 4 property. One Dimension and one Metric can be specified arbitrarily. Extraction filter is also available. (exact match of the Dimension value) Google Analytics: GA4 Realtime Report, Create Custom Creates a TSV report for any Metric from events in the last 30 mins (Google Analytics 4 property). One Realtime Dimension and one Realtime Metric can be specified arbitrarily. Extraction filter is also available. (exact match of the Dimension value)
	Google Fit Google Fit: FitnessData, Get Steps Gets the step count data in Google Fit. Gets the aggregated value for any period. It is also possible to acquire travel distance data (meters). For example, the number of steps taken during working hours for care workers and delivery staff is acquired
	Google Translate Google Translate: Translation API Basic, Translate Translates using Google Translation API v2. Specifying the target language is mandatory, but specifying the source language is optional (Detected). The NMT (Neural Machine Translation) model is applied in most languages, while the PBMT (Phrase-Based Machine Translation) model is done in some languages
	Google BigQuery *You can see the relevant auto-processing Tasks here
	DeepL DeepL: Text, Translate Translates using DeepL API v2. Specifying the target language is mandatory, but specifying the source language is optional (Detected). It is also possible to translate into more formal or broken sentences (Formality)
	Salesforce Salesforce: Accounts BatchGet 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 *You can see the relevant auto-processing Tasks here
	Microsoft 365 Outlook Microsoft 365 Outlook: Calendar Event Insert Insert an event in the Outlook Calendar. A maximum of three participants can be specified
	Microsoft 365 Excel Microsoft 365 Excel: Update Cell Updates cell data at the specified position in an Excel sheet Microsoft 365 Excel: Get Cell Value Gets cell data at the specified position in an Excel sheet as String-type Data Microsoft 365 Excel: Find Row Number By Specified Value Searches the Excel sheet for the specified value and obtains the row number Microsoft 365 Excel: Append New Row Adds a row to the end of an Excel sheet and enters data in each of its cells. The input range can be up to 10 columns Microsoft 365 Excel: Delete Row Deletes data in specified rows of an Excel sheet. You can specify a range of columns to be deleted Microsoft 365 Excel: Get Row Obtains data from the specified row of an Excel sheet as String-type data. The acquisition range can be specified up to 10 columns Microsoft 365 Excel: Update Row Updates Rows of an Excel sheet. The update range can be specified up to 10 columns
	Microsoft Teams Microsoft Teams Post Message Posts a message specifying its title and text body to Microsoft Teams
	kintone *You can see the relevant auto-processing Tasks here kintone: Find Record ID By Specified Value Identifies the record number that contains the specified value from the target column in a kintone app
	AirTable AirTable: Add New Record Adds a new record to the AirTable Base
	SendGrid SendGrid: Recipient, Add or Update Adds a destination to the SendGrid contact. If a destination with the same email address has already been registered, the value of the reserved and custom fields will be updated SendGrid: Group Unsubscribes, Add Emails Adds Email addresses to the SendGrid Group Unsubscribe list SendGrid: Global Unsubscribes, Add Emails Adds Email addresses to the SendGrid Global Unsubscribe list SendGrid: Campaign, Send Sends an email according to you Campaign settings in SendGrid
	Slack *You can see the relevant auto-processing Tasks here Slack: Chat, Post Block Posts a message in block format. A table data can be attached as needed. It is also possible to change to an ephemeral message that is displayed only to a specific user Slack: Get Slack Id By Questetra Account User Retrieves the ID from the Slack user profile. The user profile is identified using the Questetra account email address as the key. You can post a message with mentions using your ID.
	Hangouts Chat Hangouts Chat Post Message Post a message which is specified in “text” to Hangouts Chat
	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
	Backlog Backlog Add Issue Adds an Issue based on its Project ID, Summary, Type ID, etc., and stores the communication log in a respective Data Item
	PayPal PayPal: Invoice, Create Draft Creates a draft invoice on the payment platform PayPal. To move the invoice from a draft to payable state, the SEND action is required. Billing automation and paperless operations are realized PayPal: Invoice, Send Sends an Invoice on the payment platform PayPal. Both Recipient (customer) and Invoicer will receive an email notification. The invoice status updates to SENT from DRAFT, and anyone who knows the Invoice URL will be able to pay PayPal: Invoice, Check Detail Checks the status of Invoice on the payment platform PayPal. If in PAID status, payment date is retrievable
	Stripe Stripe: Customer, Create Creates a Customer object on the payment platform Stripe. Customer objects allow you to perform recurring charges. Note that it is necessary to implement tokenization mechanism that directly interacts with the customer browser and Stripe in advance Stripe: Customer, Charge Creates the Charge object on the payment platform Stripe. If the primary payment method (Customer object) fails, the backup payment method will be charged. If all method fails, no Charge object will be created and an Abended Error log will be output Stripe: Customer, Destination Charge Creates the Charge object with Transfer Amount to charge the Customer ID for any amount in any currency. Any Connected Account are available. If the primary payment method (Customer object) fails, the backup payment method will be charged. If all method fails, no Charge object will be created and an Abended Error log will be output. Stripe: Payouts, Extract as TSV Lists all Payouts on the payment platform Stripe. Payouts can be filtered by status and arrival date. Stripe: Balance Transactions, Extract as TSV by Payout ID List all Balance Transactions on the payment platform Stripe. They can be filtered with Payout ID.
	WordPress.Com WordPress.com: Posts, Create Draft Creates a draft of the article on WordPress.com. Not only post type articles but also page type articles can be generated. It automates WordPress and saves time on post-publication tasks. Wordpress.com: Media, Upload Uploads new pieces of media. Even if multiple files are attached to the workflow data, uploads them all. It is possible to upload not only image files such as PNG and GIF, but also PDF and DOCX files Wordpress.com: Media, List Lists the URLs of the content in the media library. Up to 100 items are listed in order of new arrival. It is possible to narrow down by the uploaded datetime. For example, it is used for monitoring public files that can be viewed from the Internet WordPress.com: Stats, Get Views Gets the number of the specified article has been viewed. Gets the “subtotal” for the specified period and the “total” for the entire period from Jetpack. It is also possible to obtain the daily values for the specified period in TSV format
	Image-Charts Image-Charts: QR Code, Create Creates a QR Code using the Image-Chart QRCode web service generation. It is possible to encode any string data to the QR code. The QR Code image will be output in png format Image-Charts: Bar Chart, Create Creates a Bar/Line Chart from numeric TSV (population by country, monthly sales) using Image-Chart. The Y-axis tick marks are automatically generated. The X-axis tick marks are refered to the first line of the TSV. The image is output in PNG format
	Zendesk Support Zendesk Ticket Update Update a specified Zendesk ticket
	Corporate Number Corp Num Web-API: Organizations, Search Name with ID Searches the corporate name, furigana, address, history, etc, with the 13-digit identifier, accessing to the Corporate Number System Web-API, about 5 million companies registered by National Tax Agency Japan. “Application ID” is required in advance Corp Num Web-API: Organizations, Search ID with Name Searches the 13-digit identifier with the corporate name, etc., accessing to the Corporate Number System Web-API, about 5 million companies registered by National Tax Agency Japan. “Application ID” is required in advance
	OpenWeather OpenWeather: Weather History, Get by Time Gets weather history for the specific time from OpenWeather (corrected to zero minutes) with the specified latitude and longitude. Temperature, humidity and wind speed can be obtained as well as snow volume and wind gust OpenWeather: Weather Forecast, Get by Time Gets weather forecast for the specific time (corrected to zero minutes) from OpenWeather with specifying latitude and longitude of the world. Not only temperature, humidity and wind speed, but also visibility and sensible temperature can be obtained OpenWeather: Weather Forecast, Get by Date Gets weather forecast for the specific date from OpenWeather with specifying latitude and longitude of the world. Not only temperature, humidity and wind speed, but also sunset time and dew point temperature can be obtained
	NHK Program NHK Program Guide: Programs, Search Searches the program guide of the specified area channel and date. You can filter by keywords, program genre or time range. The keyword search is applied to the string that combines the program title, subtitle, content, and performers
	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] Questetra Get Membership Mail Address Belong To Org Gets the email address of members that belong to a specified Organisation in Questetra Questetra BPMS: User, Check Belonging to 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 multiline TSV string from local or remote workflow platform via API. Field-Items are specified in CSV format such as “string:0,date:2,select:3”. Range is specified by date: Start Date, End Date, or any date type. Questetra BPMS: Process, Batch Extract by Filter as TSV Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance 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 in Questetra BPM Suite. A line break is added between each data which 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  *You can see the relevant auto-processing Tasks here Google Chat: Space, Create Message Posts a message in a Google Chat Space. Bold decoration (with asterisks) and Inline-code decoration (with backticks) are also applied as they are. It is also possible to attach some Process Data in card format

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 *You can see the relevant auto-processing Tasks here 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 Email-HTML String, Create SimpleNotice Assembles HTML text for email from workflow data. The html text will consist of blocks of abstract, image, main sentence, link button, and sub-sentence. If the setting is blank, the block will not be displayed Email-HTML String, Create ImageList Assembles HTML text for email that can list multiple images. Sets image URLs in the img tag and arranges them. It is used in cases where you want to share images published on a web server or when you want to strengthen the check system Email-HTML String, Create TsvTable Assembles HTML code for HTML-email that can confirm TSV string. Inserts TableRow (TR) and TableData (TD) depending on the number of items in the TSV string. It is used when you want to automatically notify the TSV data stored in the workflow by mail Email-HTML String, Create DataitemList Generates HTML code (for HTML mail) that lists stored data. Assembles the specified Data Items in the workflow in the specified order. You can share your data with any party by using the [Throwing Message Intermediate Event]
	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 *You can see the relevant auto-processing Tasks here Converter: Datetimes in different time zones Converts the datetime in time zone A to the datetime in time zone B. Any time zone can be set for either datetimes. If nothing is set the Workflow Platform time zone will be applied. Converter: Workflow Datetime to ISO-Datetime-String Converts Datetime type data (“2021-12-31 20:34” JST) to ISO 8601 datetime string data (“2021-12-31T20:34:00+09:00” or “2021-12-31T11:34:00Z”). As a general rule, Datetime type data is regarded as the time of Workflow Platform timezone. Converter: ISO-Datetime-String to Workflow Datetime Converts ISO 8601 datetime string data (“2021-12-31T20:34:56+09:00”, “2021-12-31T11:34:56.789Z”, etc.) to Datetime type data (“2021-12-31 20:34”). Datetime type data is based on the time zone configured for your Workflow Platform. Converter: Timestamp-Number to Datetime Converts a timestamp number (UNIX time) to datetime data. That is, the number of seconds elapsed since UTC 1970-01-01 00:00:00 is assigned to the datetime type data according to the workflow platform time zone. (10-digit integer after 2002) Converter: Table to TSV-String Converts Table-type data to a TSV String. The string value of all cells in the Table-type Data Item is copied over TSV string B. Cells with no input are regarded as empty strings Converter: TSV-String to Table Converts a TSV String to Table-type data. The string values of all cells in the TSV string are copied over to Table-type data B. If there is an inconsistency in the Table column design, an error may occur Converter: CSV-String to TSV-String Converts a CSV string to a TSV string. The TSV is output as the simplest tab-delimited string. If the field contains line breaks or tabs, they will be replaced with spaces. If the double-quotes in the input CSV are not escaped there may be unintended consequences. Converter: Multiline-String to Singleline-CSV-String Converts a multiline string to a CSV string. Converts each row of a multiline string as the value of each cell in the CSV. If commas are included they will be deleted in advance. Lines with only line feed code are recognized as empty data 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. Multiline strings are 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” Converter: JigyosyoZipCsv to JigyosyoZipXml Generates a postal code master. The business zip “JIGYOSYO.CSV” (20k lines) by Japan Post Co., Ltd. is converted to “Jigyosyo-Zip.xml”. If “Japan-Zip.xml” (120k lines) is specified, “Jigyosyo-Zip.xml” (140k lines) will be created TSV String, Convert Changes column order of TSV text. The new order is specified by enumerating the column IDs of the original TSV, like “0,1,3,0”. The new TSV text can also be stored in formats such as TSV file format and CSV file format 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” TSV String, Switch Rows and Columns Switches the row and column indices of the rectangle TSV. The output matrix (Transposed Matrix) is obtained by changing cell(x,y) to (y,x). Used for data arrangement for frequency distribution tables and histograms Text Files, Convert Character Encoding Converts text files charset (Coded Character Set). For example, converts UTF-8 encoding to Shift_JIS or UTF-16. If multiple files are attached, all will be converted according to the same rules 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 UrlEncoded String, Decode UriComponent Decodes URL-encoded string that is an encoded component of a Uniform Resource Identifier. “5%25off%3F” will be decoded to “5%off?” and “%E3%81%82%20%E3%81%84” will be decoded to “あ い” Date, Get Day of Week String Gets the string for the day of the week. The notation of the day is set in the config such as “Sun,Mon,Tue,Wed,Thu,Fri,Sat” or “Closed,Open,Open,Open,Open,Open,Closed”. The beginning is Sunday Date, Get Weekend Sunday Gets weekend Sundays of any date. If Sunday is specified, that day itself will be returned. If you want to get “Monday of the next week” or “Tuesday of the current week”, you need to convert like #q_date.addDays(1) or #q_date.addDays(-5) Date, Determine Whether Business Day Determines whether the date value is Business Day or not. If a holiday, returns the name of the holiday. If Sat or Sun, returns the day name. Otherwise, returns an empty string. You can also set special holidays set by your company Date, Calc after N Business Days Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary to set a holiday in advance. It is also possible to add company-original holidays
	Filter Multiline String, Filter by Text Filters a 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” Multiline String, Search by Text Searches a multiple-line string with any search text. Only lines that exactly matches the search text are output 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. To OR multiple ranges, use a comma separated format like "2021-01-01&lt;2021-01-07,2021-01-21&lt;2021-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 you want to OR multiple ranges, use comma-separated values like "2021-01-01 00:00&lt;2021-01-07 23:59,2021-01-21 00:00&lt;2021-01-27 23:59" TSV String, Verify Rectangle Verifies that the cells are in a matrix format. If the number of cell values are different for each row, tabs will be added. It is also possible to get the number of rows and columns after formatting. No trailing newline will be added to the verified TSV. Multiline String, Delete Empty Lines Removes all blank rows. Line breaks at the end of the text (including TSV and CSV) are also removed. If there is even one single-byte space on the line, it will not be deleted Multiline String, Get Range Lines Extracts the specified range of rows. The range is specified by Begin Index and End Index. The index is zero-based and the index on the first row is zero. Note that the row specified by the End Index is not included in the range
	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, Batch Add Thousands Separators Detects numbers with more than three digits in the text and adds thousand separators to each number. A comma, dot, or space can be specified as the digit separator. Note that this replacement will also be applied to decimals, postal codes and years 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 Concatenates all data in the specified column with the prefix string to generate a new TSV string. The concatenated strings are added at the end of the line. Removes whitespace from both ends of a string TSV String; Add Suffix to Column Concatenates all data in the specified column with the suffix string to generate a new TSV string. 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 string by adding N to each number in the number column. Calculation results are added at the end of the line. This can be used for creating discounted price lists, etc. Removes whitespace from both ends of a string TSV String; Multiply N by Number Column Generates a new TSV string by multiplying N by each number in the number column. Calculation results are rounded off and added at the end of the line. This can be used for tax calculations, etc. Removes whitespace from both ends of a TSV string TSV String, Calc Changes in Two Numeric Columns Calculates the difference and rate of change for two numeric columns in a TSV. Adds the calculated value to the rightmost column. It realizes month-on-month and year-on-year automation Select-type Data Item, Auto Assignment(el-enabled) The selection result is set to a Select-type Data Item by an arbitrary string. EL expressions can also be used for strings.
	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 (x32 characters in hexadecimal notation). This checksum algorithm is a commonly used function for validating data integrity TSV String, Create Cross Table for Numeric Column Aggregates the values in a numeric column with 2 aggregation-key columns (pivot table). Sum, Percentage, Count and Average are tabulated as a cross table TSV. E.g. “Sales for each combination of Client-Y and Store-X” is aggregated from “Sales log TSV” TSV String, Create Summary Table for Numeric Column Aggregates the values in a numeric column by aggregation-keys. Sum, Percentage, Count and Average are tabulated as a summary table TSV. For example, “Sales for each client” is aggregated from “Sales log TSV”. Grand Total Tabulation TSV String, Create Summary Table of Count Aggregates the count of data by aggregation-keys. Count and Percentage are tabulated as a summary table TSV. Eg, Survey Results TSV is automatically generated from Survey Records TSV. Frequency distribution TSV String, Create Cross Table of Count Aggregates the count of data by 2 aggregation-key columns: Pivot table. Count and Percentage are tabulated as a cross table TSV. Eg, Survey Results TSV is automatically generated from Survey Records TSV. 2D frequency distribution TSV String, Sum Numeric Column Sums the values in the numeric column of a TSV. If the numeric field contains commas, they will be removed and then parsed. If you need to add up the values for each key, use Summary tabulation or Cross tabulation JSON String, Extract Value using JSON-Path Extracts value from JSON using JSON Path. It is used when extracting necessary data from JSON received by the Incoming Webhook function. It is also possible to set the path to get multiple values 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 URL String, Extract Parts Parses the URL/URI string to extract each components such as Protocol (Scheme), Host, Hostname, Path, Query, Fragment, etc. For components that require URL decoding, decodeURIComponent processing is required separately in the downstream process MoneyForward Journal, Create Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only batch sales invoices but also invoices that are prorated for each month Fiscal Month-Day String, Create Creates a date ID for sorting within a fiscal year. 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" Singleline TSV String, Extract Cell Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data Singleline String, Set One Line from Multiline using Round-Robin Extracts one line from the multi-line string in order using a round robin method and sets that line in single-line string data. For example, it can be used to test sales copy or to set the response text for lottery results. It is also possible to exclude specific rows from the selection candidates Singleline String, Set One Line from Multiline Randomly Extracts one line randomly from the multi-line string and sets that line in singleline string data. For example, it can be used to test sales copy or to set the response text for lottery results. It is also possible to exclude specific rows from the selection candidates Singleline String, Set Nth Line of Multiline Extracts one line of a multi-line string and sets that line in single-line String-type Data Item. The Line ID mut be an integer starting with zero. If the Line ID is not specified, or if a number outside the range is specified, the last line will be extracted Multiline String, Dequeue First Removes the first line from the multiline string. One line less than the original string. By placing in a loop flow or in a recursive workflow, data list can be processed sequentially Quser, Set One User of Qorg using Round-Robin Extracts one user from the members of Qorg in order using a round robin method and sets that user in the Quser data. It is also possible to exclude specific users from the extraction target. If there are no candidates in the population, an error will occur Quser, Set One User of Qorg Randomly Extracts one user from the members of Qorg randomly and sets that user in Quser data. It is also possible to exclude specific users from the extraction target. If no candidates in the population, an error will occur Questetra-Addon-XML file, 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) Questetra-Model-XML file, Extract Definitions Extracts the step names and the data item names (variable names) of the Workflow App. The Model-XML file is parsed to extract information such as whether it is a human task or an automated task, what the type of data item is, and so on
	Compare Two Datetimes, Calculate Duration Calculates the duration between datetimes A and B to be output numerically as days, hours, minutes, or as a string value (h:mm). If B is in the past a minus sign will be added. Date-type data is also available Diff (Table and Table) Checks the difference between information in 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 Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that have a matching cell in A. 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 Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that do not have a cell match for A. If A and B match exactly, an empty string is returned. If they are completely different, all lines in B are returned Two TSV Strings, Join on Common Column Merges two TSVs based on a common key-field. Keeps all the rows from TsvA (left table) and brings in any matching rows from TsvB (right table); Left Outer Join. Neither TSV needs to be sorted. Only the upper row in TsvB will be matched
	Delete any data-type, Output to Log Outputs business data to “Auto-Processing Log”. Administrators of the Workflow Application can verify the data that was stored when the process reached this step
	Act+Misc Open Chat, Post Posts the text to OpenChat in the Workflow Platform. Since the ProcessID hashtag (topic) like “#p123” is automatically added, it will be displayed on the timeline of the process participants. Note that all users can browse with searching. 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 Backs up the master information shared in the Workflow Platform by saving as it 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, Get Options Data Gets master data by referring to the master table on Workflow Platform 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 the TSV String. The specified column data are set as Master IDs, and the other data is set as Master Labels. By placing a [Service Task (Choices Update)] in the downstream process, the update task can be automated. 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 My-Number String, Test Check Digit Determines whether a My-Number string is valid. If valid, "OK" is recorded in the log. If invalid, the processing is terminated. It is possible to control the flow with an 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, processing is terminated which can be controlled with an Error Boundary Event. The numbers are 13-digit IDs assigned to companies and other organizations registered in Japan