ROQL- multiple rows into a single row

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"