Xano handles all timestamps in milliseconds. Integrations like Stripe use seconds.
To convert Stripe timestamp 1717306413 to Xano 1717306413000 is simple to multiply by 1000.
However, Stripe may also return null or missing keys and when performing a math calculation returns an error because the value is null or missing.
The Get filter works for null or missing keys, however fails if multiply filter is added.
What I have done for now:
If value is_empty = true, create variable = null
If value is_empty = false, create variable * 1000 = timestamp in milliseconds
As Stripe has many webhooks and many dates, the way I have achieved a successful result would require many If statements.
Is there a better way to handle this?
The solution should cover all 3 scenarios, timestamp in seconds, null values, and missing keys.