pixiGetServerTime · Pixi API documentation

Returns a single row with two columns:

ServerTime: the current local date and time of the SQL Server (CURRENT_TIMESTAMP).
ServerTimeUTC: the current date and time in UTC (GETUTCDATE()).

The call has no parameters and does not access any tables.

Notes

Useful to determine the time zone offset of the Pixi server, e.g. before passing date filters such as "changed since" to other calls that compare against server-local timestamps.
Both values are datetime with a precision of about 3 milliseconds.
ServerTime reflects the time zone setting of the database server's operating system.
Also suitable as a lightweight connectivity or authentication check.

This call has no parameters.

Result set 1 · Always

One row with the current server time in local time and in UTC.

Column	Type	Description
`ServerTime`	datetime dateTime	Current local date and time of the database server.
`ServerTimeUTC`	datetime dateTime	Current date and time in UTC.

Response example

<SqlRowSet1>
  <row>
    <ServerTime>2024-05-14T14:32:07.123+02:00</ServerTime>
    <ServerTimeUTC>2024-05-14T12:32:07.123+02:00</ServerTimeUTC>
  </row>
</SqlRowSet1>

POST https://apigateway.descartes.com/tms/pixi/
Content-Type: text/xml; charset=utf-8
Authorization: Basic BASE64(USERNAME:PASSWORD)

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://apigateway.descartes.com/tms/pixi/">
  <SOAP-ENV:Body>
    <ns1:pixiGetServerTime/>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

curl -X POST 'https://apigateway.descartes.com/tms/pixi/' \
  --user 'USERNAME:PASSWORD' \
  --header 'Content-Type: text/xml; charset=utf-8' \
  --data-binary @- <<'XML'
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://apigateway.descartes.com/tms/pixi/">
  <SOAP-ENV:Body>
    <ns1:pixiGetServerTime/>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>
XML

<?php

$soapClient = new SoapClient(null, [
    'login' => 'USERNAME',
    'password' => 'PASSWORD',
    'location' => 'https://apigateway.descartes.com/tms/pixi/',
    'uri' => 'https://apigateway.descartes.com/tms/pixi/',
]);

$arguments = [
];

$soapArguments = [];
foreach ($arguments as $name => $value) {
    $soapArguments[] = new SoapVar($value, XSD_STRING, '', '', $name);
}

$response = $soapClient->__soapCall('pixiGetServerTime', $soapArguments);