<div dir="ltr"><div dir="ltr"><div>Hi Steve,</div><div><br></div><div>I'm a little late to this thread, but I wanted to note that depending on your exact use case, the built-in OAI-PMH endpoint might be useful. You can specify the exact time range of modified times desired; choose MARC, EAD, or DC (all in XML though); set whether the entire record is downloaded or just the header; and choose whether to include deleted records. This is what we use to publish collection-level records to our catalog overnight, so I'd be happy to talk more about it if helpful.<br></div><div></div><div><br></div><div><a href="https://github.com/archivesspace/tech-docs/blob/master/architecture/oai-pmh.md">https://github.com/archivesspace/tech-docs/blob/master/architecture/oai-pmh.md</a></div><div><br></div><div>Kevin<br></div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Nov 8, 2019 at 12:01 PM Steve Mattison <<a href="mailto:smattiso@nd.edu">smattiso@nd.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">This is very helpful.<div>Thank you so much for passing this along.</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Nov 8, 2019 at 11:53 AM Custer, Mark <<a href="mailto:mark.custer@yale.edu" target="_blank">mark.custer@yale.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div>
<p class="MsoNormal">And Steve, now that I’m looking at your question, I *<b>think</b>* that everything already mentioned should point you in the right direction for doing that search with the API.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">It sounds like your use case might be aimed at performing very granular updates, but in case it’s helpful, here’s the approach that Hudson Molonglo (thanks James, et al.!) provided for us so that we can figure out which finding aids to
export, adding a new endpoint named “/resource-update-feed” via a plugin. See <a href="https://github.com/hudmol/archivesspace_export_service/tree/master/backend" target="_blank">
https://github.com/hudmol/archivesspace_export_service/tree/master/backend</a> . In this case, we wanted to know not just when a resource or archival record had been edited in a finding aid, but when any of the records that link to it were (e.g. the archival
object wasn’t edited, but an associated digital object was). We use that endpoint as part of a larger service, but I’ve also found it useful in other contexts.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Additionally, it was important to figure out which records had been unpublished or suppressed since a particular time, which is why I like this approach, since the idea is that you send a request to that new endpoint, and it will return
to you a list of IDs that need to be added (either because they’re brand new or because they’ve been edited), as well as a list of IDs that should be removed. Again, this use case was just for Resource records, but I imagine that a similar approach would
be useful for other record types.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Mark<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [mailto:<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Seth Shaw<br>
<b>Sent:</b> Friday, 08 November, 2019 11:26 AM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Help using AS Restful API to query<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Thanks, James and Mark. I appreciate the additional pointers. (And sorry for high-jacking your thread, Steve!)<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Fri, Nov 8, 2019 at 8:20 AM Custer, Mark <<a href="mailto:mark.custer@yale.edu" target="_blank">mark.custer@yale.edu</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt">
<div>
<div>
<p class="MsoNormal">Seth,
<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Here’s another example:<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">search?type[]=archival_object&page=1&aq=<u></u><u></u></p>
<p class="MsoNormal" style="background:white none repeat scroll 0% 0%">
<span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">{</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"query"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">{</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"op"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:blue;background:white none repeat scroll 0% 0%">"AND"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"subqueries"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">[</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">{</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"field"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:blue;background:white none repeat scroll 0% 0%">"keyword"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"value"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:blue;background:white none repeat scroll 0% 0%">"39002102378974"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"jsonmodel_type"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:blue;background:white none repeat scroll 0% 0%">"field_query"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"negated"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(0,0,102);background:white none repeat scroll 0% 0%">false</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"literal"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(0,0,102);background:white none repeat scroll 0% 0%">false</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">}</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">{</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"field"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:blue;background:white none repeat scroll 0% 0%">"types"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:yellow none repeat scroll 0% 0%">"value"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:yellow none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:yellow none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:blue;background:yellow none repeat scroll 0% 0%">"pui"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:yellow none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"jsonmodel_type"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:blue;background:white none repeat scroll 0% 0%">"field_query"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:yellow none repeat scroll 0% 0%">"negated"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:yellow none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:yellow none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(0,0,102);background:yellow none repeat scroll 0% 0%">true</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">}</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">]</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"jsonmodel_type"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:blue;background:white none repeat scroll 0% 0%">"boolean_query"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">}</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(30,100,150);background:white none repeat scroll 0% 0%">"jsonmodel_type"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(100,0,50);background:white none repeat scroll 0% 0%">:</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%">
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:blue;background:white none repeat scroll 0% 0%">"advanced_query"</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:black;background:white none repeat scroll 0% 0%"><br>
</span><span style="font-size:12pt;font-family:"Times New Roman",serif;color:rgb(150,0,0);background:white none repeat scroll 0% 0%">}</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">In that case, for example, we might have one archival object where that barcode has been applied. In the Solr index, there will be two documents, if and only if that record has
been published. But, we can exclude the PUI document in the result set with that second part of the subquery.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Mark<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><b>From:</b>
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [mailto:<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Seth Shaw<br>
<b>Sent:</b> Friday, 08 November, 2019 11:13 AM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Help using AS Restful API to query<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<p class="MsoNormal">That might be it. We don't use the PUI for patron access; but we do still have it left on as the staff occasionally look at it. Certainly something to investigate.<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Regardless, either the API should use
<i>one</i> index consistently, have a documented filter (I don't see one there) and/or give some other obvious indication as to where a result came from.<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">On Fri, Nov 8, 2019 at 8:02 AM James Bullen <<a href="mailto:james@hudmol.com" target="_blank">james@hudmol.com</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt">
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<p class="MsoNormal">Hi Seth,<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I’m not seeing that. Could it be you’re seeing pui docs as well - the instance I’m testing on has the pui turned off.<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Cheers,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">James<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12pt"><u></u> <u></u></p>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<div>
<p class="MsoNormal">On Nov 8, 2019, at 10:51 AM, Seth Shaw <<a href="mailto:seth.shaw@unlv.edu" target="_blank">seth.shaw@unlv.edu</a>> wrote:<u></u><u></u></p>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">James, I was hoping using the filter as you described would remove the duplicate results issue I was having by using the advanced query compound search; but I'm seeing the same
thing as before. <u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Running the search via the API: 'archivestest:8089/search?type[]=archival_object&page=1&filter={"query":{"comparator":"greater_than","field":"system_mtime","value":"2019-10-02","jsonmodel_type":"date_field_query"}}'
returns, in part, `{"page_size":10,"first_page":1,"last_page":874,"this_page":1,"offset_first":1,"offset_last":10,"total_hits":8732,` ...<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Whereas the SQL query `SELECT count(*) FROM archival_object WHERE system_mtime > '2019-10-02';` is returning "4369" (half the results of the REST query).<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Have you run into this issue before?<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">On Fri, Nov 8, 2019 at 7:34 AM James Bullen <<a href="mailto:james@hudmol.com" target="_blank">james@hudmol.com</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt">
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<p class="MsoNormal">Something like this works for me:<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">/search type[]=resource type[]=archival_object page=1 filter={"query":{"comparator":"greater_than","field":"system_mtime","value":"2019-10-02","jsonmodel_type":"date_field_query"}}<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12pt"><u></u> <u></u></p>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<div>
<p class="MsoNormal">On Nov 8, 2019, at 10:24 AM, Seth Shaw <<a href="mailto:seth.shaw@unlv.edu" target="_blank">seth.shaw@unlv.edu</a>> wrote:<u></u><u></u></p>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">To do this you need to use the advanced query parameter which, unfortunately, is not well documented. There are a few email threads that describe using the advanced search though:<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Fhtdig%2Farchivesspace_users_group%2F2015-June%2F001734.html&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973732409&sdata=4HOPKRSdqZZdb%2FZ15TJsDOQ%2B%2FxQrFf8Msy9nE77wGQc%3D&reserved=0" target="_blank">http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2015-June/001734.html</a><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I've formulated queries like you describe before (I'll have to dig through my notes to see if I can find it again); but the result set was consistently giving me back duplicate
results for some unknown reason; so I stopped using it. <u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Ideally, we would be able to add a 'modified_since' parameter to each entity's endpoint to get the most recent set. The capability exists in the code, but hasn't been exposed to
the REST end-point. I've submitted a ticket that will hopefully lead to this being resolved: <a href="https://archivesspace.atlassian.net/browse/ANW-962?filter=-2" target="_blank">https://archivesspace.atlassian.net/browse/ANW-962?filter=-2</a>.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">On Fri, Nov 8, 2019 at 7:07 AM Steve Mattison <<a href="mailto:smattiso@nd.edu" target="_blank">smattiso@nd.edu</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt">
<div>
<div>
<p class="MsoNormal">Community,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I'm new to using ArchivesSpace, and new to using the AS API. I need to use the API to search within a given repository to find records that have been modified after a particular
time (e.g. modified within the last 48 hours). (We then want to export metadata related to those resources or archival_objects for a project we're working on.)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I have found the documentation for
<a href="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Farchivesspace.github.io%2Farchivesspace%2Fapi%2F%3Fshell%23search-this-repository&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973752395&sdata=7WZLNWnShXavBBsLzHPBDZzLutLClo%2BwNeevuUvd9eI%3D&reserved=0" target="_blank">
search-this-repository</a>, but don't know how to formulate a query to find all resources and/or archival_objects where the system_mtime is after a particular time. I would be fine with performing two searches, one for resources and one for archival_objects,
if that is required.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Any help with the syntax for the query would be much appreciated.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks for your help.<u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<p class="MsoNormal">--
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-family:Arial,sans-serif">Steve Mattison</span></b><u></u><u></u></p>
<div>
<p class="MsoNormal"><i><span style="font-family:Arial,sans-serif">Lead Software Engineer, Digital Library Technologies</span></i><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><i><span style="font-family:Arial,sans-serif">Hesburgh Libraries</span></i><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal"><b><span style="font-family:Arial,sans-serif">University of Notre Dame</span></b><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif">271 Hesburgh Library</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif">Notre Dame, IN 46556-5629</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-family:Arial,sans-serif">o:</span></b><span style="font-family:Arial,sans-serif"> 574-631-8559</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-family:Arial,sans-serif">e: </span></b><a href="mailto:steve.mattison@nd.edu" target="_blank"><span style="font-family:Arial,sans-serif;color:rgb(17,85,204)">steve.mattison@nd.edu</span></a><u></u><u></u></p>
</div>
</div>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif">
[https: //<a href="http://docs.google.com/uc?export=download&id=1eLUXKKJMijoIFzQtpJutmM1uLHON9ZDt&revid=0B-gl36FdlSuTV2ZPM1NBek5HamNiOWN1UllhT3d2VWtCU3hjPQ" target="_blank">docs.google.com/uc?export=download&id=1eLUXKKJMijoIFzQtpJutmM1uLHON9ZDt&revid=0B-gl36FdlSuTV2ZPM1NBek5HamNiOWN1UllhT3d2VWtCU3hjPQ</a>] </span><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
<br>
<br>
!DSPAM:5dc588a9250937848916637!<u></u><u></u></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal">!DSPAM:5dc58f16257571993821028! _______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
<br>
<br>
!DSPAM:5dc58f16257571993821028!<u></u><u></u></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><u></u><u></u></p>
</blockquote>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><u></u><u></u></p>
</blockquote>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><b><font face="arial, sans-serif">Steve Mattison</font></b><div><i><font face="arial, sans-serif">Lead Software Engineer, Digital Library Technologies</font></i></div><div><i><font face="arial, sans-serif">Hesburgh Libraries</font></i></div><div><i><font face="arial, sans-serif"><br></font></i><div><div><b><font face="arial, sans-serif">University of Notre Dame</font></b></div><div><font face="arial, sans-serif">271 Hesburgh Library</font></div><div><font face="arial, sans-serif">Notre Dame, IN 46556-5629</font></div><div><font face="arial, sans-serif"><b>o:</b> 574-631-8559</font></div><div><font face="arial, sans-serif"><b>e: </b><a href="mailto:steve.mattison@nd.edu" style="color:rgb(17,85,204)" target="_blank">steve.mattison@nd.edu</a></font></div></div></div></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif"></font></div></div></div></div></div></div></div></div></div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature">Kevin Schlottmann<br>Head of Archives Processing<br>Rare Book & Manuscript Library<br>Butler Library, Room 801<br>Columbia University<br>535 W. 114th St., New York, NY 10027<br>(212) 854-8483</div></div>