Database 2 hours behind

Hey!

 

When i get API data from Squareup, then it is 2 hours behind.

 

Transation on my dashboard:
https://imgur.com/H5oVWeM

 

JSON from the API call:

exports {
  id: 'TYhXlyhzeHRWtzQPa1K1VvMF',
  merchant_id: 'TCH7AT15N0G88',
  created_at: '2019-04-01T21:52:51Z',
  device:
   exports {
     id:
      'DEVICE_INSTALLATION_ID:3D8C51BF-5D5D-4EE7-A89F-E9E5DC39CC0A',
     name: 'Mikkeller' },
  payment_url:
   'https://squareup.com/dashboard/sales/transactions/tb1dEFtxnjqHTg24Pgg4Tq6eV',
  receipt_url:
   'https://squareup.com/receipt/preview/TYhXlyhzeHRWtzQPa1K1VvMF',
  inclusive_tax_money: exports { amount: 194, currency_code: 'USD' },
  additive_tax_money: exports { amount: 0, currency_code: 'USD' },
  tax_money: exports { amount: 194, currency_code: 'USD' },
  tip_money: exports { amount: 675, currency_code: 'USD' },
  discount_money: exports { amount: 0, currency_code: 'USD' },
  total_collected_money: exports { amount: 3375, currency_code: 'USD' },
  processing_fee_money: exports { amount: -93, currency_code: 'USD' },
  net_total_money: exports { amount: 3282, currency_code: 'USD' },
  refunded_money: exports { amount: 0, currency_code: 'USD' },
  swedish_rounding_money: exports { amount: 0, currency_code: 'USD' },
  gross_sales_money: exports { amount: 2506, currency_code: 'USD' },
  net_sales_money: exports { amount: 2506, currency_code: 'USD' },
  inclusive_tax:
   [ exports {
       name: 'Sales Tax',
       applied_money: [exports],
       rate: '0.07750000',
       inclusion_type: 'INCLUSIVE',
       fee_id: 'L2ZVORXHYA2UCQTIPKIQYQYF' } ],
  additive_tax: [],
  tender:
   [ exports {
       id: 'TYhXlyhzeHRWtzQPa1K1VvMF',
       type: 'CREDIT_CARD',
       name: 'Credit Card',
       employee_id: '4Sn4rgA50zE7ptczHMjn',
       receipt_url:
        'https://squareup.com/receipt/preview/TYhXlyhzeHRWtzQPa1K1VvMF',
       card_brand: 'VISA',
       pan_suffix: '0592',
       entry_method: 'SWIPED',
       total_money: [exports],
       tendered_at: '2019-04-01T21:52:48Z',
       settled_at: '2019-04-01T21:52:52Z',
       refunded_money: [exports],
       is_exchange: false } ],
  refunds: [],
  itemizations:
   [ exports {
       name: 'Beards in the Letterbox',
       quantity: 1,
       itemization_type: 'ITEM',
       item_detail: [exports],
       notes:
        '- Double IPA fermented with Kveik Yeast with Idaho 7 and Rakau hops \n- 7.7% ABV \n- Big aromas of peach, apricot, and stone fruit that lead into a tea and resinous finish. Fruit flavors carry over onto the mouth with a big body that displays marmalade and stone fruit. ',
       item_variation_name: '12 oz. Full Pour',
       total_money: [exports],
       single_quantity_money: [exports],
       gross_sales_money: [exports],
       discount_money: [exports],
       net_sales_money: [exports],
       taxes: [Array],
       discounts: [],
       modifiers: [] },
     exports {
       name: 'Oh Hi Murk 4-pack',
       quantity: 1,
       itemization_type: 'ITEM',
       item_detail: [exports],
       item_variation_name: '4- Pack',
       total_money: [exports],
       single_quantity_money: [exports],
       gross_sales_money: [exports],
       discount_money: [exports],
       net_sales_money: [exports],
       taxes: [Array],
       discounts: [],
       modifiers: [] } ],
  surcharge_money: exports { amount: 0, currency_code: 'USD' },
  surcharges: [] }

Do anyone know why?

1,807 Views
Message 1 of 4
Report
1 Best Answer
Alumni

Best Answer

@Peter-Kvalifik I just ran this by an API specialist who confirmed that all transactions are reported in UTC time. It looks like you're located two hours ahead of that. Sorry for any confusion! 

️ Helen
Seller Community Manager

View Best Answer >

1,793 Views
Message 2 of 4
Report
3 REPLIES 3
Alumni

Best Answer

@Peter-Kvalifik I just ran this by an API specialist who confirmed that all transactions are reported in UTC time. It looks like you're located two hours ahead of that. Sorry for any confusion! 

️ Helen
Seller Community Manager

1,794 Views
Message 2 of 4
Report

I see. Is this only for the states? Because the Timestampe fits fine in CET.

1,775 Views
Message 3 of 4
Report
Square Community Moderator

Correct. Because of it being recorded in UTC time. 

Ashley C
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
1,766 Views
Message 4 of 4
Report