Skip to main content

Whitespace PowerSuite - Street Complete

  • What is it? 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:

  • 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​

ValueDescription
trueIf there are InCabLog records for the given date period and USRN
falseIf 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.