StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
15560585
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-03-22T00:21:36.977
FavoriteCount
0
LastActivityDate
2013-03-22T00:21:36.977
LastEditDate
2017-05-23T10:29:39.853
LastEditorUserId
-1
OwnerUserId
1217417
ParentId
11935200
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
As of March 21, 2013 Google is not providing this information in their response to the userinfo.profile endpoint -- even though they claim that they do. This documentation claims that timezone is available: <a href="https://developers.google.com/accounts/docs/OAuth2Login?hl=en#userinfocall" rel="nofollow noreferrer">https://developers.google.com/accounts/docs/OAuth2Login?hl=en#userinfocall</a> However, the current implementation only returns the following data: <ul> <li>id</li> <li>email</li> <li>verified_email</li> <li>name</li> <li>given_name</li> <li>family_name</li> <li>link (to G+ profile, if available)</li> <li>gender</li> <li>birthday</li> <li>locale</li> <li>hd (appears to be the Google Apps domain, if relevant)</li> </ul> Note that "birthday" and "hd" are not listed in the current documentation on the page listed above. I am verifying these fields from real-world responses I'm receiving from the endpoint. The best approach for getting timezone at the moment is probably to use JavaScript (to retrieve the timezone from the user's browser). This StackOverflow answer explains how to do so: <a href="https://stackoverflow.com/questions/1091372/getting-the-clients-timezone-in-javascript">Getting the client's timezone in JavaScript</a> Unfortunately, this would have to occur as a secondary action, meaning you'd have to add this data to your database separately from the data retrieved from the endpoint. One trick to consider is capturing the timezone offset on the page where you initiate the endpoint request, and then appending the timezone offset value to the "state" value in your OAuth request. This value will then be returned on the callback, and you could extract and add it to the other profile information that was returned during the same procedure in which you write to your database.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POGoogle auth2 API has missing timezone info?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USb.rad
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.