This repository has been archived by the owner on Oct 12, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 11
Query Options 2
mattkol edited this page Jan 22, 2017
·
2 revisions
This sample usage shows how to read "Leads" module entity collection data with query. For more request options make changes to the [Options parameter](Request Options).
This implements the get_entry_list SugarCRM REST API method setting the query parameter.
package com.sugaronrest.tests;
import com.sugaronrest.*;
import com.sugaronrest.modules.*;
import java.util.ArrayList;
import java.util.List;
import static com.sugaronrest.QueryOperator.*;
String url = "http://demo.suiteondemand.com/service/v4_1/rest.php";
String username = "will";
String password = "will";
SugarRestClient client = new SugarRestClient();
SugarRestRequest request = new SugarRestRequest(Leads.class);
request.setUrl(url);
request.setUsername(username);
request.setPassword(password);
request.setRequestType(RequestType.BulkRead);
String query = "leads.id IN('10a5aca7-a94b-c84a-d01a-587662da31cd', '118f5999-4e81-5510-8c00-587662372d02', '1304e89b-942b-5866-2aad-587662f632d5')";
request.getOptions().setQuery(query);
SugarRestResponse response = client.execute(request);List<Leads> readLeads = (List<Leads>)response.getData();[
{
"alt_address_city": "",
"birthdate": false,
"webtolead_invalid_email": "",
"lead_source": "Other",
"phone_work": "(340) 060-8409",
"alt_address_street": "",
"created_by_name": "Joe Bloggs",
"report_to_name": "",
"invalid_email": "0",
"primary_address_country": "USA",
"primary_address_city": "Sunnyvale",
"email2": "",
"email1": "[email protected]",
"email_opt_out": "0",
"account_description": "",
"opportunity_name": "",
"date_entered": "2017-01-11 16:51:02",
"id": "10a5aca7-a94b-c84a-d01a-587662da31cd",
"opportunity_amount": "",
"campaign_id": "",
"alt_address_state": "",
"portal_name": "",
"e_invite_status_fields": " ",
"status_description": "",
"accept_status_name": "",
"primary_address_street_3": "",
"primary_address_street_2": "",
"lead_source_description": "",
"primary_address_state": "NY",
"reports_to_id": "",
"modified_user_id": "1",
"e_accept_status_fields": " ",
"created_by": "1",
"full_name": "Sheryl Polansky",
"alt_address_postalcode": "",
"opportunity_id": "",
"converted": "0",
"jjwg_maps_geocode_status_c": "",
"assistant_phone": "",
"name": "Sheryl Polansky",
"salutation": "",
"status": "New",
"assigned_user_name": "Sally Bronsen",
"portal_app": "",
"description": "",
"event_invite_id": "",
"title": "Mgr Operations",
"contact_id": "",
"jjwg_maps_address_c": "",
"campaign_name": "",
"m_accept_status_fields": " ",
"webtolead_email2": "",
"webtolead_email1": "",
"phone_home": "(859) 301-1325",
"alt_address_country": "",
"account_name": "Sandeon Consolidation Corp",
"accept_status_id": "",
"event_status_name": "",
"department": "",
"c_accept_status_fields": " ",
"first_name": "Sheryl",
"email": "",
"primary_address_postalcode": "84052",
"phone_mobile": "(181) 586-1013",
"website": "",
"phone_fax": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"primary_address_street": "345 Sugar Blvd.",
"assistant": "",
"last_name": "Polansky",
"photo": "",
"phone_other": "",
"assigned_user_id": "seed_sally_id",
"event_status_id": "",
"webtolead_email_opt_out": "",
"deleted": "0",
"alt_address_street_2": "",
"account_id": "",
"date_modified": "2017-01-11 16:51:02",
"event_accept_status": "",
"modified_by_name": "Joe Bloggs",
"email_addresses_non_primary": "",
"alt_address_street_3": "",
"do_not_call": "0",
"refered_by": ""
},
{
"alt_address_city": "",
"birthdate": false,
"webtolead_invalid_email": "",
"lead_source": "Web Site",
"phone_work": "(522) 478-3595",
"alt_address_street": "",
"created_by_name": "Joe Bloggs",
"report_to_name": "",
"invalid_email": "0",
"primary_address_country": "USA",
"primary_address_city": "Ohio",
"email2": "",
"email1": "[email protected]",
"email_opt_out": "0",
"account_description": "",
"opportunity_name": "",
"date_entered": "2017-01-11 16:51:02",
"id": "118f5999-4e81-5510-8c00-587662372d02",
"opportunity_amount": "",
"campaign_id": "",
"alt_address_state": "",
"portal_name": "",
"e_invite_status_fields": " ",
"status_description": "",
"accept_status_name": "",
"primary_address_street_3": "",
"primary_address_street_2": "",
"lead_source_description": "",
"primary_address_state": "NY",
"reports_to_id": "",
"modified_user_id": "1",
"e_accept_status_fields": " ",
"created_by": "1",
"full_name": "Clint Dory",
"alt_address_postalcode": "",
"opportunity_id": "",
"converted": "0",
"jjwg_maps_geocode_status_c": "",
"assistant_phone": "",
"name": "Clint Dory",
"salutation": "",
"status": "New",
"assigned_user_name": "Sarah Smith",
"portal_app": "",
"description": "",
"event_invite_id": "",
"title": "Mgr Operations",
"contact_id": "",
"jjwg_maps_address_c": "",
"campaign_name": "",
"m_accept_status_fields": " ",
"webtolead_email2": "",
"webtolead_email1": "",
"phone_home": "(594) 361-6683",
"alt_address_country": "",
"account_name": "Spindle Broadcast Corp.",
"accept_status_id": "",
"event_status_name": "",
"department": "",
"c_accept_status_fields": " ",
"first_name": "Clint",
"email": "",
"primary_address_postalcode": "50175",
"phone_mobile": "(091) 679-1609",
"website": "",
"phone_fax": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"primary_address_street": "48920 San Carlos Ave",
"assistant": "",
"last_name": "Dory",
"photo": "",
"phone_other": "",
"assigned_user_id": "seed_sarah_id",
"event_status_id": "",
"webtolead_email_opt_out": "",
"deleted": "0",
"alt_address_street_2": "",
"account_id": "",
"date_modified": "2017-01-11 16:51:02",
"event_accept_status": "",
"modified_by_name": "Joe Bloggs",
"email_addresses_non_primary": "",
"alt_address_street_3": "",
"do_not_call": "0",
"refered_by": ""
},
{
"alt_address_city": "",
"birthdate": false,
"webtolead_invalid_email": "",
"lead_source": "Cold Call",
"phone_work": "(914) 890-2314",
"alt_address_street": "",
"created_by_name": "Joe Bloggs",
"report_to_name": "",
"invalid_email": "0",
"primary_address_country": "USA",
"primary_address_city": "San Jose",
"email2": "",
"email1": "[email protected]",
"email_opt_out": "0",
"account_description": "",
"opportunity_name": "",
"date_entered": "2017-01-11 16:51:02",
"id": "1304e89b-942b-5866-2aad-587662f632d5",
"opportunity_amount": "",
"campaign_id": "",
"alt_address_state": "",
"portal_name": "",
"e_invite_status_fields": " ",
"status_description": "",
"accept_status_name": "",
"primary_address_street_3": "",
"primary_address_street_2": "",
"lead_source_description": "",
"primary_address_state": "NY",
"reports_to_id": "",
"modified_user_id": "1",
"e_accept_status_fields": " ",
"created_by": "1",
"full_name": "Marla Lipsey",
"alt_address_postalcode": "",
"opportunity_id": "",
"converted": "0",
"jjwg_maps_geocode_status_c": "",
"assistant_phone": "",
"name": "Marla Lipsey",
"salutation": "",
"status": "Dead",
"assigned_user_name": "Sally Bronsen",
"portal_app": "",
"description": "",
"event_invite_id": "",
"title": "IT Developer",
"contact_id": "",
"jjwg_maps_address_c": "",
"campaign_name": "",
"m_accept_status_fields": " ",
"webtolead_email2": "",
"webtolead_email1": "",
"phone_home": "(291) 365-5847",
"alt_address_country": "",
"account_name": "Airline Maintenance Co",
"accept_status_id": "",
"event_status_name": "",
"department": "",
"c_accept_status_fields": " ",
"first_name": "Marla",
"email": "",
"primary_address_postalcode": "38807",
"phone_mobile": "(411) 093-1649",
"website": "",
"phone_fax": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"primary_address_street": "67321 West Siam St.",
"assistant": "",
"last_name": "Lipsey",
"photo": "",
"phone_other": "",
"assigned_user_id": "seed_sally_id",
"event_status_id": "",
"webtolead_email_opt_out": "",
"deleted": "0",
"alt_address_street_2": "",
"account_id": "",
"date_modified": "2017-01-11 16:51:02",
"event_accept_status": "",
"modified_by_name": "Joe Bloggs",
"email_addresses_non_primary": "",
"alt_address_street_3": "",
"do_not_call": "0",
"refered_by": ""
}
]{
"method": "get_entry_list",
"input_type": "json",
"response_type": "json",
"rest_data": {
"session": "bgmbr355a6skjjfj0eefn7e5j3",
"module_name": "Leads",
"query": " leads.id IN('10a5aca7-a94b-c84a-d01a-587662da31cd', '118f5999-4e81-5510-8c00-587662372d02', '1304e89b-942b-5866-2aad-587662f632d5') ",
"order_by": "",
"offset": 0,
"select_fields": [
],
"link_name_to_fields_array": "",
"max_results": 100,
"deleted": 0,
"favorites": false
}
}{
"total_count": "3",
"relationship_list": [
],
"entry_list": [
{
"name_value_list": {
"alt_address_city": {
"name": "alt_address_city",
"value": ""
},
"birthdate": {
"name": "birthdate",
"value": false
},
"webtolead_invalid_email": {
"name": "webtolead_invalid_email",
"value": ""
},
"lead_source": {
"name": "lead_source",
"value": "Other"
},
"phone_work": {
"name": "phone_work",
"value": "(340) 060-8409"
},
"alt_address_street": {
"name": "alt_address_street",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"report_to_name": {
"name": "report_to_name",
"value": ""
},
"invalid_email": {
"name": "invalid_email",
"value": "0"
},
"primary_address_country": {
"name": "primary_address_country",
"value": "USA"
},
"primary_address_city": {
"name": "primary_address_city",
"value": "Sunnyvale"
},
"email2": {
"name": "email2",
"value": ""
},
"email1": {
"name": "email1",
"value": "[email protected]"
},
"email_opt_out": {
"name": "email_opt_out",
"value": "0"
},
"account_description": {
"name": "account_description",
"value": ""
},
"opportunity_name": {
"name": "opportunity_name",
"value": ""
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"id": {
"name": "id",
"value": "10a5aca7-a94b-c84a-d01a-587662da31cd"
},
"opportunity_amount": {
"name": "opportunity_amount",
"value": ""
},
"campaign_id": {
"name": "campaign_id",
"value": ""
},
"alt_address_state": {
"name": "alt_address_state",
"value": ""
},
"portal_name": {
"name": "portal_name",
"value": ""
},
"e_invite_status_fields": {
"name": "e_invite_status_fields",
"value": " "
},
"status_description": {
"name": "status_description",
"value": ""
},
"accept_status_name": {
"name": "accept_status_name",
"value": ""
},
"primary_address_street_3": {
"name": "primary_address_street_3",
"value": ""
},
"primary_address_street_2": {
"name": "primary_address_street_2",
"value": ""
},
"lead_source_description": {
"name": "lead_source_description",
"value": ""
},
"primary_address_state": {
"name": "primary_address_state",
"value": "NY"
},
"reports_to_id": {
"name": "reports_to_id",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"e_accept_status_fields": {
"name": "e_accept_status_fields",
"value": " "
},
"created_by": {
"name": "created_by",
"value": "1"
},
"full_name": {
"name": "full_name",
"value": "Sheryl Polansky"
},
"alt_address_postalcode": {
"name": "alt_address_postalcode",
"value": ""
},
"opportunity_id": {
"name": "opportunity_id",
"value": ""
},
"converted": {
"name": "converted",
"value": "0"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"assistant_phone": {
"name": "assistant_phone",
"value": ""
},
"name": {
"name": "name",
"value": "Sheryl Polansky"
},
"salutation": {
"name": "salutation",
"value": ""
},
"status": {
"name": "status",
"value": "New"
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Sally Bronsen"
},
"portal_app": {
"name": "portal_app",
"value": ""
},
"description": {
"name": "description",
"value": ""
},
"event_invite_id": {
"name": "event_invite_id",
"value": ""
},
"title": {
"name": "title",
"value": "Mgr Operations"
},
"contact_id": {
"name": "contact_id",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"campaign_name": {
"name": "campaign_name",
"value": ""
},
"m_accept_status_fields": {
"name": "m_accept_status_fields",
"value": " "
},
"webtolead_email2": {
"name": "webtolead_email2",
"value": ""
},
"webtolead_email1": {
"name": "webtolead_email1",
"value": ""
},
"phone_home": {
"name": "phone_home",
"value": "(859) 301-1325"
},
"alt_address_country": {
"name": "alt_address_country",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Sandeon Consolidation Corp"
},
"accept_status_id": {
"name": "accept_status_id",
"value": ""
},
"event_status_name": {
"name": "event_status_name",
"value": ""
},
"department": {
"name": "department",
"value": ""
},
"c_accept_status_fields": {
"name": "c_accept_status_fields",
"value": " "
},
"first_name": {
"name": "first_name",
"value": "Sheryl"
},
"email": {
"name": "email",
"value": ""
},
"primary_address_postalcode": {
"name": "primary_address_postalcode",
"value": "84052"
},
"phone_mobile": {
"name": "phone_mobile",
"value": "(181) 586-1013"
},
"website": {
"name": "website",
"value": ""
},
"phone_fax": {
"name": "phone_fax",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"primary_address_street": {
"name": "primary_address_street",
"value": "345 Sugar Blvd."
},
"assistant": {
"name": "assistant",
"value": ""
},
"last_name": {
"name": "last_name",
"value": "Polansky"
},
"photo": {
"name": "photo",
"value": ""
},
"phone_other": {
"name": "phone_other",
"value": ""
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_sally_id"
},
"event_status_id": {
"name": "event_status_id",
"value": ""
},
"webtolead_email_opt_out": {
"name": "webtolead_email_opt_out",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"alt_address_street_2": {
"name": "alt_address_street_2",
"value": ""
},
"account_id": {
"name": "account_id",
"value": ""
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"event_accept_status": {
"name": "event_accept_status",
"value": ""
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"email_addresses_non_primary": {
"name": "email_addresses_non_primary",
"value": ""
},
"alt_address_street_3": {
"name": "alt_address_street_3",
"value": ""
},
"do_not_call": {
"name": "do_not_call",
"value": "0"
},
"refered_by": {
"name": "refered_by",
"value": ""
}
},
"id": "10a5aca7-a94b-c84a-d01a-587662da31cd",
"module_name": "Leads"
},
{
"name_value_list": {
"alt_address_city": {
"name": "alt_address_city",
"value": ""
},
"birthdate": {
"name": "birthdate",
"value": false
},
"webtolead_invalid_email": {
"name": "webtolead_invalid_email",
"value": ""
},
"lead_source": {
"name": "lead_source",
"value": "Web Site"
},
"phone_work": {
"name": "phone_work",
"value": "(522) 478-3595"
},
"alt_address_street": {
"name": "alt_address_street",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"report_to_name": {
"name": "report_to_name",
"value": ""
},
"invalid_email": {
"name": "invalid_email",
"value": "0"
},
"primary_address_country": {
"name": "primary_address_country",
"value": "USA"
},
"primary_address_city": {
"name": "primary_address_city",
"value": "Ohio"
},
"email2": {
"name": "email2",
"value": ""
},
"email1": {
"name": "email1",
"value": "[email protected]"
},
"email_opt_out": {
"name": "email_opt_out",
"value": "0"
},
"account_description": {
"name": "account_description",
"value": ""
},
"opportunity_name": {
"name": "opportunity_name",
"value": ""
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"id": {
"name": "id",
"value": "118f5999-4e81-5510-8c00-587662372d02"
},
"opportunity_amount": {
"name": "opportunity_amount",
"value": ""
},
"campaign_id": {
"name": "campaign_id",
"value": ""
},
"alt_address_state": {
"name": "alt_address_state",
"value": ""
},
"portal_name": {
"name": "portal_name",
"value": ""
},
"e_invite_status_fields": {
"name": "e_invite_status_fields",
"value": " "
},
"status_description": {
"name": "status_description",
"value": ""
},
"accept_status_name": {
"name": "accept_status_name",
"value": ""
},
"primary_address_street_3": {
"name": "primary_address_street_3",
"value": ""
},
"primary_address_street_2": {
"name": "primary_address_street_2",
"value": ""
},
"lead_source_description": {
"name": "lead_source_description",
"value": ""
},
"primary_address_state": {
"name": "primary_address_state",
"value": "NY"
},
"reports_to_id": {
"name": "reports_to_id",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"e_accept_status_fields": {
"name": "e_accept_status_fields",
"value": " "
},
"created_by": {
"name": "created_by",
"value": "1"
},
"full_name": {
"name": "full_name",
"value": "Clint Dory"
},
"alt_address_postalcode": {
"name": "alt_address_postalcode",
"value": ""
},
"opportunity_id": {
"name": "opportunity_id",
"value": ""
},
"converted": {
"name": "converted",
"value": "0"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"assistant_phone": {
"name": "assistant_phone",
"value": ""
},
"name": {
"name": "name",
"value": "Clint Dory"
},
"salutation": {
"name": "salutation",
"value": ""
},
"status": {
"name": "status",
"value": "New"
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Sarah Smith"
},
"portal_app": {
"name": "portal_app",
"value": ""
},
"description": {
"name": "description",
"value": ""
},
"event_invite_id": {
"name": "event_invite_id",
"value": ""
},
"title": {
"name": "title",
"value": "Mgr Operations"
},
"contact_id": {
"name": "contact_id",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"campaign_name": {
"name": "campaign_name",
"value": ""
},
"m_accept_status_fields": {
"name": "m_accept_status_fields",
"value": " "
},
"webtolead_email2": {
"name": "webtolead_email2",
"value": ""
},
"webtolead_email1": {
"name": "webtolead_email1",
"value": ""
},
"phone_home": {
"name": "phone_home",
"value": "(594) 361-6683"
},
"alt_address_country": {
"name": "alt_address_country",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Spindle Broadcast Corp."
},
"accept_status_id": {
"name": "accept_status_id",
"value": ""
},
"event_status_name": {
"name": "event_status_name",
"value": ""
},
"department": {
"name": "department",
"value": ""
},
"c_accept_status_fields": {
"name": "c_accept_status_fields",
"value": " "
},
"first_name": {
"name": "first_name",
"value": "Clint"
},
"email": {
"name": "email",
"value": ""
},
"primary_address_postalcode": {
"name": "primary_address_postalcode",
"value": "50175"
},
"phone_mobile": {
"name": "phone_mobile",
"value": "(091) 679-1609"
},
"website": {
"name": "website",
"value": ""
},
"phone_fax": {
"name": "phone_fax",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"primary_address_street": {
"name": "primary_address_street",
"value": "48920 San Carlos Ave"
},
"assistant": {
"name": "assistant",
"value": ""
},
"last_name": {
"name": "last_name",
"value": "Dory"
},
"photo": {
"name": "photo",
"value": ""
},
"phone_other": {
"name": "phone_other",
"value": ""
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_sarah_id"
},
"event_status_id": {
"name": "event_status_id",
"value": ""
},
"webtolead_email_opt_out": {
"name": "webtolead_email_opt_out",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"alt_address_street_2": {
"name": "alt_address_street_2",
"value": ""
},
"account_id": {
"name": "account_id",
"value": ""
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"event_accept_status": {
"name": "event_accept_status",
"value": ""
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"email_addresses_non_primary": {
"name": "email_addresses_non_primary",
"value": ""
},
"alt_address_street_3": {
"name": "alt_address_street_3",
"value": ""
},
"do_not_call": {
"name": "do_not_call",
"value": "0"
},
"refered_by": {
"name": "refered_by",
"value": ""
}
},
"id": "118f5999-4e81-5510-8c00-587662372d02",
"module_name": "Leads"
},
{
"name_value_list": {
"alt_address_city": {
"name": "alt_address_city",
"value": ""
},
"birthdate": {
"name": "birthdate",
"value": false
},
"webtolead_invalid_email": {
"name": "webtolead_invalid_email",
"value": ""
},
"lead_source": {
"name": "lead_source",
"value": "Cold Call"
},
"phone_work": {
"name": "phone_work",
"value": "(914) 890-2314"
},
"alt_address_street": {
"name": "alt_address_street",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"report_to_name": {
"name": "report_to_name",
"value": ""
},
"invalid_email": {
"name": "invalid_email",
"value": "0"
},
"primary_address_country": {
"name": "primary_address_country",
"value": "USA"
},
"primary_address_city": {
"name": "primary_address_city",
"value": "San Jose"
},
"email2": {
"name": "email2",
"value": ""
},
"email1": {
"name": "email1",
"value": "[email protected]"
},
"email_opt_out": {
"name": "email_opt_out",
"value": "0"
},
"account_description": {
"name": "account_description",
"value": ""
},
"opportunity_name": {
"name": "opportunity_name",
"value": ""
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"id": {
"name": "id",
"value": "1304e89b-942b-5866-2aad-587662f632d5"
},
"opportunity_amount": {
"name": "opportunity_amount",
"value": ""
},
"campaign_id": {
"name": "campaign_id",
"value": ""
},
"alt_address_state": {
"name": "alt_address_state",
"value": ""
},
"portal_name": {
"name": "portal_name",
"value": ""
},
"e_invite_status_fields": {
"name": "e_invite_status_fields",
"value": " "
},
"status_description": {
"name": "status_description",
"value": ""
},
"accept_status_name": {
"name": "accept_status_name",
"value": ""
},
"primary_address_street_3": {
"name": "primary_address_street_3",
"value": ""
},
"primary_address_street_2": {
"name": "primary_address_street_2",
"value": ""
},
"lead_source_description": {
"name": "lead_source_description",
"value": ""
},
"primary_address_state": {
"name": "primary_address_state",
"value": "NY"
},
"reports_to_id": {
"name": "reports_to_id",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"e_accept_status_fields": {
"name": "e_accept_status_fields",
"value": " "
},
"created_by": {
"name": "created_by",
"value": "1"
},
"full_name": {
"name": "full_name",
"value": "Marla Lipsey"
},
"alt_address_postalcode": {
"name": "alt_address_postalcode",
"value": ""
},
"opportunity_id": {
"name": "opportunity_id",
"value": ""
},
"converted": {
"name": "converted",
"value": "0"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"assistant_phone": {
"name": "assistant_phone",
"value": ""
},
"name": {
"name": "name",
"value": "Marla Lipsey"
},
"salutation": {
"name": "salutation",
"value": ""
},
"status": {
"name": "status",
"value": "Dead"
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Sally Bronsen"
},
"portal_app": {
"name": "portal_app",
"value": ""
},
"description": {
"name": "description",
"value": ""
},
"event_invite_id": {
"name": "event_invite_id",
"value": ""
},
"title": {
"name": "title",
"value": "IT Developer"
},
"contact_id": {
"name": "contact_id",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"campaign_name": {
"name": "campaign_name",
"value": ""
},
"m_accept_status_fields": {
"name": "m_accept_status_fields",
"value": " "
},
"webtolead_email2": {
"name": "webtolead_email2",
"value": ""
},
"webtolead_email1": {
"name": "webtolead_email1",
"value": ""
},
"phone_home": {
"name": "phone_home",
"value": "(291) 365-5847"
},
"alt_address_country": {
"name": "alt_address_country",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Airline Maintenance Co"
},
"accept_status_id": {
"name": "accept_status_id",
"value": ""
},
"event_status_name": {
"name": "event_status_name",
"value": ""
},
"department": {
"name": "department",
"value": ""
},
"c_accept_status_fields": {
"name": "c_accept_status_fields",
"value": " "
},
"first_name": {
"name": "first_name",
"value": "Marla"
},
"email": {
"name": "email",
"value": ""
},
"primary_address_postalcode": {
"name": "primary_address_postalcode",
"value": "38807"
},
"phone_mobile": {
"name": "phone_mobile",
"value": "(411) 093-1649"
},
"website": {
"name": "website",
"value": ""
},
"phone_fax": {
"name": "phone_fax",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"primary_address_street": {
"name": "primary_address_street",
"value": "67321 West Siam St."
},
"assistant": {
"name": "assistant",
"value": ""
},
"last_name": {
"name": "last_name",
"value": "Lipsey"
},
"photo": {
"name": "photo",
"value": ""
},
"phone_other": {
"name": "phone_other",
"value": ""
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_sally_id"
},
"event_status_id": {
"name": "event_status_id",
"value": ""
},
"webtolead_email_opt_out": {
"name": "webtolead_email_opt_out",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"alt_address_street_2": {
"name": "alt_address_street_2",
"value": ""
},
"account_id": {
"name": "account_id",
"value": ""
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"event_accept_status": {
"name": "event_accept_status",
"value": ""
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"email_addresses_non_primary": {
"name": "email_addresses_non_primary",
"value": ""
},
"alt_address_street_3": {
"name": "alt_address_street_3",
"value": ""
},
"do_not_call": {
"name": "do_not_call",
"value": "0"
},
"refered_by": {
"name": "refered_by",
"value": ""
}
},
"id": "1304e89b-942b-5866-2aad-587662f632d5",
"module_name": "Leads"
}
],
"result_count": 3,
"next_offset": 3
}SugarOnRest
- Home
- Request
- Request Types
- Request Options
- Response
- Error Response
- Read Module By Id
- Read Module Collection By Page
- Read Module Collection
- Create Module
- Create Module Collection
- Update Module
- Update Module Collection
- Delete Module
- Linked Modules 1
- Linked Modules 2
- Linked Modules 3
- Query Options 1
- Query Options 2
- Query Options 3