FileMaker Data Api
Looking for a .NET wrapper for the new FileMaker Data API? Check out https://github.com/fuzzzerd/FMData.
fmDotNet: a wrapper for the FileMaker XML API
This is a fork of the original fmDotNet. It includes additional coverage of the FileMaker XML API that was not present in the original version. Most notibly support for the
-findquery operation via the fmDotNet.Requests.CompoundFind class. Our fork also includes a set of unit/integration tests.
If you are familiar with FileMaker Pro 6 CDML Web Publishing or the FileMaker PHP API, fmDotNet will feel familiar to you. Many of the core principles and techniques are the same. The operations and vocabulary are the same as in FileMaker Pro.
The integration tests provided with this library have been tested against the latest FileMaker Server with all tests passing.
Getting Started with fmDotNet
fmDotNet is available on NuGet!
PM> Install-Package fmDotNet
Nuget Package Site: https://nuget.org/packages/fmDotNet/
Using fmDotNet in Code
You can start querying data from your FileMaker database with just a few lines of code:
var fms = new fmDotNet.FMSAxml("YourServerName", "user", "passw0rd"); fms.SetDatabase("yourDatabase"); fms.SetLayout("yourLayout"); var request = fms.CreateFindRequest(Enumerations.SearchType.Subset); request.AddSearchField("YourFieldName", "value-to-query-for"); var response = request.Execute();
You can query against related data too:
var fms = new fmDotNet.FMSAxml("YourServerName", "user", "passw0rd"); fms.SetDatabase("yourDatabase"); fms.SetLayout("yourLayout"); var request = fms.CreateFindRequest(Enumerations.SearchType.Subset); request.AddSearchField("RELATEDTALE::RelatedField", "value-to-query-for"); var response = request.Execute();
Note: the search is on related fields via Table::Field where the related field is on
You can perform complex finds with code like the following:
var fms = new fmDotNet.FMSAxml("YourServerName", "user", "passw0rd"); fms.SetDatabase("yourDatabase"); fms.SetLayout("yourLayout"); var cpfRequest = fms.CreateCompoundFindRequest(); cpfRequest.AddSearchCriterion("Colors::Name", "Blue", true, false); cpfRequest.AddSearchCriterion("Colors::Name", "Red", true, false); var response = cpfRequest.Execute();
This finds all items where the color is Red OR Blue.
Additional fmDotNet Example Usage
Browse the code in the test project fmDotNet.Tests for basic usage of the library. This is the automated test code that is used to ensure that fmDotNet functions correctly. It is a good place to see how specific tasks are completed using fmDotNet. In the future, we would love to have a full sample application showing usage of fmDotNet in the context of a real application.
There are several differences between this fork of fmDotNet and the original. This version
- Uses HTTP POST for all requests to FileMaker Server
- Has method, property, and field names in line with MSDN Naming Guidelines
- Does not include support for ADODB RecordSets
- Targets .NET Standard 2.0
Contributing to fmDotNet
- Submit an issue/bug with steps to reproduce it.
- Create a wiki page with more detailed examples, tutorials, or documentation.
Please make sure that that changes you submit to the core fmDotNet project pass the tests in fmDotNet.Tests or explain why they don't and why the test should be updated. These are integration tests, so you'll need to run the included FileMaker database on a copy of FileMaker Server.
Documentation for the FileMaker APIs that fmDotNet covers are linked below.
- FileMaker Server 16 Web Publishing Guide
- FileMaker Server 15 Web Publishing Guide
- FileMaker Server 14 Web Publishing Guide
- FileMaker Server 13 Web Publishing with XML
- FileMaker Server 12 Web Publishing with XML
- FileMaker Server 11 Web Publishing with XSLT and XML
We use Semantic Versioning. Using the Major.Minor.Patch syntax, we attempt to follow the basic rules
- MAJOR version when you make incompatible API changes,
- MINOR version when you add functionality in a backwards-compatible manner, and
- PATCH version when you make backwards-compatible bug fixes.