import requests

respuesta = requests.get(
    "https://orvixjoin.com/api/v1/tipo-cambio/sunat?date=2026-10-02",
    headers={"Authorization": "Bearer TU_API_KEY", "Accept": "application/json"},
    timeout=30,
)
respuesta.raise_for_status()
print(respuesta.json())

using System.Net.Http.Headers;

var url = "https://orvixjoin.com/api/v1/tipo-cambio/sunat?date=2026-10-02";
using var http = new HttpClient();
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", "TU_API_KEY");
http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
Console.WriteLine(await http.GetStringAsync(url));

 ["Authorization: Bearer TU_API_KEY", "Accept: application/json"],
    CURLOPT_RETURNTRANSFER => true,
]);
echo curl_exec($ch);
curl_close($ch);

var cliente = HttpClient.newHttpClient();
var pedido = HttpRequest.newBuilder()
    .uri(URI.create("https://orvixjoin.com/api/v1/tipo-cambio/sunat?date=2026-10-02"))
    .header("Authorization", "Bearer TU_API_KEY")
    .header("Accept", "application/json")
    .GET().build();
System.out.println(cliente.send(pedido, HttpResponse.BodyHandlers.ofString()).body());

const respuesta = await fetch("https://orvixjoin.com/api/v1/tipo-cambio/sunat?date=2026-10-02", {
  headers: { Authorization: "Bearer TU_API_KEY", Accept: "application/json" },
});
console.log(await respuesta.json());

import requests

respuesta = requests.get(
    "https://orvixjoin.com/api/v1/sunat/ruc?numero=20100070970",
    headers={"Authorization": "Bearer TU_API_KEY", "Accept": "application/json"},
    timeout=30,
)
respuesta.raise_for_status()
print(respuesta.json())

using System.Net.Http.Headers;

var url = "https://orvixjoin.com/api/v1/sunat/ruc?numero=20100070970";
using var http = new HttpClient();
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", "TU_API_KEY");
http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
Console.WriteLine(await http.GetStringAsync(url));

 ["Authorization: Bearer TU_API_KEY", "Accept: application/json"],
    CURLOPT_RETURNTRANSFER => true,
]);
echo curl_exec($ch);
curl_close($ch);

var cliente = HttpClient.newHttpClient();
var pedido = HttpRequest.newBuilder()
    .uri(URI.create("https://orvixjoin.com/api/v1/sunat/ruc?numero=20100070970"))
    .header("Authorization", "Bearer TU_API_KEY")
    .header("Accept", "application/json")
    .GET().build();
System.out.println(cliente.send(pedido, HttpResponse.BodyHandlers.ofString()).body());

const respuesta = await fetch("https://orvixjoin.com/api/v1/sunat/ruc?numero=20100070970", {
  headers: { Authorization: "Bearer TU_API_KEY", Accept: "application/json" },
});
console.log(await respuesta.json());

import requests

respuesta = requests.get(
    "https://orvixjoin.com/api/v1/tipo-cambio/sbs?currency=USD&date=2026-09-30",
    headers={"Authorization": "Bearer TU_API_KEY", "Accept": "application/json"},
    timeout=30,
)
respuesta.raise_for_status()
print(respuesta.json())

using System.Net.Http.Headers;

var url = "https://orvixjoin.com/api/v1/tipo-cambio/sbs?currency=USD&date=2026-09-30";
using var http = new HttpClient();
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", "TU_API_KEY");
http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
Console.WriteLine(await http.GetStringAsync(url));

 ["Authorization: Bearer TU_API_KEY", "Accept: application/json"],
    CURLOPT_RETURNTRANSFER => true,
]);
echo curl_exec($ch);
curl_close($ch);

var cliente = HttpClient.newHttpClient();
var pedido = HttpRequest.newBuilder()
    .uri(URI.create("https://orvixjoin.com/api/v1/tipo-cambio/sbs?currency=USD&date=2026-09-30"))
    .header("Authorization", "Bearer TU_API_KEY")
    .header("Accept", "application/json")
    .GET().build();
System.out.println(cliente.send(pedido, HttpResponse.BodyHandlers.ofString()).body());

