Using sinceDate

The sinceDate key allows you to run queries to retrieve data updated after the specified date.

The sinceDate key requires that data is available in one of the following columns:

• For P6 tables: UPDATE_DATE, LASTUPDATEDATE, CHANGEDATE, UPDATEDATE
• For Unifier tables: LASTMODIFIEDDATE, LASTUPDATEDATE, LAST_MODIFIED_DATE, LAST_MODIFY_DATE, LAST_UPDATED, MODIFIEDDATE, MODIFIED_DATE, MODIFYDATE, MODIFY_DATE, UPDATEDATE, UPDATED_DATE, UPDATE_DATE, UUU_RECORD_LAST_UPDATE_DATE

Example Simple Query Using sinceDate

{
  "name": "My Activities",
  "pageSize":"7000",
  "sinceDate": "2010-11-15 14:27:49 -0500",
       "tables": [
                   {
                     "tableName": "TASK",
                     "columns": [
                          "PROJ_ID",
                          "TASK_ID",
                          "TASK_NAME",
                          "TASK_TYPE",
                          "STATUS_CODE",
                          "ACT_START_DATE",
                          "ACT_END_DATE"
                                ]
                    }
                 ]
     
}