Answers.Body: <p>If you choose a particular report id rather than a general template it should get the config from that report. I'm not sure if it picks up stuff from anywhere from the default templates (e.g first configured instance of that template).</p>
  
  <p>You can pass in other parameters somewhat in line with the POST vars I believe</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-06-16T06:19:53.903Z
Answers.Text: Thanks Eileen for responding! As far as I know, the only way to retrieve report is to query on the **ReportTemplate** entity  which requires a **report_id** to be specified. So, in the example, I did specify a *particular* report_id, that is **contact/summary**.
  
  Could you please post an example query which retrieves a report through the rest API as expected (with all columns configured for a report in the UI)?
Answers.UserDisplayName: Mouna A
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-06-15T21:00:57.753Z
Answers.LastActivityDate: 2016-06-15T21:00:57.753Z
Answers.UserDisplayName: Eileen
Answers.Body: <p>A report id could be a number of a report instance as well a string representing a template</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-06-22T21:44:08.517Z
Answers.LastActivityDate: 2016-06-22T21:44:08.517Z
Answers.UserDisplayName: Eileen
Body: <p>I have been trying to retrieve reports based on default report templates through REST API calls. But the fields returned for each report instance is not same as what it is supposed to according to a report instance's description.</p>
  
  <p>Here is an example query in the API explorer,</p>
  
  <p>Query to retrieve Constituent Summary report: </p>
  
  <p><a href="https://i.sstatic.net/FVSoK.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/FVSoK.png" alt="Query"></a></p>
  
  <p>Here is the result of the query:</p>
  
  <p><a href="https://i.sstatic.net/XSrXe.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/XSrXe.png" alt="query result"></a></p>
  
  <p>The default description of the Constituent Summary report is:</p>
  
  <blockquote>
    <p>Provides a list of address and telephone information for constituent records in your system.</p>
  </blockquote>
  
  <p>But as you see the result of the query, all the returned rows have only name, and there is no other option in the API explorer to specify fields to be returned.</p>
  
  <p>Things I did to analyse/rectify my query's result it further:</p>
  
  <ul>
  <li>Made sure that the report instance created in the UI has more than one column selected (that is, not only name but other fields like address, email etc.)</li>
  <li>Deleted the default report instance and created by own in the UI based on the default report templates. But still, the API query returns only these specific fields (in image.)</li>
  </ul>
  
  <p>The above behavior is true for all query against report: It returns only specific fields/columns irrespective of the column selected in the UI.</p>
  
  <p>Please let me know how can I retrieve a report with all columns (as specified for a particular report in Reports tab)</p>
  
Tags: <api><civireport><reports><rest>
Title: CiviCRM REST API query doesn't return all fields of a 'Report'
ThreadText: # CiviCRM REST API query doesn't return all fields of a 'Report'
  
  (Asked by: username_0 on 2016-06-15)
  
  I have been trying to retrieve reports based on default report templates through REST API calls. But the fields returned for each report instance is not same as what it is supposed to according to a report instance's description.
  
  Here is an example query in the API explorer,
  
  Query to retrieve Constituent Summary report:
  
  [![Query](https://i.sstatic.net/FVSoK.png)](https://i.sstatic.net/FVSoK.png)
  
  Here is the result of the query:
  
  [![query result](https://i.sstatic.net/XSrXe.png)](https://i.sstatic.net/XSrXe.png)
  
  The default description of the Constituent Summary report is:
  
  > Provides a list of address and telephone information for constituent records in your system.
  
  But as you see the result of the query, all the returned rows have only name, and there is no other option in the API explorer to specify fields to be returned.
  
  Things I did to analyse/rectify my query's result it further:
  
  * Made sure that the report instance created in the UI has more than one column selected (that is, not only name but other fields like address, email etc.)
  * Deleted the default report instance and created by own in the UI based on the default report templates. But still, the API query returns only these specific fields (in image.)
  
  The above behavior is true for all query against report: It returns only specific fields/columns irrespective of the column selected in the UI.
  
  Please let me know how can I retrieve a report with all columns (as specified for a particular report in Reports tab)
  
  **Tags:** api, civireport, reports, rest
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-06-15. Score: 1
  
  If you choose a particular report id rather than a general template it should get the config from that report. I'm not sure if it picks up stuff from anywhere from the default templates (e.g first configured instance of that template).
  
  You can pass in other parameters somewhat in line with the POST vars I believe
  
  > **Comments:**
  > **username_0**: Thanks username_1 for responding! As far as I know, the only way to retrieve report is to query on the **ReportTemplate** entity  which requires a **report_id** to be specified. So, in the example, I did specify a *particular* report_id, that is **contact/summary**.  Could you please post an example query which retrieves a report through the rest API as expected (with all columns configured for a report in the UI)?  
  
  ---
  
  ### Answer by username_1 on 2016-06-22. Score: 0
  
  A report id could be a number of a report instance as well a string representing a template
  
  
  ---
  
  