RegistryDBQuery
Click here for a complete list of operations.
DSQuery
Input SQL Query. This can query the entire registry database. Requires passphrase.
Test
To test the operation using the HTTP POST protocol, click the 'Invoke' button.SOAP 1.1
The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.
POST /directory/RegistryDBQuery.asmx HTTP/1.1
Host: vao.stsci.edu
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.us-vo.org/DSQuery"
<?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>
<DSQuery xmlns="http://www.us-vo.org">
<sqlStmnt>string</sqlStmnt>
<password>string</password>
</DSQuery>
</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>
<DSQueryResponse xmlns="http://www.us-vo.org">
<DSQueryResult>
<xsd:schema>schema</xsd:schema>xml</DSQueryResult>
</DSQueryResponse>
</soap:Body>
</soap:Envelope>
SOAP 1.2
The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.
POST /directory/RegistryDBQuery.asmx HTTP/1.1
Host: vao.stsci.edu
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
<soap12:Body>
<DSQuery xmlns="http://www.us-vo.org">
<sqlStmnt>string</sqlStmnt>
<password>string</password>
</DSQuery>
</soap12:Body>
</soap12:Envelope>
HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
<soap12:Body>
<DSQueryResponse xmlns="http://www.us-vo.org">
<DSQueryResult>
<xsd:schema>schema</xsd:schema>xml</DSQueryResult>
</DSQueryResponse>
</soap12:Body>
</soap12:Envelope>
HTTP GET
The following is a sample HTTP GET request and response. The placeholders shown need to be replaced with actual values.
GET /directory/RegistryDBQuery.asmx/DSQuery?sqlStmnt=string&password=string HTTP/1.1 Host: vao.stsci.edu
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <DataSet xmlns="http://www.us-vo.org"> <schema xmlns="http://www.w3.org/2001/XMLSchema">schema</schema>xml</DataSet>
HTTP POST
The following is a sample HTTP POST request and response. The placeholders shown need to be replaced with actual values.
POST /directory/RegistryDBQuery.asmx/DSQuery HTTP/1.1 Host: vao.stsci.edu Content-Type: application/x-www-form-urlencoded Content-Length: length sqlStmnt=string&password=string
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <DataSet xmlns="http://www.us-vo.org"> <schema xmlns="http://www.w3.org/2001/XMLSchema">schema</schema>xml</DataSet>