I am lost when it comes to API calls in SugarCRM.. I want to have a better understanding.
Can someone give me an example of dashlet with an API call in it?
Thank you
Eventually I will need to create an api call that returns data for this query.
SELECT IFNULL(lev_contracts.id,'') primaryid
,IFNULL(lev_contracts.cost_center,'') cost_center
,IFNULL(assigned_user.id,'') assigned_user_id
,CONCAT(
IFNULL(assigned_user.first_name,''),
' ',
IFNULL(assigned_user.last_name,'')
) assigned_user_full_name
,lev_contracts.contract_id_gen contract_num
,IFNULL(lev_contracts.account_id_c,'') associated_account
,IFNULL(accounts1.name,'') associated_account_name
,IFNULL(lev_contracts.id,'') lev_contracts_id
,courses_cstm.lev_course_catalog_id_c course_catalog_id
,IFNULL(lev_course_catalog2.name,'') course_catalog_name
,IFNULL(courses.contact_id_c,'') courses_contact_id_c
,LTRIM(RTRIM( CONCAT(IFNULL(contacts3.first_name,''),' ',IFNULL(contacts3.last_name,'')) )) contacts3_name
,IFNULL(contacts3.id,'') contact3_id
,courses.start_date courses_start_date
,courses.billing_date courses_billing_date
,courses.total_client_fee courses_total_client_fee
,IFNULL( courses.currency_id,'') courses_TOTAL_CLIENT_FEE_CU4402B2
,courses.total_expense courses_total_expense
,IFNULL( courses.currency_id,'') courses_total_expense_currency
,courses.course_net courses_course_net
,IFNULL( courses.currency_id,'') courses_course_net_currency
,courses.gross_margin courses_gross_margin
FROM lev_contracts
LEFT JOIN lev_contracts_lev_courses_c contract_courses ON lev_contracts.id=contract_courses.lev_contracts_lev_courseslev_contracts_ida AND contract_courses.deleted=0
LEFT JOIN lev_courses courses ON courses.id=contract_courses.lev_contracts_lev_courseslev_courses_idb AND courses.deleted=0
INNER JOIN users assigned_user ON lev_contracts.assigned_user_id=assigned_user.id AND assigned_user.deleted=0
LEFT JOIN accounts accounts1 ON accounts1.id = lev_contracts.account_id_c
LEFT JOIN lev_courses_cstm courses_cstm ON courses.id = courses_cstm.id_c
LEFT JOIN lev_course_catalog lev_course_catalog2 ON lev_course_catalog2.id = courses_cstm.lev_course_catalog_id_c
LEFT JOIN contacts contacts3 ON contacts3.id = courses.contact_id_c
WHERE ({$this->where['billing_date']})
AND ({$this->where['cost_center']})
AND ({$this->where['associated_account']})
AND lev_contracts.deleted=0
ORDER BY lev_contracts.cost_center
, accounts1.name
,lev_contracts.contract_id_gen
,courses.billing_date ASC
