String, Extract Values using Line-Begin Matching
Matches the string at the beginning of the line and extracts the following string.
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.
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.
Microsoft 365 Excel: Delete Row Range
Deletes data in specified rows of an Excel sheet. You can specify a range of columns to be deleted.
Microsoft 365 Excel: Update Row
Updates Rows of an Excel sheet. The update range can be specified up to 15 columns.
#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.
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 15 columns.
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: Find Row Number By Specified Value
Searches the Excel sheet for the specified value and obtains the row number.
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.
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 Analytics #GA4_Report: Create Custom
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).
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)
Stripe: Payouts, Extract as TSV
List all Payouts on the payment platform Stripe. Payouts can be filtered by status and arrival date.
Questetra Get Membership Mail Address Belong To Org
Gets the email address of members that belong to a specified Organisation in Questetra.
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.
Slack: Get Slack Id By Questetra Account User
Get a Slack ID. The ID is the information in your Slack user profile that matches your Questetra account email address.
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.
Microsoft 365 Excel: Get Cell Value
Gets cell data at the specified position in an Excel sheet.
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.
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.