Text to SQL Query API

curl --location --request POST 'https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query' --header 'Authorization: Bearer YOUR_API_KEY' 
--data-raw '{
    "input": "find all male users aged between 18 to 35",
    "schema": "user(id, name, age, gender) "
}'

    

OkHttpClient client = new OkHttpClient().newBuilder()
.build();
MediaType mediaType = MediaType.parse("text/plain");
RequestBody body = RequestBody.create(mediaType, "{\r\n    \"input\": \"find all male users aged between 18 to 35\",\r\n    \"schema\": \"user(id, name, age, gender) \"\r\n}");
Request request = new Request.Builder()
.url("https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query")
.method("POST", body)
.addHeader("Authorization", "YOUR_API_KEY")
.build();
Response response = client.newCall(request).execute();

var settings = {
"url": "https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query",
"method": "POST",
"timeout": 0,
"headers": {
    "Authorization": "YOUR_API_KEY"
},
"data": "{\r\n    \"input\": \"find all male users aged between 18 to 35\",\r\n    \"schema\": \"user(id, name, age, gender) \"\r\n}",
};

$.ajax(settings).done(function (response) {
console.log(response);
});

var data = "{\r\n    \"input\": \"find all male users aged between 18 to 35\",\r\n    \"schema\": \"user(id, name, age, gender) \"\r\n}";
var xhr = new XMLHttpRequest();
xhr.withCredentials = true;
    
xhr.addEventListener("readystatechange", function() {
if(this.readyState === 4) {
    console.log(this.responseText);
    }
});
    
xhr.open("POST", "https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query");
xhr.setRequestHeader("Authorization", "Bearer YOUR_API_KEY");
xhr.send(data);

var axios = require('axios');
var data = "{\r\n    \"input\": \"find all male users aged between 18 to 35\",\r\n    \"schema\": \"user(id, name, age, gender) \"\r\n}";
var config = {
method: 'POST',
url: 'https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query',
headers: { 
    'Authorization': 'Bearer YOUR_API_KEY'
    },
data : data
};
axios(config).then(function (response) {
console.log(JSON.stringify(response.data));
})
.catch(function (error) {
console.log(error);
});

$curl = curl_init();
    
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => '{
    "input": "find all male users aged between 18 to 35",
    "schema": "user(id, name, age, gender) "
}',
CURLOPT_HTTPHEADER => array(
    'Authorization: Bearer YOUR_API_KEY'
    ),
));
    
$response = curl_exec($curl);
    
curl_close($curl);
echo $response;

import requests
    
url = "https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query"
    
payload = "{\r\n    \"input\": \"find all male users aged between 18 to 35\",\r\n    \"schema\": \"user(id, name, age, gender) \"\r\n}" 
headers = {
    'Authorization': 'Bearer YOUR_API_KEY'
}
    
response = requests.request("POST", url, headers=headers, data=payload)
    
print(response.text)
    

require "uri"
require "net/http"
    
url = URI("https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query")
    
http = Net::HTTP.new(url.host, url.port);
request = Net::HTTP::POST.new(url)
request["Authorization"] = "Bearer YOUR_API_KEY"
request.body = "{\r\n    \"input\": \"find all male users aged between 18 to 35\",\r\n    \"schema\": \"user(id, name, age, gender) \"\r\n}"    
response = http.request(request)
puts response.read_body

printf '{
    "input": "find all male users aged between 18 to 35",
    "schema": "user(id, name, age, gender) "
}'| 
http --follow --timeout 3600 POST 'https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query' \
Authorization:'Bearer YOUR_API_KEY'

var client = new RestClient("https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query");
client.Timeout = -1;
var request = new RestRequest(Method.POST);
request.AddHeader("Authorization", "Bearer YOUR_API_KEY");
var body = "{\r\n    \"input\": \"find all male users aged between 18 to 35\",\r\n    \"schema\": \"user(id, name, age, gender) \"\r\n}";
request.AddParameter("text/plain", body, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);

package main
import (
    "fmt"
    "net/http"
    "io/ioutil"
)
func main() {
    url := "https://zylalabs.com/api/832/text+to+sql+query+api/594/get+sql+query"
    method := "POST"
    payload := strings.NewReader("{
    "input": "find all male users aged between 18 to 35",
    "schema": "user(id, name, age, gender) "
}")
    client := &http.Client {
    }
    req, err := http.NewRequest(method, url, nil)
    if err != nil {
    fmt.Println(err)
    return
    }
    req.Header.Add("Authorization", "Bearer YOUR_API_KEY")
    res, err := client.Do(req)
    if err != nil {
    fmt.Println(err)
    return
    }
    defer res.Body.Close()

    body, err := ioutil.ReadAll(res.Body)
    if err != nil {
    fmt.Println(err)
    return
    }
    fmt.Println(string(body))
}