const respuesta = await fetch("https://orvixjoin.com/api/v1/tipo-cambio/sbs?currency=USD&date=2026-09-30", {
  headers: { Authorization: "Bearer TU_API_KEY", Accept: "application/json" },
});
console.log(await respuesta.json());

import requests

respuesta = requests.get(
    "https://orvixjoin.com/api/v1/dni?numero=46027897",
    headers={"Authorization": "Bearer TU_API_KEY", "Accept": "application/json"},
    timeout=30,
)
respuesta.raise_for_status()
print(respuesta.json())

using System.Net.Http.Headers;

var url = "https://orvixjoin.com/api/v1/dni?numero=46027897";
using var http = new HttpClient();
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", "TU_API_KEY");
http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
Console.WriteLine(await http.GetStringAsync(url));

 ["Authorization: Bearer TU_API_KEY", "Accept: application/json"],
    CURLOPT_RETURNTRANSFER => true,
]);
echo curl_exec($ch);
curl_close($ch);

var cliente = HttpClient.newHttpClient();
var pedido = HttpRequest.newBuilder()
    .uri(URI.create("https://orvixjoin.com/api/v1/dni?numero=46027897"))
    .header("Authorization", "Bearer TU_API_KEY")
    .header("Accept", "application/json")
    .GET().build();
System.out.println(cliente.send(pedido, HttpResponse.BodyHandlers.ofString()).body());

const respuesta = await fetch("https://orvixjoin.com/api/v1/dni?numero=46027897", {
  headers: { Authorization: "Bearer TU_API_KEY", Accept: "application/json" },
});
console.log(await respuesta.json());

import requests

respuesta = requests.get(
    "https://orvixjoin.com/api/v1/afp/comisiones?year=2025&month=8",
    headers={"Authorization": "Bearer TU_API_KEY", "Accept": "application/json"},
    timeout=30,
)
respuesta.raise_for_status()
print(respuesta.json())

using System.Net.Http.Headers;

var url = "https://orvixjoin.com/api/v1/afp/comisiones?year=2025&month=8";
using var http = new HttpClient();
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", "TU_API_KEY");
http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
Console.WriteLine(await http.GetStringAsync(url));

 ["Authorization: Bearer TU_API_KEY", "Accept: application/json"],
    CURLOPT_RETURNTRANSFER => true,
]);
echo curl_exec($ch);
curl_close($ch);

var cliente = HttpClient.newHttpClient();
var pedido = HttpRequest.newBuilder()
    .uri(URI.create("https://orvixjoin.com/api/v1/afp/comisiones?year=2025&month=8"))
    .header("Authorization", "Bearer TU_API_KEY")
    .header("Accept", "application/json")
    .GET().build();
System.out.println(cliente.send(pedido, HttpResponse.BodyHandlers.ofString()).body());

const respuesta = await fetch("https://orvixjoin.com/api/v1/afp/comisiones?year=2025&month=8", {
  headers: { Authorization: "Bearer TU_API_KEY", Accept: "application/json" },
});
console.log(await respuesta.json());

import requests

respuesta = requests.get(
    "https://orvixjoin.com/api/v1/digemid?numero=10715929746",
    headers={"Authorization": "Bearer TU_API_KEY", "Accept": "application/json"},
    timeout=30,
)
respuesta.raise_for_status()
print(respuesta.json())

using System.Net.Http.Headers;

var url = "https://orvixjoin.com/api/v1/digemid?numero=10715929746";
using var http = new HttpClient();
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", "TU_API_KEY");
http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
Console.WriteLine(await http.GetStringAsync(url));

 ["Authorization: Bearer TU_API_KEY", "Accept: application/json"],
    CURLOPT_RETURNTRANSFER => true,
]);
echo curl_exec($ch);
curl_close($ch);

var cliente = HttpClient.newHttpClient();
var pedido = HttpRequest.newBuilder()
    .uri(URI.create("https://orvixjoin.com/api/v1/digemid?numero=10715929746"))
    .header("Authorization", "Bearer TU_API_KEY")
    .header("Accept", "application/json")
    .GET().build();
