Totp

The Totp() function calculates a time-based one-time password based on the given secret and given UTC time.

WIKI: https://en.wikipedia.org/wiki/Time-based_one-time_password

MyWEM Forum: https://my.wem.io/forum?threadid=184

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text value based on the given secret and UTC time, containing 6 numbers. Returns Unknown if one of the parameter values is unknown or outside the common valid boundaries. May throw a Server500 error when the secret is NOT a proper Base32 value with characters from the collection "ABCDEFGHIJKLMNOPQRSTUVWXYZ234567"

Syntax

Totp(secret)

Totp( "ABCDEFGHIJKLMNOPQRSTUVWXYZ234567" ) => "838893" (UtcNow() is implicitly used as date-time value)

Totp(secret, date)

Totp("ABCDEFGHIJKLMNOPQRSTUVWXYZ234567", Date(2022,05,11,14,15,0)) => "527549"

Parameters

Name	Type	Required	Description
secret	Base32 text	☑️	secret the password is based on. Must be base32 encoded and must contain any of the characters from the collection as indicated in the syntax example.
date	date time	☑️	UTC time or time and interval the password is based on.