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 3
mattkol edited this page Jan 22, 2017
·
2 revisions
This sample usage shows how to read "Accounts" module entity collection data with query. Both "query" and "query predicates" as set, but the predicates are ignored. 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(Cases.class);
request.setUrl(url);
request.setUsername(username);
request.setPassword(password);
request.setRequestType(RequestType.BulkRead);
String query = "cases.name = 'Need assistance with large customization'";
request.getOptions().setQuery(query);
List<QueryPredicate> queryPredicates = new ArrayList<QueryPredicate>();
queryPredicates.add(new QueryPredicate(NameOf.Cases.Name, Equal, "System not responding"));
queryPredicates.add(new QueryPredicate("status", Equal, "Open_New"));
String fromDate = "2016-06-01 00:00:00";
String toDate = "2017-01-20 00:00:00";
// Since query was set, the predicates will be ignored.
queryPredicates.add(new QueryPredicate(NameOf.Cases.DateEntered, QueryOperator.Between, null, fromDate, toDate));
request.getOptions().setQueryPredicates(queryPredicates);
SugarRestResponse response = client.execute(request);List<Cases> readCases = (List<Cases>)response.getData();[
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Max Jensen",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "Lexington Shores Corp",
"date_entered": "2017-01-11 16:51:02",
"case_number": "28",
"id": "15a99525-8583-293c-b9cd-5876620c91e5",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_max_id",
"priority": "P3",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "1038295e-6960-3a32-289d-5876627679e2",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Open_New"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Chris Olliver",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "P Piper & Sons",
"date_entered": "2017-01-11 16:51:02",
"case_number": "5",
"id": "19a63b88-952c-82c8-ec2b-58766272ae3a",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_chris_id",
"priority": "P1",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "13441586-9c1d-66d7-89ac-587662562409",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Open_Assigned"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Sally Bronsen",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "Nelson Inc",
"date_entered": "2017-01-11 16:51:02",
"case_number": "46",
"id": "2bf4871f-1880-d78d-1b3b-5876622c97e5",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_sally_id",
"priority": "P3",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "2750c059-4f18-23d0-7b75-5876628fd436",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Open_New"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Chris Olliver",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "RR. Talker Co",
"date_entered": "2017-01-11 16:51:02",
"case_number": "17",
"id": "31fa3f1f-bd6e-4e06-53b4-587662c4681b",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_chris_id",
"priority": "P1",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "2da8333f-10b8-d173-e38c-587662482d83",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Open_Assigned"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Sally Bronsen",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "Tracker Com LP",
"date_entered": "2017-01-11 16:51:02",
"case_number": "30",
"id": "5cdcc2e6-6939-206b-8740-587662165cbc",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_sally_id",
"priority": "P2",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "587e2a9e-fd4f-9338-9fcd-58766238c003",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Open_Pending Input"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Max Jensen",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "Kaos Trading Ltd",
"date_entered": "2017-01-11 16:51:02",
"case_number": "1",
"id": "687737b0-f774-e521-e9e5-587662aa725f",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_max_id",
"priority": "P1",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "6346cfcd-1884-2a71-0b37-587662f188f6",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Closed_Rejected"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Sally Bronsen",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "SuperG Tech",
"date_entered": "2017-01-11 16:51:02",
"case_number": "10",
"id": "6e2c0382-bce0-d576-99eb-5876622ac275",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_sally_id",
"priority": "P2",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "26d6061c-dceb-ffef-ae86-58766247c253",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Closed_Rejected"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Max Jensen",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "International Art Inc",
"date_entered": "2017-01-11 16:51:02",
"case_number": "37",
"id": "9025f08e-6ee1-b4a0-9379-5876620d63d1",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_max_id",
"priority": "P1",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "8af9330b-3625-d329-b767-587662b99ba5",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Open_Assigned"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Chris Olliver",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "Max Holdings Ltd",
"date_entered": "2017-01-11 16:51:02",
"case_number": "14",
"id": "bb8f8acf-6c01-8da9-3f03-58766205b394",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_chris_id",
"priority": "P2",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "b6aa521e-9b82-e4dd-5639-5876628789e7",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Open_New"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Max Jensen",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "Sea Region Inc",
"date_entered": "2017-01-11 16:51:02",
"case_number": "49",
"id": "c60361f1-a035-bf56-703d-58766256cb2f",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_max_id",
"priority": "P3",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "c0b7cc28-e12d-a83c-15f5-587662c87ddd",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Open_Assigned"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Max Jensen",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "Hammer Group Inc",
"date_entered": "2017-01-11 16:51:02",
"case_number": "40",
"id": "d9950a29-898f-a274-037a-587662a484b7",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_max_id",
"priority": "P3",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "873a02e8-f15f-7ba3-90b9-587662d74e85",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Closed_Duplicate"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Max Jensen",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "Smith & Sons",
"date_entered": "2017-01-11 16:51:02",
"case_number": "21",
"id": "e461f8e4-2e0d-6f29-7a7b-587662e5b65a",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_max_id",
"priority": "P1",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "dfe73502-e409-aa65-6ab5-58766269b419",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Closed_Duplicate"
},
{
"internal": "",
"suggestion_box": "",
"assigned_user_name": "Sarah Smith",
"description": "",
"created_by_name": "Joe Bloggs",
"type": "",
"resolution": "",
"work_log": "",
"jjwg_maps_address_c": "",
"account_name": "Tri-State Medical Corp",
"date_entered": "2017-01-11 16:51:02",
"case_number": "4",
"id": "e4cb4d19-8859-2ae8-798a-5876623e130e",
"state": "Open",
"account_name1": "",
"contact_created_by_name": "",
"jjwg_maps_lat_c": "",
"jjwg_maps_lng_c": "",
"modified_user_id": "1",
"assigned_user_id": "seed_sarah_id",
"priority": "P3",
"created_by": "1",
"update_text": "",
"deleted": "0",
"account_id": "dfe6fe2d-c51c-be45-3d84-5876624d2910",
"date_modified": "2017-01-11 16:51:02",
"jjwg_maps_geocode_status_c": "",
"contact_created_by_id": "",
"name": "Need assistance with large customization",
"modified_by_name": "Joe Bloggs",
"aop_case_updates_threaded": "",
"case_update_form": "",
"case_attachments_display": "",
"status": "Closed_Closed"
}
]{
"method": "get_entry_list",
"input_type": "json",
"response_type": "json",
"rest_data": {
"session": "ddr2cd3vihs3gp6jrtj4a3k087",
"module_name": "Cases",
"query": " cases.name = 'Need assistance with large customization' ",
"order_by": "",
"offset": 0,
"select_fields": [
],
"link_name_to_fields_array": "",
"max_results": 100,
"deleted": 0,
"favorites": false
}
}{
"total_count": "13",
"relationship_list": [
],
"entry_list": [
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Max Jensen"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Lexington Shores Corp"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "28"
},
"id": {
"name": "id",
"value": "15a99525-8583-293c-b9cd-5876620c91e5"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_max_id"
},
"priority": {
"name": "priority",
"value": "P3"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "1038295e-6960-3a32-289d-5876627679e2"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Open_New"
}
},
"id": "15a99525-8583-293c-b9cd-5876620c91e5",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Chris Olliver"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "P Piper & Sons"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "5"
},
"id": {
"name": "id",
"value": "19a63b88-952c-82c8-ec2b-58766272ae3a"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_chris_id"
},
"priority": {
"name": "priority",
"value": "P1"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "13441586-9c1d-66d7-89ac-587662562409"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Open_Assigned"
}
},
"id": "19a63b88-952c-82c8-ec2b-58766272ae3a",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Sally Bronsen"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Nelson Inc"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "46"
},
"id": {
"name": "id",
"value": "2bf4871f-1880-d78d-1b3b-5876622c97e5"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_sally_id"
},
"priority": {
"name": "priority",
"value": "P3"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "2750c059-4f18-23d0-7b75-5876628fd436"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Open_New"
}
},
"id": "2bf4871f-1880-d78d-1b3b-5876622c97e5",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Chris Olliver"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "RR. Talker Co"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "17"
},
"id": {
"name": "id",
"value": "31fa3f1f-bd6e-4e06-53b4-587662c4681b"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_chris_id"
},
"priority": {
"name": "priority",
"value": "P1"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "2da8333f-10b8-d173-e38c-587662482d83"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Open_Assigned"
}
},
"id": "31fa3f1f-bd6e-4e06-53b4-587662c4681b",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Sally Bronsen"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Tracker Com LP"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "30"
},
"id": {
"name": "id",
"value": "5cdcc2e6-6939-206b-8740-587662165cbc"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_sally_id"
},
"priority": {
"name": "priority",
"value": "P2"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "587e2a9e-fd4f-9338-9fcd-58766238c003"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Open_Pending Input"
}
},
"id": "5cdcc2e6-6939-206b-8740-587662165cbc",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Max Jensen"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Kaos Trading Ltd"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "1"
},
"id": {
"name": "id",
"value": "687737b0-f774-e521-e9e5-587662aa725f"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_max_id"
},
"priority": {
"name": "priority",
"value": "P1"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "6346cfcd-1884-2a71-0b37-587662f188f6"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Closed_Rejected"
}
},
"id": "687737b0-f774-e521-e9e5-587662aa725f",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Sally Bronsen"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "SuperG Tech"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "10"
},
"id": {
"name": "id",
"value": "6e2c0382-bce0-d576-99eb-5876622ac275"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_sally_id"
},
"priority": {
"name": "priority",
"value": "P2"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "26d6061c-dceb-ffef-ae86-58766247c253"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Closed_Rejected"
}
},
"id": "6e2c0382-bce0-d576-99eb-5876622ac275",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Max Jensen"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "International Art Inc"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "37"
},
"id": {
"name": "id",
"value": "9025f08e-6ee1-b4a0-9379-5876620d63d1"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_max_id"
},
"priority": {
"name": "priority",
"value": "P1"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "8af9330b-3625-d329-b767-587662b99ba5"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Open_Assigned"
}
},
"id": "9025f08e-6ee1-b4a0-9379-5876620d63d1",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Chris Olliver"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Max Holdings Ltd"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "14"
},
"id": {
"name": "id",
"value": "bb8f8acf-6c01-8da9-3f03-58766205b394"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_chris_id"
},
"priority": {
"name": "priority",
"value": "P2"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "b6aa521e-9b82-e4dd-5639-5876628789e7"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Open_New"
}
},
"id": "bb8f8acf-6c01-8da9-3f03-58766205b394",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Max Jensen"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Sea Region Inc"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "49"
},
"id": {
"name": "id",
"value": "c60361f1-a035-bf56-703d-58766256cb2f"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_max_id"
},
"priority": {
"name": "priority",
"value": "P3"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "c0b7cc28-e12d-a83c-15f5-587662c87ddd"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Open_Assigned"
}
},
"id": "c60361f1-a035-bf56-703d-58766256cb2f",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Max Jensen"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Hammer Group Inc"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "40"
},
"id": {
"name": "id",
"value": "d9950a29-898f-a274-037a-587662a484b7"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_max_id"
},
"priority": {
"name": "priority",
"value": "P3"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "873a02e8-f15f-7ba3-90b9-587662d74e85"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Closed_Duplicate"
}
},
"id": "d9950a29-898f-a274-037a-587662a484b7",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Max Jensen"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Smith & Sons"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "21"
},
"id": {
"name": "id",
"value": "e461f8e4-2e0d-6f29-7a7b-587662e5b65a"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_max_id"
},
"priority": {
"name": "priority",
"value": "P1"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "dfe73502-e409-aa65-6ab5-58766269b419"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Closed_Duplicate"
}
},
"id": "e461f8e4-2e0d-6f29-7a7b-587662e5b65a",
"module_name": "Cases"
},
{
"name_value_list": {
"internal": {
"name": "internal",
"value": ""
},
"suggestion_box": {
"name": "suggestion_box",
"value": ""
},
"assigned_user_name": {
"name": "assigned_user_name",
"value": "Sarah Smith"
},
"description": {
"name": "description",
"value": ""
},
"created_by_name": {
"name": "created_by_name",
"value": "Joe Bloggs"
},
"type": {
"name": "type",
"value": ""
},
"resolution": {
"name": "resolution",
"value": ""
},
"work_log": {
"name": "work_log",
"value": ""
},
"jjwg_maps_address_c": {
"name": "jjwg_maps_address_c",
"value": ""
},
"account_name": {
"name": "account_name",
"value": "Tri-State Medical Corp"
},
"date_entered": {
"name": "date_entered",
"value": "2017-01-11 16:51:02"
},
"case_number": {
"name": "case_number",
"value": "4"
},
"id": {
"name": "id",
"value": "e4cb4d19-8859-2ae8-798a-5876623e130e"
},
"state": {
"name": "state",
"value": "Open"
},
"account_name1": {
"name": "account_name1",
"value": ""
},
"contact_created_by_name": {
"name": "contact_created_by_name",
"value": ""
},
"jjwg_maps_lat_c": {
"name": "jjwg_maps_lat_c",
"value": ""
},
"jjwg_maps_lng_c": {
"name": "jjwg_maps_lng_c",
"value": ""
},
"modified_user_id": {
"name": "modified_user_id",
"value": "1"
},
"assigned_user_id": {
"name": "assigned_user_id",
"value": "seed_sarah_id"
},
"priority": {
"name": "priority",
"value": "P3"
},
"created_by": {
"name": "created_by",
"value": "1"
},
"update_text": {
"name": "update_text",
"value": ""
},
"deleted": {
"name": "deleted",
"value": "0"
},
"account_id": {
"name": "account_id",
"value": "dfe6fe2d-c51c-be45-3d84-5876624d2910"
},
"date_modified": {
"name": "date_modified",
"value": "2017-01-11 16:51:02"
},
"jjwg_maps_geocode_status_c": {
"name": "jjwg_maps_geocode_status_c",
"value": ""
},
"contact_created_by_id": {
"name": "contact_created_by_id",
"value": ""
},
"name": {
"name": "name",
"value": "Need assistance with large customization"
},
"modified_by_name": {
"name": "modified_by_name",
"value": "Joe Bloggs"
},
"aop_case_updates_threaded": {
"name": "aop_case_updates_threaded",
"value": ""
},
"case_update_form": {
"name": "case_update_form",
"value": ""
},
"case_attachments_display": {
"name": "case_attachments_display",
"value": ""
},
"status": {
"name": "status",
"value": "Closed_Closed"
}
},
"id": "e4cb4d19-8859-2ae8-798a-5876623e130e",
"module_name": "Cases"
}
],
"result_count": 13,
"next_offset": 13
}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