System.out.println(cliente.send(pedido, HttpResponse.BodyHandlers.ofString()).body());

const respuesta = await fetch("https://orvixjoin.com/api/v1/digemid?numero=10715929746", {
  headers: { Authorization: "Bearer TU_API_KEY", Accept: "application/json" },
});
console.log(await respuesta.json());

import requests

respuesta = requests.get(
    "https://orvixjoin.com/api/v1/digemid/productos?registro=EE02436",
    headers={"Authorization": "Bearer TU_API_KEY", "Accept": "application/json"},
    timeout=30,
)
respuesta.raise_for_status()
print(respuesta.json())

using System.Net.Http.Headers;

var url = "https://orvixjoin.com/api/v1/digemid/productos?registro=EE02436";
using var http = new HttpClient();
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", "TU_API_KEY");
http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
Console.WriteLine(await http.GetStringAsync(url));

 ["Authorization: Bearer TU_API_KEY", "Accept: application/json"],
    CURLOPT_RETURNTRANSFER => true,
]);
echo curl_exec($ch);
curl_close($ch);

var cliente = HttpClient.newHttpClient();
var pedido = HttpRequest.newBuilder()
    .uri(URI.create("https://orvixjoin.com/api/v1/digemid/productos?registro=EE02436"))
    .header("Authorization", "Bearer TU_API_KEY")
    .header("Accept", "application/json")
    .GET().build();
System.out.println(cliente.send(pedido, HttpResponse.BodyHandlers.ofString()).body());

const respuesta = await fetch("https://orvixjoin.com/api/v1/digemid/productos?registro=EE02436", {
  headers: { Authorization: "Bearer TU_API_KEY", Accept: "application/json" },
});
console.log(await respuesta.json());

import requests

respuesta = requests.get(
    "https://orvixjoin.com/api/v1/digesa/alimentos?ruc=20515108794",
    headers={"Authorization": "Bearer TU_API_KEY", "Accept": "application/json"},
    timeout=30,
)
respuesta.raise_for_status()
print(respuesta.json())

using System.Net.Http.Headers;

var url = "https://orvixjoin.com/api/v1/digesa/alimentos?ruc=20515108794";
using var http = new HttpClient();
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", "TU_API_KEY");
http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
Console.WriteLine(await http.GetStringAsync(url));

 ["Authorization: Bearer TU_API_KEY", "Accept: application/json"],
    CURLOPT_RETURNTRANSFER => true,
]);
echo curl_exec($ch);
curl_close($ch);

var cliente = HttpClient.newHttpClient();
var pedido = HttpRequest.newBuilder()
    .uri(URI.create("https://orvixjoin.com/api/v1/digesa/alimentos?ruc=20515108794"))
    .header("Authorization", "Bearer TU_API_KEY")
    .header("Accept", "application/json")
    .GET().build();
System.out.println(cliente.send(pedido, HttpResponse.BodyHandlers.ofString()).body());

const respuesta = await fetch("https://orvixjoin.com/api/v1/digesa/alimentos?ruc=20515108794", {
  headers: { Authorization: "Bearer TU_API_KEY", Accept: "application/json" },
});
console.log(await respuesta.json());

import base64
import requests
import psycopg

headers = {"Authorization": "Bearer TU_API_KEY", "Content-Type": "application/json"}

def post(url, cuerpo):
    respuesta = requests.post(url, headers=headers, json=cuerpo, timeout=90)
    respuesta.raise_for_status()
    return respuesta.json()

factura = {
    "tipo": "01",
    "serie": "F001",
    "numero": 1,
    "moneda": "PEN",
    "cliente": {
        "tipo_documento": "6",
        "numero": "20100070970",
        "nombre": "EMPRESA DE PRUEBA S.A.C.",
        "direccion": "AV. EJEMPLO 100",
    },
    "items": [{
        "descripcion": "Servicio",
        "cantidad": 1,
        "valor_unitario": 100,
        "afectacion": "10",
    }],
}
cpe = post("https://orvixjoin.com/api/v1/cpe/xml", factura)
cpe = post("https://orvixjoin.com/api/v1/cpe/firmar", {"id": cpe["id"]})
cpe = post("https://orvixjoin.com/api/v1/cpe/enviar", {"id": cpe["id"]})
if cpe["estado"] != "aceptado":
    raise SystemExit(cpe.get("mensaje") or cpe["estado"])

