Areas of Interest | REST Api Call: /services/data/v37.0/query/?q=SELECT+Name,OnePlace__Parent__c+FROM+OnePlace__Interest__c+WHERE+OnePlace__Parent__c+=+'' Result: HTTP/1.1 200 OK Date: Tue, 06 Sep 2016 19:02:38 GMT Set-Cookie: BrowserId=uHZKp6SGSES_NjaMFMWb5Q;Path=/;Domain=.salesforce.com;Expires=Sat, 05-Nov-2016 19:02:38 GMT Expires: Thu, 01 Jan 1970 00:00:00 GMT Sforce-Limit-Info: api-usage=143/15000 Content-Type: application/json;charset=UTF-8 Content-Encoding: gzip Transfer-Encoding: chunked { "totalSize" : 3, "done" : true, "records" : [ { "attributes" : { "type" : "OnePlace__Interest__c", "url" : "/services/data/v37.0/sobjects/OnePlace__Interest__c/a0M41000000AfKBEA0" }, "Name" : "Parent Interest 3", "OnePlace__Parent__c" : null }, { "attributes" : { "type" : "OnePlace__Interest__c", "url" : "/services/data/v37.0/sobjects/OnePlace__Interest__c/a0M41000000AfJmEAK" }, "Name" : "Parent Interest 2", "OnePlace__Parent__c" : null }, { "attributes" : { "type" : "OnePlace__Interest__c", "url" : "/services/data/v37.0/sobjects/OnePlace__Interest__c/a0M41000000AfJhEAK" }, "Name" : "Parent Interest 1", "OnePlace__Parent__c" : null } ] }
Top level code: SELECT Name,OnePlace__Parent__c FROM OnePlace__Interest__c WHERE OnePlace__Parent__c = '' Example:
| Name | OnePlace__Parent__c |
---|
1 | Parent Interest 3 |
| 2 | Parent Interest 2 |
| 3 | Parent Interest 1 |
|
All codes: SELECT ID,Name,OnePlace__Parent__c FROM OnePlace__Interest__c Example:
|
Function List / Dropdown | REST Api Call: /services/data/v37.0/query/?q=SELECT+Id,Name,OnePlace__Function_Code__c+FROM+OnePlace__Function__c+WHERE+OnePlace__Active__c+=+true+ORDER+BY+Name+ASC Result: HTTP/1.1 200 OK Date: Tue, 06 Sep 2016 19:01:32 GMT Set-Cookie: BrowserId=OytQ-2WZTZmr6EZ17XxaNw;Path=/;Domain=.salesforce.com;Expires=Sat, 05-Nov-2016 19:01:32 GMT Expires: Thu, 01 Jan 1970 00:00:00 GMT Sforce-Limit-Info: api-usage=141/15000 Content-Type: application/json;charset=UTF-8 Content-Encoding: gzip Transfer-Encoding: chunked { "totalSize" : 1, "done" : true, "records" : [ { "attributes" : { "type" : "OnePlace__Function__c", "url" : "/services/data/v37.0/sobjects/OnePlace__Function__c/a0I41000000Bx1WEAS" }, "Id" : "a0I41000000Bx1WEAS", "Name" : "Test1A ECA", "OnePlace__Function_Code__c" : "Test1A" } ] } Code: SELECT Id,Name,OnePlace__Function_Code__c FROM OnePlace__Function__c WHERE OnePlace__Active__c = true ORDER BY Name ASC
Example: |
Function Invitees | REST Api Call: /services/data/v37.0/query/?q=SELECT+Id,OnePlace__Company_Name__c,OnePlace__Contact_Email__c,OnePlace__Contact_Name__c,OnePlace__Function__c,OnePlace__Job_Title__c,OnePlace__Last_First_Names__c+FROM+OnePlace__Invitee__c+WHERE+OnePlace__Exclusion_Reasons__c+=+''+AND+OnePlace__Function__c+=+'a0I41000000Bx1W' Result: HTTP/1.1 200 OK Date: Tue, 06 Sep 2016 19:05:20 GMT Set-Cookie: BrowserId=Tdv6if15TxiZi0D6wplBsw;Path=/;Domain=.salesforce.com;Expires=Sat, 05-Nov-2016 19:05:20 GMT Expires: Thu, 01 Jan 1970 00:00:00 GMT Sforce-Limit-Info: api-usage=147/15000 Content-Type: application/json;charset=UTF-8 Content-Encoding: gzip Transfer-Encoding: chunked { "totalSize" : 2, "done" : true, "records" : [ { "attributes" : { "type" : "OnePlace__Invitee__c", "url" : "/services/data/v37.0/sobjects/OnePlace__Invitee__c/a0O410000006ECWEA2" }, "Id" : "a0O410000006ECWEA2", "OnePlace__Company_Name__c" : "Company2A", "OnePlace__Contact_Email__c" : "firstname2a.lastname2a@company2a.com", "OnePlace__Contact_Name__c" : "FirstName2A LastName2A", "OnePlace__Function__c" : "a0I41000000Bx1WEAS", "OnePlace__Job_Title__c" : null, "OnePlace__Last_First_Names__c" : "LastName2A, FirstName2A" }, { "attributes" : { "type" : "OnePlace__Invitee__c", "url" : "/services/data/v37.0/sobjects/OnePlace__Invitee__c/a0O410000006ECUEA2" }, "Id" : "a0O410000006ECUEA2", "OnePlace__Company_Name__c" : "Company1A", "OnePlace__Contact_Email__c" : null, "OnePlace__Contact_Name__c" : "FirstName1A Surname1A", "OnePlace__Function__c" : "a0I41000000Bx1WEAS", "OnePlace__Job_Title__c" : null, "OnePlace__Last_First_Names__c" : "Surname1A, FirstName1A" } ] }
Code: SELECT Id,OnePlace__Company_Name__c,OnePlace__Contact_Email__c,OnePlace__Contact_Name__c,OnePlace__Function__c,OnePlace__Job_Title__c,OnePlace__Last_First_Names__c WHERE OnePlace__Exclusion_Reasons__c = '' AND OnePlace__Function__c = 'ID of Function'
Example: SELECT Id,OnePlace__Company_Name__c,OnePlace__Contact_Email__c,OnePlace__Contact_Name__c,OnePlace__Function__c,OnePlace__Job_Title__c,OnePlace__Last_First_Names__c FROM OnePlace__Invitee__c WHERE OnePlace__Exclusion_Reasons__c = '' AND OnePlace__Function__c = 'a0I41000000Bx1W'
|
Function Invitees (current status) | REST Api Call: /services/data/v37.0/query/?q=SELECT+Id,OnePlace__Contact_Email__c,OnePlace__Function__c,OnePlace__RSVP__c,OnePlace__Attended__c,+OnePlace__Dietary__c,OnePlace__Paid__c+FROM+OnePlace__Invitee__c+WHERE+OnePlace__Exclusion_Reasons__c+=+''+AND+OnePlace__Function__c+=+'a0I41000000Bx1W'Result: Result:
HTTP/1.1 200 OK Date: Tue, 06 Sep 2016 19:06:30 GMT Set-Cookie: BrowserId=b4Jjk6kwTMOzcO3eQebJPg;Path=/;Domain=.salesforce.com;Expires=Sat, 05-Nov-2016 19:06:30 GMT Expires: Thu, 01 Jan 1970 00:00:00 GMT Sforce-Limit-Info: api-usage=150/15000 Content-Type: application/json;charset=UTF-8 Content-Encoding: gzip Transfer-Encoding: chunked { "totalSize" : 2, "done" : true, "records" : [ { "attributes" : { "type" : "OnePlace__Invitee__c", "url" : "/services/data/v37.0/sobjects/OnePlace__Invitee__c/a0O410000006ECWEA2" }, "Id" : "a0O410000006ECWEA2", "OnePlace__Contact_Email__c" : "firstname2a.lastname2a@company2a.com", "OnePlace__Function__c" : "a0I41000000Bx1WEAS", "OnePlace__RSVP__c" : "No Response", "OnePlace__Attended__c" : null, "OnePlace__Dietary__c" : null, "OnePlace__Paid__c" : "No" }, { "attributes" : { "type" : "OnePlace__Invitee__c", "url" : "/services/data/v37.0/sobjects/OnePlace__Invitee__c/a0O410000006ECUEA2" }, "Id" : "a0O410000006ECUEA2", "OnePlace__Contact_Email__c" : null, "OnePlace__Function__c" : "a0I41000000Bx1WEAS", "OnePlace__RSVP__c" : "No Response", "OnePlace__Attended__c" : null, "OnePlace__Dietary__c" : null, "OnePlace__Paid__c" : "No" } ] }
Code: SELECT Id,OnePlace__Contact_Email__c,OnePlace__Function__c,OnePlace__RSVP__c,OnePlace__Attended__c, OnePlace__Dietary__c,OnePlace__Paid__c FROM OnePlace__Invitee__c WHERE OnePlace__Exclusion_Reasons__c = '' AND OnePlace__Function__c = 'ID of Function'
Example: SELECT Id,OnePlace__Contact_Email__c,OnePlace__Function__c,OnePlace__RSVP__c,OnePlace__Attended__c, OnePlace__Dietary__c,OnePlace__Paid__c FROM OnePlace__Invitee__c WHERE OnePlace__Exclusion_Reasons__c = '' AND OnePlace__Function__c = 'a0I41000000Bx1W'
|