unionpopla.blogg.se - Filemaker pro 11 examples

#Filemaker pro 11 examples how to
#Filemaker pro 11 examples archive
#Filemaker pro 11 examples plus
#Filemaker pro 11 examples series

Q: Can I use a POST HTTP request, instead of a GET, to avoid having sensitive data logged in the OData access log?Ī: Queries that fetch data are required to use the GET HTTP verb, however, such queries can be wrapped inside of an OData batch request, which results in the overall HTTP request being transmitted as a POST (#45 in the example file). (#7 in the example file) 2) Log Privacy and Avoiding GET 1) Returned fieldsĪ: Use the $select query option. As such, it is possible that the best solutions to these questions may be yet to come. Please keep in mind that, as FM OData is still a very recent technology, we are all still learning the answers. Each point listed below is also illustrated in the example file.

The following are answers to questions which may arise as you first get started with FM OData.

When matching a record via Primary Key, if no there is no field in the target table which is set to unique and non-null, then FM OData will use the record’s Record ID value as a primary key.

When matching a record via Primary Key, FM OData checks the table definition for a field defined to be unique and non-null, and takes the first-such found field as the Primary Key field.

When invoking a Script via FM OData, both the On First Window Open and the On Last Window Close scripts are invoked.

FM OData schema references use Table Occurrence names (not Table names).These are a few nuances to keep in mind as you work through the FM OData API examples and sample queries.

#Filemaker pro 11 examples how to

Tips for how to keep sensitive information out of the server logs Nuances of using FM OData From “ Access To Hosted File” choose the appropriate option:

From the Examples menu, select “ Access To Hosted File“Ģ.

Upload the OData_Sample file to an FM OData enabled server.

Secure the newly added accounts with strong passwords.

Open the OData_SampleData file using FileMaker Pro.

Prepare and host the OData_SampleData file:

OData_SampleData.fmp12 (Optional sample data file).

OData_Examples.fmp12 (Sample OData requests).

#Filemaker pro 11 examples archive

The archive should contain the following two files:.

If you do not have an OData-enabled FileMaker server, or if you do not wish to host the sample data file, please skip ahead to the Forty Examples of FileMaker OData section. Setting Up The Example Files for Hosted Use Even without a server, there is much which can be learned just by browsing the content. If you do not have an OData-enabled FileMaker server at your disposal, you are still encouraged to download the example file and review its contents. Using the example file in a fully-hands-on fashion requires having either Claris FileMaker Cloud, or a Linux FileMaker Server installation available.

I’ll sometimes refer to this functionality as “FM OData” for short. Get Started With Hands-On LearningĪs a learning tool, this post shares an example file that illustrates the basics of many common FileMaker OData API requests. As a follow-up, this post will cover the basics and dig into the nuances of using OData with Claris FileMaker.

#Filemaker pro 11 examples series

Part one of the series highlighted some of the key features of the API which make it an exciting addition to the FileMaker platform.

#Filemaker pro 11 examples plus

This blog post is the second of a three-part series about the FileMaker OData API, introducing a demo file with more than 40 examples plus helpful tips, along with Q&A.