xml_firmado = cpe["xml_firmado"].encode("iso-8859-1")
cdr = base64.b64decode(cpe["cdr_base64"])
pdf = base64.b64decode(cpe["pdf_base64"])
with psycopg.connect("postgresql://usuario:clave@localhost/tu_base") as con:
    con.execute(
        """
        INSERT INTO comprobante_electronico
            (codigo, tipo, serie, numero, estado, codigo_respuesta, mensaje, xml_firmado, cdr, pdf)
        VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
        ON CONFLICT (codigo) DO UPDATE SET
            estado = EXCLUDED.estado,
            codigo_respuesta = EXCLUDED.codigo_respuesta,
            mensaje = EXCLUDED.mensaje,
            xml_firmado = EXCLUDED.xml_firmado,
            cdr = EXCLUDED.cdr,
            pdf = EXCLUDED.pdf
        """,
        (cpe["id"], cpe["tipo"], cpe["serie"], cpe["numero"], cpe["estado"],
         cpe["codigo_respuesta"], cpe["mensaje"], xml_firmado, cdr, pdf),
    )

using System.Net.Http.Headers;
using System.Text;
using System.Text.Json;
using Npgsql;

using var http = new HttpClient();
http.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", "TU_API_KEY");

async Task Post(string url, string json)
{
    var cuerpo = new StringContent(json, Encoding.UTF8, "application/json");
    using var doc = JsonDocument.Parse(await (await http.PostAsync(url, cuerpo)).Content.ReadAsStringAsync());
    return doc.RootElement.Clone();
}

var factura = """
{"tipo":"01","serie":"F001","numero":1,"moneda":"PEN",
 "cliente":{"tipo_documento":"6","numero":"20100070970","nombre":"EMPRESA DE PRUEBA S.A.C.","direccion":"AV. EJEMPLO 100"},
 "items":[{"descripcion":"Servicio","cantidad":1,"valor_unitario":100,"afectacion":"10"}]}
""";
var cpe = await Post("https://orvixjoin.com/api/v1/cpe/xml", factura);
var id = cpe.GetProperty("id").GetString();
cpe = await Post("https://orvixjoin.com/api/v1/cpe/firmar", $"{{\"id\":\"{id}\"}}");
cpe = await Post("https://orvixjoin.com/api/v1/cpe/enviar", $"{{\"id\":\"{id}\"}}");
if (cpe.GetProperty("estado").GetString() != "aceptado")
    throw new Exception(cpe.GetProperty("mensaje").GetString());

var xml = Encoding.GetEncoding("iso-8859-1").GetBytes(cpe.GetProperty("xml_firmado").GetString()!);
var cdr = Convert.FromBase64String(cpe.GetProperty("cdr_base64").GetString()!);
var pdf = Convert.FromBase64String(cpe.GetProperty("pdf_base64").GetString()!);
await using var con = new NpgsqlConnection("Host=localhost;Username=usuario;Password=clave;Database=tu_base");
await con.OpenAsync();
await using var cmd = new NpgsqlCommand("""
    INSERT INTO comprobante_electronico
        (codigo, tipo, serie, numero, estado, codigo_respuesta, mensaje, xml_firmado, cdr, pdf)
    VALUES (@codigo, @tipo, @serie, @numero, @estado, @codigo_respuesta, @mensaje, @xml, @cdr, @pdf)
    ON CONFLICT (codigo) DO UPDATE SET
        estado = EXCLUDED.estado, xml_firmado = EXCLUDED.xml_firmado, cdr = EXCLUDED.cdr, pdf = EXCLUDED.pdf
    """, con);
