-
●
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”). The 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)
-
●
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.
-
●
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.
-
●
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.
-
●
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”.
-
●
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.
-
●
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.
-
●
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, 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, 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.
-
●
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 formatted, the value “12-24” will be converted to “12/24/2021”. Or, “’12-31” will be updated as the string…
-
●
Questetra Org Membership Add
Adds a member to a Questetra “Organization” and stores the communication log in a String-type Data Item
-
●
Questetra Org Membership Delete
Deletes a member from Questetra’s “Organization” and stores the communication log in a String type Data Item
-
●
Questetra Role Membership Delete
Deletes a member from Questetra’s “Role” and stores the communication log in a String type Data Item
-
●
Questetra Role Membership Add
Adds a member to a Questetra “Role” and stores the communication log in a String-type Data Item
-
●
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.
-
●
Open Chat, Post
Posts to Open Chat (Enterprise Social in Questetra BPMS) with PID like “#p123” from the workflow engine standpoint. Posts will only be displayed on the participant timelines. Note that any BPMS user can search in their timeline, unlike Workflow Data.
-
●
Google Sheets: Values, Export as TSV
Exports the values in the rectangular range as TSV text, which has the same number of tab delimiters on each line. Empty cells are regarded as the null string. Two range export are also supported: e.g. Freezed headings and recent data.
-
●
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.
Add-ons
-
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”). The Datetime type data is based on the time zone configured for your…
-
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…
-
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…
-
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…
-
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,…
-
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…
-
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…
-
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.
-
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.
-
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…
-
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…
-
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…
-
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 formatted, the value…
-
Questetra Org Membership Add
Adds a member to a Questetra “Organization” and stores the communication log in a String-type Data Item
-
Questetra Org Membership Delete
Deletes a member from Questetra’s “Organization” and stores the communication log in a String type Data Item
-
Questetra Role Membership Delete
Deletes a member from Questetra’s “Role” and stores the communication log in a String type Data Item
-
Questetra Role Membership Add
Adds a member to a Questetra “Role” and stores the communication log in a String-type Data Item
-
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…
-
Open Chat, Post
Posts to Open Chat (Enterprise Social in Questetra BPMS) with PID like “#p123” from the workflow engine standpoint. Posts will only be displayed on the participant timelines. Note…
-
Google Sheets: Values, Export as TSV
Exports the values in the rectangular range as TSV text, which has the same number of tab delimiters on each line. Empty cells are regarded as the null…
-
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,…