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

Email Addresses and Phone Numbers as Separate SELECT Values in a ROQL Query

Accepted answer
23
Views
10
Comments
edited Jun 6, 2016 7:36PM in Integrations and APIs 10 comments

Content

We are trying to get the individual phone numbers and email addresses included as separate values in a ROQL SELECT statement, along with other contact fields, in the same returned contact record.

 

In theory, using the database field names from the data dictionary, the query would look something like this:

 

SELECT C.ID, C.email, C.email_alt1, C.email_alt2, C.ph_fax, C.ph_home, C.ph_office, C.ph_mobile, C.ph_asst FROM Contact C

 

The ROQL documentation shows that the individual phone numbers and email addresses are returned as list values and not as separate fields, which implies that what we are looking to do is not possible.  Is there another way to accomplish this that we're not considering?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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