Raw Data WebServices with Incremental Replication
Raw Data WebServices with Incremental Replication: Overview
Raw Data WebServices can retrieve data from any Landmark BusinessClass (table). The data can be returned in an XML, JSON or CSV format. The primary url parameters are BusinessClass name, a list of field names and an optional filter. An incremental replication extract can be run by specifying the FromTimeStamp (_fts) and ToTimeStamp (_tts) parameters. If the from time stamp parameter is specified the extract will only retrieve records that have changed after the time stamp provided and up to the optional to time stamp parameter. When replicating related sets of records it is important to specify the same to time stamp for all the extract calls. A replication extract will always have a standard field added to the beginning of the returned fields list to indicate whether the record was added, changed or deleted since the from time stamp. To initially load a table, use a value of “0” for _fts.
Related Replicates
A business class can be replicated in a de-normalized form. For example, ItemLocation has a one-to-one relation to Item. To replicate this combination in a single web service call ItemLocation can be replicated with a set of ItemLocation fields as well as Item fields. By default the _fts parameter will only retrieve the changed ItemLocation records. However, if an Item record was changed it is important to retrieve all the related ItemLocation records whether they have changed or not since _fts. This can be done by specifying the “_rrs” (related replicates) parameter with the Relation/KeyField name from ItemLocation to Item. In this case: “_rrs=Item” as “Item” is the key field from ItemLocation to Item. Multiple related replicates can be specified.
Date Format to be used with _fts and _tts - all values are in UTC time
2000022605584551YYYYMMDDHHMMSSFF