Service Task Definition

Avatar
Jun YAMAMOTO
  • Updated
Follow

Once imported, modeling elements that are not built in as the standard will be added to the modeling palette and used.qmascot-dummy-automatic-task.png

Related Manual

Data Processing Involving Communication with the Outside of Workflow App

Processing such as adding appointments to Google Calendar, collecting business partners from Salesforce in bulk, and sharing information with other departments in Slack is automated on the server side.

  • Google Calender
    • Google Calendar Event List
      Accessing to Google Calendar and retrieves a list of events (schedules) registered during the specified time period. In combination with Workflow, it will be possible to get schedule of next week collectively, and notify (announce) them by email.
    • Google Calendar Schedule Append
      Adds the appointment specified by String type data item to the time period specified by DateTime type data item on Google Calendar, and stores its communication log in a String type data item
  • Google Drive
    • Creating Folder on Google Drive
      Creates a new folder by specifying a name under the specified folder in Google Drive
    • Google Drive Upload
      Uploads the file specified by File type data item to the specified directory of Google Drive, and stores its communication log in a String type data item
    • Google Drive Files Copy
      Copies a file on Google Drive and save it to the specified directory. Preparing a file to be a template and it will be a copy automatically at the Start of a new Issue.
    • Google Drive Files Retrieve
      Download Drive-File and Add to file-type data (FileID via Link URL at Shareing settings Advanced)
  • Google Sheets
  • LINE
    • Post message through LINE Notify
      Post message to your LINE Group through LINE Notify. In advance you have to get a personal access token. When get the one, choose where messages are sent.
  • Google Groups
    • Google Group members retriev
      Retrieves Google Group members (email address) list. By checking group members (ML members) on a regular basis, ML management becomes easier. It also helps to prevent e-mail transmission to unnecessary members or to prevent lefting out proper members from information sharing.
    • Google Group Member Deletion
      Deletes members (email address) from Google Group. It is possible to respond to email newsletter delivery cancellation, or to delete automatically from the group when employees move or leave the company
    • Google Group member add
      Add a member (email address) to Google Group. You can create an newsletter subscriber list (ML) distributed for the requester for material document, or register to group at the same time when adding a new employee account.
  • Google Analytics
    Accesses to Google Analytics and get Ranking report (PV / Referrer / Domain). it is possible to specify duration and filter criteria, so you can get regular reports without having to sign in to Google Analytics.
  • Google Cloud Print
    Prints the file specified by File type data item with the specified printer, and stores its communication log in a String type data item 
  • Box
    • Box File Upload (Password / Expiration)
      Uploads a file specifying the folder of Box, obtains the URL for publication and stores it in String type Data Item. Since you can set download password and download expiration date, it can be used for file sharing etc.
    • Upload to box
      Uploads the file specified by File type data item to the specified directory of box, and stores its communication log in a String type data item
  • Dropbox
    • Upload to Dropbox
      Uploads the file specified by File type data item to the specified directory of box, and stores its communication log in a String type data item
  • kintone
    • kintone Batch acquisition of Two rows data
      Stores the value of the field code of two columns of the specified kintone application into a data item respectively, and stores its communication log in a String type data item.
  • Slack
  • Salesforce
    • Salesforce Order Create
      Registers new order information in Salesforce specifying the Client and order details. Stores Order ID and communication logs into String type Data Item.
    • Batch acquisition of Salesforce Customer Data
      Stores business partner’s ID and Name inside Salesforce respectively into data items, and stores its communication log in a String type data item.
  • Backlog
    • Backlog Add Issue
      Adds an Issue based on its Project ID, Summary, Type ID, etc., and stores the communication log into Data Item respectively.
  • PayPal
    • PayPal Invoicing Create (JPY)
      Generates Paypal invoice automatically from the setting item information, and stores Paypal Invoice ID in a String type data item
    • PayPal Invoicing Create (USD)
      Generates Paypal invoice automatically from the setting item information, and stores Paypal Invoice ID in a String type data item
    • PayPal Invoicing Status
      Stored the status of the Paypal Invoice ID specified by String type data item in a String type data item, and if having been paid, stores the payment date and time and the amount in a data item
    • PayPal Invoicing Send
      Sends an invoice with the Paypal Invoice ID specified by String type data item via email, and stores the status in a String type data item
  •  Stripe
    • Stripe Charge to Customer ID
      From Customer ID, charge amount, currency code etc. stores Charge ID, last 4 digits of credit card number, status of registration process, communication log respectively into data items as billing record
    • Stripe Customer ID Create from Token
      Registers a customer in Stripe by using the ID which tokenized credit card information. Customer ID used for billing, last 4 digits of the credit card, status of registration processing, and communication log are stored in Data Item.
    • Card Info to Stripe (MM/YY edition)
      Registers customer’s settlement information to Stripe and stores the Customer ID and the last 4 digits of credit card number to be used for billing, the status of registration processing, and the communication log into the data items respectively
    • Card Info to Stripe
      Registers customer’s settlement information to Stripe and stores the Customer ID and the last 4 digits of credit card number to be used for billing, the status of registration processing, and the communication log into the data items respectively
  • Twilio
    • Twilio FAX Send
      You need to create a project at Twilio console, and acquire ACCOUNT SID / AUTHTOKEN / Telephone number befroehand
  • Corporate Number
    • Get Info via Corporate Number API
      Stores the “company name”, “postal code”, “domestic address” of the Corporate Number system respectively into the data item, and stores its communication log in a String type data item
  • Questetra
    • Post to OpenChat (Questetra’s Enterprise Social)
      Messages that all users can search and view will be posted to OpenChat. Since posted on the workflow engine’s standpoint, there is no concept of followers. It is displayed in the timeline of the participants as “#p1234”.
    • Check The User Is In The 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 Role Membership Deletion
      Deletes a member from Questetra’s “Role” and stores the communication log in a String type Data Item.
    • Questetra Role Add Membership
      Adds a member to Questetra’s “Role” and stores the communication log in a String type Data Item.
    • Questetra Org Delete Membership
      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 Add Membership
      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] 
  •  Other
    • HTTP Files Retrieve
      Download the file with HTTP and add it to the file type data item
    • NHK Program Search
      Stores program information matching the keyword specified in String type data item into a String type data item, and stores its communication log in a String type data item

