Published fmOAuth(v0.0.4) to Github

Hello.
I am Teruhiro Komaki of frudens Inc.

As stated in the title, we released fmOAuth to GitHub.

This time I will write about the announcement and “why did it published to GitHub?”

Announcement

Please download from the link below.

https://github.com/frudens/fmoauth

Please see the image below for usage.

If you have any requests or questions, please feel free to contact us at Gitter!

https://gitter.im/frudens-com/fmoauth

Wish

I am glad that you can tell me when you use it.

Why did it publish to GitHub?

Simply put, I decided that it is better not to call the API from FileMaker, which is no longer necessary for me.

And it is unnecessary to me, but I thought that it might be useful for someone.

Why has it become unnecessary for me …

That’s because it began to develop with Golang.

People who can develop not only in Golang but also in Python, Javascript, PHP, etc, I think that I think the same way as I do.

Also, since there are convenient libraries and packages in any language, compared with FileMaker, it can be developed quite efficiently.

As FileMaker developers also learn general programming languages, the possibility of problem solving will expand, so it is recommended!

It is an image like the following.

Call API directly from FileMaker

published-fmoauth-to-github-1

Call the API via GAE/Go

published-fmoauth-to-github-2

Continue reading →

tried the FileMaker 17 Data API from the terminal

Hello.
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
https://fmhelp.filemaker.com/docs/16/en/restapi/

FileMaker 17 Data API
https://fmhelp.filemaker.com/docs/17/en/dataapi/

About FileMaker Data API Reference

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

https://your-domain.com/fmi/data/apidoc/

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

Notes

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

Environment

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

Hello.
I am Teruhiro Komaki of frudens Inc.

I recently started using Vim.
I try to live with Terminal.app 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 …)

Afterword

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!

fmOAuth v0.0.3 has been released

Hello.
I am Teruhiro Komaki of frudens Inc.

fmOAuth v0.0.3 has been released.

Please check the Release Notes for detail.

As a result of updating the client ID of fmOAuth, selecting “Use fmOAuth” in v0.0.2 or earlier sample file results in an error.

Regarding updating the client ID, you can dynamically manage files by placing files on S3 etc, always downloading the latest files …

This time, we have not fixed it.

Also, as I received an inquiry that “fmoauth.fmp 12 is hosted on the server, I can not cooperate well,” I confirmed it.
In my environment, I could confirm that I can cooperate.

In the next version upgrade, I would like to cover all Gmail APIs.
You can also send HTML mails.

Please look at the sample file and ask questions if there are unknown points such as scripts.

If you have an API etc. that you would like to collaborate, I hope that you can request.

To developers who used fmOAuth

Thank you for always using it.
If possible, it would be greatly appreciated if you could give us your impressions (both good and bad).

Nice to meet you.

fmOAuth v0.0.2 has been released

Hello.
I am Teruhiro Komaki of frudens Inc.

fmOAuth v0.0.2 has been released.

Please check the Release Notes for detail.

Personally, I think that it is great that you can use the API using any client!

By logging in to Google Cloud Platform with your own account, You created a client to use the API, and You made it available by passing the created client information as a script argument.

You login to Google Cloud Platform with your google account, create a client to use the API, and make it available if you pass the created client information as a script argument.

In addition, you can now download Gmail (via Gmail API).
If you run it on the server side, I think that you can sync Gmail.
I think that it is easy to incorporate it because it implements it only by Insert From URL without using a plug-in or the like.

Please look at the sample file and question if there are unknown points such as script!

Although story changes…

Currently, I create a template file that can easily incorporate FullCalendar that can be used in FileMaker Web Viewer.

I might like to sell it at the Web store, so it may be cheap, but it may be sold for a fee!

In that case, I think that you can purchase by all means m(__)m

If you have an API etc. that you would like to integrate, I hope that you can request.

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

Hello.
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

Hello.
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.

https://www.filemaker.com/help/15/fmp/en/#page/FMP_Help%2Finsert-from-url.html

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.

https://baseelementsplugin.zendesk.com/hc/en-us/articles/203843738-BE-HTTP-POST

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

Hello.
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.

fmoauth-002-google-oauth-application1

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.

fmoauth-002-google-oauth-application2

Continue reading →

1 Comment

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

Hello.
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

fmoauth-002-gmail-api-download-send1

Gmail API Response data

fmoauth-002-gmail-api-download-send2

Continue reading →