RGC DATA INSIGHTS

Connecting a Custom Website to FileMaker: A restCWP Case Study

A custom website securely exchanging data with a FileMaker backend through a REST integration layer

What happens when a business already has a capable FileMaker solution, but its public website is not built on WordPress?

That was the situation one of our clients brought to us. FileMaker was doing important work behind the scenes. The website had its own custom technology stack and needed dependable access to that data. The client needed more than a few API calls that worked during a demo. They needed authentication that could be managed safely, predictable access to FileMaker layouts, clean data exchange, useful diagnostics, and an architecture that could grow with the site.

A WordPress plugin was not an option. Rebuilding the website just to simplify the integration did not make sense either.

This is exactly the kind of problem restCWP was built to solve.

The client’s problem was not the website or FileMaker

The client already had two valuable systems:

  • A FileMaker solution that supported the organization’s real business workflow
  • A custom website built with tools appropriate for its users and development team

The problem was the space between them.

The website needed to read and update FileMaker data without exposing FileMaker credentials to the browser. It needed to work with layouts and scripts that reflected the business rules already built into the solution. It also needed to manage FileMaker Data API sessions without making every page request responsible for login, token reuse, expiration, and cleanup.

Those details are easy to underestimate. A proof of concept can call an endpoint, receive JSON, and appear finished. A production integration has to keep working when traffic increases, a token expires, a layout changes, a server responds slowly, or a developer needs to understand why a request failed.

The client did not need a different website. They needed a reliable integration layer.

Why the traditional approaches became difficult

There are several reasonable ways to begin a FileMaker web integration. A developer can write direct cURL requests in PHP, call an internal endpoint from React, or build a small collection of helper functions around the FileMaker Data API.

That can be enough for a narrow project. The difficulty appears when the integration becomes part of daily operations.

Token management spreads into application code

The FileMaker Data API uses session tokens. The application has to create them, store them safely, reuse them when appropriate, recognize expiration, and end sessions deliberately. If that logic is repeated across routes or components, small differences begin to appear. One part of the site may retry correctly while another fails. One request may log useful context while another returns a generic error.

Layout access is part of the contract

FileMaker layouts are not just screens. For the Data API, they help define fields, portals, scripts, and the context available to the integration. A renamed field, a changed privilege set, or a layout adjustment can affect the website. Developers need one understandable place to configure and test that contract.

Security has to remain server-side

A modern front end may be written in React, but FileMaker credentials and privileged requests should not live in browser code. The site needs a server-side boundary that validates requests, protects configuration, limits what the public application can do, and returns only the data the interface actually needs.

Troubleshooting should not require guesswork

When an integration fails, the team needs to know whether the problem is authentication, configuration, network access, a FileMaker privilege, a layout, a script, or the request itself. Scattered API code makes that investigation slower than it needs to be.

Growth changes the risk

A small site may begin with one form or one listing page. Later it may add customer accounts, search, registration, payments, mobile access, or automated workflows. An integration assembled one request at a time can become fragile as those features accumulate.

How we implemented restCWP

We placed restCWP between the custom website and FileMaker Server. The website kept its existing presentation layer. FileMaker remained the system of record. restCWP became the focused service layer responsible for communicating with FileMaker in a consistent way.

The pattern was simple:

  1. The browser or application sends a request to the site’s server-side endpoint.
  2. The endpoint validates the request and decides which FileMaker operation is allowed.
  3. restCWP handles the FileMaker connection, session token, layout context, request, and response normalization.
  4. The endpoint returns a deliberate response to the website.

This separation matters. The browser does not need to know how FileMaker authentication works. The React component does not need to know how a portal is represented by the Data API. The rest of the application gets a stable interface while the FileMaker-specific work stays in one maintainable place.

Guided setup instead of hidden assumptions

The first step was restCWP’s guided configuration process. Connection settings, database and layout context, authentication, storage options, and environment-specific details could be reviewed deliberately instead of being buried throughout the application.

The setup process also gave the development team a repeatable way to validate the connection before building features on top of it.

Secure token management

restCWP manages the FileMaker Data API session lifecycle so each application feature does not have to reinvent it. Depending on the deployment, token information can use file, session, or SQL-backed storage. Configuration and relevant log context can be encrypted when SQL storage is used.

The important result is not merely fewer lines of code. It is one consistent policy for how the application authenticates, reuses a valid session, responds to expiration, and avoids exposing credentials to the client.

A clean boundary for PHP, React, and custom stacks

The client’s website could keep using its existing stack. PHP endpoints called restCWP directly. React consumed those endpoints as ordinary application services. The same approach works for a custom JavaScript application, a traditional server-rendered site, or another modern web stack with a suitable server-side layer.

restCWP did not ask the client to reorganize the website around FileMaker. It allowed FileMaker to participate cleanly in the architecture the client already had.

Data API and OData paths

For layout-based workflows, scripts, portals, related records, and container operations, restCWP uses the FileMaker Data API. When a project is better served by table-native OData 4.0 access, we use the matching ODataCWP client with a familiar setup and developer experience.

This gives developers a practical choice. The API is selected for the job instead of forcing every integration into the same access model.