Data Processing Closed within Workflow App

  • Specific Line Reader
    Extracts a specified line from a String type data item (multiple line) and sets it in another String type data item. It can be used for loop processing of multiple line list line by line.
  • Single Value from a JSON object using JSONPath
    Extracts an arbitrary value from the JSON text stored in a String type Data Item and sets it to another String type Data Item or Numeric type Data Item. It can be used for e.g. extracting necessary data from JSON received by Webhook feature. JsonPath is used to specify the value.
  • Random Password Generator
    Generates a password from the specified combination of character strings and stores it in a data item. It can be used for “Issuing new user account” of the information system.
  • Random Number Generator (dynamic)
    Generates a random number in the specified range and stores it in a data item. It can be used for determining the person in charge of processing by the generated numerical value for the sake of “preventing fixation of reviewers”, or “determining strict winner numbers” in lottery, and so on.
  • Random Number Generator
    Generates a random number in the specified range and stores it in a data item. It can be used for determining the person in charge of processing by the generated numerical value for the sake of “preventing fixation of reviewers”, or “determining strict winner numbers” in lottery, and so on.
  • Minites Calculator
    Calculates the elapsed time (minutes) from the two specified date time types and stores it in the data item
  • Line Counter
    Measure the number of lines in text
  • Hash Calculator (SHA256)
    Generating hash value (SHA256 method) of a string and stores it in a String type data item.
  • Hash Calculator (MD5)
    Generating hash value (MD5 method) of a string and stores it in a String type data item.
  • Generate Transfer Slips
    Regarding to the down payment for long-term service, stores sales transfer slip data for the number of months of contract into a data item
  • Journal Slip TSV from Invoice Data
    Generate transfer slip TSV (tab-separated-values) with sales amount, sales date, due date. It supports cases where add a sales collectively or divided into several months or mixture of those. In order to generate a file for the accounting system, you need to place a converter such as “TSV to Excel-CSV FILE”.
  • File Name Generator
    Stores a filename generated by concatenating prefix, item ID, date / time, and suffix in a data item
  • Email a Excel-CSV (Table) sjis
    Converting the values in a Table type data item to an Excel CSV file (TSV), and sends it as email attachment.
  • Email a Excel-CSV (Table)
    Excel-CSV Email Attachment (Table)
  • Delete Data (Overwrite with Null)
    Deletes the data of the selected data item.
  • Days Calculator
    Calculate the number of elapsed days from the two specified dates and store it in a data item
  • Data Duplicator (Table)
    Duplicate the value of Table type data item: A at Table type data item: B.
  • Data Duplicator (Files)
    Duplicate the file of File type data item: A to File type data item: B.
  • Converter (Tsv to Table)
    Parses a tab delimited text (TSV) stored in a String type data item, and stores it in a Table type data item.
  • Converter (TSV to Excel-CSV) SJIS
    A tab delimited text (TSV) stored in a String type data item is saved as an Excel compatible CSV file in a String type data item.
  • Converter (TSV to Excel-CSV FILE)
    A tab delimited text (TSV) stored in a String type data item is saved as an Excel compatible CSV file in a String type data item.
  • Converter (Table to TSV)
    Converts the value of a Table type data item to the tab delimited format (TSV) and stores it in a String type data item
  • Converter (Table to Excel-CSV FILE)
    A tab delimited text (TSV) stored in a String type data item is saved as an Excel compatible CSV file in a String type data item.
  • Converter (Table to Excel-CSV FILE sjis)
    Stores the values in a Table type data item into a File type data item as an Excel compatible CSV.
  • Converter (Quser to ID, Name, Email)
    Stores the UID, Name, and Email of a User type data item A in a String type data item selected at B, C, D respectively.
  • Converter (Email to Quser)
    Judging the User by the email address in a String type data item and store it in a User type data item.
  • Converter (Date to Japanese Era String)
    Converts a Date type data item to Japanese calendar and stores it in a String type data item.
  • Connector (TSV Bulk Start)
    Launching the Start event specified by each line data of tab delimited format data (TSV) and stores the communication log.
  • Character (Letter) Counter
    Counts the number of characters in a text and store it in a data item. It can be used, for example, counting the number characters in original sentences in the translation work, or checking the received manuscript data.
  • Add Column to Tsv
    Adding a character string to the end of the tab delimited text (TSV) and stores it as a new TSV in a String type data item.
  • Delete Rows of Tsv
    Remove the specified number of rows from the top from the tab-delimited text (TSV) stored in the String type Data Item
  • Change Order of Tsv
    Sorting the columns of the TSV in the order as indicated
  • TSV Filtering by Date
    dateString should be in a format recognized by the Date.parse() method. Date-only strings (e.g. “1970-01-01”) are treated as UTC, not local.
  • Accumulated Hours Calculator
    Calculates the elapsed time from the specified two date times and adds it as cumulative time to the data item

Articles in this section

Comments

0 comments

Please sign in to leave a comment.

Related articles