We keep missing Jobs that were recently changed in status or that had their amounts updated. This is because the “updated at” filter is not available in Housecall Pro’s API, and we are filtering only on the “schedule start” field.
Since we can sort Jobs by the “updated_at” field and pagination is an option, we can sort them in descending order. So the first page will always be the latest updated Jobs.
The problem is that all Jobs will always appear in the results because we are not filtering. A workaround is to set a limit on the number of pages to search (this depends on the account). Then, filter out the Jobs that were updated before the “last date pointer”. This can be done in batches and within a Code Step to avoid creating many tasks.
We can now pull updated Jobs in Housecall Pro without the “updated at” filter option.
A sample application of this workaround can be found in this Zap. https://zapier.com/editor/335461360/published