Integra Data Pilot Tax paso a paso

# ──────────────────────────────────────────────────────────────
#  Data Pilot Tax — Generar factura FacturaE / VeriFactu
#  Requisitos: curl 7.x+  |  Compatible macOS, Linux, Git Bash
# ──────────────────────────────────────────────────────────────

curl -X POST "https://api.datapilotax.es/api/v1/facturae/json" \
  -H "Content-Type: application/json" \
  -H "X-API-KEY: txp_live_TU_CLAVE_AQUI" \
  -H "X-Certificate-Password: PIN_DE_TU_P12" \
  -o factura_firmada.xml \
  -d '{
    "series":    "F2025",
    "number":    "0001",
    "issueDate": "2025-06-15",
    "currency":  "EUR",
    "issuer": {
      "taxIdNumber":      "B12345678",
      "taxIdCountryCode": "ESP",
      "legalName":        "Mi Empresa SL",
      "address": {
        "address": "Calle Gran Vía 1", "postCode": "28013",
        "town": "Madrid", "province": "Madrid", "countryCode": "ESP"
      }
    },
    "receiver": {
      "taxIdNumber":      "A98765432",
      "taxIdCountryCode": "ESP",
      "legalName":        "Cliente SA",
      "address": {
        "address": "Diagonal 100", "postCode": "08019",
        "town": "Barcelona", "province": "Barcelona", "countryCode": "ESP"
      }
    },
    "lines": [{
      "description": "Servicio de consultoría",
      "quantity": 1,
      "unitPriceWithoutTax": 1500.00,
      "totalAmountWithoutTax": 1500.00,
      "taxRate": 21.0
    }],
    "totals": {
      "totalGrossAmount": 1500.00,
      "totalTaxAmount": 315.00,
      "totalPayableAmount": 1815.00
    }
  }'

# Respuesta 200 → el fichero factura_firmada.xml contiene el XML FacturaE listo
# Respuesta 4xx → revisar el JSON (campos requeridos marcados con * en Swagger)

╔══════════════════════════════════════════════════════════════════╗
║  Script FileMaker Pro: "Generar Factura FacturaE"               ║
║  Usando: Insertar desde URL  +  Funciones JSON nativas           ║
║  Probado en FileMaker Pro 19+ / FileMaker Server 19+             ║
╚══════════════════════════════════════════════════════════════════╝

# ── 1. Configuración (guardar en tabla "Config", no hardcodeada) ──
Establecer Variable [$url    ; "https://api.datapilotax.es/api/v1/facturae/json"]
Establecer Variable [$apikey ; Config::api_key]
Establecer Variable [$pin    ; Config::pin_certificado_p12]

