FormattedDateToEpoch

Converts a custom-formatted timestamp to UNIX epoch time. Use it to convert custom time stamps to a XSOAR date field. If you pass formatter argument, we will use it to transform. If not, we will use dateparser.parse for transforming. For more info, see: https://docs.python.org/3.7/library/datetime.html#strftime-and-strptime-behavior

python · Filters And Transformers

Details

IDFormattedDateToEpoch
Languagepython
From Version5.0.0
Docker Imagedemisto/python3:3.12.13.10404775
Tagstransformer date

README

Converts a custom-formatted timestamp to UNIX epoch time. Use it to convert custom time stamps to a XSOAR date field. If you pass formatter argument, we will use it to transform. If not, we will use dateparser.parse for transforming. For more info, see: https://docs.python.org/3.7/library/datetime.html#strftime-and-strptime-behavior

Script Data

Name Description
Script Type python3
Tags transformer, date
Cortex XSOAR Version 5.0.0

Inputs

Argument Name Description
value Time stamp to convert
formatter Python ‘strptime’ formatter string

Outputs

There are no outputs for this script.

Source

FormattedDateToEpoch.py FormattedDateToEpoch_test.py FormattedDateToEpoch.yml
Download History Raw 
import demistomock as demisto
import pytest
from FormattedDateToEpoch import date_to_epoch, main


@pytest.mark.parametrize(
    "date,formatter,expected_result",
    [
        ("2020-03-31T13:19:41.000+0100", "%Y-%m-%dT%H:%M:%S.%f%z", 1585657181),
        ("2020-03-31T13:19:41.000+0100", None, 1585657181),
        ("2020-03-31T13:19:41.000+0000", "%Y-%m-%dT%H:%M:%S.%f%z", 1585660781),
        ("2020-03-31T13:19:41.000+0000", None, 1585660781),
        pytest.param("2020-03-31T13:19:41.000+0100", "%Y-%m-%dT%H:%M:%S.%f%z", 1585657181, marks=pytest.mark.xfail),
    ],
)
def test_date_to_epoch(date, formatter, expected_result):
    assert date_to_epoch(date, formatter) == expected_result


@pytest.mark.parametrize(
    "date,formatter",
    [
        ("2020-03-31T13:19:41.000", "%Y-%m-%dT%H:%M:%S.%f"),
        ("2020-03-31T13:19:41", "%Y-%m-%dT%H:%M:%S"),
        ("2020-03-31T13:19", "%Y-%m-%dT%H:%M"),
        ("2020-31-03T13:19:41", "%Y-%d-%mT%H:%M:%S"),
        ("13:19:41T2020-03-31", "%H:%M:%ST%Y-%m-%d"),
        ("2020/03/31T13:19", "%Y/%m/%dT%H:%M"),
        ("2020 03 31 T 13:19", "%Y %m %d T %H:%M"),
        ("2020/03/31", "%Y/%m/%d"),
        ("13:19:41", "%H:%M:%S"),
    ],
)
def test_date_to_epoch_without_timezone(date, formatter):
    assert date_to_epoch(date, formatter) == date_to_epoch(date)


@pytest.mark.parametrize(
    "date,formatter,date_without_formatter",
    [
        ("2020/03/31", "%Y/%m/%d", "March 31, 2020"),
        ("2020/03/31", "%Y/%m/%d", "Tuesday March 31, 2020"),
    ],
)
def test_date_to_epoch_different_format(date, formatter, date_without_formatter):
    assert date_to_epoch(date, formatter) == date_to_epoch(date_without_formatter)


@pytest.mark.parametrize(
    "args",
    [
        {"value": "2020-03-31T13:19:41.000", "formatter": "%Y-%m-%dT%H:%M:%S.%f"},
    ],
)
def test_date_to_epoch_main(mocker, args):
    """
    Given:
        value and formatter
    When:
        date_to_epoch
    Then:
        demisto.results called
    """
    mocker.patch.object(demisto, "args", return_value=args)
    mocker.patch.object(demisto, "results")
    main()
    assert demisto.results.call_count == 1