String, Extract Values using Line-Begin Matching
Matches the string at the beginning of the line and extracts the following string.
Matches the string at the beginning of the line and extracts the following string.
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.
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.
Deletes data in specified rows of an Excel sheet. You can specify a range of columns to be deleted.
Updates Rows of an Excel sheet. The update range can be specified up to 15 columns.
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.
Obtains data from the specified row of an Excel sheet as String-type data. The acquisition range can be specified up to 15 columns.
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.
Searches the Excel sheet for the specified value and obtains the row number.
List all Balance Transactions on the payment platform Stripe. They can be filtered with Payout ID.
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).
Creates 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).
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)
List all Payouts on the payment platform Stripe. Payouts can be filtered by status and arrival date.
Gets the email address of members that belong to a specified Organisation in Questetra.
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.
Get a Slack ID. The ID is the information in your Slack user profile that matches your Questetra account email address.
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.
Gets cell data at the specified position in an Excel sheet.
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.
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.