Protected PALFA Web Services


Click here for a complete list of operations.

QueryDatabase

Ad-hoc database query.

Test

The test form is only available for requests from the local machine.

SOAP

The following is a sample SOAP request and response. The placeholders shown need to be replaced with actual values.

POST /PALFA_WS/protected_WS.asmx HTTP/1.1
Host: arecibo.tc.cornell.edu
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://arecibo.tc.cornell.edu/PALFA_WS/QueryDatabase"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <QueryDatabase xmlns="http://arecibo.tc.cornell.edu/PALFA_WS">
      <username>string</username>
      <password>string</password>
      <sqlText>string</sqlText>
    </QueryDatabase>
  </soap:Body>
</soap:Envelope>
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <QueryDatabaseResponse xmlns="http://arecibo.tc.cornell.edu/PALFA_WS">
      <QueryDatabaseResult ID="ID" version="v1.0">
        <DESCRIPTION>string</DESCRIPTION>
        <DEFINITIONS>
          <COOSYS ID="ID" equinox="token" epoch="token" system="eq_FK4 or eq_FK5 or ICRS or ecl_FK4 or ecl_FK5 or galactic or supergalactic or xy or barycentric or geo_app" />
          <PARAM ID="ID" unit="token" datatype="boolean or bit or unsignedByte or short or int or long or char or unicodeChar or float or double or floatComplex or doubleComplex or single" precision="token" width="positiveInteger" ref="IDREF" name="token" ucd="token" value="string" arraysize="token">
            <DESCRIPTION>string</DESCRIPTION>
            <VALUES xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
          </PARAM>
        </DEFINITIONS>
        <INFO />
        <INFO />
        <RESOURCE name="token" ID="ID" type="results or meta">
          <DESCRIPTION>string</DESCRIPTION>
          <INFO />
          <INFO />
          <COOSYS ID="ID" equinox="token" epoch="token" system="eq_FK4 or eq_FK5 or ICRS or ecl_FK4 or ecl_FK5 or galactic or supergalactic or xy or barycentric or geo_app" />
          <COOSYS ID="ID" equinox="token" epoch="token" system="eq_FK4 or eq_FK5 or ICRS or ecl_FK4 or ecl_FK5 or galactic or supergalactic or xy or barycentric or geo_app" />
          <PARAM ID="ID" unit="token" datatype="boolean or bit or unsignedByte or short or int or long or char or unicodeChar or float or double or floatComplex or doubleComplex or single" precision="token" width="positiveInteger" ref="IDREF" name="token" ucd="token" value="string" arraysize="token">
            <DESCRIPTION>string</DESCRIPTION>
            <VALUES xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
          </PARAM>
          <PARAM ID="ID" unit="token" datatype="boolean or bit or unsignedByte or short or int or long or char or unicodeChar or float or double or floatComplex or doubleComplex or single" precision="token" width="positiveInteger" ref="IDREF" name="token" ucd="token" value="string" arraysize="token">
            <DESCRIPTION>string</DESCRIPTION>
            <VALUES xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
          </PARAM>
          <LINK ID="ID" content-role="query or hints or doc" content-type="token" title="string" value="string" href="anyURI" gref="token" action="anyURI" />
          <LINK ID="ID" content-role="query or hints or doc" content-type="token" title="string" value="string" href="anyURI" gref="token" action="anyURI" />
          <TABLE ID="ID" name="token" ref="IDREF">
            <DESCRIPTION>string</DESCRIPTION>
            <FIELD xsi:nil="true" />
            <FIELD xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
            <DATA xsi:nil="true" />
          </TABLE>
          <TABLE ID="ID" name="token" ref="IDREF">
            <DESCRIPTION>string</DESCRIPTION>
            <FIELD xsi:nil="true" />
            <FIELD xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
            <DATA xsi:nil="true" />
          </TABLE>
          <RESOURCE name="token" ID="ID" type="results or meta">
            <DESCRIPTION>string</DESCRIPTION>
            <INFO xsi:nil="true" />
            <INFO xsi:nil="true" />
            <COOSYS xsi:nil="true" />
            <COOSYS xsi:nil="true" />
            <PARAM xsi:nil="true" />
            <PARAM xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
            <TABLE xsi:nil="true" />
            <TABLE xsi:nil="true" />
            <RESOURCE xsi:nil="true" />
            <RESOURCE xsi:nil="true" />
          </RESOURCE>
          <RESOURCE name="token" ID="ID" type="results or meta">
            <DESCRIPTION>string</DESCRIPTION>
            <INFO xsi:nil="true" />
            <INFO xsi:nil="true" />
            <COOSYS xsi:nil="true" />
            <COOSYS xsi:nil="true" />
            <PARAM xsi:nil="true" />
            <PARAM xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
            <TABLE xsi:nil="true" />
            <TABLE xsi:nil="true" />
            <RESOURCE xsi:nil="true" />
            <RESOURCE xsi:nil="true" />
          </RESOURCE>
        </RESOURCE>
        <RESOURCE name="token" ID="ID" type="results or meta">
          <DESCRIPTION>string</DESCRIPTION>
          <INFO />
          <INFO />
          <COOSYS ID="ID" equinox="token" epoch="token" system="eq_FK4 or eq_FK5 or ICRS or ecl_FK4 or ecl_FK5 or galactic or supergalactic or xy or barycentric or geo_app" />
          <COOSYS ID="ID" equinox="token" epoch="token" system="eq_FK4 or eq_FK5 or ICRS or ecl_FK4 or ecl_FK5 or galactic or supergalactic or xy or barycentric or geo_app" />
          <PARAM ID="ID" unit="token" datatype="boolean or bit or unsignedByte or short or int or long or char or unicodeChar or float or double or floatComplex or doubleComplex or single" precision="token" width="positiveInteger" ref="IDREF" name="token" ucd="token" value="string" arraysize="token">
            <DESCRIPTION>string</DESCRIPTION>
            <VALUES xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
          </PARAM>
          <PARAM ID="ID" unit="token" datatype="boolean or bit or unsignedByte or short or int or long or char or unicodeChar or float or double or floatComplex or doubleComplex or single" precision="token" width="positiveInteger" ref="IDREF" name="token" ucd="token" value="string" arraysize="token">
            <DESCRIPTION>string</DESCRIPTION>
            <VALUES xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
          </PARAM>
          <LINK ID="ID" content-role="query or hints or doc" content-type="token" title="string" value="string" href="anyURI" gref="token" action="anyURI" />
          <LINK ID="ID" content-role="query or hints or doc" content-type="token" title="string" value="string" href="anyURI" gref="token" action="anyURI" />
          <TABLE ID="ID" name="token" ref="IDREF">
            <DESCRIPTION>string</DESCRIPTION>
            <FIELD xsi:nil="true" />
            <FIELD xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
            <DATA xsi:nil="true" />
          </TABLE>
          <TABLE ID="ID" name="token" ref="IDREF">
            <DESCRIPTION>string</DESCRIPTION>
            <FIELD xsi:nil="true" />
            <FIELD xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
            <DATA xsi:nil="true" />
          </TABLE>
          <RESOURCE name="token" ID="ID" type="results or meta">
            <DESCRIPTION>string</DESCRIPTION>
            <INFO xsi:nil="true" />
            <INFO xsi:nil="true" />
            <COOSYS xsi:nil="true" />
            <COOSYS xsi:nil="true" />
            <PARAM xsi:nil="true" />
            <PARAM xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
            <TABLE xsi:nil="true" />
            <TABLE xsi:nil="true" />
            <RESOURCE xsi:nil="true" />
            <RESOURCE xsi:nil="true" />
          </RESOURCE>
          <RESOURCE name="token" ID="ID" type="results or meta">
            <DESCRIPTION>string</DESCRIPTION>
            <INFO xsi:nil="true" />
            <INFO xsi:nil="true" />
            <COOSYS xsi:nil="true" />
            <COOSYS xsi:nil="true" />
            <PARAM xsi:nil="true" />
            <PARAM xsi:nil="true" />
            <LINK xsi:nil="true" />
            <LINK xsi:nil="true" />
            <TABLE xsi:nil="true" />
            <TABLE xsi:nil="true" />
            <RESOURCE xsi:nil="true" />
            <RESOURCE xsi:nil="true" />
          </RESOURCE>
        </RESOURCE>
      </QueryDatabaseResult>
    </QueryDatabaseResponse>
  </soap:Body>
</soap:Envelope>