ADQLTranslator


Click here for a complete list of operations.

ADQLtoSQL

Take an ADQL Select structure and convert to SQL string

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 /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/ADQLtoSQL"
<?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>
    <ADQLtoSQL xmlns="http://ws.parser.adql.ivoa.net/">
      <Select xmlns="http://www.ivoa.net/xml/ADQL/v0.7.4">
        <Allow Option="All or DISTINCT" />
        <Restrict Top="unsignedInt" />
        <SelectionList>
          <Item />
          <Item />
        </SelectionList>
        <InTo>
          <TableName>string</TableName>
        </InTo>
        <From>
          <Table />
          <Table />
        </From>
        <Where>
          <Condition />
        </Where>
        <GroupBy>
          <Column Table="string" Name="string" xpathName="string" />
          <Column Table="string" Name="string" xpathName="string" />
        </GroupBy>
        <Having>
          <Condition />
        </Having>
        <OrderBy>
          <Item>
            <Expression xsi:nil="true" />
            <Order xsi:nil="true" />
          </Item>
          <Item>
            <Expression xsi:nil="true" />
            <Order xsi:nil="true" />
          </Item>
        </OrderBy>
        <StartComment>string</StartComment>
        <EndComment>string</EndComment>
      </Select>
    </ADQLtoSQL>
  </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>
    <ADQLtoSQLResponse xmlns="http://ws.parser.adql.ivoa.net/">
      <ADQLtoSQLResult>string</ADQLtoSQLResult>
    </ADQLtoSQLResponse>
  </soap:Body>
</soap:Envelope>