
{   "select_query": "select Last_Name, Email, Phone, Industry, Revenue, ... (500 fields) from Leads where id is not null" }  | 
{   "select_query": "select Account_Name from Accounts where Industry in ('IT', 'Finance', 'Healthcare', ... (100 values))" }  | 
{   "select_query": "select Account_Name from Accounts where Industry not in ('IT', 'Finance', 'Healthcare', ... (100 values))" }  | 
Key and Value Structure  |  "system_name": "{module_name}SHAREDBYME"   | 
Example  | "system_name": "LEADSSHAREDBYME"  | 
{     "select_query": "select Lead_Status from Leads#5725767000000087501 WHERE id is not null" } //CVID: 5725767000000087501 - This is the Custom View ID in the Leads module.  | 
{     "select_query": "select Lead_Status, Phone from Leads where id is not null",     "include_meta": [         "fields"     ] }  | 
{     "data": [         {             "Lead_Status": "Attempted to Contact",             "Phone": "555-555-5555",             "id": "5725767000000420480"         },         {             "Lead_Status": "Contact in Future",             "Phone": "555-555-5555",             "id": "5725767000000420481"         },         .         .         .     ],     "fields": {         "Lead_Status": {             "webhook": true,             "operation_type": {                 "web_update": true,                 "api_create": true,                 "web_create": true,                 "api_update": true             },             "colour_code_enabled_by_system": false,             "field_label": "Lead Status",             "tooltip": null,             "type": "used",             "table_name": "CrmLeadDetails",             "field_read_only": false,             "required": false,             "display_label": "Lead Status",             "read_only": false,             "association_details": null,             "multi_module_lookup": {},             "id": "5725767000000002611",             "created_time": null,             "filterable": true,             "visible": true,             "refer_from_field": null              "auto_number": {}         }     },     "info": {         "count": 200,         "more_records": true     } }  | 
{     "select_query" : "select Last_Name from Leads where id is not null order by Lead_Source, Lead_Status, Email, ... (up to 10 fields)" }  | 
{ "select_query":"select id from Contacts where id is not null order by id,id" }  | 
{   "select_query": "select Account_Name, Territories from Accounts where id is not null" }  | 
{  "select_query" : "select Territories, Account_Name.Territories from Contacts where id is not null"  }  | 
{     "data": [         {             "Account_Name.Territories": [                 {                     "name": "USA",                     "id": "5725767000000454003"                 }             ],             "id": "5725767000000420261",             "Territories": [                 {                     "name": "China",                     "id": "5725767000000454981"                 }             ]         },         .         .         .     ],     "info": {         "count": 174,         "more_records": false     } }  | 
{     "select_query": "select Full_Name from Contacts where id is not null" }  | 
{  "select_query": "select 'What_Id->Leads.Company','What_Id->Accounts.Account_Type' from Calls where id is not null" }  | 
{  "select_query": "select 'Appointment_For->Contacts.Lead_Source' from Appointments__s where id is not null" }  | 
{ "select_query": "select Appointment_For.module.api_name, Appointment_For from Appointments__s where id is not null" }  | 
{ "select_query": "select Data_Processing_Basis_Details.Contact_Through_Survey, Data_Processing_Basis_Details.Data_Processing_Basis from Leads where Data_Processing_Basis_Details is not null" }  | 
{ "select_query" : "select Owner from Accounts where id is not null" }  | 
                                               V6  |                                       V7        | 
{     "data": [         {             "Owner": {                 "id": "5725767000000411001"             },             "id": "5725767000000420169"         },         {             "Owner": {                 "id": "5725767000000411001"             },             "id": "5725767000000420170"         },         .         .         .     ],     "info": {         "count": 23,         "more_records": false     } }  | {     "data": [         {             "Owner": {                 "name": "Boyle",                 "id": "5725767000000411001"             },             "id": "5725767000000420169"         },         {             "Owner": {                 "name": "Kate",                 "id": "5725767000000411482"             },             "id": "5725767000000420170"         },         .         .         .     ],     "info": {         "count": 23,         "more_records": false     } }  | 
                                                                         V6  |                                     V7  | 
      is null, is not null  | is null, is not null, =, !=, in, not in, like, not like | 
{  "select_query" : "select Record_Image from Leads where Record_Image = 'siwz79472749456ff433f8b88d0a795ae9855' "  }  | 
| V6 | V7 | 
   is null, is not null  | =, !=, >=, >, <=, <, between, not between, in, not in, is null, is not null | 
{  "select_query" : "select Last_Name from Leads where Total_Calls between 5 and 10" }  | 
{ "select_query": "select Last_Note_Added from Leads where id is not null" }  | 
| V6 | V7 | 
{     "data": [         {             "Last_Note_Added": "1721302770000",             "id": "5725767000003160016"         },         .         .         .     ],     "info": {         "count": 200,         "more_records": true     } }     | { "data": [         {              "Last_Note_Added": "2024-07-04T03:49:48-07:00",             "id": "5725767000003160016"         },         .         .         .     ],     "info": {         "count": 200,         "more_records": true     } }     | 
{ "select_query" : "select Last_Name, Created_Time from Leads where (Last_Name is not null and id > 5725767000003160016)" }  | 
{  "select_query" : "select id from Contacts where id is not null order by Owner.role, Created_By.profile" }  | 
{ "select_query" : "select Owner.last_name, Created_By.role from Contacts where id is not null" }  | 
{ "select_query" : "select Lead_Source,Email from Leads where Contacts in (select id from Contacts where Email='patricia@mail.com')" }  | 
Writer is a powerful online word processor, designed for collaborative work.