Create applications, register data, and share with a single email
Kintone is a convenient service by itself, but the range of utilization can be expanded by using the API. In particular, I think it's hard to publish APIs for creating and modifying applications.
So, this time, I will introduce an example of linking kintone with a contact method called e-mail that anyone can easily send, from creating an application to registering data and sharing it.
This matter has been announced at kintone devCamp 2015. If you are interested, please see the presentation materials.
kintone devCamp 2015 ultra fast improvement
Motivation
Sharing awareness is essential for improving operations. Well-known are the hiyari hats. However, these findings are volatile, and if you say "Open a business system ~" or "Contact the system administrator ~" to share it, it will be troublesome to share. Will be gone.
Therefore, the motivation is to build a platform that can be shared the moment you notice it. Specifically, we will use a simple contact tool to create a sharing platform (= app), register data there, and share it with members.
Constitution
As a "simple contact tool", a chat tool such as LINE was really good, but I felt that I had to spend a little money to use the API, so I will email it this time.
The overall structure looks like the following.
SendGrid
It is a platform that can send emails, detect receipts, etc. via API. The usage is very well organized in the following blog, so please refer to it.
[MA: Techblog / SendGrid] Email API that has a high affinity with the world of the Web
SendGrid has an official Python SDK, so I used it this time.
Microsoft Project Oxford
Microsoft's research institute publishes APIs such as image analysis and natural language processing.
There are a lot of demos, so I think it's interesting to try various things. We have released a library for easy use from Python, so please use it if you like. This time, I am also using the Microsoft Translator API, but since it also supports that person, it can also be used for translating text and then synthesizing speech.
Watson
It is a general term for APIs for natural language processing that can be used on IBM Bluemix. This time, I used NLC, which can classify natural languages.
Watson officially publishes the Python SDK, which you can easily embed in your application.
watson-developer-cloud/python-sdk
kintone
And we are kintone. We have released the Python SDK, so we will use it this time.
It also supports the deployment API, which is the key to creating and changing applications.
Other Python Libraries
In addition, I will summarize the libraries and tools used.
- Falcon
Python's Web API-only application framework. Since I don't need a screen this time, I used Falcon, which specializes in API and operates at high speed. For details, see here. - janome
A morphological analysis library for Pure Python. MeCab is famous, but the setup is quite confusing, so this is easier and more convenient. This time, I'm planning to use it with Heroku Button in the end, so I chose janome with an emphasis on portability.
I also used a tool called ngrok to test the integration with SendGrid. This is a tool that can assign a global IP to a local server, which is useful for testing applications that work with WebHook services. It's too convenient to put into words, so I hope everyone will be happy to use it (see here for details on how to use it). ..
Implementation
Here's what I actually built (I'm not in time at the time of writing (12/4), but I'm thinking of adding a Heroku Button).
The following points were actually difficult.
- Assign the text of the email to the field of the kintone app to "feel good" Characteristic texts such as the order in which they are written and the date / email address are used as clues for assignment. A little trouble was kintone's [Field Information Acquisition API](https://cybozudev.zendesk.com/hc/ja/articles/204783170-%E3%83%95%E3%82%A9%E3%83% BC% E3% 83% A0% E3% 81% AE% E8% A8% AD% E5% AE% 9A% E3% 81% AE% E5% 8F% 96% E5% BE% 97 # anchor_getform_fields) Since the order is returned to irregular? [Layout](https://cybozudev.zendesk.com/hc/ja/articles/204783170-%E3%83%95%E3%82%A9%E3%83 % BC% E3% 83% A0% E3% 81% AE% E8% A8% AD% E5% AE% 9A% E3% 81% AE% E5% 8F% 96% E5% BE% 97 # anchor_getform_layout) We are considering the order in which they are lined up on the app.
- Add / remove fields The operation itself is not difficult because you only have to hit the API, but it was quite difficult to judge "what" and "what you are trying to do" from the text (simply processing with keywords, "delete flag" I want to delete it "and so on, so I need to do it properly). I'm using the form of particles as a clue, but this is an implementation that has a need for "morphological" analysis (Janome-sama).
- Supports attachments In many cases, I would like to attach a photo to reports of problems in my work, so I worked hard here. Along with this, we have added a field to pykintone that can handle attachments.
It may be difficult to run because there are many APIs that need to be registered, but if you are interested, please try running the source of GitHub (* I will write the early document).
In this way, I think that it is kintone's flexible work to be able to automatically create applications and add / delete items. We hope that you will use this flexible platform for various services.
Recommended Posts