ADQLTranslator


Click here for a complete list of operations.

ADQLStringtoSQL

Take an ADQL Select (as an XML string) and convert to SQL string

Test

To test the operation using the HTTP POST protocol, click the 'Invoke' button.
Parameter Value
adql:

SOAP

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

POST /AdqlTranslator/ADQLTrans.asmx HTTP/1.1
Host: openskyquery.net
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://ws.parser.adql.ivoa.net/ADQLStringtoSQL"
<?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>
    <ADQLStringtoSQL xmlns="http://ws.parser.adql.ivoa.net/">
      <adql>string</adql>
    </ADQLStringtoSQL>
  </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>
    <ADQLStringtoSQLResponse xmlns="http://ws.parser.adql.ivoa.net/">
      <ADQLStringtoSQLResult>string</ADQLStringtoSQLResult>
    </ADQLStringtoSQLResponse>
  </soap:Body>
</soap:Envelope>

HTTP GET

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

GET /AdqlTranslator/ADQLTrans.asmx/ADQLStringtoSQL?adql=string HTTP/1.1
Host: openskyquery.net
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<string xmlns="http://ws.parser.adql.ivoa.net/">string</string>

HTTP POST

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

POST /AdqlTranslator/ADQLTrans.asmx/ADQLStringtoSQL HTTP/1.1
Host: openskyquery.net
Content-Type: application/x-www-form-urlencoded
Content-Length: length
adql=string
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<string xmlns="http://ws.parser.adql.ivoa.net/">string</string>