Kentico Integration - API calls

Owned by Angus Thompson
Last updated: Sept 06, 2016
2 min read

Activity

____________________________

Query
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:



NameOnePlace__Parent__c
1Parent Interest 3
2Parent Interest 2
3Parent Interest 1


All codes:

SELECT ID,Name,OnePlace__Parent__c FROM OnePlace__Interest__c 

Example:




IdNameOnePlace__Parent__c
1a0M41000000AfKBEA0Parent Interest 3
2a0M41000000AfK1EAKChild Interest 1.3a0M41000000AfJhEAK
3a0M41000000AfJmEAKParent Interest 2
4a0M41000000AfJrEAKChild Interest 1.1a0M41000000AfJhEAK
5a0M41000000AfJwEAKChild Interest 1.2a0M41000000AfJhEAK
6a0M41000000AfK6EAKChild Interest 2.1a0M41000000AfJmEAK
7a0M41000000AfJhEAKParent Interest 1
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:



IdNameOnePlace__Function_Code__c
1a0I41000000Bx1WEASTest1A ECATest1A
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'



IdOnePlace__Company_Name__cOnePlace__Contact_Email__cOnePlace__Contact_Name__cOnePlace__Function__cOnePlace__Job_Title__cOnePlace__Last_First_Names__c
1a0O410000006ECWEA2Company2Afirstname2a.lastname2a@company2a.comFirstName2A LastName2Aa0I41000000Bx1WEAS
LastName2A, FirstName2A
2a0O410000006ECUEA2Company1A
FirstName1A Surname1Aa0I41000000Bx1WEAS
Surname1A, FirstName1A



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'




IdOnePlace__Contact_Email__cOnePlace__Function__cOnePlace__RSVP__cOnePlace__Attended__cOnePlace__Dietary__cOnePlace__Paid__c
1a0O410000006ECWEA2firstname2a.lastname2a@company2a.coma0I41000000Bx1WEASNo Response

No
2a0O410000006ECUEA2
a0I41000000Bx1WEASNo Response

No



Additional calls to be added.