API View has issues with timezones

Follow

Jon Hatto

• February 15, 2014 10:41

Hello,

I am using the API to print a list of items using a view as a filter.
I am using PodioItem::filter_by_view($app_id,$viewid,array('limit' => 500)) to get the data using PHP.
The problem is that when the results are supplied by the API, any date filters seem to be in UTC, so in Australia where I am, my list updates to the current day at 11am each morning (because we are 11 hours behind UTC).
Is there some way of setting the timezone for the API to operate off or is this a bug?

Cheers, Jon.

0

• 

  Andreas Haugstrup Pedersen

  • February 18, 2014 16:16

  Are you authenticating using app authentication or are you authenticating as a user?

  0

  Comment actions Permalink
• 

  Jon Hatto

  • February 23, 2014 22:52

  Hi Andreas, I think it's app auth: Podio::authenticate('app', array('app_id' => $app_id, 'app_token' => $app_token));

  0

  Comment actions Permalink
• 

  Andreas Haugstrup Pedersen

  • February 24, 2014 01:54

  When you authenticate as an app all dates and times will always be in UTC because apps don't have a timezone attached (only Podio users do). You can specify an absolute date in your filters to compensate.

  0

  Comment actions Permalink
• 

  Chang Huang

  • April 19, 2016 12:57

  Do we have any update on this issue?

  I have a custom view of items filtered by month (not using "current month" but the calendar picker by selecting the first day and the last day of the month). The timezone is set to America/Santiago. The date comes back as UTC when authenticating using app.

  The problem is the conversion from American/Santiago to UTC is done before my custom view is filtered. For instance, an item with a date of 31/01/2016 21:00 America/Santiago -3, which should be in the my view of January, after the API call, it gets placed incorrectly into February (01/02/2016 00:00 UTC).

  What is the best way to solve this? Wouldn't it make more sense to do the conversion after the items have been filtered? That way the API returns exactly the same items as in the app, even if the results end up in a different timezone, in this case UTC. Then I can just change it back to America/Santiago using something like Moment.js.

  0

  Comment actions Permalink

Please sign in to leave a comment.