<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">To second the Andrius' answer:</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">On 2024-02-01 15:14, Goldberg, Matt
(Matthew G) wrote:<br>
</div>
<blockquote type="cite"
cite="mid:BN7PR06MB606690487B0856D1C606EF6589432@BN7PR06MB6066.namprd06.prod.outlook.com">
<p class="MsoNormal">I’m not sure if this is the correct email
address to send this question to, but I’m wondering if there’s a
way to determine whether or not there is diffraction data for a
given ID. I know you can go to, e.g.,
<a class="moz-txt-link-freetext" href="https://www.crystallography.net/cod/2002926.hkl">https://www.crystallography.net/cod/2002926.hkl</a> to get the
diffraction data if it exists, but I’m wondering if there’s a
better way than trying to obtain the diffraction data and
checking if a 404 error is returned. Nothing is jumping out at
me in the REST API documentation to suggest there would be a way
to do it through there.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Is there some way to do this? If I were to
use the SQL option, would there be an easy way to do it that
way?<o:p></o:p></p>
<p class="MsoNormal"><o:p></o:p></p>
</blockquote>
<p>If you are happy to use SQL (MySQl or MariaDB), then the
following query should answer your question:</p>
<p>
<blockquote type="cite"><font face="monospace">mysql -u cod_reader
-h sql.crystallography.net cod -e 'select file from data where
flags like "%has fobs%"'</font></blockquote>
</p>
<p>Not that there are also many coordinate CIFs that have SHELX HKL
file embedded in them; these do not yet show up in the query just
mentioned, but we working on it :)</p>
<p>HTH,<br>
Saulius<br>
</p>
<pre class="moz-signature" cols="72">--
Dr. Saulius Gražulis
Vilnius University Institute of Biotechnology, Saulėtekio al. 7
LT-10257 Vilnius, Lietuva (Lithuania)
mobile: (+370-684)-49802, (+370-614)-36366
</pre>
<br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</body>
</html>