Get list of tables
Get a list of tables and table occurrences in a database
To retrieve a list of tables from a database, use the HTTP GET method with the database name appended to the URL.
| Component | Description |
|---|---|
|
HTTP method |
GET |
|
URL |
https://host/fmi/odata/version/database-name host – FileMaker Cloud or FileMaker Server host name version – the OData version, always database-name – the name of the hosted database Example: |
Get a list of values provided by a system table
To retrieve a list of system table values from a database, use the HTTP GET method with the database name, then a system table appended to the URL.
| Component | Description |
|---|---|
|
HTTP method |
GET |
|
URL |
https://host/fmi/odata/version/database-name/system-table host – FileMaker Cloud or FileMaker Server host name version – the OData version, always database-name – the name of the hosted database system-table – the name of the system table – see FileMaker system tables in the FileMaker SQL Reference for the full list of system tables Example: |