| Expressions |
Spoiler (Highlight to read)
| JSON without expressions |
{
"days": DAYS_INT,
"hasWeeks": HAS_WEEKS_BOOL,
"weeks": WEEKS_INT,
"weeksAlt": WEEKS_ALT_INT,
"weeksAltFloat": WEEKS_ALT_FLOAT,
"weeksDollar": WEEKS_DOLLAR_INT
}
|
Where:
- DAYS_INT - Is the integer value of the difference in days
- HAS_WEEKS_BOOL - Indicates if there's enough days to make a week
- WEEKS_INT - Only provides an integer count of weeks if there's at least 7 days (rounding down)
- WEEKS_ALT_INT - Provides an integer count of weeks (rounding down)
- WEEKS_ALT_FLOAT - Provides an exact count of weeks
- WEEKS_DOLLAR_INT - Multiplies the amount of weeks by a float type Variable called dollarVAR
|
| Expressions |
| DAYS_INT |
Spoiler (Highlight to read) div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
)
|
| HAS_WEEKS_BOOL |
Spoiler (Highlight to read) greaterOrEquals(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
)
|
| WEEKS_INT |
Spoiler (Highlight to read) if(
greaterOrEquals(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
null
)
|
| WEEKS_ALT_INT |
Spoiler (Highlight to read) div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
)
|
| WEEKS_ALT_FLOAT |
Spoiler (Highlight to read) div(
float(div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
)),
float(7)
)
|
| WEEKS_DOLLAR_INT |
Spoiler (Highlight to read) mul(
div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
variables('dollarVAR')
)
|
|
JSON without expressions
{
"days": DAYS_INT,
"hasWeeks": HAS_WEEKS_BOOL,
"weeks": WEEKS_INT,
"weeksAlt": WEEKS_ALT_INT,
"weeksAltFloat": WEEKS_ALT_FLOAT,
"weeksDollar": WEEKS_DOLLAR_INT
}
Where:
DAYS_INT - Is the integer value of the difference in days
HAS_WEEKS_BOOL - Indicates if there's enough days to make a week
WEEKS_INT - Only provides an integer count of weeks if there's at least 7 days (rounding down)
WEEKS_ALT_INT - Provides an integer count of weeks (rounding down)
WEEKS_ALT_FLOAT - Provides an exact count of weeks
WEEKS_DOLLAR_INT - Multiplies the amount of weeks by a float type Variable called dollarVAR
Expressions
DAYS_INT
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
)
HAS_WEEKS_BOOL
greaterOrEquals(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
)
WEEKS_INT
if(
greaterOrEquals(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
null
)
WEEKS_ALT_INT
div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
)
WEEKS_ALT_FLOAT
div(
float(div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
)),
float(7)
)
WEEKS_DOLLAR_INT
mul(
div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
variables('dollarVAR')
)
|
| Copy/Paste |
Spoiler (Highlight to read) {
"days": @{div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
)},
"hasWeeks": @{greaterOrEquals(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
)},
"weeks": @{if(
greaterOrEquals(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
null
)},
"weeksAlt": @{div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
)},
"weeksAltFloat": @{div(
float(div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
)),
float(7)
)},
"weeksDollar": @{mul(
div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
variables('dollarVAR')
)}
}
{
"days": @{div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
)},
"hasWeeks": @{greaterOrEquals(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
)},
"weeks": @{if(
greaterOrEquals(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
null
)},
"weeksAlt": @{div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
)},
"weeksAltFloat": @{div(
float(div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
)),
float(7)
)},
"weeksDollar": @{mul(
div(
div(
sub(
max(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
),
min(
createArray(
ticks(
outputs('Get_response_details')?['body/rf7c97046e5d6431085761868856019cb']
),
ticks(
outputs('Get_response_details')?['body/re43df35f36244cd2a201d30d20569fe7']
)
)
)
),
864000000000
),
7
),
variables('dollarVAR')
)}
}
|
|