Predefined Calculation: Whitespace PowerSuite - Street Complete

Summary

This formula will returns true or false, depending on whether a street has any InCabLog records for the given date.

Inputs

This formula requires 4 inputs to be passed through to it:

Non Collection Reason Inputs

  • the USRN of the property

    The unique identifier of the street to search for.

  • the Date From

    A date to use as the beginning of the search period, in YYYY-MM-DD format. This date can be populated from the Date Plus/Minus Days Logic

  • the Date To

    A date to use as the end of the search period, in YYYY-MM-DD format. This date can be populated from the Date Plus/Minus Days Logic. Whitespace PowerSuite Web Services will set the time on any date you pass into it to 00:00:00. In order to check street collections for today are complete you will need to set Date To to tomorrow.

Return values

Value Description
true If there are InCabLog records for the given date period and USRN
false If there are no logs, or an error occurred.

Formula Logic

  1. A check is made to see if the integration has been enabled in the Settings > Integrations page. If the integration is not enabled the formula returns N/A.

  2. A call to Whitespace PowerSuite's GetInCabLogs endpoint is made, passing the USRN, Date From and Date To inputs.

  3. If some logs are returned, the return value is true. Otherwise, false is returned.

results matching ""

    No results matching ""