Execute a SQL SELECT query and export the result as a PDF or CSV file

curl --request POST \
  --url https://appdomain/dcapi/reports/queryReports/export \
  --header 'Accept: application/octet-stream' \
  --header 'Authorization:  d92d4xxxxxxxxxxxxx15f52' \
  --header 'Content-Type: application/queryReport.v1+json' \
  --data '{"reportName":"All Technician report","query":"select * from Table"}'

import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
import java.io.IOException;
import java.net.http.HttpTimeoutException;

public class Main {
  public static void main(String[] args) {

    HttpRequest request = HttpRequest.newBuilder()
        .uri(URI.create("https://appdomain/dcapi/reports/queryReports/export"))
        .header("Content-Type", "application/queryReport.v1+json")
        .header("Accept", "application/octet-stream")
        .header("Authorization", " d92d4xxxxxxxxxxxxx15f52")
        .method("POST", HttpRequest.BodyPublishers.ofString("{\"reportName\":\"All Technician report\",\"query\":\"select * from Table\"}"))
        .build();
    HttpResponse response = HttpClient.newHttpClient().send(request, HttpResponse.BodyHandlers.ofString());
    System.out.println(response.body());
  
  }
}
    

import http.client

conn = http.client.HTTPSConnection("appdomain")

payload = "{\"reportName\":\"All Technician report\",\"query\":\"select * from Table\"}"

headers = {
    'Content-Type': "application/queryReport.v1+json",
    'Accept': "application/octet-stream",
    'Authorization': " d92d4xxxxxxxxxxxxx15f52"
    }

conn.request("POST", "/dcapi/reports/queryReports/export", payload, headers)

res = conn.getresponse()
data = res.read()

print(data.decode("utf-8"))

    headersMap = Map();
    headersMap.put("Content-Type", "application/queryReport.v1+json");
    headersMap.put("Accept", "application/octet-stream");

    data=Map();
    data.put("reportName","value");
    data.put("query","value");

    response = invokeUrl
    [
        url: "https://appDomain/dcapi/reports/queryReports/export"
        type: POST
        headers: headersMap
        body: data
        connection: connection_name
    ]

    info response;
    

$headers=@{}
$headers.Add("Content-Type", "application/queryReport.v1+json")
$headers.Add("Accept", "application/octet-stream")
$headers.Add("Authorization", " d92d4xxxxxxxxxxxxx15f52")
$response = Invoke-WebRequest -Uri 'https://appdomain/dcapi/reports/queryReports/export' -Method POST -Headers $headers -ContentType 'application/queryReport.v1+json' -Body '{"reportName":"All Technician report","query":"select * from Table"}'