[Rets-dev] Retrieve only changed photos?

[Jonathan Heintzeman]

Sure enough they are there under the names:
L_PictureCount,L_Last_Photo_updt

I found them right there in the residential class tables.

Meta Data query of residential (RE_1) class table
?Type=METADATA-TABLE&ID=Property:RE_1&Format=COMPACT&rets-version=rets/1.5

Check One Listing
?format=Compact&query=(L_ListingID=164091)&querytype=DMQL2&searchtype=Property&select=L_ListingID,L_PictureCount,L_Last_Photo_updt&rets-version=rets/1.5&class=RE_1

Get All Changed since [Date]
?format=Compact&query=(L_Last_Photo_updt=2007-08-12T16:23:00-NOW)&searchtype=Property&querytype=DMQL2&select=L_ListingID,L_PictureCount,L_Last_Photo_updt&rets-version=rets/1.5&class=RE_1

You may wonder why I use the
query=(L_Last_Photo_updt=2007-08-12T16:23:00-NOW) in the between query
type.Well for some reason adding a + to the end of the query always returns
nothing. I don't know why.


I can't tell you how many times I looked for them and missed them some how.
Thanks so much for your help.

On 8/13/07, JP Fielding <jp.fielding at threewide.com> wrote:
>
> as neither option is part of the RETS spec proper, you wouldnt see it in
> any rets documentation.  as i stated before, this is something the rets
> object stuff does not manage.   but an example would be
>
> NOTE 1: replace MLSNUM with whatever the resource key is for the
> particular resource
> NOTE 2: you might want to include (PHOTOCOUNT=0+) in the query, although,
> someone deleting their all of their photos would be missed.
>
> select=MLSNUM
> query=(PHOTODATE=2007-08-12T16:23:00+)
>
> this would give you the mlsnum of listings with photos that have a
> modified to at least one of its photos, then iterate over them and pull them
>
>
> ./GetObject?Type=Photo&Resource=PROPERTY&ID=MLSNUM:*
>
> so basically, give the mlsnubers for listings with at least one photo
> changed since aug 12 2007... then iterate over these mlsnums and pull them
> (unfortunately, all photos per listing as this is the closest granularity
> this option offers)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rets.org/pipermail/rets-dev/attachments/20070815/78029e0f/attachment.html