Exemplos

Resposta

REST API

https://e2e.pt/api/#!/tools/querySql

Mais Informações

Código Fonte

<?php

require_once '../vendor/autoload.php';

use Swagger\Client\Api\ToolsApi;
use Swagger\Client\ApiException;

// PARAMETERS
$query = clear('query');

// E2E ACCESS KEYS
$client = new GuzzleHttp\Client([
    'headers' => [
        'api_key' => 'JHSV2V6KyqcbxvMHshRlPfunJymVt7GDfXyoK229o=',
        'company_key' => 'E2ELIVE',
    ]
]);

try {
    
    // EXECUTE SQL QUERY ON ERP DATABASE
    $api = new ToolsApi($client);
    $result = $api->querySql($query);
    
    if(empty($result)) {
        http_response_code(404);
        return;
    }
    
    header('Content-Type: application/json; charset=utf-8');
    echo $result->__toString();
    
} catch (Exception $e) {
    
    http_response_code($e->getCode());
    
    $msg = $e instanceof ApiException ? $e->getResponseBody() : $e->getMessage();
    
    if (!empty($msg)) {
        echo $msg;
    }
}

function clear($field)
{
    return empty($_REQUEST[$field]) ? null : $_REQUEST[$field];
}