Forum Discussion

Phocas's avatar
Phocas
Contributing User
4 years ago
Solved

High Water Mark - suggestions for Incremental extraction of Sales Invoice Data (lastModified does not work)

Hi  I am looking to incrementally load transactions from  {{company_file_uri}}/{{company_file_id}}/Sale/Invoice/Item?$filter=Date ge datetime'{{HWMvalue}}$orderby=LastModified   the High water Ma...
  • gavin12345's avatar
    4 years ago

    Hi Phocas 

     

    Just in relation to the date 1 Jan 1970, this is the default Last Modified date for all transactions that were in the file at time of upgrade from v19. Anything entered in Ar2021 should have a specific date.

     

    Regards

    Gavin