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 →