A WordPress plugin to integrate with the FileMaker Data API to allow data to be pulled from FileMaker and displayed easily in your WordPress site.
At this early stage of development only 'pull' is possible. Over time this plugin will be expanded to allow for data to be updated in FileMaker as well.
The primary means of 'pulling' data is through the use of two WordPress shortcodes
Download, copy to your plugins directory, enable, configure and you're ready to go.
The two shortcodes listed below provide access to your FileMaker data.
Pull all records from the specified layout and generate a table of records.
| Parameter | Description | Required |
|---|---|---|
| layout | Specify the layout which data should be pulled from | true |
| fields | A list of the fields which should be included in the table. | separated (see example below) | true |
| labels | The labels to use for the column headers. If ommited then the field names (as above) are used instead. | separated | false |
| types | The type of each field. Currently supported are
|
false |
| id-field | Which field on the layout acts as a primary key for the given layout | false |
| detail-url | If both this and the id-field are set then the content of the cells is converted to a link to the URL. You must provide the location in the URL which the value of id-field will be embded in using *id* e.g. detail-url="/product/?id=*id*" |
false |
| query | The JSON encoded query to apply to the records selected in the form 'field': '{ operator } value'.It is simplest to use single quotes for the JSON object, which will be transposed prior to submission to FM. e.g. query="{'Unit Price': '<500', 'Availability': 'In stock'}".Note that depending on the exact Wordpress editor you're using then less than, and greater than signs may be html encoded. Again, the parser will cope with that. Also be aware that you're performing an AND query if you specify more than one key / value pair. |
false |
Example
[FM-DATA-TABLE layout="Product Details" fields="Image|Part Number|Name|Unit Price|Category|Availability" types="Thumbnail-50|||Currency||" id-field="Part Number" detail-url="/product/?id=*id*" query="{'Unit Price': '<500', 'Availability': 'In stock'}"]
Display a single field value.
| Parameter | Description | Required |
|---|---|---|
| layout | Specify the layout which data should be pulled from | true |
| id-field | The field which contains the UUID to locate the correct record | true |
| id | The ID to search for in the above field. Either a static value, or this can be a special value URL-xxx in which case the query parameter xxx will be used. In the detail-url example above this would correspond to id, so it would be URL-id |
true |
| field | The field to display | true |
| type | The type of output - options are the same as for the 'types' above. | false |
Examples
[FM-DATA-FIELD layout="Product Details" id-field="Part Number" id="URL-id" field="Image" type="Image-200"]
[FM-DATA-FIELD layout="Product Details" id-field="Part Number" id="23456" field="Price" type="Currency"]
[FM-DATA-FIELD layout="Product Details" id-field="Part Number" id="URL-id" field="Stock Level"]
- More output types
- Write data back to FM
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent