KBEC-00200 - Workaround to use relative dates in API (findObjects)

Summary

Currently, there is no way of using relative dates to search through the API (for example: last month or 30 days ago).

Solution

Calculate the date/time using the current date and representing it in an accepted format for the findObjects command.

Examples

Create a script with findObjects in it, using the following filter:

{
propertyName => "start",
operator => "lessOrEqual",
operand1 => computeDaysAgoTimeStamp(30)
}

# where computeDaysAgoTimestamp is a sub:

# ----------------------------------------------------------------------

# computeDaysAgoTimeStamp
# Computes current-time minus $daysAgo in GMT time, for passing into
# a date filter (e.g. startTime <= 3 days ago).
#
# Arguments:
# daysAgo - number of days ago.
# ----------------------------------------------------------------------

sub computeDaysAgoTimeStamp($) {
my ($daysAgo) = @_;

# Get current time.
my $curTime = time();

# Subtract $daysAgo days.
$curTime -= 3600*24*$daysAgo;

# Convert this time to y-m-d format and return it.
my ($sec, $min, $hour, $mday, $mon, $year) = gmtime($curTime);
my $dateStr = sprintf("%4d-%02d-%02dT%02d:%02d:%02d.000Z", 1900+$year,
$mon+1, $mday, $hour, $min, $sec);
return $dateStr;
}

 

Applies to

Commander v.5.x and Flow versions 6.x and up

Have more questions? Submit a request

Comments

Powered by Zendesk