tried integration between FileMaker and Google Calendar and downloaded Gmail using the function of fmOAuth (0.0.2)

I am Teruhiro Komaki of frudens Inc.

Recently I wrote two simple articles.

developing Gmail API (download and send) to fmOAuth (0.0.2)

In fmOAuth (0.0.2), OAuth authentication (Google) implements a function that can use arbitrary applications

I thought that it would not be transmitted, and I tried moving the movie the first time.
I think that you can see what you can do when you watch the video.

This time, the sample file has been greatly modified.
I hope you will download it after release.

we will continue to develop!

After that, I would like to implement a calendar using the web viewer.

For “API integration test”, “Insert Text” is recommended

I am Teruhiro Komaki of frudens Inc.

Insert From URL has been greatly improved than FileMaker 16.
The point that you can now use the cURL options is very big.

There seems to be many people who do not know, but even version 15 you could use httpspost etc.

Insert From URL supports http, https, httppost, httpspost, ftp, ftps, and file protocols. FileMaker Pro downloads the resource that is specified by the URL to the target field.

However, when collaborating with external service, there are many things that can not be done with the default function, and I was executing the cURL command using BaseElements plugin.

BE_HTTP_POST ( url ; parameters { ; username ; password } )

Does a http POST function and returns the results. This uses the curl library so output will be similar to that. This is used in conjunction with the BE_HTTP_Set_Custom_Header function to set custom headers in advance and the BE_HTTP_Response_Code and BE_HTTP_Response_Headers functions to get the result values after the POST is complete.

Take back the story.

When doing API integration, I write variously in the cURL option, but there are a few troublesome cases to write with the FileMaker calculation formula.

Continue reading →

In fmOAuth (0.0.2), OAuth authentication (Google) implements a function that can use arbitrary applications

I am Teruhiro Komaki of frudens Inc.

Although it may be a bit hard to understand from the title, it is implemented so that you can replace the consent screen with any application, not fmOAuth(default).

That way, you can login to the console with your Google account, have the application created, and pass the arguments.

How to write your own app, write another article.

Consent screen of fmOAuth

The default agreement screen is as follows.


Consent screen of arbitrary application

When creating an application on the console (GCP) and passing the information of the application as a script argument, the following agreement screen will be displayed.


Continue reading →

1 Comment

developing Gmail API (download and send) to fmOAuth (0.0.2)

I am Teruhiro Komaki of frudens Inc.

It is a blog after a long absence.

We released a beta version (0.0.1) of the solution fmOAuth at the end of last year (2017).

After releasing it, I could not develop for a while, but I have been working on development continuously as I got a little time.

We added a script to access Gmail API in this release (0.0.2).

As a result, you can download Gmail and you can send mail via API.

As for sending e-mail, I thought that it was unnecessary because I can send e-mail at the script step of the FileMaker, but I implemented it because it’s peculiar.

By the way, now it will be plain text transmission.

Gmail API


Gmail API Response data


Continue reading →

Easily integrate FileMaker and Google Calendar with Integromat

I am Teruhiro Komaki of frudens Inc.

Since it was decided to speak at FM-Tokyo, I will tell you about it for the time being, although it is easy.

I will fix it later!

Demo file download


Screen after login

It is the screen after login.

Select “Create a new Scenario”.


Select a service for scenario creation

Enter “web” and narrow down.

Select “Webhook” and select “Continue” in the upper right.


Create a scenario

“?” Is displayed in the middle.

Right click and select “Webhook”.


Continue reading →

bought a keyboard bridge for HHKB

I am Teruhiro Komaki of frudens Inc.

Many developers in the world think that they spend most of the day with keyboards.

I think that there are many people who are committed to the development environments such as desks, machines, and displays.

I also have considerable commitment to the development environment.

In order to increase productivity, it began to pursue with nature.

Purchased HHKB keyboard

I usually use HHKB (Happy Hacking Keyboard Professional 2 Type-S English Array).

Although it can be a built-in keyboard of Macbook Pro, it is still comfortable to use, I have been using HHKB since I bought HHKB.

I will write the encounter with HHKB again next time …

This time, I bought a keyboard bridge to put HHKB on top of Macbook Pro, so I tried to take a picture of how it feels.

Purchased keyboard bridge

I bought this.

HHKB keyboard bridge installed

I installed it!



Macbook Pro 13


Continue reading →

Created a file to make FMPerception diff more visible


I am Teruhiro Komaki of frudens Inc.

I created a file to make FMPerception diff more visible.

As a developer of FileMaker, I think that many people use FMPerception, BaseElements, InspectorPro, etc.

I previously used BaseElements, but since FMPerception was released, I use little BaseElements.

So, I usually use FMPerception, but I feel that it is a little hard to understand the diff report of FMPerception.
(Perhaps my way of doing things is bad, so please point out if the recognition is incorrect.)

So, I quickly thought that I wanted to make diff easy to see.

Since it is open to GitHub, please see if you like.


Continue reading →

Web seminar “Let’s operate Dropbox using cURL option” has been added to Recording Web Seminar

I am Teruhiro Komaki of frudens Inc.

Web seminar “Let’s operate Dropbox using cURL option” on 2017-09-12 was added to the recording webinar.

Since we are talking about the following contents, if you are interested, please do…

View on FileMaker site (Japanese)

Let’s operate Dropbox with the cURL option

We introduce the demo which operates Dropbox by using “Insert From URL” and “cURL options” improved in version 16.
Liaise with external services and make custom applications more convenient.

  • Acquire information on various data in Dropbox
  • Upload various data from FileMaker to Dropbox
  • Acquire and view the temporary URL of various data in Dropbox
  • Other methods of utilization

Download demo file

Image of demo file