cmd.Parameters.AddWithValue("codigo", id);
cmd.Parameters.AddWithValue("tipo", cpe.GetProperty("tipo").GetString());
cmd.Parameters.AddWithValue("serie", cpe.GetProperty("serie").GetString());
cmd.Parameters.AddWithValue("numero", cpe.GetProperty("numero").GetString());
cmd.Parameters.AddWithValue("estado", cpe.GetProperty("estado").GetString());
cmd.Parameters.AddWithValue("codigo_respuesta", cpe.GetProperty("codigo_respuesta").GetString());
cmd.Parameters.AddWithValue("mensaje", cpe.GetProperty("mensaje").GetString());
cmd.Parameters.AddWithValue("xml", xml);
cmd.Parameters.AddWithValue("cdr", cdr);
cmd.Parameters.AddWithValue("pdf", pdf);
await cmd.ExecuteNonQueryAsync();

 true,
        CURLOPT_HTTPHEADER => ["Authorization: Bearer TU_API_KEY", "Content-Type: application/json"],
        CURLOPT_POSTFIELDS => json_encode($cuerpo),
        CURLOPT_RETURNTRANSFER => true,
    ]);
    $dato = json_decode(curl_exec($ch), true);
    curl_close($ch);
    return $dato;
}

$cpe = orvix("https://orvixjoin.com/api/v1/cpe/xml", [
    "tipo" => "01", "serie" => "F001", "numero" => 1, "moneda" => "PEN",
    "cliente" => ["tipo_documento" => "6", "numero" => "20100070970", "nombre" => "EMPRESA DE PRUEBA S.A.C.", "direccion" => "AV. EJEMPLO 100"],
    "items" => [["descripcion" => "Servicio", "cantidad" => 1, "valor_unitario" => 100, "afectacion" => "10"]],
]);
$cpe = orvix("https://orvixjoin.com/api/v1/cpe/firmar", ["id" => $cpe["id"]]);
$cpe = orvix("https://orvixjoin.com/api/v1/cpe/enviar", ["id" => $cpe["id"]]);
if ($cpe["estado"] !== "aceptado") {
    exit($cpe["mensaje"] ?? $cpe["estado"]);
}

$xml = mb_convert_encoding($cpe["xml_firmado"], "ISO-8859-1", "UTF-8");
$cdr = base64_decode($cpe["cdr_base64"]);
$pdf = base64_decode($cpe["pdf_base64"]);
$pdo = new PDO("pgsql:host=localhost;dbname=tu_base", "usuario", "clave");
$sql = "INSERT INTO comprobante_electronico
            (codigo, tipo, serie, numero, estado, codigo_respuesta, mensaje, xml_firmado, cdr, pdf)
        VALUES (?, ?, ?, ?, ?, ?, ?, decode(?, 'hex'), decode(?, 'hex'), decode(?, 'hex'))
        ON CONFLICT (codigo) DO UPDATE SET
            estado = EXCLUDED.estado, xml_firmado = EXCLUDED.xml_firmado, cdr = EXCLUDED.cdr, pdf = EXCLUDED.pdf";
$pdo->prepare($sql)->execute([
    $cpe["id"], $cpe["tipo"], $cpe["serie"], $cpe["numero"], $cpe["estado"],
    $cpe["codigo_respuesta"], $cpe["mensaje"], bin2hex($xml), bin2hex($cdr), bin2hex($pdf),
]);

public class EmitirFactura {
    static final HttpClient cliente = HttpClient.newHttpClient();
    static final ObjectMapper mapper = new ObjectMapper();

    static JsonNode post(String url, String json) throws Exception {
        var pedido = HttpRequest.newBuilder().uri(URI.create(url))
            .header("Authorization", "Bearer TU_API_KEY")
            .header("Content-Type", "application/json")
            .POST(HttpRequest.BodyPublishers.ofString(json)).build();
        return mapper.readTree(cliente.send(pedido, HttpResponse.BodyHandlers.ofString()).body());
    }

