tried the FileMaker 17 Data API from the terminal

I am Teruhiro Komaki of frudens Inc.

The other day, FileMaker 17 has been released, the neighborhood is very exciting.
Many developers write articles related to 17.
Therefore, I will write about FileMaker 17 Data API with less information this time.

As the title suggests, I use a terminal but I try to use it with Copy, so feel free to try it.

First of all, about the document.

About the FileMaker Data API

The FileMaker Data API was available from 16, but it was a trial period.
The trial period ended at 17 and it was officially released.

If you have time, please see the help.

FileMaker 16 Data API

FileMaker 17 Data API

About FileMaker Data API Reference

After installing FileMaker Server, you can see the reference at the following URL.

If you look at help it is properly written, so let’s see.

When you installed FileMaker Server, you installed the FileMaker Data API reference files. This reference provides detailed information about all of the calls supported by the FileMaker Data API.

Note:To view the reference information, check that FileMaker Data API access has been enabled in Admin Console. See FileMaker Server Help.

  • To view the reference in a browser window on the master machine, enter the URLhttps://localhost/fmi/data/apidoc/
  • To view the reference in a browser window on a remote machine, enter the URLhttps://host/fmi/data/apidoc/where host is the IP address or host name of the master machine running FileMaker Server.
  • On a Windows server, the reference files are in the folder
    [drive]:\Program Files\FileMaker\FileMaker Server\Documentation\Data API Documentationwhere [drive] is the drive on which your FileMaker Server deployment resides.If you install using a non-default location on Windows, your installation location replaces the beginning of the default installation path[drive]:[installation_location]\FileMaker\FileMaker Server\Documentation\Data API Documentation
  • On a macOS server, the reference files are in the folder/Library/FileMaker Server/Documentation/Data API Documentation


The reference files show variables in the URLs by using a keyword preceded by a colon (:). For example: :database
This guide shows variables in the URLs by using an italic font. For example: database-name


macOS High Sierra (10.13.4)
curl 7.54.0
jq 1.5 (Please install with brew!)

For windows, please do it with cygwin etc.
If I have time, I’ll try to verify.

Continue reading →

implemented “HTML mail” and “attached file” transmission from FileMaker using the Gmail API

I am Teruhiro Komaki of frudens Inc.

I recently started using Vim.
I try to live with as much as possible, not as a GUI application.

I am used to living with terminals as the main, and I gradually delete GUI applications that are no longer needed.

Although it may be serious at first, I am comfortable when I get used to it, so I recommend you to everyone!
First of all let’s get used to package management at brew while tmux, screen etc …

Since I write blogs such as “Recommended command!” If you can afford it!

I was developing fmOAuth and wanted to cover most of what I can do with the Gmail API.

And I tried implementing HTML mail sending and sending mail with attached file etc.

I tried sending “HTML mail” and “attached file” using Gmail API from FileMaker

I think we can implement it in the next version of fmOAuth!
Also, we are thinking about deploying to another product using the function here.
(I do not know yet, but …)


Since fmOAuth is implemented with “insert from URL” only, plugins etc are not used.
The API is really wonderful!

If you have trouble with API cooperation, please contact us!

fmSimpleCalendar is likely to be released



Published fmSimpleCalendar to Github

I am Teruhiro Komaki of frudens Inc.

As I mentioned earlier, I am developing a solution fmSimpleCalendar as the title suggests., It had been announced previously, but has developed a solution that as the title fmSimpleCalendar .

It is likely to be released as it has finally become a form., It is likely to be released because we have more and more in the form.

Introduction of fmSimpleCalendar

Drag and drop

Switch display

Continue reading →