Authenticating to the FileMaker OData Endpoint

Beginner

How to authenticate with Basic auth and obtain access to FileMaker data through OData.

What you'll learn

  • HTTP Basic authentication for OData
  • Required extended privilege for OData access
  • How Power BI and Excel authenticate to FileMaker OData
  • Security implications of Basic auth vs. token auth

The FileMaker OData endpoint uses HTTP Basic authentication -- the username and password are Base64-encoded and sent in the Authorization header with every request. This is different from the Data API's token-based authentication. Understanding the authentication model helps you configure BI tools and integrations correctly.

1/4
1

HTTP Basic authentication

Every OData request includes an Authorization header with Base64-encoded credentials:

HTTP
GET /fmi/odata/v4/MyDatabase/Contacts
Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQ=
// Base64(username:password)
What Is OData and Why Does FileMaker Support It?Querying Records with OData

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo