<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Andrew,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I got this working a few yesrs ago in Perl cgi, with a PHP wrapper to fetch the records 50 at a time from our DB, and write the results back to the DB. I won’t post it all here, but the core of it is below,
and I can send you the rest privately if you want, to spare myself the embarrassment of exposing my quick-and-dirty code to ridicule.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">This is the core of it, fetchLAMR function, that takes any of UT, PMID, or DOI, and returns the XML from the Web service. You’ll need to change the email address and app-id string in the src parameter of the
XML, obviously. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Hope it helps<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Andy <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-GB">Andy Reid<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-GB">Research Information Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-GB">Executive Office, Room G43<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-GB">London School of Hygiene and Tropical Medicine<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-GB">Keppel St, LONDON, WC1E 7HT<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-GB">0207-927-2618 (Internal x2618)
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">USAGE: <a href="http://myserver.ac.uk/cgi-bin/testLAMR.pl?DOI=10.1234/123abc789xyz">
http://myserver.ac.uk/cgi-bin/testLAMR.pl?DOI=10.1234/123abc789xyz</a> (and/or &PMID= and/or &UT =)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">==========================<o:p></o:p></span></p>
<div style="mso-element:para-border-div;border:none;border-bottom:double windowtext 2.25pt;padding:0cm 0cm 1.0pt 0cm">
<p class="MsoNormal" style="border:none;padding:0cm"><span style="color:#1F497D">testLAMR.pl<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D">#######################################################################################<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"># MAIN<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">#######################################################################################<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">use CGI;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">use CGI::Carp qw(fatalsToBrowser);<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">use LAMR; ########### LAMR.pm perl module below ############<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">my $query=new CGI;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">########################### takes any or all of the following in the query string<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$UT = $query->param('UT');<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$PMID= $query->param('PMID');<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$DOI= $query->param('DOI');<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">############$backref=$query->param('back'); ### used by wrapper to redirect back to calling page<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">######## OUTPUT ######################<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">print $query->header('text/xml');<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">#print $query->start_html("LAMR citation details");<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$XML .= &fetch_LAMR($UT,$PMID,$DOI);<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">{<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$XML =~ m{<val name=\"timesCited\">(\d*)<\/val>}; ### find the bit of the response that you want by crude Regexp<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">print “$DOI :times cited= “. $timesCited=$1;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">}<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">### ##################################################################################################################################<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">==========================<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">LAMR.pm<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">==========================<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">package LAMR;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">require Exporter;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">our @ISA= qw(Exporter);<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">our @EXPORT = qw(fetch_LAMR);<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">our @EXPORT_OK=qw();<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">our $VERSION = 1.00;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">sub fetch_LAMR{<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> my ($UT,$PMID,$DOI) = @_;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">use LWP::UserAgent;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">use HTTP::Request::Common;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">my $ua = new LWP::UserAgent;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">################################################################################################<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">################## XML CONTENT ####################################################################<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">###############################################################################################<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">$XMLrequest =<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">qq#<?xml version="1.0" encoding="UTF-8" ?>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><request xmlns="http://www.isinet.com/xrpc41"
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">src="app.id=LSHTM-fetchLAMR,env.id=v004,partner.email=andy.reid.at.lshtm.ac.uk" >
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <fn name="LinksAMR.retrieve"> <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <list> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><!-- WHO'S REQUESTING --> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <map> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </map> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><!-- WHAT'S REQUESTED --> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <map> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <list name="WOS"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val>timesCited</val> <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val>ut</val><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val>pmid</val><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val>doi</val><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val>sourceURL</val> <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val>citingArticlesURL</val>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val>relatedRecordsURL</val>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </list> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </map> <!--end "return_data" -->
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><!-- LOOKUP DATA --> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <map> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><!-- QUERY "cite_id1" --> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <map name="cite_id"> <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val name="ut">$UT</val>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val name="pmid">$PMID</val>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <val name="doi">$DOI</val>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </map> <!-- end of cite_id-->
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </map> <!-- end of citations -->
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </list> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </fn> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"></request> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">#;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">####################################################################################<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">####################################################################################<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">my $response =$ua->request(POST 'http://ws.isiknowledge.com/cps/xrpc',
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Content_Type => 'text/html',<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Content => $XMLrequest);<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">my $content = $response->content;
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"># $content =~ m/<val name=\"pmid\">(\d*)<\/val>/;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">#return $1;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"># return grep( /pmid|ut|doi|message/, split(/^/,$content));<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> return $content;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">}<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">1;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:EN-GB">From:</span></b><span lang="EN-US" style="mso-fareast-language:EN-GB"> eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk]
<b>On Behalf Of </b>Andrew Beeken<br>
<b>Sent:</b> 23 May 2016 10:10<br>
<b>To:</b> eprints-tech@ecs.soton.ac.uk<br>
<b>Subject:</b> [EP-tech] Thomson Reuters API/PHP<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Don’t know if this is the ideal forum for this but I’ve been banging my head against a brick wall for the last week trying to get this working. We have access to the full Thomson Reuters WoS Web Services API through our InCites subscription
and I’m trying to build a PHP script to dive in and grab citation counts for records based on DOI. I’m struggling a bit, however; the API uses SOAP which I’m really not familiar with and trying to use the (somewhat confusing) TR documentation to hack things
together, extrapolating from online examples, is leading to multiple dead ends with tech support from TR being unable to provide any language specific assistance. Has anyone successfully integrated this through PHP or have any experience using SOAP that could
give me a few pointers?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Talk soon!<o:p></o:p></p>
<p class="MsoNormal">Andrew Beeken<o:p></o:p></p>
<p class="MsoNormal">Research Information Systems Developer<o:p></o:p></p>
<p class="MsoNormal">University of Lincoln<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New Roman",serif;mso-fareast-language:EN-GB"><br>
<b>The University of Lincoln, located in the heart of the city of Lincoln, has established an international reputation based on high student satisfaction, excellent graduate employment and world-class research.</b></span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;mso-fareast-language:EN-GB"><br>
The information in this e-mail and any attachments may be confidential. If you have received this email in error please notify the sender immediately and remove it from your system. Do not disclose the contents to another person or take copies.<br>
<br>
Email is not secure and may contain viruses. The University of Lincoln makes every effort to ensure email is sent without viruses, but cannot guarantee this and recommends recipients take appropriate precautions.<br>
<br>
The University may monitor email traffic data and content in accordance with its policies and English law. Further information can be found at:
<a href="http://lincoln.ac.uk/legal">http://lincoln.ac.uk/legal</a>.</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
</div>
</div>
</body>
</html>