curl --location --request POST 'https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run' --header 'Authorization: Bearer YOUR_API_KEY' 

--data-raw '{
    "formula": "EOMONTH(DATE(2022,09,14),2)"
}'

    

import okhttp3.OkHttpClient;
import okhttp3.Request;
import okhttp3.Response;
import java.io.IOException;

public class Main {
    public static void main(String[] args) {
        OkHttpClient client = new OkHttpClient();

        // Build the GET request
        Request request = new Request.Builder()
            .url("https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run")
            .get() // Use GET method without a body
            .addHeader("Authorization", "Bearer YOUR_API_KEY")
            .build();

        // Execute the request
        try (Response response = client.newCall(request).execute()) {
            if (response.isSuccessful()) {
                // Handle the response in case of a successful request
                String responseData = response.body().string();
                System.out.println(responseData);
            } else {
                // Handle errors
                System.out.println("Request error: " + response.code());
            }
        } catch (IOException e) {
            // Handle I/O exceptions
            e.printStackTrace();
        }
    }
}

var settings = {
  "url": "https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run",
  "method": "POST",
  "timeout": 0,
  "headers": {
    "Authorization": "Bearer YOUR_API_KEY"
  },
};

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

var data = "{\r\n    \"formula\": \"EOMONTH(DATE(2022,09,14),2)\"\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://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run");
xhr.setRequestHeader("Authorization", "Bearer YOUR_API_KEY");
xhr.send(data);

var axios = require('axios');
var data = "{\r\n    \"formula\": \"EOMONTH(DATE(2022,09,14),2)\"\r\n}";
var config = {
method: 'POST',
url: 'https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run',
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://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run',
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 => '{
    "formula": "EOMONTH(DATE(2022,09,14),2)"
}',
CURLOPT_HTTPHEADER => array(
    'Authorization: Bearer YOUR_API_KEY'
    ),
));
    
$response = curl_exec($curl);
    
curl_close($curl);
echo $response;

import requests
    
url = "https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run"
    
payload = "{\r\n    \"formula\": \"EOMONTH(DATE(2022,09,14),2)\"\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://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run")
    
http = Net::HTTP.new(url.host, url.port);
request = Net::HTTP::POST.new(url)
request["Authorization"] = "Bearer YOUR_API_KEY"
request.body = "{\r\n    \"formula\": \"EOMONTH(DATE(2022,09,14),2)\"\r\n}"    
response = http.request(request)
puts response.read_body

printf '{
    "formula": "EOMONTH(DATE(2022,09,14),2)"
}'| 
http --follow --timeout 3600 POST 'https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run' \
Authorization:'Bearer YOUR_API_KEY'

var client = new RestClient("https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run");
client.Timeout = -1;
var request = new RestRequest(Method.POST);
request.AddHeader("Authorization", "Bearer YOUR_API_KEY");
var body = "{\r\n    \"formula\": \"EOMONTH(DATE(2022,09,14),2)\"\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://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run"
    method := "POST"
    payload := strings.NewReader("{
    "formula": "EOMONTH(DATE(2022,09,14),2)"
}")
    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))
}

import Foundation

let url = URL(string: "https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run")!
var request = URLRequest(url: url)
request.httpMethod = "POST"
request.setValue("Bearer YOUR_API_KEY", forHTTPHeaderField: "Authorization")
request.httpBody = "{
    "formula": "EOMONTH(DATE(2022,09,14),2)"
}".data(using: .utf8)
request.setValue("application/json", forHTTPHeaderField: "Content-Type")

let task = URLSession.shared.dataTask(with: request) { data, _, error in
    if let error = error {
        print(error.localizedDescription)
        return
    }
    if let data = data {
        print(String(decoding: data, as: UTF8.self))
    }
}
task.resume()

import okhttp3.MediaType.Companion.toMediaType
import okhttp3.OkHttpClient
import okhttp3.Request
import okhttp3.RequestBody
import okhttp3.RequestBody.Companion.toRequestBody

fun main() {
    val client = OkHttpClient()
    var body: RequestBody? = null
    body = "{
    "formula": "EOMONTH(DATE(2022,09,14),2)"
}".toRequestBody("application/json".toMediaType())

    val requestBuilder = Request.Builder()
        .url("https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run")
        .addHeader("Authorization", "Bearer YOUR_API_KEY")

    val request = requestBuilder.method("POST", body).build()

    client.newCall(request).execute().use { response ->
        println(response.body?.string())
    }
}

import 'package:http/http.dart' as http;

void main() async {
  var payload = '';
  payload = "{
    "formula": "EOMONTH(DATE(2022,09,14),2)"
}";

  final request = http.Request(
    "POST",
    Uri.parse("https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run"),
  );
  request.headers['Authorization'] = 'Bearer YOUR_API_KEY';
  if (payload.isNotEmpty) {
    request.headers['Content-Type'] = 'application/json';
    request.body = payload;
  }

  final client = http.Client();
  final response = await client.send(request);
  print(await response.stream.bytesToString());
  client.close();
}

use reqwest::blocking::Client;
use reqwest::Method;
use std::error::Error;

fn main() -> Result<(), Box> {
    let method = Method::from_bytes(b"POST")?;
    let client = Client::new();
    let mut body = String::new();
    body = r#"{
    "formula": "EOMONTH(DATE(2022,09,14),2)"
}"#.to_string();

    let mut request = client
        .request(method, "https://pr197-testing.zylalabs.com/api/956/excel+formulas+api/781/run")
        .header("Authorization", "Bearer YOUR_API_KEY");

    request = request.body(body.clone());

    let response = request.send()?;
    println!("{}", response.text()?);
    Ok(())
}