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 →