Stripe API and UNIX Timestamps

[alexcooney5]

It has been noted before that retrieving date values via the Stripe API can cause issues.

Timestamp Jan 18th 1970

Hi there, I’m having trouble to convert a timestamp to a date formatted like 6/21/2018. The Text recognise the data received from an API call as a timestamp but in the RG always displays Jan 18th 1970: [imagen] Anyone can help? Thanks a lot.

Basically Stripe dates are defined as UNIX timestamps (seconds), whereas Bubble expects milliseconds.

Solutions have been suggested:

Convert unix time to date field

Stripe returns seconds and Bubble expects milliseconds. Some discussion here with some workarounds: Another workaround which is handy if using API workflows: a plugin that sends the seconds to MathJS API and returns the result as date form.

But what I REALLY don’t understand is why this is an issue when I retrieve a date value via a GET API Call like below:

GET API Call

Resulting Value in Database

For reference, this is the API call I’m using - the “current_period_end” and “current_period_start” are set to be date (UNIX):

Annoying.

But what’s more annoying is that when I get the same values via a webhook, it seems to work absolutely fine?

Webhook pulling in subscription data

Resulting value in database

Anyone have any idea why the webhook vs. GET API call would result in different outcomes?

[mishav]

@alexcooney5

Anyone have any idea why the webhook vs. GET API call would result in different outcomes?

They should both work, so its a bug. Can you raise a bug report with Bubble while you have all the info ready?

Bubble seem more inclined to fix bugs than they have been in the past.

Regarding workarounds, did you see one that didn’t need to use a plugin? for reference
It is a really old hack, there might be an easier way by now.

[alexcooney5]

Thanks @mishav, have submitted a bug report so hopefully they can figure it out.

On another note, thanks for your plugins and all you’ve contributed to bubble over the years.