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 →

Easily integrate FileMaker and Google Calendar with Integromat

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

https://github.com/frudens/fm-tokyo-integromat

Integromat

https://www.integromat.com

Screen after login

It is the screen after login.

Select “Create a new Scenario”.

filemaker-google-integration-integromat-01

Select a service for scenario creation

Enter “web” and narrow down.

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

filemaker-google-integration-integromat-02

Create a scenario

“?” Is displayed in the middle.

Right click and select “Webhook”.

filemaker-google-integration-integromat-03

Continue reading →

Created a file to make FMPerception diff more visible

fmperception-diff-viewer-create1

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

fmperception-diff-viewer

https://github.com/frudens/fmperception-diff-viewer

Continue reading →

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

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

https://www.filemaker.com/jp/learning/webinars/recorded_webinar.html?v=20170912_curl-option_dropbox.mp4

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

https://github.com/frudens/filemaker-webseminar-curloption

Image of demo file