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>