A restCWP admin dashboard concept showing configuration, token health, diagnostics, versioning, and request activity
A visible operational layer makes configuration and troubleshooting easier to manage.

The admin dashboard changed the support experience

An integration is easier to trust when its state is visible.

restCWP includes a full admin dashboard and a straightforward setup process. The team can review configuration, run connection checks, inspect diagnostics, verify the active version, and look at useful request or logging information without searching through unrelated application code.

For developers, that shortens the distance between “the page is not loading” and a specific cause. For the client, it creates a more supportable system because the integration has an understandable operational home.

The dashboard is especially valuable during deployment. Instead of discovering a missing PHP extension, blocked connection, incorrect layout, or insufficient privilege through a public-facing feature, the team can test the integration directly and address the problem in context.

What improved after implementation

We did not measure this project with a made-up percentage or a dramatic benchmark. The meaningful improvements were architectural and operational.

Reliability

FileMaker communication moved into a consistent engine with a known request flow. Token handling, response processing, and error behavior no longer varied from one website feature to another. The integration became easier to test and less likely to break because a new feature copied an old API call incorrectly.

Security

Credentials and privileged FileMaker operations stayed on the server. The public application received only the endpoints and data it needed. Configuration could be protected appropriately for the deployment, and diagnostics did not require exposing sensitive information to the browser.

Developer workflow

The web team could work in familiar tools. Front-end developers consumed normal application endpoints. PHP developers had a readable, framework-free client. FileMaker developers could focus on layouts, scripts, privileges, and business rules without having to own every detail of the website stack.

Maintainability

Configuration, diagnostics, version information, and integration behavior had a clear home. When the website or FileMaker solution changed, the team had a defined boundary to review instead of hunting through scattered requests.

Built for future growth and automation

The first version of an integration should solve today’s problem, but it should not make tomorrow’s problem harder.

Because restCWP creates a clear service boundary, the client can add new consumers without handing each one direct responsibility for FileMaker. A mobile app can use the same carefully designed endpoints. A new React interface can reuse existing workflows. Scheduled processes can exchange data through controlled services. Additional integrations can be added without placing credentials in every system.

RGC Data also builds native mobile apps on FileMaker backends. In those projects, FileMaker remains central while each interface is designed for its audience. Staff may work in FileMaker Pro, customers may use a custom website, and field users may rely on an iOS or Android app. A consistent integration layer helps all of those experiences stay aligned.

A scalable restCWP integration connecting FileMaker to PHP, React, web, mobile, and agent-assisted workflows
One controlled integration layer can support web, mobile, automation, and future application workflows.

A practical fit for agentic workflows

Modern development teams increasingly use coding agents to inspect a codebase, draft endpoints, create tests, review logs, and document integrations. restCWP fits that workflow because its responsibilities are explicit and its configuration, diagnostics, and versioning are easy to reason about.

An agent can help a developer build against a defined service layer much more safely than against a collection of undocumented requests. The usual rules still apply: keep production credentials out of prompts, protect real customer data, review generated code, and test every operation with the correct FileMaker privilege set.

Used thoughtfully, agentic tools can reduce repetitive integration work while the developer remains responsible for architecture, security, and release decisions.

Why this matters for the FileMaker community

FileMaker has always been good at helping teams turn real business knowledge into working software. Many of those solutions now need to serve people beyond the FileMaker client. Customers expect web portals. Staff need mobile access. Organizations want forms, payments, notifications, reporting, and automation to connect with the data they already trust.

WordPress is a strong answer for some of those projects. Our free CWP Snippets tools support developers who want a WordPress-native workspace for FileMaker connections.

Other projects are not WordPress projects, and they should not have to become one.

restCWP is our way of sharing a practical path for those developers. It comes from the same kinds of integration problems we solve in client work: secure authentication, understandable configuration, useful diagnostics, and code that can live comfortably inside a custom application.

We are certified Claris Partners and certified FileMaker developers, but the point of mentioning that is not to make the work sound exclusive. It is to say that we care deeply about this platform and the people building with it. We want FileMaker developers to have better options when a project reaches beyond the desktop.

Is restCWP a fit for your project?

restCWP is worth considering when:

  • FileMaker is your system of record
  • Your website is built with PHP, React, or another custom stack
  • You need server-side access to FileMaker layouts, scripts, portals, records, or containers
  • You want secure Data API session management
  • You need guided configuration, diagnostics, logging, and version visibility
  • You expect the integration to grow into more workflows, applications, or automations
  • You want direct control without adopting a large framework

For table-native OData workflows, the companion ODataCWP client provides the matching path. For WordPress, CWP Snippets is the WordPress counterpart.

You can learn more about our FileMaker, web, mobile, and integration work at RGC Data, or review the current restCWP and ODataCWP packages on the restCWP product page.

If your integration is unusual, complicated, or already giving you trouble, that is okay. Those are often the most interesting conversations. Reach out and tell us what you are trying to connect. We will be glad to listen, help you think through the architecture, and see whether restCWP or a custom integration is the right fit.

Start a conversation with RGC Data