In some case it is necessary to connect Advendio with some surrounding systems. Here you can find the basic as an example with dataplan's Journal Designer.
...
You can send the following XML per POST-Method with "Content-Type: text/xml; charset=utf-8” in RequestHead to the service URL (which you got at your login):
| Code Block |
|---|
<?xml version="1.0" encoding="UTF-8"?> |
...
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> |
...
<soapenv:Header> |
...
<ns1:SessionHeader soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0" xmlns:ns1="urn:enterprise.soap.sforce.com"> |
...
<ns1:sessionId>THE-SESSION-ID</ns1:sessionId> |
...
</ns1:SessionHeader> |
...
</soapenv:Header> |
...
<soapenv:Body> |
...
<invalidateSessions xmlns="urn:enterprise.soap.sforce.com"> |
...
<sessionIds>THE-SESSION-ID</sessionIds> |
...
</invalidateSessions> |
...
</soapenv:Body> |
...
</soapenv:Envelope> |
The result should be the following:
| Code Block |
|---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:enterprise.soap.sforce.com"> |
...
<soapenv:Body> |
...
<invalidateSessionsResponse> |
...
<result> |
...
<success>true</success> |
...
</result> |
...
</invalidateSessionsResponse> |
...
</soapenv:Body> |
...
</soapenv:Envelope> |
You will find more details here: https://developer.salesforce.com/page/Salesforce_APIs
...
The Query will look like this:
| Code Block |
|---|
SELECT ADvendio__CampaignItem__r.Id, ADvendio__CampaignItem__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.Name, ADvendio__CampaignItem__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__Site__r.Name, ADvendio__CampaignItem__r.ADvendio__Media_Campaign__r.ADvendio__Account__r.Name, ADvendio__CampaignItem__r.ADvendio__Media_Campaign__r.ADvendio__external_Media_Campaign_Name__c, ADvendio__CampaignItem__r.ADvendio__Media_Campaign__r.Owner.Name, ADvendio__CampaignItem__r.ADvendio__Height__c, ADvendio__CampaignItem__r.ADvendio__Width__c, ADvendio__CampaignItem__r.ADvendio__NumberOfColumns__c, ADvendio__CampaignItem__r.ADvendio__PaymentType__c, ADvendio__CampaignItem__r.ADvendio__PreferredPlacement__c, ADvendio__CampaignItem__r.ADvendio__SelectedBrandProductInformation__c, ADvendio__PublicationDate__r.Id, ADvendio__PublicationDate__r.Name, ADvendio__PublicationDate__r.ADvendio__PublicationDate__c FROM ADVendio__SelectedPublicationDate__c WHERE ADvendio__PublicationDate__r.ADvendio__PublicationDate__c=2016-12-24 |
Please take note of the "WHERE"-Clause for the data.
...
Then you will receive the JSON-Response:
| Code Block |
|---|
{ |
...
"totalSize" : 1, |
...
"done" : true, |
...
"records" : [ |
...
{ |
...
"ADvendio__CampaignItem__r" : { |
...
"ADvendio__Height__c" : 350, |
...
"attributes" : { |
...
"url" : "/services/data/v37.0/sobjects/ADvendio__Campaign_Item__c/a0G0Y000000YzacUAC", |
...
"type" : "ADvendio__Campaign_Item__c" |
...
}, |
...
"ADvendio__PaymentType__c" : "Paid", |
...
"ADvendio__Media_Campaign__r" : { |
...
"ADvendio__external_Media_Campaign_Name__c" : "General Advertising Campaign Winter 2016", |
...
"Owner" : { |
...
"attributes" : { |
...
"type" : "Name", |
...
"url" : "/services/data/v37.0/sobjects/User/0050Y0000017mIiQAI" |
...
}, |
...
"Name" : "Stefan Ropte" |
...
}, |
...
"attributes" : { |
...
"type" : "ADvendio__MediaCampaign__c", |
...
"url" : "/services/data/v37.0/sobjects/ADvendio__MediaCampaign__c/a0M0Y000000ZGdmUAG" |
...
}, |
...
"ADvendio__Account__r" : { |
...
"attributes" : { |
...
"url" : "/services/data/v37.0/sobjects/Account/0010Y00000BUTVeQAP", |
...
"type" : "Account" |
...
}, |
...
"Name" : "GameCompany Ltd." |
...
} |
...
}, |
...
"ADvendio__Width__c" : 210, |
...
"ADvendio__SelectedBrandProductInformation__c" : null, |
...
"Id" : "a0G0Y000000YzacUAC", |
...
"ADvendio__Ad_Price__r" : { |
...
"ADvendio__Ad_Spec__r" : { |
...
"attributes" : { |
...
"url" : "/services/data/v37.0/sobjects/ADvendio__Ad_Specs__c/a090Y000000OJA2QAO", |
...
"type" : "ADvendio__Ad_Specs__c" |
...
}, |
...
"ADvendio__Placement__r" : { |
...
"attributes" : { |
...
"type" : "ADvendio__Placement__c", |
...
"url" : "/services/data/v37.0/sobjects/ADvendio__Placement__c/a0O0Y000000I7o3UAC" |
...
}, |
...
"ADvendio__Site__r" : { |
...
"Name" : "Seattle News", |
...
"attributes" : { |
...
"type" : "ADvendio__Site__c", |
...
"url" : "/services/data/v37.0/sobjects/ADvendio__Site__c/a0W0Y000000Hso9UAC" |
...
} |
...
} |
...
}, |
...
"ADvendio__Ad_Type__r" : { |
...
"attributes" : { |
...
"type" : "ADvendio__Ad_Type__c", |
...
"url" : "/services/data/v37.0/sobjects/ADvendio__Ad_Type__c/a0A0Y000000xs3UUAQ" |
...
}, |
...
"Name" : "Fullpage" |
...
} |
...
}, |
...
"attributes" : { |
...
"url" : "/services/data/v37.0/sobjects/ADvendio__Ad_price__c/a0B0Y000000IIbaUAG", |
...
"type" : "ADvendio__Ad_price__c" |
...
} |
...
}, |
...
"ADvendio__NumberOfColumns__c" : "1", |
...
"ADvendio__PreferredPlacement__c" : "Page 2 als Beispiel" |
...
}, |
...
"attributes" : { |
...
"type" : "ADvendio__SelectedPublicationDate__c", |
...
"url" : "/services/data/v37.0/sobjects/ADvendio__SelectedPublicationDate__c/a1F0Y000000cPkbUAE" |
...
}, |
...
"ADvendio__PublicationDate__r" : { |
...
"Id" : "a1C0Y0000000nYCUAY", |
...
"ADvendio__PublicationDate__c" : "2016-12-24", |
...
"Name" : "No. 356", |
...
"attributes" : { |
...
"url" : "/services/data/v37.0/sobjects/ADvendio__PublicationDate__c/a1C0Y0000000nYCUAY", |
...
"type" : "ADvendio__PublicationDate__c" |
...
} |
...
} |
...
} |
...
] |
...
} |
To get information about the authentification of a client towards Salesforce, which resources you can request how via REST-API, how the data-structure of the response will be please take a look at the SF REST API documentation.
...