x

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,334 Views
Message 1 of 4
Report
1 Best Answer
Admin

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

Did you find help in the Seller Community? Mark a Best Answer to help others.

View Best Answer >

1,320 Views
Message 2 of 4
Report
3 REPLIES 3
Admin

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

Did you find help in the Seller Community? Mark a Best Answer to help others.
1,321 Views
Message 2 of 4
Report

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

1,302 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,293 Views
Message 4 of 4
Report