Different results get_entry vs get_entry_list
fwbam opened this issue · 1 comments
When I run
get_entry
I get a result that looks like this:
{'entry_list': [{'id': '1111111', 'module_name': 'tr_Trainings', 'name_value_list': {'assigned_user_name': {'name': 'assigned_user_name', 'value': 'KA'}, 'modified_by_name': {'name': 'modified_by_name', 'value': 'BM'}, 'created_by_name': {'name': 'created_by_name', 'value': 'KA'}, 'id': {'name': 'id', 'value': '2222222'}, 'name': {'name': 'name', 'value': '4H'}, 'date_entered': {'name': 'date_entered', 'value': '2019-02-01 20:53:39'}, 'date_modified': {'name': 'date_modified', 'value': '2019-02-15 20:36:06'}, 'modified_user_id': {'name': 'modified_user_id', 'value': '3333333'}, 'created_by': {'name': 'created_by', 'value': '4444444'}, 'description': {'name': 'description', 'value': ''}, 'deleted': {'name': 'deleted', 'value': 0}, 'training_type': {'name': 'training_type', 'value': 'half'}, 'training_status': {'name': 'training_status', 'value': 'training_partial'}, 'purchased_date': {'name': 'purchased_date', 'value': '2019-02-07'}, 'training_start_date': {'name': 'training_start_date', 'value': ''}, 'training_end_date': {'name': 'training_end_date', 'value': ''}, 'account_id_c': {'name': 'account_id_c', 'value': ''}, 'company_name': {'name': 'company_name', 'value': ''}, 'following': {'name': 'following', 'value': ''}, 'my_favorite': {'name': 'my_favorite', 'value': False}, 'tag': {'name': 'tag', 'value': ''}, 'locked_fields': {'name': 'locked_fields', 'value': ''}, 'team_id': {'name': 'team_id', 'value': '1'}, 'team_set_id': {'name': 'team_set_id', 'value': '1'}, 'acl_team_set_id': {'name': 'acl_team_set_id', 'value': ''}, 'team_name': {'name': 'team_name', 'value': 'Global'}, 'acl_team_names': {'name': 'acl_team_names', 'value': ''}, 'assigned_user_id': {'name': 'assigned_user_id', 'value': '5555555'}, 'training_completed_c': {'name': 'training_completed_c', 'value': ''}, 'purchased_c': {'name': 'purchased_c', 'value': 'training'}, 'accounts_tr_trainings_1_name': {'name': 'accounts_tr_trainings_1_name', 'value': 'ZSD'}, 'accounts_tr_trainings_1accounts_ida': {'name': 'accounts_tr_trainings_1accounts_ida', 'value': '6666666'}, 'date_completed_c': {'name': 'date_completed_c', 'value': ''}, 'pro_services_c': {'name': 'pro_services_c', 'value': 'one_half_day_pro'}, 'trainer_c': {'name': 'trainer_c', 'value': 'bm'}, 'project_details_c': {'name': 'project_details_c', 'value': ''}}}], 'relationship_list': []}
Note the presence of a accounts_tr_trainings_1_name and accounts_tr_trainings_1accounts_ida
When I run
get_entry_list
I get results that look like this:
{'id': '1111111', 'module_name': 'tr_Trainings', 'name_value_list': {'assigned_user_name': {'name': 'assigned_user_name', 'value': 'KA'}, 'modified_by_name': {'name': 'modified_by_name', 'value': 'BM'}, 'created_by_name': {'name': 'created_by_name', 'value': 'KA'}, 'id': {'name': 'id', 'value': '2222222'}, 'name': {'name': 'name', 'value': '4H'}, 'date_entered': {'name': 'date_entered', 'value': '2019-02-01 20:53:39'}, 'date_modified': {'name': 'date_modified', 'value': '2019-02-15 20:36:06'}, 'modified_user_id': {'name': 'modified_user_id', 'value': '3333333'}, 'created_by': {'name': 'created_by', 'value': '4444444'}, 'description': {'name': 'description', 'value': ''}, 'deleted': {'name': 'deleted', 'value': '0'}, 'training_type': {'name': 'training_type', 'value': 'half'}, 'training_status': {'name': 'training_status', 'value': 'training_partial'}, 'purchased_date': {'name': 'purchased_date', 'value': '2019-02-07'}, 'training_start_date': {'name': 'training_start_date', 'value': ''}, 'training_end_date': {'name': 'training_end_date', 'value': ''}, 'account_id_c': {'name': 'account_id_c', 'value': ''}, 'company_name': {'name': 'company_name', 'value': ''}, 'following': {'name': 'following', 'value': ''}, 'my_favorite': {'name': 'my_favorite', 'value': False}, 'tag': {'name': 'tag', 'value': ''}, 'locked_fields': {'name': 'locked_fields', 'value': ''}, 'team_id': {'name': 'team_id', 'value': '1'}, 'team_set_id': {'name': 'team_set_id', 'value': '1'}, 'acl_team_set_id': {'name': 'acl_team_set_id', 'value': ''}, 'team_count': {'name': 'team_count', 'value': ''}, 'team_name': {'name': 'team_name', 'value': 'Global'}, 'acl_team_names': {'name': 'acl_team_names', 'value': 'Global'}, 'assigned_user_id': {'name': 'assigned_user_id', 'value': '5555555'}, 'training_completed_c': {'name': 'training_completed_c', 'value': ''}, 'purchased_c': {'name': 'purchased_c', 'value': 'training'}, 'accounts_tr_trainings_1_name': {'name': 'accounts_tr_trainings_1_name', 'value': ' '}, 'accounts_tr_trainings_1accounts_ida': {'name': 'accounts_tr_trainings_1accounts_ida', 'value': ''}, 'date_completed_c': {'name': 'date_completed_c', 'value': ''}, 'pro_services_c': {'name': 'pro_services_c', 'value': 'one_half_day_pro'}, 'trainer_c': {'name': 'trainer_c', 'value': 'BM'}, 'project_details_c': {'name': 'project_details_c', 'value': ''}}}
Note the 225 spaces for accounts_tr_trainings_1_name['value'] and accounts_tr_trainings_1accounts_ida value is empty.
Any idea what is happening here?
Hey @fwbam !
Sometimes sugarcrm/suitecrm asks you to send specific information about relationships when fetching lists to prevent triggering many queries on the server, and I think this might be the case for you.
If it turns out to be the case, please refer to the "get_relationships" method in the client.
If this is not the problem, would you mind giving me an example of the params you're using to make both requests? And I will check it out as soon is I can.