Logo preload
close Logo

New Records API Date Filters

May 20, 2014

API Date Filters

Our API is a core piece of the service that allows organizations to extend Fulcrum to suit their particular needs. To keep increasing the value and power of the API, we make it a priority to listen to suggestions from our users that make it easier for them to interact with their data.

Part of this power is the ability to retrieve only the records that have been updated since a specific time. This enables things like syncing. But what about filters based on when they were created in the mobile app or within a particular timeframe? This was the idea behind one recent suggestion from one of our users.

New Date Filters

Added Parameters for Records API

Today, we announce additional parameters to the Records API that allow developers to filter their datasets more precisely.

Now you can also find records:

  • updated in the cloud before a specific time
  • created in the cloud either before or since a specific time
  • created on a client either before or since a specific time
  • updated on a client either before or since a specific time

Be sure to check out the details in the updated records documentation.

Adding these features into the Fulcrum API means your application can focus more on the business logic and become more straight-forward to maintain. It’s also easier to build advanced workflows to streamline your organization’s processes.

As a quick starter guide, here’s how to filter between two dates:

‍Using the before and since filters, you can retrieve records between a date range.

For instance, you can combine the client_created_since and client_created_before parameters to find the records that were created by your field crew between two dates.

When using the various created and updated time parameters, you must give the date since epoch in seconds: 2012-04-24 15:05:22 -0400 = 1335294322.

Records will still be ordered according to the updated_at column, even when filtering with the other before/since parameters

This is just one of the many examples where user feedback helps determine which features we release next!

Let us know if you have any questions related to these new features or have a suggestion of your own.

And, as a refresher on Fulcrum date fields, here are the options available. 

Date fields in Fulcrum can be required, hidden, read-only, and be set to default to the current date. You can also have the time field default to the previous value if needed.

When editing records on the mobile device or the web, date fields let the user pick a date in a standardized format using a date picker entry control. By default, it has a button to select the current date, for more efficient data entry.