Sugar REST API filter for data records that were created after a certain date.

Steffen Scheid

The syntax you are using is not properly formed JSON. Can you try this as the filter:

?filter=[{"date_modified":{"$gt":"2024-03-06T16:56:16+01:00"}}]

and see what that provides.

Although, as Francesca Shiekh has said, you asked for records created after a certain date so you need either date_created or date_entered depending on the module in question.

Thanks,

JH.

Thank you John Hawkins  for the quick reply.
I have just tried it, it works very well. By the way, even without the time.

Best,
Steffen

Steffen,

You may want to test that thoroughly. I seem to recall that matching a datetime against a date can have unexpected results. I believe that the date may actually append "12:00:00" before the comparison, so the $gt filter may match for times after midday GMT on the day provided. So you may get extras or may miss some expected ones where the date_entered time is before 12:00:00.

Or that may have been an old bug that is fixed

All-in-all I prefer to match a datetime field against a full datetime string to make sure I am getting what I want.

Thanks,

JH.

Steffen,

You may want to test that thoroughly. I seem to recall that matching a datetime against a date can have unexpected results. I believe that the date may actually append "12:00:00" before the comparison, so the $gt filter may match for times after midday GMT on the day provided. So you may get extras or may miss some expected ones where the date_entered time is before 12:00:00.

Or that may have been an old bug that is fixed

All-in-all I prefer to match a datetime field against a full datetime string to make sure I am getting what I want.

Thanks,

JH.