# ── 2. Construir el JSON con funciones nativas de FileMaker ───────
Establecer Variable [$json ;
  JSONSetElement ( "{}" ;
    ["series"   ; Facturas::serie        ; JSONString] ;
    ["number"   ; Facturas::numero       ; JSONString] ;
    ["issueDate"; Text(Facturas::fecha;"YYYY-MM-DD") ; JSONString] ;
    ["currency" ; "EUR"                  ; JSONString] ;

    ["issuer.taxIdNumber"      ; Empresas::nif          ; JSONString] ;
    ["issuer.taxIdCountryCode" ; "ESP"                  ; JSONString] ;
    ["issuer.legalName"        ; Empresas::razon_social ; JSONString] ;
    ["issuer.address.address"  ; Empresas::direccion    ; JSONString] ;
    ["issuer.address.postCode" ; Empresas::cp           ; JSONString] ;
    ["issuer.address.town"     ; Empresas::ciudad       ; JSONString] ;
    ["issuer.address.province" ; Empresas::provincia    ; JSONString] ;
    ["issuer.address.countryCode"; "ESP"                ; JSONString] ;

    ["receiver.taxIdNumber"      ; Clientes::nif          ; JSONString] ;
    ["receiver.taxIdCountryCode" ; "ESP"                  ; JSONString] ;
    ["receiver.legalName"        ; Clientes::razon_social ; JSONString] ;
    ["receiver.address.address"  ; Clientes::direccion    ; JSONString] ;
    ["receiver.address.postCode" ; Clientes::cp           ; JSONString] ;
    ["receiver.address.town"     ; Clientes::ciudad       ; JSONString] ;
    ["receiver.address.province" ; Clientes::provincia    ; JSONString] ;
    ["receiver.address.countryCode"; "ESP"               ; JSONString] ;

    ["lines[0].description"           ; Lineas::concepto       ; JSONString] ;
    ["lines[0].quantity"              ; Lineas::cantidad        ; JSONNumber] ;
    ["lines[0].unitPriceWithoutTax"   ; Lineas::precio_unit     ; JSONNumber] ;
    ["lines[0].totalAmountWithoutTax" ; Lineas::base_imponible  ; JSONNumber] ;
    ["lines[0].taxRate"               ; Lineas::tipo_iva        ; JSONNumber] ;

    ["totals.totalGrossAmount"   ; Facturas::base_total   ; JSONNumber] ;
    ["totals.totalTaxAmount"     ; Facturas::cuota_iva    ; JSONNumber] ;
    ["totals.totalPayableAmount" ; Facturas::total_factura; JSONNumber]
  )
]

# ── 3. Llamada HTTP (Insertar desde URL) ──────────────────────────
Insertar desde URL [Seleccionar; Con diálogo: Desactivado;
  Destino: Facturas::xml_resultado;
  URL: $url;
  Verificar certificados SSL: Activado;
  Opciones cURL:
    "-X POST" &
    " --header "Content-Type: application/json"" &
    " --header "X-API-KEY: " & $apikey & """ &
    " --header "X-Certificate-Password: " & $pin & """ &
    " --data @$json"
]

# ── 4. Evaluar la respuesta ───────────────────────────────────────
Si [PatternCount(Facturas::xml_resultado ; "<Facturae") > 0]
  Establecer campo [Facturas::estado ; "FIRMADA"]
  Establecer campo [Facturas::fecha_firma ; Get(FechaActual)]
  Mostrar diálogo personalizado ["✅ Factura XML generada y almacenada correctamente."]
Si no
  Establecer campo [Facturas::estado ; "ERROR"]
  Establecer campo [Facturas::error_msg ; Facturas::xml_resultado]
  Mostrar diálogo personalizado ["❌ Error: " & Facturas::xml_resultado]
Fin Si

'================================================================
'  Módulo: modFacturaE
'  Data Pilot Tax — Integración FacturaE / VeriFactu desde Access
'  Referencia COM requerida: Microsoft XML, v6.0  (MSXML2)
'  Herramientas > Referencias > marcar "Microsoft XML, v6.0"
'================================================================
Option Explicit

