Back to Collection Items
Use ChilkatAx-win32.pkg
Procedure Test
Handle hoHttp
Boolean iSuccess
Handle hoJson
Variant vSbRequestBody
Handle hoSbRequestBody
Variant vResp
Handle hoResp
Variant vSbResponseBody
Handle hoSbResponseBody
Handle hoJResp
Integer iRespStatusCode
String sApiName
String sETag
String sDisplayValue
String sValue
String sActive__cDisplayValue
String sActive__cValue
String sAnnualRevenueDisplayValue
String sAnnualRevenueValue
String sBillingCityDisplayValue
String sBillingCityValue
String sBillingCountryDisplayValue
String sBillingCountryValue
String sBillingPostalCodeDisplayValue
String sBillingPostalCodeValue
String sBillingStateDisplayValue
String sBillingStateValue
String sBillingStreetDisplayValue
String sBillingStreetValue
String sCreatedByDisplayValue
String sApiName
String sETag
String sIdDisplayValue
String sIdValue
String sNameDisplayValue
String sNameValue
String sId
String sLastModifiedById
String sLastModifiedDate
String sRecordTypeId
String sRecordTypeInfo
String sSystemModstamp
Integer iWeakEtag
String sCreatedByIdDisplayValue
String sCreatedByIdValue
String sCreatedDateDisplayValue
String sCreatedDateValue
String sCustomerPriority__cDisplayValue
String sCustomerPriority__cValue
String sDescriptionDisplayValue
String sDescriptionValue
String sFaxDisplayValue
String sFaxValue
String sIndustryDisplayValue
String sIndustryValue
String sLastModifiedByDisplayValue
String sValueApiName
String sValueETag
String sValueId
String sValueLastModifiedById
String sValueLastModifiedDate
String sValueRecordTypeId
String sValueRecordTypeInfo
String sValueSystemModstamp
Integer iValueWeakEtag
String sLastModifiedByIdDisplayValue
String sLastModifiedByIdValue
String sLastModifiedDateDisplayValue
String sLastModifiedDateValue
String sNumberOfEmployeesDisplayValue
String sNumberOfEmployeesValue
String sNumberofLocations__cDisplayValue
String sNumberofLocations__cValue
String sOwnerDisplayValue
String sOwnerIdDisplayValue
String sOwnerIdValue
String sOwnershipDisplayValue
String sOwnershipValue
String sParentDisplayValue
String sParentValue
String sParentIdDisplayValue
String sParentIdValue
String sPhoneDisplayValue
String sPhoneValue
String sRatingDisplayValue
String sRatingValue
String sSLAExpirationDate__cDisplayValue
String sSLAExpirationDate__cValue
String sSLASerialNumber__cDisplayValue
String sSLASerialNumber__cValue
String sSLA__cDisplayValue
String sSLA__cValue
String sShippingCityDisplayValue
String sShippingCityValue
String sShippingCountryDisplayValue
String sShippingCountryValue
String sShippingPostalCodeDisplayValue
String sShippingPostalCodeValue
String sShippingStateDisplayValue
String sShippingStateValue
String sShippingStreetDisplayValue
String sShippingStreetValue
String sSicDisplayValue
String sSicValue
String sSiteDisplayValue
String sSiteValue
String sTickerSymbolDisplayValue
String sTickerSymbolValue
String sTypeDisplayValue
String sTypeValue
String sUpsellOpportunity__cDisplayValue
String sUpsellOpportunity__cValue
String sWebsiteDisplayValue
String sWebsiteValue
String sId
String sLastModifiedById
String sLastModifiedDate
String sRecordTypeId
String sRecordTypeInfo
String sSystemModstamp
Integer iWeakEtag
String sTemp1
Boolean bTemp1
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Get Create (RefClass(cComChilkatHttp)) To hoHttp
If (Not(IsComObjectCreated(hoHttp))) Begin
Send CreateComObject of hoHttp
End
// Use this online tool to generate code from sample JSON: Generate Code to Create JSON
// The following JSON is sent in the request body.
// {
// "allowSaveOnDuplicate": false,
// "fields": {
// "FieldAPIName": "FieldValue"
// }
// }
Get Create (RefClass(cComChilkatJsonObject)) To hoJson
If (Not(IsComObjectCreated(hoJson))) Begin
Send CreateComObject of hoJson
End
Get ComUpdateBool Of hoJson "allowSaveOnDuplicate" False To iSuccess
Get ComUpdateString Of hoJson "fields.FieldAPIName" "FieldValue" To iSuccess
// Adds the "Authorization: Bearer <access_token>" header.
Set ComAuthToken Of hoHttp To "<access_token>"
Send ComSetRequestHeader To hoHttp "Content-Type" "application/json"
Get Create (RefClass(cComChilkatStringBuilder)) To hoSbRequestBody
If (Not(IsComObjectCreated(hoSbRequestBody))) Begin
Send CreateComObject of hoSbRequestBody
End
Get pvComObject of hoSbRequestBody to vSbRequestBody
Get ComEmitSb Of hoJson vSbRequestBody To iSuccess
Get pvComObject of hoSbRequestBody to vSbRequestBody
Get ComPTextSb Of hoHttp "PATCH" "https://domain.com/services/data/v{{version}}/ui-api/records/:RECORD_ID" vSbRequestBody "utf-8" "application/json" False False To vResp
If (IsComObject(vResp)) Begin
Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
Set pvComObject Of hoResp To vResp
End
Get ComLastMethodSuccess Of hoHttp To bTemp1
If (bTemp1 = False) Begin
Get ComLastErrorText Of hoHttp To sTemp1
Showln sTemp1
Procedure_Return
End
Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
Send CreateComObject of hoSbResponseBody
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComGetBodySb Of hoResp vSbResponseBody To iSuccess
Get Create (RefClass(cComChilkatJsonObject)) To hoJResp
If (Not(IsComObjectCreated(hoJResp))) Begin
Send CreateComObject of hoJResp
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComLoadSb Of hoJResp vSbResponseBody To iSuccess
Set ComEmitCompact Of hoJResp To False
Showln "Response Body:"
Get ComEmit Of hoJResp To sTemp1
Showln sTemp1
Get ComStatusCode Of hoResp To iRespStatusCode
Showln "Response Status Code = " iRespStatusCode
If (iRespStatusCode >= 400) Begin
Showln "Response Header:"
Get ComHeader Of hoResp To sTemp1
Showln sTemp1
Showln "Failed."
Send Destroy of hoResp
Procedure_Return
End
Send Destroy of hoResp
// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)
// {
// "apiName": "Account",
// "childRelationships": {},
// "eTag": "1be6f040e46732e79a0999d6fea9fe7d",
// "fields": {
// "AccountNumber": {
// "displayValue": null,
// "value": null
// },
// "Active__c": {
// "displayValue": null,
// "value": null
// },
// "AnnualRevenue": {
// "displayValue": null,
// "value": null
// },
// "BillingCity": {
// "displayValue": null,
// "value": null
// },
// "BillingCountry": {
// "displayValue": null,
// "value": null
// },
// "BillingPostalCode": {
// "displayValue": null,
// "value": null
// },
// "BillingState": {
// "displayValue": null,
// "value": null
// },
// "BillingStreet": {
// "displayValue": null,
// "value": null
// },
// "CreatedBy": {
// "displayValue": "Philippe Ozil",
// "value": {
// "apiName": "User",
// "childRelationships": {},
// "eTag": "cc07f7ef1b08ddbd75074c69512dd388",
// "fields": {
// "Id": {
// "displayValue": null,
// "value": "005B0000003TOI6IAO"
// },
// "Name": {
// "displayValue": null,
// "value": "Philippe Ozil"
// }
// },
// "id": "005B0000003TOI6IAO",
// "lastModifiedById": "005B0000003TOI6IAO",
// "lastModifiedDate": "2023-02-02T10:32:12.000Z",
// "recordTypeId": null,
// "recordTypeInfo": null,
// "systemModstamp": "2023-09-27T15:47:51.000Z",
// "weakEtag": 1695829671000
// }
// },
// "CreatedById": {
// "displayValue": null,
// "value": "005B0000003TOI6IAO"
// },
// "CreatedDate": {
// "displayValue": "27/09/2023 18:01",
// "value": "2023-09-27T16:01:14.000Z"
// },
// "CustomerPriority__c": {
// "displayValue": null,
// "value": null
// },
// "Description": {
// "displayValue": null,
// "value": null
// },
// "Fax": {
// "displayValue": null,
// "value": null
// },
// "Industry": {
// "displayValue": null,
// "value": null
// },
// "LastModifiedBy": {
// "displayValue": "Philippe Ozil",
// "value": {
// "apiName": "User",
// "childRelationships": {},
// "eTag": "cc07f7ef1b08ddbd75074c69512dd388",
// "fields": {
// "Id": {
// "displayValue": null,
// "value": "005B0000003TOI6IAO"
// },
// "Name": {
// "displayValue": null,
// "value": "Philippe Ozil"
// }
// },
// "id": "005B0000003TOI6IAO",
// "lastModifiedById": "005B0000003TOI6IAO",
// "lastModifiedDate": "2023-02-02T10:32:12.000Z",
// "recordTypeId": null,
// "recordTypeInfo": null,
// "systemModstamp": "2023-09-27T15:47:51.000Z",
// "weakEtag": 1695829671000
// }
// },
// "LastModifiedById": {
// "displayValue": null,
// "value": "005B0000003TOI6IAO"
// },
// "LastModifiedDate": {
// "displayValue": "27/09/2023 18:04",
// "value": "2023-09-27T16:04:41.000Z"
// },
// "Name": {
// "displayValue": null,
// "value": "My Renamed Account"
// },
// "NumberOfEmployees": {
// "displayValue": null,
// "value": null
// },
// "NumberofLocations__c": {
// "displayValue": null,
// "value": null
// },
// "Owner": {
// "displayValue": "Philippe Ozil",
// "value": {
// "apiName": "User",
// "childRelationships": {},
// "eTag": "cc07f7ef1b08ddbd75074c69512dd388",
// "fields": {
// "Id": {
// "displayValue": null,
// "value": "005B0000003TOI6IAO"
// },
// "Name": {
// "displayValue": null,
// "value": "Philippe Ozil"
// }
// },
// "id": "005B0000003TOI6IAO",
// "lastModifiedById": "005B0000003TOI6IAO",
// "lastModifiedDate": "2023-02-02T10:32:12.000Z",
// "recordTypeId": null,
// "recordTypeInfo": null,
// "systemModstamp": "2023-09-27T15:47:51.000Z",
// "weakEtag": 1695829671000
// }
// },
// "OwnerId": {
// "displayValue": null,
// "value": "005B0000003TOI6IAO"
// },
// "Ownership": {
// "displayValue": null,
// "value": null
// },
// "Parent": {
// "displayValue": null,
// "value": null
// },
// "ParentId": {
// "displayValue": null,
// "value": null
// },
// "Phone": {
// "displayValue": null,
// "value": null
// },
// "Rating": {
// "displayValue": null,
// "value": null
// },
// "SLAExpirationDate__c": {
// "displayValue": null,
// "value": null
// },
// "SLASerialNumber__c": {
// "displayValue": null,
// "value": null
// },
// "SLA__c": {
// "displayValue": null,
// "value": null
// },
// "ShippingCity": {
// "displayValue": null,
// "value": null
// },
// "ShippingCountry": {
// "displayValue": null,
// "value": null
// },
// "ShippingPostalCode": {
// "displayValue": null,
// "value": null
// },
// "ShippingState": {
// "displayValue": null,
// "value": null
// },
// "ShippingStreet": {
// "displayValue": null,
// "value": null
// },
// "Sic": {
// "displayValue": null,
// "value": null
// },
// "Site": {
// "displayValue": null,
// "value": null
// },
// "TickerSymbol": {
// "displayValue": null,
// "value": null
// },
// "Type": {
// "displayValue": null,
// "value": null
// },
// "UpsellOpportunity__c": {
// "displayValue": null,
// "value": null
// },
// "Website": {
// "displayValue": null,
// "value": null
// }
// },
// "id": "0011Q00002Z2P5jQAF",
// "lastModifiedById": "005B0000003TOI6IAO",
// "lastModifiedDate": "2023-09-27T16:04:41.000Z",
// "recordTypeId": "012000000000000AAA",
// "recordTypeInfo": null,
// "systemModstamp": "2023-09-27T16:04:41.000Z",
// "weakEtag": 1695830681000
// }
// Sample code for parsing the JSON response...
// Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
Get ComStringOf Of hoJResp "apiName" To sApiName
Get ComStringOf Of hoJResp "eTag" To sETag
Get ComStringOf Of hoJResp "fields.AccountNumber.displayValue" To sDisplayValue
Get ComStringOf Of hoJResp "fields.AccountNumber.value" To sValue
Get ComStringOf Of hoJResp "fields.Active__c.displayValue" To sActive__cDisplayValue
Get ComStringOf Of hoJResp "fields.Active__c.value" To sActive__cValue
Get ComStringOf Of hoJResp "fields.AnnualRevenue.displayValue" To sAnnualRevenueDisplayValue
Get ComStringOf Of hoJResp "fields.AnnualRevenue.value" To sAnnualRevenueValue
Get ComStringOf Of hoJResp "fields.BillingCity.displayValue" To sBillingCityDisplayValue
Get ComStringOf Of hoJResp "fields.BillingCity.value" To sBillingCityValue
Get ComStringOf Of hoJResp "fields.BillingCountry.displayValue" To sBillingCountryDisplayValue
Get ComStringOf Of hoJResp "fields.BillingCountry.value" To sBillingCountryValue
Get ComStringOf Of hoJResp "fields.BillingPostalCode.displayValue" To sBillingPostalCodeDisplayValue
Get ComStringOf Of hoJResp "fields.BillingPostalCode.value" To sBillingPostalCodeValue
Get ComStringOf Of hoJResp "fields.BillingState.displayValue" To sBillingStateDisplayValue
Get ComStringOf Of hoJResp "fields.BillingState.value" To sBillingStateValue
Get ComStringOf Of hoJResp "fields.BillingStreet.displayValue" To sBillingStreetDisplayValue
Get ComStringOf Of hoJResp "fields.BillingStreet.value" To sBillingStreetValue
Get ComStringOf Of hoJResp "fields.CreatedBy.displayValue" To sCreatedByDisplayValue
Get ComStringOf Of hoJResp "fields.CreatedBy.value.apiName" To sApiName
Get ComStringOf Of hoJResp "fields.CreatedBy.value.eTag" To sETag
Get ComStringOf Of hoJResp "fields.CreatedBy.value.fields.Id.displayValue" To sIdDisplayValue
Get ComStringOf Of hoJResp "fields.CreatedBy.value.fields.Id.value" To sIdValue
Get ComStringOf Of hoJResp "fields.CreatedBy.value.fields.Name.displayValue" To sNameDisplayValue
Get ComStringOf Of hoJResp "fields.CreatedBy.value.fields.Name.value" To sNameValue
Get ComStringOf Of hoJResp "fields.CreatedBy.value.id" To sId
Get ComStringOf Of hoJResp "fields.CreatedBy.value.lastModifiedById" To sLastModifiedById
Get ComStringOf Of hoJResp "fields.CreatedBy.value.lastModifiedDate" To sLastModifiedDate
Get ComStringOf Of hoJResp "fields.CreatedBy.value.recordTypeId" To sRecordTypeId
Get ComStringOf Of hoJResp "fields.CreatedBy.value.recordTypeInfo" To sRecordTypeInfo
Get ComStringOf Of hoJResp "fields.CreatedBy.value.systemModstamp" To sSystemModstamp
Get ComIntOf Of hoJResp "fields.CreatedBy.value.weakEtag" To iWeakEtag
Get ComStringOf Of hoJResp "fields.CreatedById.displayValue" To sCreatedByIdDisplayValue
Get ComStringOf Of hoJResp "fields.CreatedById.value" To sCreatedByIdValue
Get ComStringOf Of hoJResp "fields.CreatedDate.displayValue" To sCreatedDateDisplayValue
Get ComStringOf Of hoJResp "fields.CreatedDate.value" To sCreatedDateValue
Get ComStringOf Of hoJResp "fields.CustomerPriority__c.displayValue" To sCustomerPriority__cDisplayValue
Get ComStringOf Of hoJResp "fields.CustomerPriority__c.value" To sCustomerPriority__cValue
Get ComStringOf Of hoJResp "fields.Description.displayValue" To sDescriptionDisplayValue
Get ComStringOf Of hoJResp "fields.Description.value" To sDescriptionValue
Get ComStringOf Of hoJResp "fields.Fax.displayValue" To sFaxDisplayValue
Get ComStringOf Of hoJResp "fields.Fax.value" To sFaxValue
Get ComStringOf Of hoJResp "fields.Industry.displayValue" To sIndustryDisplayValue
Get ComStringOf Of hoJResp "fields.Industry.value" To sIndustryValue
Get ComStringOf Of hoJResp "fields.LastModifiedBy.displayValue" To sLastModifiedByDisplayValue
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.apiName" To sValueApiName
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.eTag" To sValueETag
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.fields.Id.displayValue" To sIdDisplayValue
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.fields.Id.value" To sIdValue
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.fields.Name.displayValue" To sNameDisplayValue
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.fields.Name.value" To sNameValue
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.id" To sValueId
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.lastModifiedById" To sValueLastModifiedById
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.lastModifiedDate" To sValueLastModifiedDate
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.recordTypeId" To sValueRecordTypeId
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.recordTypeInfo" To sValueRecordTypeInfo
Get ComStringOf Of hoJResp "fields.LastModifiedBy.value.systemModstamp" To sValueSystemModstamp
Get ComIntOf Of hoJResp "fields.LastModifiedBy.value.weakEtag" To iValueWeakEtag
Get ComStringOf Of hoJResp "fields.LastModifiedById.displayValue" To sLastModifiedByIdDisplayValue
Get ComStringOf Of hoJResp "fields.LastModifiedById.value" To sLastModifiedByIdValue
Get ComStringOf Of hoJResp "fields.LastModifiedDate.displayValue" To sLastModifiedDateDisplayValue
Get ComStringOf Of hoJResp "fields.LastModifiedDate.value" To sLastModifiedDateValue
Get ComStringOf Of hoJResp "fields.Name.displayValue" To sNameDisplayValue
Get ComStringOf Of hoJResp "fields.Name.value" To sNameValue
Get ComStringOf Of hoJResp "fields.NumberOfEmployees.displayValue" To sNumberOfEmployeesDisplayValue
Get ComStringOf Of hoJResp "fields.NumberOfEmployees.value" To sNumberOfEmployeesValue
Get ComStringOf Of hoJResp "fields.NumberofLocations__c.displayValue" To sNumberofLocations__cDisplayValue
Get ComStringOf Of hoJResp "fields.NumberofLocations__c.value" To sNumberofLocations__cValue
Get ComStringOf Of hoJResp "fields.Owner.displayValue" To sOwnerDisplayValue
Get ComStringOf Of hoJResp "fields.Owner.value.apiName" To sValueApiName
Get ComStringOf Of hoJResp "fields.Owner.value.eTag" To sValueETag
Get ComStringOf Of hoJResp "fields.Owner.value.fields.Id.displayValue" To sIdDisplayValue
Get ComStringOf Of hoJResp "fields.Owner.value.fields.Id.value" To sIdValue
Get ComStringOf Of hoJResp "fields.Owner.value.fields.Name.displayValue" To sNameDisplayValue
Get ComStringOf Of hoJResp "fields.Owner.value.fields.Name.value" To sNameValue
Get ComStringOf Of hoJResp "fields.Owner.value.id" To sValueId
Get ComStringOf Of hoJResp "fields.Owner.value.lastModifiedById" To sValueLastModifiedById
Get ComStringOf Of hoJResp "fields.Owner.value.lastModifiedDate" To sValueLastModifiedDate
Get ComStringOf Of hoJResp "fields.Owner.value.recordTypeId" To sValueRecordTypeId
Get ComStringOf Of hoJResp "fields.Owner.value.recordTypeInfo" To sValueRecordTypeInfo
Get ComStringOf Of hoJResp "fields.Owner.value.systemModstamp" To sValueSystemModstamp
Get ComIntOf Of hoJResp "fields.Owner.value.weakEtag" To iValueWeakEtag
Get ComStringOf Of hoJResp "fields.OwnerId.displayValue" To sOwnerIdDisplayValue
Get ComStringOf Of hoJResp "fields.OwnerId.value" To sOwnerIdValue
Get ComStringOf Of hoJResp "fields.Ownership.displayValue" To sOwnershipDisplayValue
Get ComStringOf Of hoJResp "fields.Ownership.value" To sOwnershipValue
Get ComStringOf Of hoJResp "fields.Parent.displayValue" To sParentDisplayValue
Get ComStringOf Of hoJResp "fields.Parent.value" To sParentValue
Get ComStringOf Of hoJResp "fields.ParentId.displayValue" To sParentIdDisplayValue
Get ComStringOf Of hoJResp "fields.ParentId.value" To sParentIdValue
Get ComStringOf Of hoJResp "fields.Phone.displayValue" To sPhoneDisplayValue
Get ComStringOf Of hoJResp "fields.Phone.value" To sPhoneValue
Get ComStringOf Of hoJResp "fields.Rating.displayValue" To sRatingDisplayValue
Get ComStringOf Of hoJResp "fields.Rating.value" To sRatingValue
Get ComStringOf Of hoJResp "fields.SLAExpirationDate__c.displayValue" To sSLAExpirationDate__cDisplayValue
Get ComStringOf Of hoJResp "fields.SLAExpirationDate__c.value" To sSLAExpirationDate__cValue
Get ComStringOf Of hoJResp "fields.SLASerialNumber__c.displayValue" To sSLASerialNumber__cDisplayValue
Get ComStringOf Of hoJResp "fields.SLASerialNumber__c.value" To sSLASerialNumber__cValue
Get ComStringOf Of hoJResp "fields.SLA__c.displayValue" To sSLA__cDisplayValue
Get ComStringOf Of hoJResp "fields.SLA__c.value" To sSLA__cValue
Get ComStringOf Of hoJResp "fields.ShippingCity.displayValue" To sShippingCityDisplayValue
Get ComStringOf Of hoJResp "fields.ShippingCity.value" To sShippingCityValue
Get ComStringOf Of hoJResp "fields.ShippingCountry.displayValue" To sShippingCountryDisplayValue
Get ComStringOf Of hoJResp "fields.ShippingCountry.value" To sShippingCountryValue
Get ComStringOf Of hoJResp "fields.ShippingPostalCode.displayValue" To sShippingPostalCodeDisplayValue
Get ComStringOf Of hoJResp "fields.ShippingPostalCode.value" To sShippingPostalCodeValue
Get ComStringOf Of hoJResp "fields.ShippingState.displayValue" To sShippingStateDisplayValue
Get ComStringOf Of hoJResp "fields.ShippingState.value" To sShippingStateValue
Get ComStringOf Of hoJResp "fields.ShippingStreet.displayValue" To sShippingStreetDisplayValue
Get ComStringOf Of hoJResp "fields.ShippingStreet.value" To sShippingStreetValue
Get ComStringOf Of hoJResp "fields.Sic.displayValue" To sSicDisplayValue
Get ComStringOf Of hoJResp "fields.Sic.value" To sSicValue
Get ComStringOf Of hoJResp "fields.Site.displayValue" To sSiteDisplayValue
Get ComStringOf Of hoJResp "fields.Site.value" To sSiteValue
Get ComStringOf Of hoJResp "fields.TickerSymbol.displayValue" To sTickerSymbolDisplayValue
Get ComStringOf Of hoJResp "fields.TickerSymbol.value" To sTickerSymbolValue
Get ComStringOf Of hoJResp "fields.Type.displayValue" To sTypeDisplayValue
Get ComStringOf Of hoJResp "fields.Type.value" To sTypeValue
Get ComStringOf Of hoJResp "fields.UpsellOpportunity__c.displayValue" To sUpsellOpportunity__cDisplayValue
Get ComStringOf Of hoJResp "fields.UpsellOpportunity__c.value" To sUpsellOpportunity__cValue
Get ComStringOf Of hoJResp "fields.Website.displayValue" To sWebsiteDisplayValue
Get ComStringOf Of hoJResp "fields.Website.value" To sWebsiteValue
Get ComStringOf Of hoJResp "id" To sId
Get ComStringOf Of hoJResp "lastModifiedById" To sLastModifiedById
Get ComStringOf Of hoJResp "lastModifiedDate" To sLastModifiedDate
Get ComStringOf Of hoJResp "recordTypeId" To sRecordTypeId
Get ComStringOf Of hoJResp "recordTypeInfo" To sRecordTypeInfo
Get ComStringOf Of hoJResp "systemModstamp" To sSystemModstamp
Get ComIntOf Of hoJResp "weakEtag" To iWeakEtag
End_Procedure
Curl Command
curl -X PATCH
-H "Authorization: Bearer <access_token>"
-H "Content-Type: application/json"
-d '{
"allowSaveOnDuplicate": false,
"fields": {
"FieldAPIName": "FieldValue"
}
}'
https://domain.com/services/data/v{{version}}/ui-api/records/:RECORD_ID
Postman Collection Item JSON
{
"name": "Update a Record",
"event": [
{
"listen": "prerequest",
"script": {
"exec": [
""
],
"type": "text/javascript"
}
}
],
"request": {
"method": "PATCH",
"header": [
{
"key": "Content-Type",
"type": "text",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"allowSaveOnDuplicate\": false,\n \"fields\": {\n \"FieldAPIName\": \"FieldValue\"\n }\n}"
},
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/ui-api/records/:RECORD_ID",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"ui-api",
"records",
":RECORD_ID"
],
"variable": [
{
"key": "RECORD_ID",
"value": "",
"description": "Record ID"
}
]
},
"description": "Update a record's data.\nUser Interface API enforces Salesforce validation rules. If a validation rule fails, the response is an Error with Output.\n\nWhen you make a PATCH request to update a record, make sure that the record hasn’t changed since the user started editing it. To find out whether it’s safe to save a record, pass the If-Modified-Since HTTP header in the request.\n\nAs of API version 43.0, if you pass read-only fields in a request body, the response is an Error with Output."
},
"response": [
{
"name": "Update a Record",
"originalRequest": {
"method": "PATCH",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"allowSaveOnDuplicate\": false,\n \"fields\": {\n \"Name\": \"My Renamed Account\"\n }\n}"
},
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/ui-api/records/:RECORD_ID",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"ui-api",
"records",
":RECORD_ID"
],
"variable": [
{
"key": "RECORD_ID",
"value": "0011Q00002Z2P5jQAF",
"description": "Record ID"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Date",
"value": "Wed, 27 Sep 2023 16:04:41 GMT"
},
{
"key": "Strict-Transport-Security",
"value": "max-age=63072000; includeSubDomains"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-XSS-Protection",
"value": "1; mode=block"
},
{
"key": "X-Robots-Tag",
"value": "none"
},
{
"key": "Cache-Control",
"value": "no-cache,must-revalidate,max-age=0,no-store,private"
},
{
"key": "ETag",
"value": "\"1be6f040e46732e79a0999d6fea9fe7d\""
},
{
"key": "Content-Type",
"value": "application/json;charset=UTF-8"
},
{
"key": "Transfer-Encoding",
"value": "chunked"
}
],
"cookie": [
],
"body": "{\n \"apiName\": \"Account\",\n \"childRelationships\": {},\n \"eTag\": \"1be6f040e46732e79a0999d6fea9fe7d\",\n \"fields\": {\n \"AccountNumber\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Active__c\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"AnnualRevenue\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"BillingCity\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"BillingCountry\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"BillingPostalCode\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"BillingState\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"BillingStreet\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"CreatedBy\": {\n \"displayValue\": \"Philippe Ozil\",\n \"value\": {\n \"apiName\": \"User\",\n \"childRelationships\": {},\n \"eTag\": \"cc07f7ef1b08ddbd75074c69512dd388\",\n \"fields\": {\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"005B0000003TOI6IAO\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"Philippe Ozil\"\n }\n },\n \"id\": \"005B0000003TOI6IAO\",\n \"lastModifiedById\": \"005B0000003TOI6IAO\",\n \"lastModifiedDate\": \"2023-02-02T10:32:12.000Z\",\n \"recordTypeId\": null,\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-09-27T15:47:51.000Z\",\n \"weakEtag\": 1695829671000\n }\n },\n \"CreatedById\": {\n \"displayValue\": null,\n \"value\": \"005B0000003TOI6IAO\"\n },\n \"CreatedDate\": {\n \"displayValue\": \"27/09/2023 18:01\",\n \"value\": \"2023-09-27T16:01:14.000Z\"\n },\n \"CustomerPriority__c\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Description\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Fax\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Industry\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"LastModifiedBy\": {\n \"displayValue\": \"Philippe Ozil\",\n \"value\": {\n \"apiName\": \"User\",\n \"childRelationships\": {},\n \"eTag\": \"cc07f7ef1b08ddbd75074c69512dd388\",\n \"fields\": {\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"005B0000003TOI6IAO\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"Philippe Ozil\"\n }\n },\n \"id\": \"005B0000003TOI6IAO\",\n \"lastModifiedById\": \"005B0000003TOI6IAO\",\n \"lastModifiedDate\": \"2023-02-02T10:32:12.000Z\",\n \"recordTypeId\": null,\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-09-27T15:47:51.000Z\",\n \"weakEtag\": 1695829671000\n }\n },\n \"LastModifiedById\": {\n \"displayValue\": null,\n \"value\": \"005B0000003TOI6IAO\"\n },\n \"LastModifiedDate\": {\n \"displayValue\": \"27/09/2023 18:04\",\n \"value\": \"2023-09-27T16:04:41.000Z\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"My Renamed Account\"\n },\n \"NumberOfEmployees\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"NumberofLocations__c\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Owner\": {\n \"displayValue\": \"Philippe Ozil\",\n \"value\": {\n \"apiName\": \"User\",\n \"childRelationships\": {},\n \"eTag\": \"cc07f7ef1b08ddbd75074c69512dd388\",\n \"fields\": {\n \"Id\": {\n \"displayValue\": null,\n \"value\": \"005B0000003TOI6IAO\"\n },\n \"Name\": {\n \"displayValue\": null,\n \"value\": \"Philippe Ozil\"\n }\n },\n \"id\": \"005B0000003TOI6IAO\",\n \"lastModifiedById\": \"005B0000003TOI6IAO\",\n \"lastModifiedDate\": \"2023-02-02T10:32:12.000Z\",\n \"recordTypeId\": null,\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-09-27T15:47:51.000Z\",\n \"weakEtag\": 1695829671000\n }\n },\n \"OwnerId\": {\n \"displayValue\": null,\n \"value\": \"005B0000003TOI6IAO\"\n },\n \"Ownership\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Parent\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"ParentId\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Phone\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Rating\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"SLAExpirationDate__c\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"SLASerialNumber__c\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"SLA__c\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"ShippingCity\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"ShippingCountry\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"ShippingPostalCode\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"ShippingState\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"ShippingStreet\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Sic\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Site\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"TickerSymbol\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Type\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"UpsellOpportunity__c\": {\n \"displayValue\": null,\n \"value\": null\n },\n \"Website\": {\n \"displayValue\": null,\n \"value\": null\n }\n },\n \"id\": \"0011Q00002Z2P5jQAF\",\n \"lastModifiedById\": \"005B0000003TOI6IAO\",\n \"lastModifiedDate\": \"2023-09-27T16:04:41.000Z\",\n \"recordTypeId\": \"012000000000000AAA\",\n \"recordTypeInfo\": null,\n \"systemModstamp\": \"2023-09-27T16:04:41.000Z\",\n \"weakEtag\": 1695830681000\n}"
}
]
}