You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

CreatedTime and UpdatedTime in Account table are blank

Received Response
edited Feb 19, 2018 3:05PM in Integrations and APIs 4 comments


Hi all,

I'm not the most technical so bear with me.   For an integration/SSO solution I need to query the accounts table and pull up a list of account created/edited between a certain time - so i get my delta.   To start with I've built a query to show all accounts:

select name.first, name.last, login, emails.address, updatedtime, createdtime from Account

This is where my problems start.   I'm getting no data returned for updatedtime or createdtime (see screen shot).    If I switch to another table (contact, incident, organization) i get data.   I know the Accounts table doesn't have an explicit created or updated field in it according to data dictionary - however in the agent desktop editing an account and clicking audit log shows there is data present.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!