Parts

Next Plus uses 2 queries to fetch parts from priority -

1. Changes - once a minute
2. Full sync - once a day

Queries:

Changes:

/PART?$select=PARTNAME,SERNFLAG,TAKEFLAG,UDATE&$filter=UDATE ${op} ${lastDate}

Full Sync:

/PART?$expand=PARTALT_SUBFORM($select=ALTNAME,ALT),PARTARC_SUBFORM($select=SONNAME,SONQUANT,INFOONLY),PARTREV_SUBFORM($expand=PARTREVEXTFILES_SUBFORM($select=EXTFILEDES,EXTFILENUM,SUFFIX)),PARTEXTFILE_SUBFORM($select=EXTFILEDES,EXTFILENUM,SUFFIX)

/PROCESS?$top=1&$select=PROCNAME&$filter=PROC eq -8

/FAMILY_LOG?$select=FAMILYNAME,FAMILYDESC

/UNIT?$select=UNITNAME,UNITDES

Frequency:

Changes - Every minute

Full - Every day

Pagination (Chunks):

500

Work Orders

To pull work orders deltas from Priority, Next Plus uses 4 queries on data that affect the work orders:

1. The work order itself (open and released )(GET_WORKORDER_AND_KIT_ITEMS_CHANGES)