サーバーワークスでは、社内業務においても Slack、 Salesforce、 G Suite、 Backlog など、様々なクラウドサービスを活用しています。たとえば「社内メーリングリストを作りたい」といった場合には、申請が上司承認され次第、自動的に G Suite の API が呼び出されるように Questetra で設定しています。
このように日ごろからクラウド API に慣れ親しんでいるため、お客様向けの作業こそ「省力化」や「自動化」がミスの軽減に繋がると考えることができるのかも知れません。
事実、数多くのワークフローシステムから Questetra を選んだ大きなポイントは、多くのクラウドシステムに対して API クライアントになれる機能が備わっており、また多くのクラウドシステムからの API アクセスを受けられるところです。
Full-time employees: 120, Operators: 800 (as of May 2024)
Business
Operation of call centers and back offices, Outsourcing of back-office (BPO) operations, Human resources, telecommunications, and content-related businesses, Various debugging services, Development, sales, and maintenance of call center systems
Q. What kind of business do you use Questetra BPM Suite for?
We develop, sell, and maintain InfiniTalk, a telephone system used in call centers.
With InfiniTalk as the core, we have developed the “CTI solution” service that proposes the construction of the entire call center, and is being used by over 10,000 seats in 300 companies in 48 industries. Today, we also offer a cloud-based telephone system service which contributes greatly to the early launch of call centers.
We use Questetra for various application-related tasks across the company.
Q. What kind of challenges did you face?
For the task of purchasing hardware, etc. the salesperson applies for purchase, the superior approves it and the management department places the order. Prior to using Questetra, we used to have a paper a rule: application -> approval -> order processing by the Management department. However, it used to take time from the request application to order placement, since the superior was not available and the applicant himself had placed the order request after the approval.
Since we started using Questetra the superior has been able to give approval from anywhere, and information on the order request is now transferred to the Management department at the same time as approval, so the time from application to ordering has been reduced.
Furthermore, In addition to purchasing, work such as contract approval and expense settlement are subject to business audit, and since all the past processes are managed in Questetra it also leads to cost reduction for the business audit.
further productivity improvement such as automation of PDF generation
Q. Is there anything you have devised?
In the expense reimbursement process we have a “Receipt Attachment Form” which is automatically generated as a PDF.
On this form, information such as the application ID or applicant’s name is automatically filled in. After applying through Questetra the applicant prints out the automatically generated Receipt Attachment Form, attaches receipts to it and submits it to the Management department.
For the applicants, they don’t need to make the Receipt Attachment Form by themselves anymore, and for the Management department it became very easy to process because of the unified format.
Q. Please tell me about your expansion plan for the future.
I would like to make use of Questetra for further improvements in the operational efficiency of the Sales department.
We are using the Cloud SFA service and we manage information on business opportunities there. We are using Questetra to carry out the task of creating an estimate, but we are not yet able to link it with Cloud SFA.
In the future, I would like to make it possible to use the business partner information that has been stored in the cloud SFA in Questetra, or to make information of the estimates which have been approved on Questetra be automatically stored in the Cloud SFA.
In this article, I will introduce a case study which had great results by incorporating “parallel processing” into an existing Workflow.
Parallel processing shortened the period of time for evaluation work to 1/5
In a certain mail-order company, they have succeeded in reducing the period of time for evaluation work in the workflow of private label product development to 1/5 by incorporating “parallel processing”. (The name of the mail-order company is not disclosed)
In merchandise development of private brands, the “evaluation” work related to purchasing is an important task. There are three evaluation tasks: evaluation of suppliers, evaluation of manufacturing / production systems of products to be purchased, evaluation of the logistics system concerning the goods.
These evaluation tasks were done one after another in the past. That meant, after the evaluation of the supplier was done, they evaluated the manufacturing and production system, then evaluated the logistics system after the evaluation of the manufacturing/production system was done, and so on.
At the place of goods planning, they wanted to shorten the time required from “drafting” to “completion” (lead time), so that they could proceed with the planning of more goods. Thereupon, they considered parallelizing these three evaluation works.
I suppose that they had to proceed with the evaluation work one after another since they used to manage each goods planning project with documents in paper. By using a workflow system instead of doing it with paper, it became possible to reliably manage the situation of the projects, even when processing parallelly which is said to be difficult to manage.
They say that the time from drafting to completion has been shortened to one-fifth since they made it into parallel evaluation.
Sooner or later, I will describe the business management including parallel processing using the workflow system.
If you can find a part where you can parallelize in a Workflow, your productivity will be improved greatly. In this article, I am going to talk about “parallel” processing in a Workflow.
What is “parallel” processing in a Workflow?
A Workflow is a series of Steps (tasks) necessary to produce some results, such as making products and providing services, arranged in a proper order and connecting them with arrows.
There are two ways to connect these Steps in Workflow diagram, “serially” and “parallelly”.
To define “serial” versus “parallel”, I would like you to imagine the concept of “balls of work”. A “work ball” is what shows which process (Step) in the workflow is being handled and what is being processed in it.
When connecting “serially”, only one ball is at a given Step (the Step that is being processed).
Whereas, when connecting “parallelly”, several balls can be at different Steps as well. In “parallel” processing, at the beginning when there was only one ball, it can become two or more at a certain point.
Advantage of “parallel”processing
If you are looking at a workflow diagram and you can find a part where you can process “parallelly”, it is a great opportunity to improve the business process.
If you can connect multiple Steps in parallel and process them simultaneously, you can reduce the time from the start to the end of the entire flow. That is the biggest advantage of “parallel” processing.
Assuming that the time required for processing Step A as t1 and the time for processing Step B as t2, the time needed to complete these two Steps is the sum of t1 and t2 if Step A and Step B were connected in series. Whereas, if Step A and Step B are connected in parallel, the time to complete these two steps will be only the one that takes the longest, either t1 or t2.
“t1 + t2 > t1 or t2”, thus serial is greater than parallel, it is obvious that parallel processing can shorten the processing time required for the entire workflow.
Since there is such an advantage in parallel processing, I think that it is worthwhile to consider whether or not there is a part in the process which can be done “in parallel” in the Workflow diagram, including the review of the entire work.
Is “parallel” processing difficult to manage?
By arranging “parallel” processing in the Workflow, you will be able to gain the benefits described in the previous section. However, adding “parallel” processing makes management more difficult.
Since the original, single work ball becomes several, it becomes difficult to manage where each of the balls are.
The management of parallel processing will become easy by using a Workflow system (BPM system). Also, there are cases where business improvement was achieved by arranging parallel processing. I would like to continue talking about parallel processing in the future.
It will take five more years for bank APIs to become usable…So… “Invoice + bank remittance” is …, after all, out of date now…
“When you mail a billing invoice in paper, it will be paid until its deadline. Indeed, I believed it was the way to do it until a couple of years ago, but now, it is old-fashioned.
Table of contents
1. Bill invoice in paper
For example, when you mailed a couple of invoices, naturally it will be paid combined. Then a person would identify the payments…really analog!
Speaking of human tasks, it reminds me an old time when salaries were paid in brown envelopes, even to the pennies.
2. Online banking
People are talking about ‘Fintech’, yet it is useless.
Even in “Bank API as a national policy”, only “Reference type APIs” have been released partially after a long way. Moreover, the Nationwide Bank Data Communication System in Japan has its unique problem in text data communication. That must be corrected…
3. Full automation until settlement
I would like to process from billing to payment settlement without human intervention.
That’s right! “The ones born in the 70’s” should be the ones to say good-by to “bad ways of doing things” done so far. (?)
If Banks are not yet usable, let’s use a “Settlement agent” (Money transfer agent)!
Register “electronic invoice” on the settlement agent,
Make request to the settlement agent and have them email the “customer”,
Receive a report if there was a deposit from “customer” to the settlement agent.
In this way, the workflow would become unmanned.
4. Correspondence with Technical Support
Conversations with Technical Support of a money transfer agent regarding APIs… (This is fiction!)
Me: “Hey, hey, even if I specify the template ID it is not reflected in the invoice, right?”
(1 month later)
Support: “Ah, that’s true. I confirmed with our developers, they said the specification is not to reflect it. Our document is wrong.” (What?)
Me: “And also, even if I have set JST as timezone for date of invoices, it doesn’t seem to be reflected.”」
(1 month later)
Support: “That is the specification. Even if you specify the timezone, it is shown in PST.” (Huh?)
Me: “Also, the phone number for the billing source is not indicated on the bill…”
(1 month later)
Support; “Ah, that is a mistake in the document. The Phone object works if requested as child object of address object. Even though it is described as a sibling in the document. (I’ll kill you!)
note) In the capture image of sample code below, relationship of address and phone is wrong.
Well, the APIs designed by the settlement agent (money transfer agent) is really rational. And regarding the “REST Invoicing API” of “PayPAL Inc.”, I think it is awesome. (For overseas remittances, banks cannot match it.)
(But, there are some problems, at the same time… Especially, Support…)
5. Practical example
Incidentally, in an open event “Super Networking 2017” (2017-06-17), for which I am involved in the committee, electronic invoices (PayPal invoice) are practically used for collection of participation fee.
If you are up for the challenge, please join. (!?)
An email of “electronic invoice” will be delivered immediately… supposedly…
Automated task such as “Date Formatting” and “Slack Posting” is available for companywide
Kyoto, Japan – March 13rd, 2017 – Questetra, Inc., the global SaaS provider of Business Process Management (BPM), today announced that they have published the new version 11.3 of the Cloud-based Workflow product “Questetra BPM Suite” on Mar 13rd, 2017. In this new version, “automatic steps” utilized in various departments within the company can be managed unitary.
When modeling daily works such as “Quotation process” or “Invoice process” into Workflow systems, the Process owner (Workflow designer) defines the process by arranging several “Human Tasks” and “Automated Tasks”. However, if you wanted to place an automated task that is not included as a standard modeling element, you had to download or make your own definition file (Addon XML) and import it individually for each modeling so far. Since the new version 11.3, it is possible to share definition files.
With this function, in a company with many desk works of document preparation for Japanese government agencies for example, if the automated task of “Date Format Converter for JP” has been shared, you will be able to call it from any department. Alternatively, if an automated task which “Auto-Posting to Slack” has been shared in a company where promoting work progress to be posted to Slack, it will be possible to easily design Workflows containing it in any department. (Slack: Cloud based enterprise social network service which is widely used as a communication platform)
User companies will be able to improve their own productivity with automation.
Questetra BPM Suite
Cloud-based Workflow “Questetra BPM Suite” is a business platform for realizing environments of paper-less and remote-working. When a process reaches “Human task”, the user will be asked to input. If it reaches “Automated task”, server-side scripting will be executed. (BPM: Business Process Management)
Since it is possible to add arbitrary “Automated tasks” besides ones incorporated as standard such as “PDF Auto-Generation” and “Auto-Save to Google Drive”, you will be able to promote “Labor saving” or “Error rate reduction” or “Eliminating fraud”, etc., proactively in accordance with the management issues. More than 500 downloadable samples have been published for your convenience.
Shared File feature
By importing the service definition file (Addon XML) describing the contents of processing of the server-side in advance, you can use Service-Task not included in the standard menu as a modeling element. Starting with version 11.3, you can import it as a shared addon that can be used across the entire business platform. You can place this Service-Task to any work you are modeling.
Other Improvements
Smartphone Interface
Improved to a responsive interface to support multiple devices. In Version 11.3, we have greatly improved screen to confirm the details of the content of the Issue, and the screen for operating the Issues in My Tasks.
Personal Default of Listing
It is now possible to specify the default value for the number of items to display when displaying the list, such as Operation history of your own or Issues you have Started. Each user can select from “10 items / 20 items / 50 items / 100 items”.
Dependency on Shared-File
You can check which App is referring the shared-file in a list. It will be helpful for the maintenance of;
“Options Master” to be referred by Select type data item setting,
“PDF Form” (Template PDF) to be referred by the Service-Task for PDF Auto-Generation,
クラウド型ワークフロー『Questetra BPM Suite』は、ペーパレス環境やリモートワーク環境を実現するための業務プラットフォームです。案件が「人間工程」に到達すればユーザ(社員)に処理結果の入力を求め、また「自動工程」に到達すればサーバサイド処理を行います。(BPM: Business Process Management)
Case of accessing Questetra’s API from the midstream of Questetra’s process. Happy New Year. Thank you for your continuous support this year.
Though I have written blog posts about various system collaboration cases so far, I would like to write more of those kind of posts this year as well. Besides, I personally like the topic of system collaboration because it can extend options in many aspects.
In this post, I would like to introduce a method for accessing Questetra’s API from a Process of Questetra.
Table of contents
1: Use Case
As far as I know, the method has been used in the following cases.
After approving User addition/deletion request, add/delete User account of Questetra. (API for addition/deletion of User)
To launch the Task regularly in order to have a User changing the password periodically, and reflects the changes to the User settings of Questetra. (API for addition/deletion of User)
Change the organization setting of Questera so that the User who makes approval is changed for a certain period, and reverse the change after reaching a deadline. (API for adding/deleting user’s affiliation to organizations)
In Approval flows such as approval request or decision-making request, obtaining the organizational information of the applicant User and determine an approver on the request by the computing, and then allocate the Task of approval to the User. (API for querying settings of User, Organization, and Role)
Calculate the progress rate and delay degree by referring to the data of certain Process that performs process management and write the result to the original Process. (API for acquiring processing result of business flow, API for executing task)
2: General classification of Questetra’s API
If I roughly classify the APIs of Questetra, it will be;
A. To prepare by placing as parts in the Workflow: Operates such tasks as sending and receiving of HTTP request etc. in the midstream of a Process.
B. Other than the above: Operate such tasks as referring and updating of Users or data in a Process that Questetra retains.
The latter is a REST API, which can be accessed with “Throwing Message Intermediate Event (HTTP)” which is one of the former.
However, even if from the same Questetra environment, it requires authentication when accessing the API of the latter.
Besides, in the case of processing (computing, etc.) based on the obtained data, you need to parse the response with “Script Task”.
In this post, I will describe the case of accessing an API for adding Users through Basic authentication. (A simple case that does not require response parsing with “Script Task”.)
*When accessing API with Basic authentication, please note the following two points:
“System Settings” > “API Clients” in the left menu > in the “API access with Basic Authentication”, enable accessing by checking on “Enable API access with Basic Authentication” in advance.
You can confirm your API password at “Account Settings” > “Password” in the left menu > “API Password”.
The following is a sample Workflow App in which automatically adding a User account after a request has been approved by superiors.
The specification of User addition API is described in the API reference.
*The API manual can be displayed from the menu on the left side of each Questetra environment, and the URL is as follows. https://xxxxx.questetra.net/Swagger/index
The link to the manual of online demo environment is as follows. There, you can see the manual immediately even if you do not have a Questetra environment. System Settings API Workflow API
The following is a screenshot for of the corresponding API.
* In order to perform user addition processing, authentication by a User with System Administrator Authorization is needed. As it might be naturally expected.
Based on the API specification above, the settings of “Throwing Message Intermediate Event (HTTP)” can be configured as follows.
Specify the URL of API you want to access as Access URL (If in the same Questetra environment, you can also specify a variable such as “${var[applicationRoot]}”).
Specify Username and Password for Basic Authentication (Use API Password mentioned above).
Specify the parameters of the API to be accessed as sending parameters.
You can download an archive of the sample Workflow App above from here (zip expands qar file). * Change the part of Basic Authentication according to your environment.
For the other API specification of Questetra, please refer to the following.
In addition to PDF generation, capable of generating Excel files and saving received files
Kyoto, Japan – November 28th, 2016 – Questetra, Inc., the global SaaS provider of Business Process Management (BPM), today announced that they have published the new version 11.2 of the Cloud-based Workflow product “Questetra BPM Suite” on Nov 28th, 2016. In this new version 11.2, auto-steps such as “Excel-CSV file conversion of Table type data” and “saving received binary from external API” can be done.
Today, productivity improvement is the main focus, so the delivery of business information is now being shifted from “transfer of paper” to “data flow in system”, and the “manual work processing” in each step is replaced by “automatic computer processing” . Even in the Cloud-based workflow “Questetra BPM Suite”, various Processing can be automated, not only for simple work Step such as counting the “number of characters” in draft data, but even complicated process such as acquiring the latest information (JSON / XML) from an external API.
In the new version 11.2, the function of adding new files has been enhanced, so that you can automate the processing steps such as, 1) Creation and storage of files in which the entity is defined in string data, 2) Saving of received binary files, 3) Duplication and storage of files which are attached to a File type data item. In the invoice issuance process, for example, it is also possible to automatically generate a “CSV file for importing into accounting system” (File type data) from “Billing data” (Numeric type data).
Questetra BPM Suite
Cloud-based Workflow “Questetra BPM Suite” is a business platform for achieving paperless and telework environments. When a business issue “arrives” at a Step, a User (worker) processes it in a previously specified manner and enters the work result, then the issue goes on to the next Step automatically. Its most outstanding feature is its drag&drop feature used in the configuration of the “Business flow”. This feature allows a Process-owner to iterate the Improvement cycle on his/her as a part of the day-to-day work.
(BPM: Business Process Management).
Since it is applicable not only to simple business operations such as “Decision-making request” or “Document translation”, but also more complicated operations such as “Pre-shipment Quality check” and “Invoicing-Payment confirmation”, it allows to centrally visualize the progress of various in-house businesses. More than 500 downloadable Business Samples have been published for your convenience.
File Addition feature
It can be said that the file type data items so far were “items mainly for uploading work as human processing”. As a function for automatically adding new files, there was only the “PDF generation function” (function to generate PDF with strings and images inserted into the template). With the new version 11.2 onwards, you can automatically generate and save various text-based files such as CSV, TSV, JSON, and XML. In addition, binary files such as JPEG, PNG, DOC, PPT can be received from the external APIs and saved. It is also possible to automatically delete data by overwriting it wit null data. Note that, no method is provided for binary editing in v11.2.
Other Improvements
Enhancement of Table type data
When defining each column of “Table type data”, “Date column” can be set now, in addition to “String column”, “Numeric column” and “Select column”. Also, when defining settings that automatically calculate cell values in each column (record), you could only set the “product of two numeric columns”, but you can now define “sums of two numeric columns” or “addition of constant values”.
Enhancement of Nested Select type data
When setting filtered indication of “Select type data” by referring to nested data, narrowed down display was possible only for “Select type” and “Radio button type”, but now it is also possible to set it for “Checkbox type”.
Enhancement of Automated Step
Up until now, only one data setting formula could be set for one “Service Task (Data assignment)”, but now it is possible to define multiple data setting formulas. (It makes items easy-to-see such as Business flow with multiple Service Tasks standing in a row.)