SiteLink CallCenter API timezone

terencey

I'm posting here because I'm quite confused with the way SiteLink API parses and returns information where timezone is important.

My site/facility is set to Singapore time, GMT+8.

I'm using TenantInvoicesByTenantID, requesting for all invoices for a particular tenant, from 0000 hrs to 2359hrs of a particular day.

This is my request body:

<?xml version="1.0" encoding="utf-8"?>

<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">

  <soap12:Body>

    <TenantInvoicesByTenantID xmlns="http://tempuri.org/CallCenterWs/CallCenterWs">

      <sCorpCode>XXXX</sCorpCode>

      <sLocationCode>XXXX</sLocationCode>

      <sCorpUserName>XXXX</sCorpUserName>

      <sCorpPassword>XXXX</sCorpPassword>

      <dDateStart>2021-08-06T00:00:00</dDateStart>

        <dDateEnd>2021-08-06T23:59:59</dDateEnd>

      <sTenantIDsCommaDelimited>739884</sTenantIDsCommaDelimited>

    </TenantInvoicesByTenantID>

  </soap12:Body>

</soap12:Envelope>

Question 1: Does the API interpret this as "Give me all invoices invoiced on 6 Aug 2021 GMT+8", or "Give me all invoices invoiced on 06 Aug 2021 UTC"?

This is a snippet of the response I receive:

...

<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">

  <NewDataSet xmlns="">

      <Table diffgr:id="Table1" msdata:rowOrder="0">

          <SiteID>XXXX</SiteID>

          <InvoiceID>3154108</InvoiceID>

          <iInvoiceNum>24110</iInvoiceNum>

          <dInvoiced>2021-08-06T09:18:13.577-04:00</dInvoiced>

          <EmployeeID>7364</EmployeeID>

          <TenantID>739884</TenantID>

          <dDue>2021-08-20T23:59:59-04:00</dDue>

          <dUpdated>2021-08-05T21:18:14.693-04:00</dUpdated>

          <iDetailCount>2</iDetailCount>

      </Table>

...

Question 2: dInvoiced is 2021-08-06T09:18:13.577-04:00. Do I take this to mean that this invoice was invoiced on 6 Aug 2021 GMT-5, and when I convert it to GMT+8, be 7 Aug 2021 GMT +8? Or do I take this to mean that the invoice was invoiced on 6 Aug 2021 GMT+8, please ignore the timezone?

storable_support

Hi, @terencey. We're sorry for this confusion and to best assist you, please contact apisupport@storable.com. Thank you!

terencey

Thanks @storable_support

Is apisupport@storable.com different from support@storable.com?

The reason I asked this question in the forums is because I'm not getting a clear and direct answer from support@storable.com.

storable_support

Hi again, @terencey; yes, apisupport@storable.com is the support address for all API-related issues that are typically out of scope for Support. We're so glad that you asked, so we could better direct you. Additionally, we're going to make sure that Support knows to do this moving forward for all customers reaching out with API questions. Thank you, Amy C.