AnsweredAssumed Answered

REST V10 Report Data - So Close

Question asked by Gavan Walker on May 2, 2016
Latest reply on May 15, 2016 by Gavan Walker

Hey Guys,

 

I've done my research, used wrappers - read the API and all examples end at the same point which is retrieving the report heading\names ect but never the report data.

 

I've followed the https://developer.sugarcrm.com/?s=Export+Report guide and I get back below.

My expected action is to retrieve the below WITH the report data.

Currently, only the display columns are returned.

 

I think prehaps before the CURL request I maybe need to POST some stuff to it stating I would like it returned in full... but can't find any documentation or examples on this

 

My code below

$curl = curl_init($url . "/Reports/c6eaf84e-cde2-38e8-3267-571efc8a4ab7");
curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "GET");
curl_setopt($curl, CURLOPT_HEADER, false);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_HTTPHEADER, array('Content-Type: application/json',"OAuth-Token: $token"));
// Make the REST call, returning the result
$response = curl_exec($curl);
//var_dump($response);
$response = json_decode($response);

 

This outputs the below

 

stdClass::__set_state(array(
  'team_count' => '',
  'team_name' => 
  array (
  0 => 
  stdClass::__set_state(array(
  'id' => 1,
  'name' => 'Global',
  'name_2' => '',
  'primary' => true,
  )),
  ),
  'id' => 'c6eaf84e-cde2-38e8-3267-571efc8a4ab7',
  'name' => 'Weekly Calendar ',
  'module' => 'Contacts',
  'report_type' => 'tabular',
  'content' => '{"display_columns":[{"name":"date_start","label":"Start Date","table_key":"Contacts:meetings"},{"name":"full_name","label":"Full Name","table_key":"Contacts:assigned_user_link"},{"name":"meeting_type_c","label":"Meeting Type","table_key":"Contacts:meetings"},{"name":"location","label":"Location","table_key":"Contacts:meetings"},{"name":"title","label":"Title","table_key":"self"},{"name":"alt_address_city","label":"Physical Address City","table_key":"self"},{"name":"referral_source_c","label":"Referral Source","table_key":"self"},{"name":"first_appointment_consultant_c","label":"First Appointment Consultant","table_key":"self"},{"name":"first_appointment_c","label":"First Appointment","table_key":"self"},{"name":"booking_fee_c","label":"Booking Fee","table_key":"self"},{"name":"personal_borrow_capacity_c","label":"Personal Borrow Capacity","table_key":"self"},{"name":"smsf_borrowing_capacity_c","label":"SMSF Borrowing Capacity","table_key":"self"},{"name":"status","label":"Status","table_key":"Contacts:meetings"},{"name":"second_meeting_result_c","label":"Meeting Result","table_key":"Contacts:meetings"}],"module":"Contacts","group_defs":[],"summary_columns":[],"report_name":"Weekly Calendar ","chart_type":"none","do_round":1,"numerical_chart_column":"","numerical_chart_column_type":"","assigned_user_id":"975c440f-5951-d8a6-2b2c-54e1764e5324","report_type":"tabular","order_by":[{"name":"date_start","vname":"Start Date","type":"datetimecombo","dbType":"datetime","importable":"required","required":true,"enable_range_search":true,"options":[{"value":"=","text":"Equals"},{"value":"not_equal","text":"Not On"},{"value":"greater_than","text":"After"},{"value":"less_than","text":"Before"},{"value":"last_7_days","text":"Last 7 Days"},{"value":"next_7_days","text":"Next 7 Days"},{"value":"last_30_days","text":"Last 30 Days"},{"value":"next_30_days","text":"Next 30 Days"},{"value":"last_month","text":"Last Month"},{"value":"this_month","text":"This Month"},{"value":"next_month","text":"Next Month"},{"value":"last_year","text":"Last Year"},{"value":"this_year","text":"This Year"},{"value":"next_year","text":"Next Year"},{"value":"between","text":"Is Between"}],"table_key":"Contacts:meetings","sort_dir":"d"}],"full_table_list":{"self":{"value":"Contacts","module":"Contacts","label":"Contacts","dependents":[]},"Contacts:meetings":{"name":"Clients \\u003E Meetings","parent":"self","link_def":{"name":"meetings","relationship_name":"meetings_contacts","bean_is_lhs":false,"link_type":"many","label":"Meetings","module":"Meetings","table_key":"Contacts:meetings"},"dependents":["Filter.1_table_filter_row_1","display_cols_row_1","display_cols_row_3","display_cols_row_4","display_cols_row_14","display_cols_row_15","Filter.1_table_filter_row_1","display_cols_row_1","display_cols_row_3","display_cols_row_4","display_cols_row_14","display_cols_row_15","Filter.1_table_filter_row_1","display_cols_row_1","display_cols_row_3","display_cols_row_4","display_cols_row_13","display_cols_row_14"],"module":"Meetings","label":"Meetings","optional":true},"Contacts:assigned_user_link":{"name":"Clients \\u003E Assigned to User","parent":"self","link_def":{"name":"assigned_user_link","relationship_name":"contacts_assigned_user","bean_is_lhs":false,"link_type":"one","label":"Assigned to User","module":"Users","table_key":"Contacts:assigned_user_link"},"dependents":["display_cols_row_2","display_cols_row_2","display_cols_row_2"],"module":"Users","label":"Assigned to User","optional":true}},"filters_def":{"Filter_1":{"operator":"AND","0":{"name":"date_start","table_key":"Contacts:meetings","qualifier_name":"tp_next_7_days","input_name0":"tp_next_7_days","input_name1":"on"},"1":{"name":"title","table_key":"self","qualifier_name":"not_empty","input_name0":"not_empty","input_name1":"on"}}}}',
  'deleted' => false,
  'date_entered' => '2016-04-26T15:27:17+10:00',
  'date_modified' => '2016-05-03T13:18:47+10:00',
  'assigned_user_id' => '975c440f-5951-d8a6-2b2c-54e1764e5324',
  'modified_user_id' => 'c29ffe9c-c329-4d39-a7b0-54d3b82b58b8',
  'assigned_user_name' => 'CE NSW Calendar',
  'created_by' => '975c440f-5951-d8a6-2b2c-54e1764e5324',
  'is_published' => false,
  'last_run_date' => '',
  'chart_type' => 'none',
  'schedule_type' => 'pro',
  'favorite' => '',
  'my_favorite' => false,
  '_acl' => 
  stdClass::__set_state(array(
  'fields' => 
  stdClass::__set_state(array(
  )),
  )),
  '_module' => 'Reports',
))

Outcomes