Step1 : Getting access token from salesforce
Input :
--------
curl https://eu10.salesforce.com/services/oauth2/token -d "grant_type=password" -d "client_id=3MVG9mIli7ewofGu2Fey6P0EzbHrEZ5QW7IfZGGs6XOpO8AA3tMPg647IVo5jWNEiQduBdQTxRG.KAMSlYvIW" -d "client_secret=6367330749412135519" -d "username=cisco.systems%40yopmail.com" -d "password=Rishan786%25" -X POST -H "X-PrettyPrint:1"
Output :
========
{
"access_token" : "00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa",
"instance_url" : "https://eu10.salesforce.com",
"id" : "https://login.salesforce.com/id/00D0X000000uTD0UAM/0050X000007a0ZeQAI",
"token_type" : "Bearer",
"issued_at" : "1532774651728",
"signature" : "ejZ1kpsoqlPP1yAL4Mvs62yC73X3QN+Wc6xn3PZqb5o="
}
Step2 : Getting organization objects information
Input :
-------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/ -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
Output :
--------
{
"encoding" : "UTF-8",
"maxBatchSize" : 200,
"sobjects" : [ {
"activateable" : false,
"createable" : false,
"custom" : false,
"customSetting" : false,
"deletable" : false,
"deprecatedAndHidden" : false,
"feedEnabled" : false,
"keyPrefix" : null,
"label" : "History: ACC_ATTRIBUTE",
"labelPlural" : "History: ACC_ATTRIBUTE",
"layoutable" : false,
"mergeable" : false,
"name" : "ACC_ATTRIBUTES__History",
"queryable" : true,
"replicateable" : true,
"retrieveable" : true,
"searchable" : false,
"triggerable" : false,
"undeletable" : false,
"updateable" : false,
"urls" : {
"rowTemplate" : "/services/data/v20.0/sobjects/ACC_ATTRIBUTES__History/{ID}",
"describe" : "/services/data/v20.0/sobjects/ACC_ATTRIBUTES__History/describe",
"sobject" : "/services/data/v20.0/sobjects/ACC_ATTRIBUTES__History"
}
}
}
Step3 :
-------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/Account -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
{
"objectDescribe" : {
"activateable" : false,
"createable" : true,
"custom" : false,
"customSetting" : false,
"deletable" : true,
"deprecatedAndHidden" : false,
"feedEnabled" : true,
"keyPrefix" : "001",
"label" : "Account",
"labelPlural" : "Accounts",
"layoutable" : true,
"mergeable" : true,
"name" : "Account",
"queryable" : true,
"replicateable" : true,
"retrieveable" : true,
"searchable" : true,
"triggerable" : true,
"undeletable" : true,
"updateable" : true,
"urls" : {
"rowTemplate" : "/services/data/v20.0/sobjects/Account/{ID}",
"describe" : "/services/data/v20.0/sobjects/Account/describe",
"sobject" : "/services/data/v20.0/sobjects/Account"
}
},
"recentItems" : [ ]
}
Step4 :
-------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/Cisco_FY__c/describe -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
{
"activateable" : false,
"childRelationships" : [ {
"cascadeDelete" : true,
"childSObject" : "Attachment",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : "Attachments"
}, {
"cascadeDelete" : true,
"childSObject" : "Cisco_Team__c",
"deprecatedAndHidden" : false,
"field" : "Cisco_FY__c",
"relationshipName" : "Tracks__r"
}, {
"cascadeDelete" : false,
"childSObject" : "ContentVersion",
"deprecatedAndHidden" : false,
"field" : "FirstPublishLocationId",
"relationshipName" : null
}, {
"cascadeDelete" : true,
"childSObject" : "EntitySubscription",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : "FeedSubscriptionsForEntity"
}, {
"cascadeDelete" : false,
"childSObject" : "FeedComment",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : null
}, {
"cascadeDelete" : true,
"childSObject" : "FeedPost",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : null
}, {
"cascadeDelete" : true,
"childSObject" : "NewsFeed",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : null
}, {
"cascadeDelete" : true,
"childSObject" : "Note",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : "Notes"
}, {
"cascadeDelete" : true,
"childSObject" : "NoteAndAttachment",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : "NotesAndAttachments"
}, {
"cascadeDelete" : true,
"childSObject" : "ProcessInstance",
"deprecatedAndHidden" : false,
"field" : "TargetObjectId",
"relationshipName" : "ProcessInstances"
}, {
"cascadeDelete" : false,
"childSObject" : "ProcessInstanceHistory",
"deprecatedAndHidden" : false,
"field" : "TargetObjectId",
"relationshipName" : "ProcessSteps"
}, {
"cascadeDelete" : true,
"childSObject" : "UserProfileFeed",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : null
} ],
"createable" : true,
"custom" : true,
"customSetting" : false,
"deletable" : true,
"deprecatedAndHidden" : false,
"feedEnabled" : false,
"fields" : [ {
"autoNumber" : false,
"byteLength" : 18,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : true,
"inlineHelpText" : null,
"label" : "Record ID",
"length" : 18,
"name" : "Id",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "tns:ID",
"sortable" : true,
"type" : "id",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 18,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : true,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Owner ID",
"length" : 18,
"name" : "OwnerId",
"nameField" : false,
"namePointing" : true,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ "Group", "User" ],
"relationshipName" : "Owner",
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "tns:ID",
"sortable" : true,
"type" : "reference",
"unique" : false,
"updateable" : true,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 0,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Deleted",
"length" : 0,
"name" : "IsDeleted",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:boolean",
"sortable" : true,
"type" : "boolean",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 240,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : true,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : true,
"inlineHelpText" : null,
"label" : "FY Name",
"length" : 80,
"name" : "Name",
"nameField" : true,
"namePointing" : false,
"nillable" : true,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:string",
"sortable" : true,
"type" : "string",
"unique" : false,
"updateable" : true,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 0,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : false,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Created Date",
"length" : 0,
"name" : "CreatedDate",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:dateTime",
"sortable" : true,
"type" : "datetime",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 18,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Created By ID",
"length" : 18,
"name" : "CreatedById",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ "User" ],
"relationshipName" : "CreatedBy",
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "tns:ID",
"sortable" : true,
"type" : "reference",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 0,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : false,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Last Modified Date",
"length" : 0,
"name" : "LastModifiedDate",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:dateTime",
"sortable" : true,
"type" : "datetime",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 18,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Last Modified By ID",
"length" : 18,
"name" : "LastModifiedById",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ "User" ],
"relationshipName" : "LastModifiedBy",
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "tns:ID",
"sortable" : true,
"type" : "reference",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 0,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : false,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "System Modstamp",
"length" : 0,
"name" : "SystemModstamp",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:dateTime",
"sortable" : true,
"type" : "datetime",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 765,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : true,
"custom" : true,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : false,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Main Track",
"length" : 255,
"name" : "Main_Track__c",
"nameField" : false,
"namePointing" : false,
"nillable" : true,
"picklistValues" : [ {
"active" : true,
"defaultValue" : true,
"label" : "RTB",
"validFor" : null,
"value" : "RTB"
} ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : true,
"scale" : 0,
"soapType" : "xsd:string",
"sortable" : true,
"type" : "picklist",
"unique" : false,
"updateable" : true,
"writeRequiresMasterRead" : false
} ],
"keyPrefix" : "a06",
"label" : "Cisco FY",
"labelPlural" : "Cisco FY",
"layoutable" : true,
"listviewable" : null,
"lookupLayoutable" : null,
"mergeable" : false,
"name" : "Cisco_FY__c",
"queryable" : true,
"recordTypeInfos" : [ {
"available" : true,
"defaultRecordTypeMapping" : true,
"name" : "Master",
"recordTypeId" : "012000000000000AAA"
} ],
"replicateable" : true,
"retrieveable" : true,
"searchLayoutable" : null,
"searchable" : true,
"triggerable" : true,
"undeletable" : true,
"updateable" : true,
"urls" : {
"rowTemplate" : "/services/data/v20.0/sobjects/Cisco_FY__c/{ID}",
"uiDetailTemplate" : "https://eu10.salesforce.com/{ID}",
"uiEditTemplate" : "https://eu10.salesforce.com/{ID}/e",
"describe" : "/services/data/v20.0/sobjects/Cisco_FY__c/describe",
"uiNewRecord" : "https://eu10.salesforce.com/a06/e",
"sobject" : "/services/data/v20.0/sobjects/Cisco_FY__c"
}
}
Step5 :
-------
curl https://eu10.salesforce.com/services/data/v20.0/query?q=SELECT+name+from+Cisco_FY__c -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
{
"totalSize" : 1,
"done" : true,
"records" : [ {
"attributes" : {
"type" : "Cisco_FY__c",
"url" : "/services/data/v20.0/sobjects/Cisco_FY__c/a060X00002XNYY1QAP"
},
"Name" : "FY2018"
} ]
}
Step6 :
-------
curl https://eu10.salesforce.com/services/data/v28.0/recent/ -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
[ {
"attributes" : {
"type" : "Cisco_Team__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Team__c/a070X00001FTP8LQAX"
},
"Id" : "a070X00001FTP8LQAX",
"Name" : "Marketing"
}, {
"attributes" : {
"type" : "Cisco_Track_Leads__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Track_Leads__c/a0H0X00001OWD3IUAX"
},
"Id" : "a0H0X00001OWD3IUAX",
"Name" : "Abhishek"
}, {
"attributes" : {
"type" : "Cisco_Quarter_Details__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Quarter_Details__c/a080X00005EfMXxQAN"
},
"Id" : "a080X00005EfMXxQAN",
"Name" : "Q1"
}, {
"attributes" : {
"type" : "Cisco_FY__c",
"url" : "/services/data/v28.0/sobjects/Cisco_FY__c/a060X00002XNYY1QAP"
},
"Id" : "a060X00002XNYY1QAP",
"Name" : "FY2018"
}, {
"attributes" : {
"type" : "Cisco_User__c",
"url" : "/services/data/v28.0/sobjects/Cisco_User__c/a0E0X00002UAtI5UAL"
},
"Id" : "a0E0X00002UAtI5UAL",
"Name" : "Fazurulla Ganganapalli"
}, {
"attributes" : {
"type" : "Cisco_User_Session__c",
"url" : "/services/data/v28.0/sobjects/Cisco_User_Session__c/a0F0X00000cu6BIUAY"
},
"Id" : "a0F0X00000cu6BIUAY",
"Name" : "0000"
}, {
"attributes" : {
"type" : "Cisco_Appllications__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Appllications__c/a0C0X00000qGQ0DUAW"
},
"Id" : "a0C0X00000qGQ0DUAW",
"Name" : "NGCC"
}, {
"attributes" : {
"type" : "Cisco_Quarter_Details__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Quarter_Details__c/a080X00005EfMY2QAN"
},
"Id" : "a080X00005EfMY2QAN",
"Name" : "Q2"
}, {
"attributes" : {
"type" : "Contact",
"url" : "/services/data/v28.0/sobjects/Contact/0030X00002CWDfMQAX"
},
"Id" : "0030X00002CWDfMQAX",
"Name" : "Andy faz Young"
}, {
"attributes" : {
"type" : "ContentDocument",
"url" : "/services/data/v28.0/sobjects/ContentDocument/0690X0000060Oh3QAE"
},
"Id" : "0690X0000060Oh3QAE",
"Title" : "ACFrOgAo0rdnou-_D2OTEVtviwkLK1b55Mg78bUvplkr5y8KH90fT0ASyrI3aT2dDkZCAJFkWCrryWwZHdIE0uJUy7f0-6qUCOESOM4CfcgLKOZ6ovTEvLmE5-VEAew="
} ]
Step 7 :
--------
curl https://eu10.salesforce.com/services/data/v20.0/query?q=SELECT+Id+,+Main_Track__c+,+name+from+Cisco_FY__c -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
{
"totalSize" : 1,
"done" : true,
"records" : [ {
"attributes" : {
"type" : "Cisco_FY__c",
"url" : "/services/data/v20.0/sobjects/Cisco_FY__c/a060X00002XNYY1QAP"
},
"Id" : "a060X00002XNYY1QAP",
"Main_Track__c" : "RTB",
"Name" : "FY2018"
} ]
}
Step 8 :
--------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/Account/ -H "Authorization: Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "Content-Type: application/json" -d "@newaccount.json" -X POST -H "X-PrettyPrint:1"
{
"id" : "0010X00004DZMDJQA5",
"success" : true,
"errors" : [ ]
}
Step 9 :
========
Prepare the JSON data like the below :
{
"records": [
{
"attributes": {
"type": "Account",
"referenceId": "ref1"
},
"name": "SampleAccount1",
"phone": "1234567890",
"website": "www.salesforce.com",
"numberOfEmployees": "100",
"industry": "Banking",
"Contacts": {
"records": [
{
"attributes": {
"type": "Contact",
"referenceId": "ref2"
},
"lastname": "Smith",
"Title": "President",
"email": "sample@salesforce.com"
},
{
"attributes": {
"type": "Contact",
"referenceId": "ref3"
},
"lastname": "Evans",
"title": "Vice President",
"email": "sample@salesforce.com"
}
]
}
},
{
"attributes": {
"type": "Account",
"referenceId": "ref4"
},
"name": "SampleAccount2",
"phone": "1234567890",
"website": "www.salesforce.com",
"numberOfEmployees": "52000",
"industry": "Banking",
"childAccounts": {
"records": [
{
"attributes": {
"type": "Account",
"referenceId": "ref5"
},
"name": "SampleChildAccount1",
"phone": "1234567890",
"website": "www.salesforce.com",
"numberOfEmployees": "100",
"industry": "Banking"
}
]
},
"Contacts": {
"records": [
{
"attributes": {
"type": "Contact",
"referenceId": "ref6"
},
"lastname": "Jones",
"title": "President",
"email": "sample@salesforce.com"
}
]
}
}
]
}
Input :
=======
curl https://eu10.salesforce.com/services/data/v34.0/composite/tree/Account/ -H "Authorization: Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "Content-Type: application/json" -d "@newrecords.json" -X POST -H "X-PrettyPrint:1"
Output :
========
{
"hasErrors" : false,
"results" : [ {
"referenceId" : "ref1",
"id" : "0010X00004DZMDxQAP"
}, {
"referenceId" : "ref2",
"id" : "0010X00004DZMDyQAP"
}, {
"referenceId" : "ref3",
"id" : "0010X00004DZMDzQAP"
}, {
"referenceId" : "ref4",
"id" : "0010X00004DZME0QAP"
} ]
}
Step 10 : Getting the user complete information
---------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/User/0050X000007a0ZeQAI -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -X GET -H "X-PrettyPrint:1"
{
"attributes" : {
"type" : "User",
"url" : "/services/data/v20.0/sobjects/User/0050X000007a0ZeQAI"
},
"Id" : "0050X000007a0ZeQAI",
"Username" : "cisco.systems@yopmail.com",
"LastName" : "Systems",
"FirstName" : "Cisco",
"Name" : "Cisco Systems",
"CompanyName" : "Cisco",
"Division" : null,
"Department" : null,
"Title" : null,
"Street" : null,
"City" : null,
"State" : null,
"PostalCode" : null,
"Country" : "UM",
"Email" : "cisco.systems@yopmail.com",
"Phone" : null,
"Fax" : null,
"MobilePhone" : null,
"Alias" : "CSyst",
"CommunityNickname" : "cisco.systems",
"IsActive" : true,
"TimeZoneSidKey" : "Europe/Dublin",
"UserRoleId" : null,
"LocaleSidKey" : "en_IE_EURO",
"ReceivesInfoEmails" : false,
"ReceivesAdminInfoEmails" : true,
"EmailEncodingKey" : "ISO-8859-1",
"ProfileId" : "00e0X000001LevTQAS",
"UserType" : "Standard",
"LanguageLocaleKey" : "en_US",
"EmployeeNumber" : null,
"DelegatedApproverId" : null,
"ManagerId" : null,
"LastLoginDate" : "2018-07-28T06:03:03.000+0000",
"LastPasswordChangeDate" : "2018-07-02T14:30:44.000+0000",
"CreatedDate" : "2018-07-02T14:29:08.000+0000",
"CreatedById" : "0050X000007a0ZeQAI",
"LastModifiedDate" : "2018-07-28T08:33:49.000+0000",
"LastModifiedById" : "0050X000007a0ZeQAI",
"SystemModstamp" : "2018-07-28T08:33:50.000+0000",
"OfflineTrialExpirationDate" : null,
"OfflinePdaTrialExpirationDate" : null,
"UserPermissionsMarketingUser" : true,
"UserPermissionsOfflineUser" : true,
"UserPermissionsCallCenterAutoLogin" : false,
"UserPermissionsMobileUser" : false,
"UserPermissionsSFContentUser" : true,
"UserPermissionsKnowledgeUser" : false,
"UserPermissionsInteractionUser" : false,
"UserPermissionsSupportUser" : true,
"ForecastEnabled" : true,
"UserPreferencesActivityRemindersPopup" : true,
"UserPreferencesEventRemindersCheckboxDefault" : true,
"UserPreferencesTaskRemindersCheckboxDefault" : true,
"UserPreferencesReminderSoundOff" : false,
"UserPreferencesDisableAutoSubForFeeds" : false,
"UserPreferencesApexPagesDeveloperMode" : true,
"UserPreferencesHideCSNGetChatterMobileTask" : false,
"UserPreferencesHideCSNDesktopTask" : false,
"UserPreferencesSortFeedByComment" : false,
"UserPreferencesOptOutOfTouch" : false,
"UserPreferencesLightningExperiencePreferred" : false,
"ContactId" : null,
"AccountId" : null,
"CallCenterId" : null,
"Extension" : null,
"FederationIdentifier" : null,
"AboutMe" : null,
"CurrentStatus" : null,
"FullPhotoUrl" : "https://c.eu10.content.force.com/profilephoto/7290X000000srob/F",
"SmallPhotoUrl" : "https://c.eu10.content.force.com/profilephoto/7290X000000srob/T",
"DigestFrequency" : "D",
"Clone_Admin__c" : false
}
Step 11 :
=========
curl https://eu10.salesforce.com/services/data/ -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -X GET -H "X-PrettyPrint:1"
[ {
"label" : "Winter '11",
"url" : "/services/data/v20.0",
"version" : "20.0"
}, {
"label" : "Spring '11",
"url" : "/services/data/v21.0",
"version" : "21.0"
}, {
"label" : "Summer '11",
"url" : "/services/data/v22.0",
"version" : "22.0"
}, {
"label" : "Winter '12",
"url" : "/services/data/v23.0",
"version" : "23.0"
}, {
"label" : "Spring '12",
"url" : "/services/data/v24.0",
"version" : "24.0"
}, {
"label" : "Summer '12",
"url" : "/services/data/v25.0",
"version" : "25.0"
}, {
"label" : "Winter '13",
"url" : "/services/data/v26.0",
"version" : "26.0"
}, {
"label" : "Spring '13",
"url" : "/services/data/v27.0",
"version" : "27.0"
}, {
"label" : "Summer '13",
"url" : "/services/data/v28.0",
"version" : "28.0"
}, {
"label" : "Winter '14",
"url" : "/services/data/v29.0",
"version" : "29.0"
}, {
"label" : "Spring '14",
"url" : "/services/data/v30.0",
"version" : "30.0"
}, {
"label" : "Summer '14",
"url" : "/services/data/v31.0",
"version" : "31.0"
}, {
"label" : "Winter '15",
"url" : "/services/data/v32.0",
"version" : "32.0"
}, {
"label" : "Spring '15",
"url" : "/services/data/v33.0",
"version" : "33.0"
}, {
"label" : "Summer '15",
"url" : "/services/data/v34.0",
"version" : "34.0"
}, {
"label" : "Winter '16",
"url" : "/services/data/v35.0",
"version" : "35.0"
}, {
"label" : "Spring '16",
"url" : "/services/data/v36.0",
"version" : "36.0"
}, {
"label" : "Summer '16",
"url" : "/services/data/v37.0",
"version" : "37.0"
}, {
"label" : "Winter '17",
"url" : "/services/data/v38.0",
"version" : "38.0"
}, {
"label" : "Spring '17",
"url" : "/services/data/v39.0",
"version" : "39.0"
}, {
"label" : "Summer '17",
"url" : "/services/data/v40.0",
"version" : "40.0"
}, {
"label" : "Winter '18",
"url" : "/services/data/v41.0",
"version" : "41.0"
}, {
"label" : "Spring ΓÇÖ18",
"url" : "/services/data/v42.0",
"version" : "42.0"
}, {
"label" : "Summer '18",
"url" : "/services/data/v43.0",
"version" : "43.0"
} ]
Step 12 :
=========
curl https://eu10.salesforce.com/services/data/v43.0 -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -X GET -H "X-PrettyPrint:1"
{
"tooling" : "/services/data/v43.0/tooling",
"metadata" : "/services/data/v43.0/metadata",
"folders" : "/services/data/v43.0/folders",
"eclair" : "/services/data/v43.0/eclair",
"prechatForms" : "/services/data/v43.0/prechatForms",
"chatter" : "/services/data/v43.0/chatter",
"tabs" : "/services/data/v43.0/tabs",
"appMenu" : "/services/data/v43.0/appMenu",
"quickActions" : "/services/data/v43.0/quickActions",
"queryAll" : "/services/data/v43.0/queryAll",
"commerce" : "/services/data/v43.0/commerce",
"wave" : "/services/data/v43.0/wave",
"iot" : "/services/data/v43.0/iot",
"analytics" : "/services/data/v43.0/analytics",
"search" : "/services/data/v43.0/search",
"identity" : "https://login.salesforce.com/id/00D0X000000uTD0UAM/0050X000007a0ZeQAI",
"composite" : "/services/data/v43.0/composite",
"parameterizedSearch" : "/services/data/v43.0/parameterizedSearch",
"fingerprint" : "/services/data/v43.0/fingerprint",
"theme" : "/services/data/v43.0/theme",
"nouns" : "/services/data/v43.0/nouns",
"event" : "/services/data/v43.0/event",
"serviceTemplates" : "/services/data/v43.0/serviceTemplates",
"recent" : "/services/data/v43.0/recent",
"connect" : "/services/data/v43.0/connect",
"licensing" : "/services/data/v43.0/licensing",
"limits" : "/services/data/v43.0/limits",
"process" : "/services/data/v43.0/process",
"async-queries" : "/services/data/v43.0/async-queries",
"dedupe" : "/services/data/v43.0/dedupe",
"query" : "/services/data/v43.0/query",
"jobs" : "/services/data/v43.0/jobs",
"match" : "/services/data/v43.0/match",
"emailConnect" : "/services/data/v43.0/emailConnect",
"compactLayouts" : "/services/data/v43.0/compactLayouts",
"knowledgeManagement" : "/services/data/v43.0/knowledgeManagement",
"sobjects" : "/services/data/v43.0/sobjects",
"actions" : "/services/data/v43.0/actions",
"support" : "/services/data/v43.0/support"
}
Input :
--------
curl https://eu10.salesforce.com/services/oauth2/token -d "grant_type=password" -d "client_id=3MVG9mIli7ewofGu2Fey6P0EzbHrEZ5QW7IfZGGs6XOpO8AA3tMPg647IVo5jWNEiQduBdQTxRG.KAMSlYvIW" -d "client_secret=6367330749412135519" -d "username=cisco.systems%40yopmail.com" -d "password=Rishan786%25" -X POST -H "X-PrettyPrint:1"
Output :
========
{
"access_token" : "00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa",
"instance_url" : "https://eu10.salesforce.com",
"id" : "https://login.salesforce.com/id/00D0X000000uTD0UAM/0050X000007a0ZeQAI",
"token_type" : "Bearer",
"issued_at" : "1532774651728",
"signature" : "ejZ1kpsoqlPP1yAL4Mvs62yC73X3QN+Wc6xn3PZqb5o="
}
Step2 : Getting organization objects information
Input :
-------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/ -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
Output :
--------
{
"encoding" : "UTF-8",
"maxBatchSize" : 200,
"sobjects" : [ {
"activateable" : false,
"createable" : false,
"custom" : false,
"customSetting" : false,
"deletable" : false,
"deprecatedAndHidden" : false,
"feedEnabled" : false,
"keyPrefix" : null,
"label" : "History: ACC_ATTRIBUTE",
"labelPlural" : "History: ACC_ATTRIBUTE",
"layoutable" : false,
"mergeable" : false,
"name" : "ACC_ATTRIBUTES__History",
"queryable" : true,
"replicateable" : true,
"retrieveable" : true,
"searchable" : false,
"triggerable" : false,
"undeletable" : false,
"updateable" : false,
"urls" : {
"rowTemplate" : "/services/data/v20.0/sobjects/ACC_ATTRIBUTES__History/{ID}",
"describe" : "/services/data/v20.0/sobjects/ACC_ATTRIBUTES__History/describe",
"sobject" : "/services/data/v20.0/sobjects/ACC_ATTRIBUTES__History"
}
}
}
Step3 :
-------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/Account -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
{
"objectDescribe" : {
"activateable" : false,
"createable" : true,
"custom" : false,
"customSetting" : false,
"deletable" : true,
"deprecatedAndHidden" : false,
"feedEnabled" : true,
"keyPrefix" : "001",
"label" : "Account",
"labelPlural" : "Accounts",
"layoutable" : true,
"mergeable" : true,
"name" : "Account",
"queryable" : true,
"replicateable" : true,
"retrieveable" : true,
"searchable" : true,
"triggerable" : true,
"undeletable" : true,
"updateable" : true,
"urls" : {
"rowTemplate" : "/services/data/v20.0/sobjects/Account/{ID}",
"describe" : "/services/data/v20.0/sobjects/Account/describe",
"sobject" : "/services/data/v20.0/sobjects/Account"
}
},
"recentItems" : [ ]
}
Step4 :
-------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/Cisco_FY__c/describe -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
{
"activateable" : false,
"childRelationships" : [ {
"cascadeDelete" : true,
"childSObject" : "Attachment",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : "Attachments"
}, {
"cascadeDelete" : true,
"childSObject" : "Cisco_Team__c",
"deprecatedAndHidden" : false,
"field" : "Cisco_FY__c",
"relationshipName" : "Tracks__r"
}, {
"cascadeDelete" : false,
"childSObject" : "ContentVersion",
"deprecatedAndHidden" : false,
"field" : "FirstPublishLocationId",
"relationshipName" : null
}, {
"cascadeDelete" : true,
"childSObject" : "EntitySubscription",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : "FeedSubscriptionsForEntity"
}, {
"cascadeDelete" : false,
"childSObject" : "FeedComment",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : null
}, {
"cascadeDelete" : true,
"childSObject" : "FeedPost",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : null
}, {
"cascadeDelete" : true,
"childSObject" : "NewsFeed",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : null
}, {
"cascadeDelete" : true,
"childSObject" : "Note",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : "Notes"
}, {
"cascadeDelete" : true,
"childSObject" : "NoteAndAttachment",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : "NotesAndAttachments"
}, {
"cascadeDelete" : true,
"childSObject" : "ProcessInstance",
"deprecatedAndHidden" : false,
"field" : "TargetObjectId",
"relationshipName" : "ProcessInstances"
}, {
"cascadeDelete" : false,
"childSObject" : "ProcessInstanceHistory",
"deprecatedAndHidden" : false,
"field" : "TargetObjectId",
"relationshipName" : "ProcessSteps"
}, {
"cascadeDelete" : true,
"childSObject" : "UserProfileFeed",
"deprecatedAndHidden" : false,
"field" : "ParentId",
"relationshipName" : null
} ],
"createable" : true,
"custom" : true,
"customSetting" : false,
"deletable" : true,
"deprecatedAndHidden" : false,
"feedEnabled" : false,
"fields" : [ {
"autoNumber" : false,
"byteLength" : 18,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : true,
"inlineHelpText" : null,
"label" : "Record ID",
"length" : 18,
"name" : "Id",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "tns:ID",
"sortable" : true,
"type" : "id",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 18,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : true,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Owner ID",
"length" : 18,
"name" : "OwnerId",
"nameField" : false,
"namePointing" : true,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ "Group", "User" ],
"relationshipName" : "Owner",
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "tns:ID",
"sortable" : true,
"type" : "reference",
"unique" : false,
"updateable" : true,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 0,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Deleted",
"length" : 0,
"name" : "IsDeleted",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:boolean",
"sortable" : true,
"type" : "boolean",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 240,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : true,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : true,
"inlineHelpText" : null,
"label" : "FY Name",
"length" : 80,
"name" : "Name",
"nameField" : true,
"namePointing" : false,
"nillable" : true,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:string",
"sortable" : true,
"type" : "string",
"unique" : false,
"updateable" : true,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 0,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : false,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Created Date",
"length" : 0,
"name" : "CreatedDate",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:dateTime",
"sortable" : true,
"type" : "datetime",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 18,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Created By ID",
"length" : 18,
"name" : "CreatedById",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ "User" ],
"relationshipName" : "CreatedBy",
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "tns:ID",
"sortable" : true,
"type" : "reference",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 0,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : false,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Last Modified Date",
"length" : 0,
"name" : "LastModifiedDate",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:dateTime",
"sortable" : true,
"type" : "datetime",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 18,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Last Modified By ID",
"length" : 18,
"name" : "LastModifiedById",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ "User" ],
"relationshipName" : "LastModifiedBy",
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "tns:ID",
"sortable" : true,
"type" : "reference",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 0,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : false,
"custom" : false,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : true,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : false,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "System Modstamp",
"length" : 0,
"name" : "SystemModstamp",
"nameField" : false,
"namePointing" : false,
"nillable" : false,
"picklistValues" : [ ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : false,
"scale" : 0,
"soapType" : "xsd:dateTime",
"sortable" : true,
"type" : "datetime",
"unique" : false,
"updateable" : false,
"writeRequiresMasterRead" : false
}, {
"autoNumber" : false,
"byteLength" : 765,
"calculated" : false,
"calculatedFormula" : null,
"caseSensitive" : false,
"controllerName" : null,
"createable" : true,
"custom" : true,
"defaultValue" : null,
"defaultValueFormula" : null,
"defaultedOnCreate" : false,
"dependentPicklist" : false,
"deprecatedAndHidden" : false,
"digits" : 0,
"externalId" : false,
"filterable" : true,
"groupable" : true,
"htmlFormatted" : false,
"idLookup" : false,
"inlineHelpText" : null,
"label" : "Main Track",
"length" : 255,
"name" : "Main_Track__c",
"nameField" : false,
"namePointing" : false,
"nillable" : true,
"picklistValues" : [ {
"active" : true,
"defaultValue" : true,
"label" : "RTB",
"validFor" : null,
"value" : "RTB"
} ],
"precision" : 0,
"referenceTo" : [ ],
"relationshipName" : null,
"relationshipOrder" : null,
"restrictedPicklist" : true,
"scale" : 0,
"soapType" : "xsd:string",
"sortable" : true,
"type" : "picklist",
"unique" : false,
"updateable" : true,
"writeRequiresMasterRead" : false
} ],
"keyPrefix" : "a06",
"label" : "Cisco FY",
"labelPlural" : "Cisco FY",
"layoutable" : true,
"listviewable" : null,
"lookupLayoutable" : null,
"mergeable" : false,
"name" : "Cisco_FY__c",
"queryable" : true,
"recordTypeInfos" : [ {
"available" : true,
"defaultRecordTypeMapping" : true,
"name" : "Master",
"recordTypeId" : "012000000000000AAA"
} ],
"replicateable" : true,
"retrieveable" : true,
"searchLayoutable" : null,
"searchable" : true,
"triggerable" : true,
"undeletable" : true,
"updateable" : true,
"urls" : {
"rowTemplate" : "/services/data/v20.0/sobjects/Cisco_FY__c/{ID}",
"uiDetailTemplate" : "https://eu10.salesforce.com/{ID}",
"uiEditTemplate" : "https://eu10.salesforce.com/{ID}/e",
"describe" : "/services/data/v20.0/sobjects/Cisco_FY__c/describe",
"uiNewRecord" : "https://eu10.salesforce.com/a06/e",
"sobject" : "/services/data/v20.0/sobjects/Cisco_FY__c"
}
}
Step5 :
-------
curl https://eu10.salesforce.com/services/data/v20.0/query?q=SELECT+name+from+Cisco_FY__c -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
{
"totalSize" : 1,
"done" : true,
"records" : [ {
"attributes" : {
"type" : "Cisco_FY__c",
"url" : "/services/data/v20.0/sobjects/Cisco_FY__c/a060X00002XNYY1QAP"
},
"Name" : "FY2018"
} ]
}
Step6 :
-------
curl https://eu10.salesforce.com/services/data/v28.0/recent/ -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
[ {
"attributes" : {
"type" : "Cisco_Team__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Team__c/a070X00001FTP8LQAX"
},
"Id" : "a070X00001FTP8LQAX",
"Name" : "Marketing"
}, {
"attributes" : {
"type" : "Cisco_Track_Leads__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Track_Leads__c/a0H0X00001OWD3IUAX"
},
"Id" : "a0H0X00001OWD3IUAX",
"Name" : "Abhishek"
}, {
"attributes" : {
"type" : "Cisco_Quarter_Details__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Quarter_Details__c/a080X00005EfMXxQAN"
},
"Id" : "a080X00005EfMXxQAN",
"Name" : "Q1"
}, {
"attributes" : {
"type" : "Cisco_FY__c",
"url" : "/services/data/v28.0/sobjects/Cisco_FY__c/a060X00002XNYY1QAP"
},
"Id" : "a060X00002XNYY1QAP",
"Name" : "FY2018"
}, {
"attributes" : {
"type" : "Cisco_User__c",
"url" : "/services/data/v28.0/sobjects/Cisco_User__c/a0E0X00002UAtI5UAL"
},
"Id" : "a0E0X00002UAtI5UAL",
"Name" : "Fazurulla Ganganapalli"
}, {
"attributes" : {
"type" : "Cisco_User_Session__c",
"url" : "/services/data/v28.0/sobjects/Cisco_User_Session__c/a0F0X00000cu6BIUAY"
},
"Id" : "a0F0X00000cu6BIUAY",
"Name" : "0000"
}, {
"attributes" : {
"type" : "Cisco_Appllications__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Appllications__c/a0C0X00000qGQ0DUAW"
},
"Id" : "a0C0X00000qGQ0DUAW",
"Name" : "NGCC"
}, {
"attributes" : {
"type" : "Cisco_Quarter_Details__c",
"url" : "/services/data/v28.0/sobjects/Cisco_Quarter_Details__c/a080X00005EfMY2QAN"
},
"Id" : "a080X00005EfMY2QAN",
"Name" : "Q2"
}, {
"attributes" : {
"type" : "Contact",
"url" : "/services/data/v28.0/sobjects/Contact/0030X00002CWDfMQAX"
},
"Id" : "0030X00002CWDfMQAX",
"Name" : "Andy faz Young"
}, {
"attributes" : {
"type" : "ContentDocument",
"url" : "/services/data/v28.0/sobjects/ContentDocument/0690X0000060Oh3QAE"
},
"Id" : "0690X0000060Oh3QAE",
"Title" : "ACFrOgAo0rdnou-_D2OTEVtviwkLK1b55Mg78bUvplkr5y8KH90fT0ASyrI3aT2dDkZCAJFkWCrryWwZHdIE0uJUy7f0-6qUCOESOM4CfcgLKOZ6ovTEvLmE5-VEAew="
} ]
Step 7 :
--------
curl https://eu10.salesforce.com/services/data/v20.0/query?q=SELECT+Id+,+Main_Track__c+,+name+from+Cisco_FY__c -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "X-PrettyPrint:1"
{
"totalSize" : 1,
"done" : true,
"records" : [ {
"attributes" : {
"type" : "Cisco_FY__c",
"url" : "/services/data/v20.0/sobjects/Cisco_FY__c/a060X00002XNYY1QAP"
},
"Id" : "a060X00002XNYY1QAP",
"Main_Track__c" : "RTB",
"Name" : "FY2018"
} ]
}
Step 8 :
--------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/Account/ -H "Authorization: Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "Content-Type: application/json" -d "@newaccount.json" -X POST -H "X-PrettyPrint:1"
{
"id" : "0010X00004DZMDJQA5",
"success" : true,
"errors" : [ ]
}
Step 9 :
========
Prepare the JSON data like the below :
{
"records": [
{
"attributes": {
"type": "Account",
"referenceId": "ref1"
},
"name": "SampleAccount1",
"phone": "1234567890",
"website": "www.salesforce.com",
"numberOfEmployees": "100",
"industry": "Banking",
"Contacts": {
"records": [
{
"attributes": {
"type": "Contact",
"referenceId": "ref2"
},
"lastname": "Smith",
"Title": "President",
"email": "sample@salesforce.com"
},
{
"attributes": {
"type": "Contact",
"referenceId": "ref3"
},
"lastname": "Evans",
"title": "Vice President",
"email": "sample@salesforce.com"
}
]
}
},
{
"attributes": {
"type": "Account",
"referenceId": "ref4"
},
"name": "SampleAccount2",
"phone": "1234567890",
"website": "www.salesforce.com",
"numberOfEmployees": "52000",
"industry": "Banking",
"childAccounts": {
"records": [
{
"attributes": {
"type": "Account",
"referenceId": "ref5"
},
"name": "SampleChildAccount1",
"phone": "1234567890",
"website": "www.salesforce.com",
"numberOfEmployees": "100",
"industry": "Banking"
}
]
},
"Contacts": {
"records": [
{
"attributes": {
"type": "Contact",
"referenceId": "ref6"
},
"lastname": "Jones",
"title": "President",
"email": "sample@salesforce.com"
}
]
}
}
]
}
Input :
=======
curl https://eu10.salesforce.com/services/data/v34.0/composite/tree/Account/ -H "Authorization: Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -H "Content-Type: application/json" -d "@newrecords.json" -X POST -H "X-PrettyPrint:1"
Output :
========
{
"hasErrors" : false,
"results" : [ {
"referenceId" : "ref1",
"id" : "0010X00004DZMDxQAP"
}, {
"referenceId" : "ref2",
"id" : "0010X00004DZMDyQAP"
}, {
"referenceId" : "ref3",
"id" : "0010X00004DZMDzQAP"
}, {
"referenceId" : "ref4",
"id" : "0010X00004DZME0QAP"
} ]
}
Step 10 : Getting the user complete information
---------
curl https://eu10.salesforce.com/services/data/v20.0/sobjects/User/0050X000007a0ZeQAI -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -X GET -H "X-PrettyPrint:1"
{
"attributes" : {
"type" : "User",
"url" : "/services/data/v20.0/sobjects/User/0050X000007a0ZeQAI"
},
"Id" : "0050X000007a0ZeQAI",
"Username" : "cisco.systems@yopmail.com",
"LastName" : "Systems",
"FirstName" : "Cisco",
"Name" : "Cisco Systems",
"CompanyName" : "Cisco",
"Division" : null,
"Department" : null,
"Title" : null,
"Street" : null,
"City" : null,
"State" : null,
"PostalCode" : null,
"Country" : "UM",
"Email" : "cisco.systems@yopmail.com",
"Phone" : null,
"Fax" : null,
"MobilePhone" : null,
"Alias" : "CSyst",
"CommunityNickname" : "cisco.systems",
"IsActive" : true,
"TimeZoneSidKey" : "Europe/Dublin",
"UserRoleId" : null,
"LocaleSidKey" : "en_IE_EURO",
"ReceivesInfoEmails" : false,
"ReceivesAdminInfoEmails" : true,
"EmailEncodingKey" : "ISO-8859-1",
"ProfileId" : "00e0X000001LevTQAS",
"UserType" : "Standard",
"LanguageLocaleKey" : "en_US",
"EmployeeNumber" : null,
"DelegatedApproverId" : null,
"ManagerId" : null,
"LastLoginDate" : "2018-07-28T06:03:03.000+0000",
"LastPasswordChangeDate" : "2018-07-02T14:30:44.000+0000",
"CreatedDate" : "2018-07-02T14:29:08.000+0000",
"CreatedById" : "0050X000007a0ZeQAI",
"LastModifiedDate" : "2018-07-28T08:33:49.000+0000",
"LastModifiedById" : "0050X000007a0ZeQAI",
"SystemModstamp" : "2018-07-28T08:33:50.000+0000",
"OfflineTrialExpirationDate" : null,
"OfflinePdaTrialExpirationDate" : null,
"UserPermissionsMarketingUser" : true,
"UserPermissionsOfflineUser" : true,
"UserPermissionsCallCenterAutoLogin" : false,
"UserPermissionsMobileUser" : false,
"UserPermissionsSFContentUser" : true,
"UserPermissionsKnowledgeUser" : false,
"UserPermissionsInteractionUser" : false,
"UserPermissionsSupportUser" : true,
"ForecastEnabled" : true,
"UserPreferencesActivityRemindersPopup" : true,
"UserPreferencesEventRemindersCheckboxDefault" : true,
"UserPreferencesTaskRemindersCheckboxDefault" : true,
"UserPreferencesReminderSoundOff" : false,
"UserPreferencesDisableAutoSubForFeeds" : false,
"UserPreferencesApexPagesDeveloperMode" : true,
"UserPreferencesHideCSNGetChatterMobileTask" : false,
"UserPreferencesHideCSNDesktopTask" : false,
"UserPreferencesSortFeedByComment" : false,
"UserPreferencesOptOutOfTouch" : false,
"UserPreferencesLightningExperiencePreferred" : false,
"ContactId" : null,
"AccountId" : null,
"CallCenterId" : null,
"Extension" : null,
"FederationIdentifier" : null,
"AboutMe" : null,
"CurrentStatus" : null,
"FullPhotoUrl" : "https://c.eu10.content.force.com/profilephoto/7290X000000srob/F",
"SmallPhotoUrl" : "https://c.eu10.content.force.com/profilephoto/7290X000000srob/T",
"DigestFrequency" : "D",
"Clone_Admin__c" : false
}
Step 11 :
=========
curl https://eu10.salesforce.com/services/data/ -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -X GET -H "X-PrettyPrint:1"
[ {
"label" : "Winter '11",
"url" : "/services/data/v20.0",
"version" : "20.0"
}, {
"label" : "Spring '11",
"url" : "/services/data/v21.0",
"version" : "21.0"
}, {
"label" : "Summer '11",
"url" : "/services/data/v22.0",
"version" : "22.0"
}, {
"label" : "Winter '12",
"url" : "/services/data/v23.0",
"version" : "23.0"
}, {
"label" : "Spring '12",
"url" : "/services/data/v24.0",
"version" : "24.0"
}, {
"label" : "Summer '12",
"url" : "/services/data/v25.0",
"version" : "25.0"
}, {
"label" : "Winter '13",
"url" : "/services/data/v26.0",
"version" : "26.0"
}, {
"label" : "Spring '13",
"url" : "/services/data/v27.0",
"version" : "27.0"
}, {
"label" : "Summer '13",
"url" : "/services/data/v28.0",
"version" : "28.0"
}, {
"label" : "Winter '14",
"url" : "/services/data/v29.0",
"version" : "29.0"
}, {
"label" : "Spring '14",
"url" : "/services/data/v30.0",
"version" : "30.0"
}, {
"label" : "Summer '14",
"url" : "/services/data/v31.0",
"version" : "31.0"
}, {
"label" : "Winter '15",
"url" : "/services/data/v32.0",
"version" : "32.0"
}, {
"label" : "Spring '15",
"url" : "/services/data/v33.0",
"version" : "33.0"
}, {
"label" : "Summer '15",
"url" : "/services/data/v34.0",
"version" : "34.0"
}, {
"label" : "Winter '16",
"url" : "/services/data/v35.0",
"version" : "35.0"
}, {
"label" : "Spring '16",
"url" : "/services/data/v36.0",
"version" : "36.0"
}, {
"label" : "Summer '16",
"url" : "/services/data/v37.0",
"version" : "37.0"
}, {
"label" : "Winter '17",
"url" : "/services/data/v38.0",
"version" : "38.0"
}, {
"label" : "Spring '17",
"url" : "/services/data/v39.0",
"version" : "39.0"
}, {
"label" : "Summer '17",
"url" : "/services/data/v40.0",
"version" : "40.0"
}, {
"label" : "Winter '18",
"url" : "/services/data/v41.0",
"version" : "41.0"
}, {
"label" : "Spring ΓÇÖ18",
"url" : "/services/data/v42.0",
"version" : "42.0"
}, {
"label" : "Summer '18",
"url" : "/services/data/v43.0",
"version" : "43.0"
} ]
Step 12 :
=========
curl https://eu10.salesforce.com/services/data/v43.0 -H "Authorization:Bearer 00D0X000000uTD0!AQwAQCkbfDBhPM0gDej6hlPQGz6PROmeye0SOaFKnMl6iZmqpvraRPokhDoMN1eHIguvF3lqjkOeko_Te8Dvbj9pnbHf7HAa" -X GET -H "X-PrettyPrint:1"
{
"tooling" : "/services/data/v43.0/tooling",
"metadata" : "/services/data/v43.0/metadata",
"folders" : "/services/data/v43.0/folders",
"eclair" : "/services/data/v43.0/eclair",
"prechatForms" : "/services/data/v43.0/prechatForms",
"chatter" : "/services/data/v43.0/chatter",
"tabs" : "/services/data/v43.0/tabs",
"appMenu" : "/services/data/v43.0/appMenu",
"quickActions" : "/services/data/v43.0/quickActions",
"queryAll" : "/services/data/v43.0/queryAll",
"commerce" : "/services/data/v43.0/commerce",
"wave" : "/services/data/v43.0/wave",
"iot" : "/services/data/v43.0/iot",
"analytics" : "/services/data/v43.0/analytics",
"search" : "/services/data/v43.0/search",
"identity" : "https://login.salesforce.com/id/00D0X000000uTD0UAM/0050X000007a0ZeQAI",
"composite" : "/services/data/v43.0/composite",
"parameterizedSearch" : "/services/data/v43.0/parameterizedSearch",
"fingerprint" : "/services/data/v43.0/fingerprint",
"theme" : "/services/data/v43.0/theme",
"nouns" : "/services/data/v43.0/nouns",
"event" : "/services/data/v43.0/event",
"serviceTemplates" : "/services/data/v43.0/serviceTemplates",
"recent" : "/services/data/v43.0/recent",
"connect" : "/services/data/v43.0/connect",
"licensing" : "/services/data/v43.0/licensing",
"limits" : "/services/data/v43.0/limits",
"process" : "/services/data/v43.0/process",
"async-queries" : "/services/data/v43.0/async-queries",
"dedupe" : "/services/data/v43.0/dedupe",
"query" : "/services/data/v43.0/query",
"jobs" : "/services/data/v43.0/jobs",
"match" : "/services/data/v43.0/match",
"emailConnect" : "/services/data/v43.0/emailConnect",
"compactLayouts" : "/services/data/v43.0/compactLayouts",
"knowledgeManagement" : "/services/data/v43.0/knowledgeManagement",
"sobjects" : "/services/data/v43.0/sobjects",
"actions" : "/services/data/v43.0/actions",
"support" : "/services/data/v43.0/support"
}