    public static void main(String[] args) throws Exception {
    var factura = """
{"tipo":"01","serie":"F001","numero":1,"moneda":"PEN",
 "cliente":{"tipo_documento":"6","numero":"20100070970","nombre":"EMPRESA DE PRUEBA S.A.C.","direccion":"AV. EJEMPLO 100"},
 "items":[{"descripcion":"Servicio","cantidad":1,"valor_unitario":100,"afectacion":"10"}]}
""";
var cpe = post("https://orvixjoin.com/api/v1/cpe/xml", factura);
var id = cpe.get("id").asText();
cpe = post("https://orvixjoin.com/api/v1/cpe/firmar", "{\"id\":\"" + id + "\"}");
cpe = post("https://orvixjoin.com/api/v1/cpe/enviar", "{\"id\":\"" + id + "\"}");
if (!"aceptado".equals(cpe.get("estado").asText()))
    throw new IllegalStateException(cpe.get("mensaje").asText());

var xml = cpe.get("xml_firmado").asText().getBytes(StandardCharsets.ISO_8859_1);
var cdr = Base64.getDecoder().decode(cpe.get("cdr_base64").asText());
var pdf = Base64.getDecoder().decode(cpe.get("pdf_base64").asText());
try (var con = DriverManager.getConnection("jdbc:postgresql://localhost/tu_base", "usuario", "clave");
     var cmd = con.prepareStatement("""
        INSERT INTO comprobante_electronico
            (codigo, tipo, serie, numero, estado, codigo_respuesta, mensaje, xml_firmado, cdr, pdf)
        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        ON CONFLICT (codigo) DO UPDATE SET
            estado = EXCLUDED.estado, xml_firmado = EXCLUDED.xml_firmado, cdr = EXCLUDED.cdr, pdf = EXCLUDED.pdf
        """)) {
    cmd.setString(1, id);
    cmd.setString(2, cpe.get("tipo").asText());
    cmd.setString(3, cpe.get("serie").asText());
    cmd.setString(4, cpe.get("numero").asText());
    cmd.setString(5, cpe.get("estado").asText());
    cmd.setString(6, cpe.get("codigo_respuesta").asText());
    cmd.setString(7, cpe.get("mensaje").asText());
    cmd.setBytes(8, xml);
    cmd.setBytes(9, cdr);
    cmd.setBytes(10, pdf);
    cmd.executeUpdate();
    }
    }
}

async function orvix(url, cuerpo) {
  const respuesta = await fetch(url, {
    method: "POST",
    headers: { Authorization: "Bearer TU_API_KEY", "Content-Type": "application/json" },
    body: JSON.stringify(cuerpo),
  });
  if (!respuesta.ok) throw new Error(await respuesta.text());
  return respuesta.json();
}

let cpe = await orvix("https://orvixjoin.com/api/v1/cpe/xml", {
  tipo: "01", serie: "F001", numero: 1, moneda: "PEN",
  cliente: { tipo_documento: "6", numero: "20100070970", nombre: "EMPRESA DE PRUEBA S.A.C.", direccion: "AV. EJEMPLO 100" },
  items: [{ descripcion: "Servicio", cantidad: 1, valor_unitario: 100, afectacion: "10" }],
});
cpe = await orvix("https://orvixjoin.com/api/v1/cpe/firmar", { id: cpe.id });
cpe = await orvix("https://orvixjoin.com/api/v1/cpe/enviar", { id: cpe.id });
if (cpe.estado !== "aceptado") throw new Error(cpe.mensaje || cpe.estado);

const xml = Buffer.from(cpe.xml_firmado, "latin1");
const cdr = Buffer.from(cpe.cdr_base64, "base64");
const pdf = Buffer.from(cpe.pdf_base64, "base64");
const { Client } = require("pg");
const con = new Client({ connectionString: "postgresql://usuario:clave@localhost/tu_base" });
await con.connect();
await con.query(
  `INSERT INTO comprobante_electronico
      (codigo, tipo, serie, numero, estado, codigo_respuesta, mensaje, xml_firmado, cdr, pdf)
   VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10)
   ON CONFLICT (codigo) DO UPDATE SET
      estado = EXCLUDED.estado, xml_firmado = EXCLUDED.xml_firmado, cdr = EXCLUDED.cdr, pdf = EXCLUDED.pdf`,
  [cpe.id, cpe.tipo, cpe.serie, cpe.numero, cpe.estado, cpe.codigo_respuesta, cpe.mensaje, xml, cdr, pdf]
);
await con.end();