Add-on Auto-Steps

Avatar
Hirotaka NISHI
  • Updated
Follow
 

qmascot-dummy-automatic-task.png

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
Addons except for "Service Task Definition"
  • Options Definition is here
  • Base PDF is here

 

qmascot-api-access-automation.png

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

GoogleDrive-128.png

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
GoogleDocuments-440.png

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
GoogleSheets-128.png

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)
GoogleSlides-440.png

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.
GoogleGroups-128.png

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
GoogleCalender-128.png

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
gmail-thumb.png

Gmail

*You can see the relevant auto-processing Tasks here
GoogleChat.png

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
GoogleAnalytics-128.png

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)
GoogleFit.png

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
______.png

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
GoogleBigQuery.png

Google BigQuery

*You can see the relevant auto-processing Tasks here
________1_.png

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-128.png

Salesforce
Box-128.png

Box

*You can see the relevant auto-processing Tasks here
microsoft365-thumb.png

Microsoft 365
ms-365-outlook-thumb.png

Microsoft 365 Outlook
ms-excel-128.png

Microsoft 365 Excel

*You can see the relevant auto-processing Tasks here

 
MicrosoftTeams-128.png

Microsoft Teams

 
onedrive-thumb.png

Microsoft OneDrive

*You can see the relevant auto-processing Tasks here
kintone-128.png

kintone

*You can see the relevant auto-processing Tasks here
airtable-128.png

AirTable
sendgrid-icon.png

SendGrid
Slack.png

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.
LINE.png

LINE

  • Post Message through LINE Notify
    Posts a message to a LINE group through LINE Notify. Please obtain a personal access token in advance. The recipient of the message will be selected at the time of acquiring the token, either the user acquiring the token themself or a group in which that person participates
HangoutsChat-128.png

Hangouts Chat
ChatWork-128.png

ChatWork
Typetalk-128.png

Typetalk
Backlog-128.png

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-128.png

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-128.png

Stripe

*You can see the relevant auto-processing Tasks here

  • 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.
climbercloud.png

ClimberCloud

（ClimberCloud® is a registered trademark of NTT Data Business Brains Corporation.）
WordPressCom-128.png

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
openai-thumb1.png

OpenAI

  • OpenAI: Chat, Start
    Starts a conversation with the OpenAI API (ChatGPT). The MODEL used is “gpt-4” by default (configurable). A response (COMPLETION) to an instruction question (PROMPT) is automatically obtained
  • OpenAI: Chat, Interact with Parameters
    Communicates with OpenAI API (ChatGPT); the default MODEL is “gpt-4” (configurable). Supports almost all Chat features, such as re-asking based on histories and/or parameters; sampling temperature-Top_P, Presence-Frequency penalty, Logit bias
  • OpenAI: Audio, Transcribe
    Transcribes from audio file. The “whisper-1” model in the OpenAI API converts speech data into text data. If set abbreviations and technical terms as summary (PROMPT), more accurate data conversion will be achieved
  • OpenAI: Audio, Translate into English
    Translates audio into English. English text data is generated from sound or video file containing Japanese or other, using the OpenAI API “whisper-1” model. Abbreviations and technical terms can be set as PRMOPT to achieve more accurate translation
  • OpenAI: Audio, Transcribe to WebVTT
    Transcribes audio and video files in caption format WebVTT, using the OpenAI API “whisper-1” model by default (configurable) to convert audio data into text data. Set abbreviations and technical terms as PROMPT for more accurate transcription
  • OpenAI: Images, Generate
    Creates an image given a prompt. By default a 1024×1024 image is generated, but you can change it to 256×256 or 512×512. Note that PROMPT must be defined within 1000 characters
  • OpenAI: Images, Create Variation
    Creates a variation of a given image. By default a 1024×1024 image is created. 256×256 or 512×512 are also creatable. The given image must be a square image less than 4MB. The maximum number that can be created at once is 10
  • OpenAI: Images, Edit Specific Area
    Completes the transparent areas of an original image with a PROMPT, by default 1024×1024. The areas to be edited can also be specified in another file. The given image must be square less than 4MB. The maximum number created at once is 10
Image-Charts-128.png

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-128.png

Zendesk Support
national-tax-agency-en.png

National Tax Agency

  • 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
  • Qualified Invoice Issuer Web-API: Search Name with ID
    Searches the Qualified Invoice Issuer’s name, address, history, etc, with the registrated number, accessing to the Qualified Invoice Issuer System Web-API by National Tax Agency Japan. “Application ID” is required in advance
________1_.png

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
________2_.png

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-128.png

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: User, Check Belonging to Role
    If the specified user belong to the specified role, this task returns role name. 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
________3_.png

Misc 