Public Sub GenerarFacturaFacturaE()

    '-- Configuración (mejor leerlo de tabla tConfig)
    Const API_URL   As String = "https://api.datapilotax.es/api/v1/facturae/json"
    Dim sApiKey     As String: sApiKey = DLookup("valor", "tConfig", "clave='API_KEY'")
    Dim sPinP12     As String: sPinP12 = InputBox("PIN del certificado P12:", "Firma Segura")
    If sPinP12 = "" Then Exit Sub   ' usuario canceló

    '-- Construir JSON (Access no tiene JSON nativo; usamos concatenación)
    Dim sSerie      As String: sSerie   = Forms!fFacturas!serie
    Dim sNumero     As String: sNumero  = Forms!fFacturas!numero
    Dim sFecha      As String: sFecha   = Format(Forms!fFacturas!fecha, "YYYY-MM-DD")

    Dim sJson As String
    sJson = "{" & _
        """series"":""" & sSerie & """," & _
        """number"":""" & sNumero & """," & _
        """issueDate"":""" & sFecha & """," & _
        """currency"":""EUR""," & _
        """issuer"":{" & _
            """taxIdNumber"":""" & Forms!fFacturas!nif_emisor & """," & _
            """taxIdCountryCode"":""ESP""," & _
            """legalName"":""" & Forms!fFacturas!razon_emisor & """," & _
            """address"":{" & _
                """address"":""" & Forms!fFacturas!dir_emisor & """," & _
                """postCode"":""" & Forms!fFacturas!cp_emisor & """," & _
                """town"":""" & Forms!fFacturas!ciudad_emisor & """," & _
                """province"":""" & Forms!fFacturas!prov_emisor & """," & _
                """countryCode"":""ESP""}}," & _
        """receiver"":{" & _
            """taxIdNumber"":""" & Forms!fFacturas!nif_receptor & """," & _
            """taxIdCountryCode"":""ESP""," & _
            """legalName"":""" & Forms!fFacturas!razon_receptor & """," & _
            """address"":{" & _
                """address"":""" & Forms!fFacturas!dir_receptor & """," & _
                """postCode"":""" & Forms!fFacturas!cp_receptor & """," & _
                """town"":""" & Forms!fFacturas!ciudad_receptor & """," & _
                """province"":""" & Forms!fFacturas!prov_receptor & """," & _
                """countryCode"":""ESP""}}," & _
        """lines"":[{" & _
            """description"":""" & Forms!fFacturas!concepto & """," & _
            """quantity"":" & Forms!fFacturas!cantidad & "," & _
            """unitPriceWithoutTax"":" & Forms!fFacturas!precio_unit & "," & _
            """totalAmountWithoutTax"":" & Forms!fFacturas!base_imp & "," & _
            """taxRate"":" & Forms!fFacturas!iva & "}]," & _
        """totals"":{" & _
            """totalGrossAmount"":" & Forms!fFacturas!base_total & "," & _
            """totalTaxAmount"":" & Forms!fFacturas!cuota_iva & "," & _
            """totalPayableAmount"":" & Forms!fFacturas!total_factura & "}" & _
    "}"

    '-- Petición HTTP con MSXML2 (soporta TLS 1.2+)
    Dim http As Object
    Set http = CreateObject("MSXML2.ServerXMLHTTP.6.0")

    On Error GoTo ErrHandler
    http.Open "POST", API_URL, False
    http.setRequestHeader "Content-Type", "application/json"
    http.setRequestHeader "X-API-KEY", sApiKey
    http.setRequestHeader "X-Certificate-Password", sPinP12
    http.send sJson

    '-- Evaluar respuesta
    If http.Status = 200 Then
        Dim sXml As String
        sXml = http.responseText

        '-- Guardar XML en disco
        Dim iFile As Integer: iFile = FreeFile
        Dim sRuta As String
        sRuta = CurrentProject.Path & "acturas" & sSerie & "-" & sNumero & ".xml"
        Open sRuta For Output As #iFile
            Print #iFile, sXml
        Close #iFile

        '-- Actualizar tabla
        CurrentDb.Execute "UPDATE tFacturas SET estado='FIRMADA', ruta_xml='" & _
            sRuta & "' WHERE serie='" & sSerie & "' AND numero='" & sNumero & "'"

        MsgBox "✅ Factura generada: " & sRuta, vbInformation
    Else
        MsgBox "❌ Error " & http.Status & ": " & http.responseText, vbCritical
    End If

    Set http = Nothing
    Exit Sub

ErrHandler:
    MsgBox "Error de conexión: " & Err.Description, vbCritical
    Set http = Nothing
End Sub

<?php
/**
 * Data Pilot Tax — Generar factura FacturaE / VeriFactu
 * Compatibilidad: PHP 7.4+  |  WordPress, WooCommerce, Laravel, puro
 * Extensión requerida: ext-curl (activa en casi todos los hostings)
 */

