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

How do I find out what is available from roql objects

Accepted answer
12
Views
9
Comments
edited Oct 21, 2016 12:06PM in Integrations and APIs 9 comments

Content

Is there a reference somewhere that tells me what is in each roql object?

For example, I have the following ROQL query:

SELECT id, name.first, name.last, Emails.address, phones.number, phones.phonetype.lookupname
FROM Contact
WHERE ID = 2319

I had to guess "Emails.address" was the name of the field for the email address.  Using the "Connect Object Explorer", I find "Contact" on the list.  I click on Contact and find that "Emails" is on the list.  I click on that and I get this:

(see attached image)

No mention of an address string at all.  So I thought maybe there is an Email object which will give me more information, but no there isn't.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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