*You can see the relevant auto-processing Tasks here

  • Google reCAPTCHA: Token, Verify
    Verifies the reCAPTCHA token (reCAPTCHA user response token). Validation boolean (true: human) and/or validation score (1.0: human) are output. The token is valid for two minutes, and can only be verified once.

 

qmascot-data-editing-automation.png

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_en-128.png

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]
__.png

Duplicate

  • Files, Duplicate
    Duplicates File-type data. All files stored in Data Item A1 (Original Files) will be copied over to Data Item B1 (Clone Files). Also possible to change the file name or Content-Type. If the same Data Item is specified as A1 and B1, overwritten
  • Files Duplicate From Multi Items
    Duplicates Files-type datas to Other Files-type data. All files stored in Files-type datas 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_en-128.png

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: Date-or-Datetime-String to Workflow Datetime
    Converts strings such as “2022-12-31” or “2022-12-31 00:00” to Datetime (or Date) data. Also supports strings like “2022/12/31” and “19700101”. Any string is evaluated as local time. The timestamp value (seconds since 1 Jan 1970) is also gettable
  • 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 (File to Base64 String)
    Converts file type data to Base 64 encoded string type data. If there are multiple files in File-type data, or if the file size exceeds 10 MB the data will not be converted
  • Converter: Email-String to Quser
    Converts an Email string to USER data. If the address is not registered as a user address, an error will occur (USER not updated). If multiple addresses are enumerated in a multiline or comma-delimited string, determined sequentially from the top
  • 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, 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
  • TSV String, Convert date data to yyyy-MM format
    Converts the date data in the specified column to yyyy-MM or yyyy format and appends the value to the end of all lines
  • 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 “あ い”
Filter_en-128.png

Filter

  • 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”
  • 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, Filter by Keyword
    Narrows multi-line text down to matching lines only. The match condition can be either “equals”, “contains”, “begins with”, or “ends with”. A case-insensitive filter can also be specified. It is also possible to separately store the excluded rows (filtered rows)
  • 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, Filter by Keywords
    Filters TSV text to column-matched lines only. The match condition can be either “equals”, “contains”, “begins with”, or “ends with”. A case-insensitive filter can also be specified. It is also possible to separately store the excluded rows (filtered rows)
  • TSV String, Filter by RegExp
    Narrows down to just the column-matched lines from the TSV text. A regular expression (RegExp) can be specified as the match condition. Evaluates whether the column matches the regular expression. Also stores the filtered-out lines (removed lines)
  • Multiline String, Filter by RegExp
    Narrows down to just the matched lines from the multiline text. A regular expression (RegExp) can be specified as the match condition. Each line is determined to match a regular expression. Also stores the filtered-out lines (removed lines)
addremove.png

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”
  • String, Batch Replace to UpperCase
    Replaces lowercase letters in the text with corresponding uppercase letters. An input of “ABC”, “Abc”, “abc” will all be output as “ABC”. It is used to store case-insensitive data such as MS-DOS file names or BASIC codes
  • String, Batch Replace to LowerCase
    Replaces uppercase letters in the text with corresponding lowercase letters. An input of “ABC”, “Abc”, “abc” will all be output as “abc”. It is used to store case-insensitive data such as Internet domain or search words
  • Multiline String, Remove Duplicate Lines
    Extracts and deletes all duplicate rows. In forward order mode, the first row is retained; in reverse order mode, the last row is retained. Note that “ABC” and “Abc” are recognized as different columns. (case sensitive)
  • 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
  • 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
  • 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
  • TSV String, Remove Column-Duplicate Lines
    Extracts and deletes rows with duplicate column elements. In forward mode it keeps the first row, in reverse mode it keeps the last row. Note that “ABC” and “Abc” are recognized as different columns. (case sensitive)
  • 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.
__.png

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 Values using Line-Begin Matching
    Matches the string at the beginning of the line and extracts the following string
  • 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
  • String List, Check for Existence of Search String
    Checks for the existence of string elements in the list that match the search string
  • 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
  • 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
  • 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 Auto Step (automated task). The Addon-XML file (for Questetra BPMS automatic task) is parsed and information such as summary, last-modified, config etc. are extracted
  • 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
  • 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
__.png

Compare

  • Two Datetimes, Calculate Duration
    Calculates the duration between Datetime-A and Datetime-B; like elapsed days (e.g. “1.38 d”), hours (e.g. “33.33 h”), minutes (e.g. “2000.00 min”) and/or time (e.g. “33:20”). A minus sign is given if Datetime-B is earlier than Datetime-A
  • Two Dates, Calculate Business Days
    Calculates the number of business days between date A and date B. Holidays must be set in advance. Company’s original holidays can be added. For example, this function can be used for calculating the number of business days for the month in advance and planning the work.
  • 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
Act.png

Act+Misc

  • 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
  • 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

 

Articles in this section

Comments

0 comments

Please sign in to leave a comment.

Related articles