KarlS-PI | Stripe Developers | Page 1

agile plover Sep 29, 2021, 1:29 AM

#

hello @river pewter! can you share your req id, it'd look something like req_123

river pewter Sep 29, 2021, 1:31 AM

#

yep, 1 sec.

#

looking. is it under Logs under Developers?

agile plover Sep 29, 2021, 1:33 AM

#

yep, but you would need to click on the Method button and select 'GET' methods

#

otherwise it doesn't show GET methods in the logs by default

river pewter Sep 29, 2021, 1:34 AM

#

req_pmNWHzX0JEoPFe

agile plover Sep 29, 2021, 1:37 AM

#

give me a second to look into this

river pewter Sep 29, 2021, 1:37 AM

#

ok

agile plover Sep 29, 2021, 1:51 AM

#

@river pewter doesn't look like you're using PaymentIntents in your integration, can you switch to retrieving Charges instead? https://stripe.com/docs/api/charges/list

Stripe API reference – List all charges

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

river pewter Sep 29, 2021, 1:53 AM

#

OK, I may have sent wrong req_. keep this thread alive. Just sitting down for dinner.

agile plover Sep 29, 2021, 1:55 AM

#

sure thing!

river pewter Sep 29, 2021, 2:10 AM

#

Just ran another request for Payments

#

The date I sent was 9/28/2021 5:14:36 PM

#

The request is: req_b1oSyRodb6gsgN

#

And this date/time is this PI: pi_3Jejt2G30Vl6ne6N0jUYEf9r

#

I think I see the problem Alex.

agile plover Sep 29, 2021, 2:18 AM

#

out of curiosity what was it?

river pewter Sep 29, 2021, 2:19 AM

#

The time that I am saving to DB is my local time (which I do not understand) and the time I see on the PI is 3 hours earlier

#

So... if I fetch dates from Stripe API, are the date/times returned local time?

agile plover Sep 29, 2021, 2:23 AM

#

Stripe API uses the unix timestamp (not local time)

river pewter Sep 29, 2021, 2:24 AM

#

OK, I'm going to run a test

#

well that is it, but now need to understand the date/time conversion

agile plover Sep 29, 2021, 2:31 AM

#

datetime conversions are my bane, i'm absolutely terrible with it

river pewter Sep 29, 2021, 2:32 AM

#

what timezone is the Stripe UI?

agile plover Sep 29, 2021, 2:32 AM

#

you mean your Dashboard?

river pewter Sep 29, 2021, 2:32 AM

#

yes

#

so this PI for example: https://dashboard.stripe.com/payments/pi_3Jejt2G30Vl6ne6N0jUYEf9r

#

I see a payment date of 9/28 1:14 PM

agile plover Sep 29, 2021, 2:34 AM

#

you would need to check your Dashboard settings here : https://dashboard.stripe.com/settings/account

#

there's a time zone field

river pewter Sep 29, 2021, 2:37 AM

#

OK, I see it. The API is giving me a different time than what I see as the Time Zone, so is the API date/time all UTC?

agile plover Sep 29, 2021, 2:39 AM

#

yes the API date/time is all UTC

river pewter Sep 29, 2021, 2:51 AM

#

Alex

#

Can you confirm the Create Date Time of this PI: pi_3Jejt2G30Vl6ne6N0jUYEf9r

agile plover Sep 29, 2021, 2:54 AM

#

1632849276

#

or in a more readable format : 2021-09-28 17:14:36

river pewter Sep 29, 2021, 2:55 AM

#

I see the problem (on my end)

#

I put the date/time in DB without UTC syntax and when I parse it in C# it parses to my local date/time.

agile plover Sep 29, 2021, 2:57 AM

#

aaaaah, it's great that you've managed to figure it out

#KarlS-PI