---
title: "Request records from a table"
topic_type: "conceptual"
sections: ["FileMaker information"]
locale: "en-US"
product: "FileMaker Server"
doc: "Claris FileMaker OData Guide"
version: 22
version_year: 2025
url: "https://help.claris.com/en/odata-guide/content/request-records-from-table.html"
id: "en/odata-guide/request-records-from-table.md"
keywords: []
---

# Request records from a table

To return a collection of records from the FileMaker Pro database, use the HTTP GET method with the table name included in the URL.

| Component | Description |
| --- | --- |
| HTTP method | GET |
| URL | https://*host*/fmi/odata/*version*/*database-name*/*table-name*<br>*host* – FileMaker Cloud or FileMaker Server host name<br>*version* – the OData version, always v4<br>*database-name* – the name of the hosted database<br>*table-name* - the name of the table or FileMaker Table ID (FMTID)<br>Example: `/fmi/odata/v4/ContactMgmt/Contacts`<br>Example: `/fmi/odata/v4/ContactMgmt/FMTID:123456789` |

## FileMaker information

- Container and summary fields are not included in the response result when you get all records or a single record. See [Request an individual field value](https://help.claris.com/en/odata-guide/content/request-field-value.html) for information about requesting container and summary field values.
- A maximum of 10,000 records are returned at a time. If the total records in a request exceeds 10,000, the nextLink value is also returned providing the next set of records.