Following a create or update operation,
the output message body contains the input message body augmented
with data from the Salesforce system. Following a retrieve or delete operation,
the input message body is discarded and replaced.
The data that is added varies according to the operation
performed by the
SalesforceRequest node
(create, retrieve, update, or delete):
- Following a
create operation, the output message
body contains the input message body augmented with the Salesforce
ID of the newly created Salesforce record
- Following a
retrieve operation, the output message
body contains the following data:
- If you specified a Salesforce ID, the output message body contains
a JSON object for the record
- If you did not specify a Salesforce ID, the output message body
contains a JSON array for zero or more records
- Following an
update operation, the output message
body contains the following data:
- If you specified a Salesforce ID, the output message body contains
the input message body augmented with the Salesforce ID of the updated
Salesforce record
- If you specified an External ID and the Salesforce record already
existed, the output message body contains the input message body
- If you specified an External ID and the Salesforce record did
not previously exist, the output message body contains the input message
body augmented with the Salesforce ID of the newly created Salesforce
record
- Following a
delete operation, the output message
body contains the Salesforce ID of the Salesforce record that was
deleted.
The following table shows example input and output message
bodies for each operation:
Table 1. SalesforceRequest
node - input and output message bodies. Example input
message bodies to the SalesforceRequest node and
the output message bodies following a create, retrieve, update, or
delete operation.
| Operation |
input message body to SalesforceRequest node |
output message body from SalesforceRequest node |
create |
(0x01000000:Object):JSON = ( ['json' : 0x7fe8bc1b65c0]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Name = 'Account-32' (CHARACTER)
(0x03000000:NameValue):Type = 'good' (CHARACTER)
(0x03000000:NameValue):BillingStreet = 'Romsey Road' (CHARACTER)
(0x03000000:NameValue):BillingCity = 'Winchester' (CHARACTER)
(0x03000000:NameValue):BillingState = 'Hampshire' (CHARACTER)
(0x03000000:NameValue):BillingPostalCode = 'SO21 2JN' (CHARACTER)
(0x03000000:NameValue):BillingCountry = 'United Kingdom' (CHARACTER)
(0x03000000:NameValue):Phone = '01962815000' (CHARACTER)
(0x03000000:NameValue):Fax = '01962816666' (CHARACTER)
(0x03000000:NameValue):AccountNumber = '001122334455' (CHARACTER)
(0x03000000:NameValue):Website = 'http://www.ibm.com' (CHARACTER)
)
)
|
(0x01000000:Object):JSON = ( ['json' : 0x7fe8dc2d9a70]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Name = 'Account-32' (CHARACTER)
(0x03000000:NameValue):Type = 'good' (CHARACTER)
(0x03000000:NameValue):BillingStreet = 'Romsey Road' (CHARACTER)
(0x03000000:NameValue):BillingCity = 'Winchester' (CHARACTER)
(0x03000000:NameValue):BillingState = 'Hampshire' (CHARACTER)
(0x03000000:NameValue):BillingPostalCode = 'SO21 2JN' (CHARACTER)
(0x03000000:NameValue):BillingCountry = 'United Kingdom' (CHARACTER)
(0x03000000:NameValue):Phone = '01962815000' (CHARACTER)
0x03000000:NameValue):Fax = '01962816666' (CHARACTER)
0x03000000:NameValue):AccountNumber = '001122334455' (CHARACTER)
0x03000000:NameValue):Website = 'http://www.ibm.com' (CHARACTER)
0x03000000:NameValue):Id = '00158000003M6LzAAK' (CHARACTER)
)
)
|
retrieve (by Id) |
LocalEnvironment:
(0x01000000:Name):Destination = (
(0x01000000:Name):Salesforce = (
(0x01000000:Name):Request = (
(0x03000000:NameValue):id = '00158000003M6LzAAK' (CHARACTER)
)
)
)
No Input data
|
(0x01000000:Object):JSON = ( ['json' : 0x7fe8dc376bd0]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Id = '00158000003M6LzAAK' (CHARACTER)
(0x01000000:Object ):attributes = (
(0x03000000:NameValue):type = 'Account' (CHARACTER)
(0x03000000:NameValue):url = '/services/data/v34.0/sobjects/Account/00158000003M6LzAAK' (CHARACTER)
)
(0x03000000:NameValue):IsDeleted = FALSE (BOOLEAN)
(0x03000000:NameValue):MasterRecordId = NULL
(0x03000000:NameValue):Name = 'Account-32' (CHARACTER)
(0x03000000:NameValue):Type = 'good' (CHARACTER)
(0x03000000:NameValue):ParentId = NULL
(0x03000000:NameValue):BillingStreet = 'Romsey Road' (CHARACTER)
(0x03000000:NameValue):BillingCity = 'Winchester' (CHARACTER)
(0x03000000:NameValue):BillingState = 'Hampshire' (CHARACTER)
(0x03000000:NameValue):BillingPostalCode = 'SO21 2JN' (CHARACTER)
(0x03000000:NameValue):BillingCountry = 'United Kingdom' (CHARACTER)
(0x03000000:NameValue):BillingLatitude = NULL
(0x03000000:NameValue):BillingLongitude = NULL
(0x01000000:Object ):BillingAddress = (
(0x03000000:NameValue):city = 'Winchester' (CHARACTER)
(0x03000000:NameValue):country = 'United Kingdom' (CHARACTER)
(0x03000000:NameValue):countryCode = NULL
(0x03000000:NameValue):geocodeAccuracy = NULL
(0x03000000:NameValue):latitude = NULL
(0x03000000:NameValue):longitude = NULL
(0x03000000:NameValue):postalCode = 'SO21 2JN' (CHARACTER)
(0x03000000:NameValue):state = 'Hampshire' (CHARACTER)
(0x03000000:NameValue):stateCode = NULL
(0x03000000:NameValue):street = 'Romsey Road' (CHARACTER)
)
(0x03000000:NameValue):ShippingStreet = NULL
(0x03000000:NameValue):ShippingCity = NULL
(0x03000000:NameValue):ShippingState = NULL
(0x03000000:NameValue):ShippingPostalCode = NULL
(0x03000000:NameValue):ShippingCountry = NULL
(0x03000000:NameValue):ShippingLatitude = NULL
(0x03000000:NameValue):ShippingLongitude = NULL
(0x03000000:NameValue):ShippingAddress = NULL
(0x03000000:NameValue):Phone = '01962815000' (CHARACTER)
(0x03000000:NameValue):Fax = '01962816666' (CHARACTER)
(0x03000000:NameValue):AccountNumber = '001122334455' (CHARACTER)
(0x03000000:NameValue):Website = 'http://www.ibm.com' (CHARACTER)
(0x03000000:NameValue):PhotoUrl = '/services/images/photo/00158000003M6LzAAK' (CHARACTER)
(0x03000000:NameValue):Sic = NULL
(0x03000000:NameValue):Industry = NULL
(0x03000000:NameValue):AnnualRevenue = NULL
(0x03000000:NameValue):NumberOfEmployees = NULL
(0x03000000:NameValue):Ownership = NULL
(0x03000000:NameValue):TickerSymbol = NULL
(0x03000000:NameValue):Description = NULL
(0x03000000:NameValue):Rating = NULL
(0x03000000:NameValue):Site = NULL
(0x03000000:NameValue):OwnerId = '00558000000a0qdAAA' (CHARACTER)
(0x03000000:NameValue):CreatedDate = '2016-02-17T13:39:30.000+0000' (CHARACTER)
(0x03000000:NameValue):CreatedById = '00558000000a0qdAAA' (CHARACTER)
(0x03000000:NameValue):LastModifiedDate = '2016-02-17T13:39:30.000+0000' (CHARACTER)
(0x03000000:NameValue):LastModifiedById = '00558000000a0qdAAA' (CHARACTER)
(0x03000000:NameValue):SystemModstamp = '2016-02-17T13:39:30.000+0000' (CHARACTER)
(0x03000000:NameValue):LastActivityDate = NULL
(0x03000000:NameValue):LastViewedDate = '2016-02-17T13:39:30.000+0000' (CHARACTER)
(0x03000000:NameValue):LastReferencedDate = '2016-02-17T13:39:30.000+0000' (CHARACTER)
(0x03000000:NameValue):Jigsaw = NULL
(0x03000000:NameValue):JigsawCompanyId = NULL
(0x03000000:NameValue):CleanStatus = 'Pending' (CHARACTER)
(0x03000000:NameValue):AccountSource = NULL
(0x03000000:NameValue):DunsNumber = NULL
(0x03000000:NameValue):Tradestyle = NULL
(0x03000000:NameValue):NaicsCode = NULL
(0x03000000:NameValue):NaicsDesc = NULL
(0x03000000:NameValue):YearStarted = NULL
(0x03000000:NameValue):SicDesc = NULL
(0x03000000:NameValue):DandbCompanyId = NULL
(0x03000000:NameValue):CustomerPriority__c = NULL
(0x03000000:NameValue):SLA__c = NULL
(0x03000000:NameValue):Active__c = NULL
(0x03000000:NameValue):NumberofLocations__c = NULL
(0x03000000:NameValue):UpsellOpportunity__c = NULL
(0x03000000:NameValue):SLASerialNumber__c = NULL
(0x03000000:NameValue):SLAExpirationDate__c = NULL
(0x03000000:NameValue):MyExternalId__c = NULL
)
)
|
retrieve using a filter (filter.limit
=2) |
LocalEnvironment:
(0x01000000:Name):Destination = (
(0x01000000:Name):Salesforce = (
(0x01000000:Name):Request = (
(0x01000000:Name):filter = (
(0x03000000:NameValue):limit = 2 (INTEGER)
)
)
)
)
|
(0x01000000:Object):JSON = ( ['json' : 0x7f80d02f0710]
(0x01001000:Array):Data = (
(0x01000000:Object):Item = (
(0x03000000:NameValue):Id = '00158000002dQ2eAAE' (CHARACTER)
(0x01000000:Object ):attributes = (
(0x03000000:NameValue):type = 'Account' (CHARACTER)
(0x03000000:NameValue):url = '/services/data/v34.0/sobjects/Account/00158000002dQ2eAAE' (CHARACTER)
)
(0x03000000:NameValue):IsDeleted = FALSE (BOOLEAN)
(0x03000000:NameValue):MasterRecordId = NULL
(0x03000000:NameValue):Name = 'One' (CHARACTER)
(0x03000000:NameValue):Type = NULL
(0x03000000:NameValue):ParentId = NULL
(0x03000000:NameValue):BillingStreet = 'Sanjay Billing Street' (CHARACTER)
(0x03000000:NameValue):BillingCity = 'Southampton' (CHARACTER)
(0x03000000:NameValue):BillingState = NULL
(0x03000000:NameValue):BillingPostalCode = NULL
(0x03000000:NameValue):BillingCountry = NULL
(0x03000000:NameValue):BillingLatitude = NULL
(0x03000000:NameValue):BillingLongitude = NULL
(0x01000000:Object ):BillingAddress = (
(0x03000000:NameValue):city = 'Southampton' (CHARACTER)
(0x03000000:NameValue):country = NULL
(0x03000000:NameValue):countryCode = NULL
(0x03000000:NameValue):geocodeAccuracy = NULL
(0x03000000:NameValue):latitude = NULL
(0x03000000:NameValue):longitude = NULL
(0x03000000:NameValue):postalCode = NULL
(0x03000000:NameValue):state = NULL
(0x03000000:NameValue):stateCode = NULL
(0x03000000:NameValue):street = 'Sanjay Billing Street' (CHARACTER)
)
(0x03000000:NameValue):ShippingStreet = 'Sanjay Shipping Street' (CHARACTER)
(0x03000000:NameValue):ShippingCity = 'Southampton' (CHARACTER)
(0x03000000:NameValue):ShippingState = NULL
(0x03000000:NameValue):ShippingPostalCode = NULL
(0x03000000:NameValue):ShippingCountry = NULL
(0x03000000:NameValue):ShippingLatitude = NULL
(0x03000000:NameValue):ShippingLongitude = NULL
(0x01000000:Object ):ShippingAddress = (
(0x03000000:NameValue):city = 'Southampton' (CHARACTER)
(0x03000000:NameValue):country = NULL
(0x03000000:NameValue):countryCode = NULL
(0x03000000:NameValue):geocodeAccuracy = NULL
(0x03000000:NameValue):latitude = NULL
(0x03000000:NameValue):longitude = NULL
(0x03000000:NameValue):postalCode = NULL
(0x03000000:NameValue):state = NULL
(0x03000000:NameValue):stateCode = NULL
(0x03000000:NameValue):street = 'Sanjay Shipping Street' (CHARACTER)
)
(0x03000000:NameValue):Phone = NULL
(0x03000000:NameValue):Fax = NULL
(0x03000000:NameValue):AccountNumber = '12341234' (CHARACTER)
(0x03000000:NameValue):Website = NULL
(0x03000000:NameValue):PhotoUrl = '/services/images/photo/00158000002dQ2eAAE' (CHARACTER)
(0x03000000:NameValue):Sic = NULL
(0x03000000:NameValue):Industry = NULL
(0x03000000:NameValue):AnnualRevenue = NULL
(0x03000000:NameValue):NumberOfEmployees = NULL
(0x03000000:NameValue):Ownership = NULL
(0x03000000:NameValue):TickerSymbol = NULL
(0x03000000:NameValue):Description = NULL
(0x03000000:NameValue):Rating = NULL
(0x03000000:NameValue):Site = NULL
(0x03000000:NameValue):OwnerId = '00558000000a0qdAAA' (CHARACTER)
(0x03000000:NameValue):CreatedDate = '2016-01-13T22:26:03.000+0000' (CHARACTER)
(0x03000000:NameValue):CreatedById = '00558000000a0qdAAA' (CHARACTER)
(0x03000000:NameValue):LastModifiedDate = '2016-01-19T12:35:55.000+0000' (CHARACTER)
(0x03000000:NameValue):LastModifiedById = '00558000000a0qdAAA' (CHARACTER)
(0x03000000:NameValue):SystemModstamp = '2016-01-19T12:35:55.000+0000' (CHARACTER)
(0x03000000:NameValue):LastActivityDate = NULL
(0x03000000:NameValue):LastViewedDate = '2016-01-19T12:35:55.000+0000' (CHARACTER)
(0x03000000:NameValue):LastReferencedDate = '2016-01-19T12:35:55.000+0000' (CHARACTER)
(0x03000000:NameValue):Jigsaw = NULL
(0x03000000:NameValue):JigsawCompanyId = NULL
(0x03000000:NameValue):CleanStatus = 'Pending' (CHARACTER)
(0x03000000:NameValue):AccountSource = NULL
(0x03000000:NameValue):DunsNumber = NULL
(0x03000000:NameValue):Tradestyle = NULL
(0x03000000:NameValue):NaicsCode = NULL
(0x03000000:NameValue):NaicsDesc = NULL
(0x03000000:NameValue):YearStarted = NULL
(0x03000000:NameValue):SicDesc = NULL
(0x03000000:NameValue):DandbCompanyId = NULL
(0x03000000:NameValue):CustomerPriority__c = NULL
(0x03000000:NameValue):SLA__c = NULL
(0x03000000:NameValue):Active__c = NULL
(0x03000000:NameValue):NumberofLocations__c = NULL
(0x03000000:NameValue):UpsellOpportunity__c = NULL
(0x03000000:NameValue):SLASerialNumber__c = NULL
(0x03000000:NameValue):SLAExpirationDate__c = NULL
(0x03000000:NameValue):MyExternalId__c = NULL
)
(0x01000000:Object):Item = (
(0x03000000:NameValue):Id = '001580000031ir8AAA' (CHARACTER)
(0x01000000:Object ):attributes = (
(0x03000000:NameValue):type = 'Account' (CHARACTER)
(0x03000000:NameValue):url = '/services/data/v34.0/sobjects/Account/001580000031ir8AAA' (CHARACTER)
)
(0x03000000:NameValue):IsDeleted = FALSE (BOOLEAN)
(0x03000000:NameValue):MasterRecordId = NULL
(0x03000000:NameValue):Name = 'Account-42' (CHARACTER)
(0x03000000:NameValue):Type = 'My Special Type' (CHARACTER)
(0x03000000:NameValue):ParentId = NULL
(0x03000000:NameValue):BillingStreet = NULL
(0x03000000:NameValue):BillingCity = NULL
(0x03000000:NameValue):BillingState = NULL
(0x03000000:NameValue):BillingPostalCode = NULL
(0x03000000:NameValue):BillingCountry = NULL
(0x03000000:NameValue):BillingLatitude = NULL
(0x03000000:NameValue):BillingLongitude = NULL
(0x03000000:NameValue):BillingAddress = NULL
(0x03000000:NameValue):ShippingStreet = NULL
(0x03000000:NameValue):ShippingCity = NULL
(0x03000000:NameValue):ShippingState = NULL
(0x03000000:NameValue):ShippingPostalCode = NULL
(0x03000000:NameValue):ShippingCountry = NULL
(0x03000000:NameValue):ShippingLatitude = NULL
(0x03000000:NameValue):ShippingLongitude = NULL
(0x03000000:NameValue):ShippingAddress = NULL
(0x03000000:NameValue):Phone = NULL
(0x03000000:NameValue):Fax = NULL
(0x03000000:NameValue):AccountNumber = NULL
(0x03000000:NameValue):Website = NULL
(0x03000000:NameValue):PhotoUrl = '/services/images/photo/001580000031ir8AAA' (CHARACTER)
(0x03000000:NameValue):Sic = NULL
(0x03000000:NameValue):Industry = NULL
(0x03000000:NameValue):AnnualRevenue = NULL
(0x03000000:NameValue):NumberOfEmployees = NULL
(0x03000000:NameValue):Ownership = NULL
(0x03000000:NameValue):TickerSymbol = NULL
(0x03000000:NameValue):Description = NULL
(0x03000000:NameValue):Rating = NULL
(0x03000000:NameValue):Site = NULL
(0x03000000:NameValue):OwnerId = '00558000000a0qdAAA' (CHARACTER)
(0x03000000:NameValue):CreatedDate = '2016-02-01T22:58:06.000+0000' (CHARACTER)
(0x03000000:NameValue):CreatedById = '00558000000a0qdAAA' (CHARACTER)
(0x03000000:NameValue):LastModifiedDate = '2016-02-01T22:58:06.000+0000' (CHARACTER)
(0x03000000:NameValue):LastModifiedById = '00558000000a0qdAAA' (CHARACTER)
(0x03000000:NameValue):SystemModstamp = '2016-02-01T22:58:06.000+0000' (CHARACTER)
(0x03000000:NameValue):LastActivityDate = NULL
(0x03000000:NameValue):LastViewedDate = '2016-02-01T22:58:06.000+0000' (CHARACTER)
(0x03000000:NameValue):LastReferencedDate = '2016-02-01T22:58:06.000+0000' (CHARACTER)
(0x03000000:NameValue):Jigsaw = NULL
(0x03000000:NameValue):JigsawCompanyId = NULL
(0x03000000:NameValue):CleanStatus = 'Pending' (CHARACTER)
(0x03000000:NameValue):AccountSource = NULL
(0x03000000:NameValue):DunsNumber = NULL
(0x03000000:NameValue):Tradestyle = NULL
(0x03000000:NameValue):NaicsCode = NULL
(0x03000000:NameValue):NaicsDesc = NULL
(0x03000000:NameValue):YearStarted = NULL
(0x03000000:NameValue):SicDesc = NULL
(0x03000000:NameValue):DandbCompanyId = NULL
(0x03000000:NameValue):CustomerPriority__c = NULL
(0x03000000:NameValue):SLA__c = NULL
(0x03000000:NameValue):Active__c = NULL
(0x03000000:NameValue):NumberofLocations__c = NULL
(0x03000000:NameValue):UpsellOpportunity__c = NULL
(0x03000000:NameValue):SLASerialNumber__c = NULL
(0x03000000:NameValue):SLAExpirationDate__c = NULL
(0x03000000:NameValue):MyExternalId__c = NULL
)
)
)
|
update (using Id) |
LocalEnvironment:
(0x01000000:Name):Destination = (
(0x01000000:Name):Salesforce = (
(0x01000000:Name):Request = (
(0x03000000:NameValue):Id = '00158000003M6LzAAK' (CHARACTER)
)
)
)
(0x01000000:Object):JSON = ( ['json' : 0x7fe88c359150]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Name = 'Account-32' (CHARACTER)
(0x03000000:NameValue):BillingStreet = 'Test Road' (CHARACTER)
(0x03000000:NameValue):BillingCity = 'Hedge End' (CHARACTER)
0x03000000:NameValue):BillingState = 'Hampshire' (CHARACTER)
(0x03000000:NameValue):BillingPostalCode = 'SO30' (CHARACTER)
(0x03000000:NameValue):BillingCountry = 'United Kingdom' (CHARACTER)
)
)
|
(0x01000000:Object):JSON = ( ['json' : 0x7fe8dc43c460]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Name = 'Account-32' (CHARACTER)
(0x03000000:NameValue):BillingStreet = 'Test Road' (CHARACTER)
(0x03000000:NameValue):BillingCity = 'Hedge End' (CHARACTER)
(0x03000000:NameValue):BillingState = 'Hampshire' (CHARACTER)
(0x03000000:NameValue):BillingPostalCode = 'SO30' (CHARACTER)
(0x03000000:NameValue):BillingCountry = 'United Kingdom' (CHARACTER)
(0x03000000:NameValue):Id = '00158000003M6LzAAK' (CHARACTER)
)
)
|
update (using external Id
and the Salesforce record did not already exist) |
LocalEnvironment:
(0x01000000:Name):Destination = (
(0x01000000:Name):Salesforce = (
(0x01000000:Name):Request = (
(0x03000000:NameValue):externalIdName = 'MyExternalId__c' (CHARACTER)
(0x03000000:NameValue):externalId = 'special4' (CHARACTER)
)
)
)
(0x01000000:Object):JSON = ( ['json' : 0x7f80f817c0a0]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Name = 'Account-82' (CHARACTER)
(0x03000000:NameValue):BillingStreet = 'New Road' (CHARACTER)
)
)
|
(0x01000000:Object):JSON = ( ['json' : 0x7f80d0188760]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Name = 'Account-82' (CHARACTER)
(0x03000000:NameValue):BillingStreet = 'New Road' (CHARACTER)
(0x03000000:NameValue):Id = '00158000003MBiuAAG' (CHARACTER)
)
)
|
update (using external Id
and the Salesforce record already existed) |
LocalEnvironment:
(0x01000000:Name):Destination = (
(0x01000000:Name):Salesforce = (
(0x01000000:Name):Request = (
(0x03000000:NameValue):externalIdName = 'MyExternalId__c' (CHARACTER)
(0x03000000:NameValue):externalId = 'special4' (CHARACTER)
)
)
)
(0x01000000:Object):JSON = ( ['json' : 0x7f80f817c0a0]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Name = 'Account-82' (CHARACTER)
(0x03000000:NameValue):BillingStreet = 'New Road' (CHARACTER)
)
)
|
(0x01000000:Object):JSON = ( ['json' : 0x7f80d0188760]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Name = 'Account-82' (CHARACTER)
(0x03000000:NameValue):BillingStreet = 'New Road' (CHARACTER)
)
)
|
delete |
LocalEnvironment:
(0x01000000:Name):Destination = (
(0x01000000:Name):Salesforce = (
(0x01000000:Name):Request = (
(0x03000000:NameValue):id = '00158000003M82WAAS' (CHARACTER)
)
)
)
No Input data
|
(0x01000000:Object):JSON = ( ['json' : 0x7fe128478650]
(0x01000000:Object):Data = (
(0x03000000:NameValue):Id = '00158000003M82WAAS' (CHARACTER)
)
)
|