// ── Configuración ─────────────────────────────────────────────────────────────
define('DPT_API_URL',  'https://api.datapilotax.es/api/v1/facturae/json');
define('DPT_API_KEY',  getenv('DPT_API_KEY') ?: 'txp_live_TU_CLAVE_AQUI');
define('DPT_PIN_P12',  getenv('DPT_PIN_P12')  ?: 'PIN_DE_TU_CERTIFICADO');
// ⚠️  Nunca hardcodear credenciales. Usa variables de entorno o wp-config.php

// ── Payload — estructura exacta requerida por el backend ──────────────────────
$payload = [
    'series'    => 'F2025',
    'number'    => '0001',
    'issueDate' => '2025-06-15',   // formato YYYY-MM-DD
    'currency'  => 'EUR',
    'version'   => '3.2.1',

    'issuer' => [
        'taxIdNumber'      => 'B12345678',   // NIF/CIF emisor — 9 chars
        'taxIdCountryCode' => 'ESP',
        'legalName'        => 'Mi Empresa SL',
        'address' => [
            'address'     => 'Calle Gran Vía 1',
            'postCode'    => '28013',
            'town'        => 'Madrid',
            'province'    => 'Madrid',
            'countryCode' => 'ESP',
        ],
    ],

    'receiver' => [
        'taxIdNumber'      => 'A98765432',   // NIF/CIF receptor
        'taxIdCountryCode' => 'ESP',
        'legalName'        => 'Cliente Ejemplo SA',
        'address' => [
            'address'     => 'Avenida Diagonal 100',
            'postCode'    => '08019',
            'town'        => 'Barcelona',
            'province'    => 'Barcelona',
            'countryCode' => 'ESP',
        ],
    ],

    // ⚠️ Clave correcta: "lines" (NO "items")
    'lines' => [
        [
            'description'           => 'Desarrollo módulo ERP integración FacturaE',
            'quantity'              => 1,
            'unitPriceWithoutTax'   => 1500.00,
            'totalAmountWithoutTax' => 1500.00,   // quantity * unitPrice
            'taxRate'               => 21.0,
        ],
    ],

    'totals' => [
        'totalGrossAmount'   => 1500.00,
        'totalTaxAmount'     =>  315.00,   // base * (taxRate/100)
        'totalPayableAmount' => 1815.00,   // gross + tax
    ],
];

// ── Petición cURL ──────────────────────────────────────────────────────────────
$ch = curl_init(DPT_API_URL);
curl_setopt_array($ch, [
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_POST           => true,
    CURLOPT_POSTFIELDS     => json_encode($payload, JSON_UNESCAPED_UNICODE),
    CURLOPT_HTTPHEADER     => [
        'Content-Type: application/json',
        'X-API-KEY: '              . DPT_API_KEY,
        'X-Certificate-Password: ' . DPT_PIN_P12,
    ],
    CURLOPT_TIMEOUT        => 30,
    CURLOPT_SSL_VERIFYPEER => true,   // Nunca deshabilitar en producción
]);

$response = curl_exec($ch);
$httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
$curlErr  = curl_error($ch);
curl_close($ch);

// ── Manejar resultado ──────────────────────────────────────────────────────────
if ($curlErr) {
    error_log('[DataPilotTax] cURL error: ' . $curlErr);
    throw new RuntimeException('Error de red: ' . $curlErr);
}

if ($httpCode === 200) {
    // $response contiene el XML FacturaE firmado
    $filename = 'factura_' . $payload['series'] . '_' . $payload['number'] . '.xml';
    file_put_contents(__DIR__ . '/facturas/' . $filename, $response);

    // Para WooCommerce / WordPress puedes adjuntarlo al pedido:
    // update_post_meta($order_id, '_factura_xml_path', $filename);

    echo "✅ Factura generada: {$filename}";
    return $response;
} else {
    error_log('[DataPilotTax] Error ' . $httpCode . ': ' . $response);
    throw new RuntimeException("Error API ({$httpCode}): {$response}");
}
?>