Trying to filter createReplica by date with an ArcREST Script

DerekWaggenspack

Ok, so I am trying to use the ArcRest API to try and export a feature class with attachments to a File Geodatabase.  I believe because my file is too large, it is failing out.  I have copied the feature service and tried the export script and it works on the copied one [with far fewer data points].  I wondered if there was a way I could filter the data by last edited date.  I use editor tracking on an ArcGIS Online Hosted Layer.  In the request, how would I set the filter to only get stuff newer than yesterday?   Thanks in advance!

RandyBurton

See the script in this thread for an idea: query-minimum-date-using-rest-service. Note the comment on line 35. You would use the EditDate field.

Have you checked this page: Sync workflow examples?  The topic Workflow Example 4: Setting up sync using LayerQueries contains this:

&nbsp;&nbsp;&nbsp; <SPAN class="string token">"layerQueries"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"1"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"queryOption"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"useFilter"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"useGeometry"</SPAN><SPAN class="punctuation token">:</SPAN> false<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"where"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"region = 'Southwest'"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The "where" would be edited to something like:

<SPAN class="string token">"where"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"EditDate >= DATE '2016-05-29 18:30:00'"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>