Method Community

Hi, I am trying to sync over my Customers table to my own database to allow faster/more complex searches than the API allows and I am running into a problem. How do I know the latest rows to fetch from Method? What I am currently trying to do is get all rows with TimeModifiedAccounting > max(TimeModifiedAccounting) in my local table. But now I am finding that there are a bunch of Customer rows with TimeModifiedAccounting as null. Under what conditions is TimeModifiedAccounting null?

Would it be better to get all rows with RecordID > my highest RecordID? The reason why I did not do this in the first place is that I am afraid somebody will edit an existing record; I would want to sync over that updated information, but presumably the RecordID will still be the same.

Thanks!

Gary

Hi gbisaga,

Off the top of my head there are 2 possibilities. 1. The customer has not synced to quickbooks yet. 2. Check the field entity type, if it is a 'Customer Lead' and not a 'Customer' it won't sync to QB.

Dave