We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

ROQL- multiple rows into a single row

Received Response
27
Views
2
Comments
edited Jan 28, 2019 11:33AM in Integrations and APIs 2 comments

Summary

How to return multiple rows into one row with ROQL via rest API

Content

Hi All

We are using a ROQL query via the Service Cloud REST API and have a questions with how the results are displayed.

The below query returns two rows and we are trying to figure out how to just return the results into one row with the specified column values displayed.

the query is:

SELECT
BS.Name "Business Service",
CM.Name "Customer Name",
C.Version "Product Version",
M.Name "Member Name",
M.Function"Member Function",
A.login "Business Owner",
CE.CustomerAccountNumber "Customer Account Number"
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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