Back to Collection Items
IncludeFile "CkJsonObject.pb"
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkHttp.pb"
IncludeFile "CkHttpResponse.pb"
Procedure ChilkatExample()
; This example assumes the Chilkat API to have been previously unlocked.
; See Global Unlock Sample for sample code.
http.i = CkHttp::ckCreate()
If http.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
success.i
queryParams.i = CkJsonObject::ckCreate()
If queryParams.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkJsonObject::ckUpdateString(queryParams,"q","SELECT FIELDS(All) FROM ACCOUNT ORDER BY Name LIMIT 5")
; Adds the "Authorization: Bearer <access_token>" header.
CkHttp::setCkAuthToken(http, "<access_token>")
CkHttp::ckSetRequestHeader(http,"Content-Type","application/json")
resp.i = CkHttp::ckQuickRequestParams(http,"GET","https://domain.com/services/data/v{{version}}/query/",queryParams)
If CkHttp::ckLastMethodSuccess(http) = 0
Debug CkHttp::ckLastErrorText(http)
CkHttp::ckDispose(http)
CkJsonObject::ckDispose(queryParams)
ProcedureReturn
EndIf
sbResponseBody.i = CkStringBuilder::ckCreate()
If sbResponseBody.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkHttpResponse::ckGetBodySb(resp,sbResponseBody)
jResp.i = CkJsonObject::ckCreate()
If jResp.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkJsonObject::ckLoadSb(jResp,sbResponseBody)
CkJsonObject::setCkEmitCompact(jResp, 0)
Debug "Response Body:"
Debug CkJsonObject::ckEmit(jResp)
respStatusCode.i = CkHttpResponse::ckStatusCode(resp)
Debug "Response Status Code = " + Str(respStatusCode)
If respStatusCode >= 400
Debug "Response Header:"
Debug CkHttpResponse::ckHeader(resp)
Debug "Failed."
CkHttpResponse::ckDispose(resp)
CkHttp::ckDispose(http)
CkJsonObject::ckDispose(queryParams)
CkStringBuilder::ckDispose(sbResponseBody)
CkJsonObject::ckDispose(jResp)
ProcedureReturn
EndIf
CkHttpResponse::ckDispose(resp)
; Sample JSON response:
; (Sample code for parsing the JSON response is shown below)
; {
; "totalSize": 5,
; "done": true,
; "records": [
; {
; "attributes": {
; "type": "Account",
; "url": "/services/data/v58.0/sobjects/Account/001B000000UnQ2wIAF"
; },
; "Id": "001B000000UnQ2wIAF",
; "IsDeleted": false,
; "MasterRecordId": null,
; "Name": "Burlington Textiles Corp of America",
; "Type": "Customer - Direct",
; "ParentId": null,
; "BillingStreet": "525 S. Lexington Ave",
; "BillingCity": "Burlington",
; "BillingState": "NC",
; "BillingPostalCode": "27215",
; "BillingCountry": "USA",
; "BillingLatitude": null,
; "BillingLongitude": null,
; "BillingGeocodeAccuracy": null,
; "BillingAddress": {
; "city": "Burlington",
; "country": "USA",
; "geocodeAccuracy": null,
; "latitude": null,
; "longitude": null,
; "postalCode": "27215",
; "state": "NC",
; "street": "525 S. Lexington Ave"
; },
; "ShippingStreet": null,
; "ShippingCity": null,
; "ShippingState": null,
; "ShippingPostalCode": null,
; "ShippingCountry": null,
; "ShippingLatitude": null,
; "ShippingLongitude": null,
; "ShippingGeocodeAccuracy": null,
; "ShippingAddress": null,
; "Phone": "(336) 222-7000",
; "Fax": "(336) 222-8000",
; "AccountNumber": "CD656092",
; "Website": "www.burlington.com",
; "PhotoUrl": "/services/images/photo/001B000000UnQ2wIAF",
; "Sic": "546732",
; "Industry": "Apparel",
; "AnnualRevenue": 350000000,
; "NumberOfEmployees": 9000,
; "Ownership": "Public",
; "TickerSymbol": "BTXT",
; "Description": null,
; "Rating": "Warm",
; "Site": null,
; "OwnerId": "005B0000003TOI6IAO",
; "CreatedDate": "2017-08-18T14:46:22.000+0000",
; "CreatedById": "005B0000003TOI6IAO",
; "LastModifiedDate": "2017-08-18T14:46:22.000+0000",
; "LastModifiedById": "005B0000003TOI6IAO",
; "SystemModstamp": "2017-08-18T14:46:22.000+0000",
; "LastActivityDate": null,
; "LastViewedDate": null,
; "LastReferencedDate": null,
; "IsPartner": false,
; "IsCustomerPortal": false,
; "ChannelProgramName": null,
; "ChannelProgramLevelName": null,
; "Jigsaw": null,
; "JigsawCompanyId": null,
; "CleanStatus": "Pending",
; "AccountSource": null,
; "DunsNumber": null,
; "Tradestyle": null,
; "NaicsCode": null,
; "NaicsDesc": null,
; "YearStarted": null,
; "SicDesc": null,
; "DandbCompanyId": null,
; "CustomerPriority__c": null,
; "SLA__c": "Silver",
; "Active__c": null,
; "NumberofLocations__c": 6,
; "UpsellOpportunity__c": "Maybe",
; "SLASerialNumber__c": "5367",
; "SLAExpirationDate__c": "2016-09-12"
; },
; {
; "attributes": {
; "type": "Account",
; "url": "/services/data/v58.0/sobjects/Account/001B000000UnQ2yIAF"
; },
; "Id": "001B000000UnQ2yIAF",
; "IsDeleted": false,
; "MasterRecordId": null,
; "Name": "Dickenson plc",
; "Type": "Customer - Channel",
; "ParentId": null,
; "BillingStreet": "1301 Hoch Drive",
; "BillingCity": "Lawrence",
; "BillingState": "KS",
; "BillingPostalCode": "66045",
; "BillingCountry": "USA",
; "BillingLatitude": null,
; "BillingLongitude": null,
; "BillingGeocodeAccuracy": null,
; "BillingAddress": {
; "city": "Lawrence",
; "country": "USA",
; "geocodeAccuracy": null,
; "latitude": null,
; "longitude": null,
; "postalCode": "66045",
; "state": "KS",
; "street": "1301 Hoch Drive"
; },
; "ShippingStreet": "1301 Hoch Drive",
; "ShippingCity": "Lawrence",
; "ShippingState": "KS",
; "ShippingPostalCode": "66045",
; "ShippingCountry": "USA",
; "ShippingLatitude": null,
; "ShippingLongitude": null,
; "ShippingGeocodeAccuracy": null,
; "ShippingAddress": {
; "city": "Lawrence",
; "country": "USA",
; "geocodeAccuracy": null,
; "latitude": null,
; "longitude": null,
; "postalCode": "66045",
; "state": "KS",
; "street": "1301 Hoch Drive"
; },
; "Phone": "(785) 241-6200",
; "Fax": "(785) 241-6201",
; "AccountNumber": "CC634267",
; "Website": "dickenson-consulting.com",
; "PhotoUrl": "/services/images/photo/001B000000UnQ2yIAF",
; "Sic": "6752",
; "Industry": "Consulting",
; "AnnualRevenue": 50000000,
; "NumberOfEmployees": 120,
; "Ownership": "Private",
; "TickerSymbol": null,
; "Description": null,
; "Rating": null,
; "Site": null,
; "OwnerId": "005B0000003TOI6IAO",
; "CreatedDate": "2017-08-18T14:46:22.000+0000",
; "CreatedById": "005B0000003TOI6IAO",
; "LastModifiedDate": "2017-08-18T14:46:22.000+0000",
; "LastModifiedById": "005B0000003TOI6IAO",
; "SystemModstamp": "2017-08-18T14:46:22.000+0000",
; "LastActivityDate": null,
; "LastViewedDate": null,
; "LastReferencedDate": null,
; "IsPartner": false,
; "IsCustomerPortal": false,
; "ChannelProgramName": null,
; "ChannelProgramLevelName": null,
; "Jigsaw": null,
; "JigsawCompanyId": null,
; "CleanStatus": "Pending",
; "AccountSource": null,
; "DunsNumber": null,
; "Tradestyle": null,
; "NaicsCode": null,
; "NaicsDesc": null,
; "YearStarted": null,
; "SicDesc": null,
; "DandbCompanyId": null,
; "CustomerPriority__c": "Low",
; "SLA__c": "Bronze",
; "Active__c": "Yes",
; "NumberofLocations__c": 2,
; "UpsellOpportunity__c": "No",
; "SLASerialNumber__c": "7425",
; "SLAExpirationDate__c": "2017-03-15"
; },
; {
; "attributes": {
; "type": "Account",
; "url": "/services/data/v58.0/sobjects/Account/001B000000UnQ2vIAF"
; },
; "Id": "001B000000UnQ2vIAF",
; "IsDeleted": false,
; "MasterRecordId": null,
; "Name": "Edge Communications",
; "Type": "Customer - Direct",
; "ParentId": null,
; "BillingStreet": "312 Constitution Place\nAustin, TX 78767\nUSA",
; "BillingCity": "Austin",
; "BillingState": "TX",
; "BillingPostalCode": null,
; "BillingCountry": null,
; "BillingLatitude": null,
; "BillingLongitude": null,
; "BillingGeocodeAccuracy": null,
; "BillingAddress": {
; "city": "Austin",
; "country": null,
; "geocodeAccuracy": null,
; "latitude": null,
; "longitude": null,
; "postalCode": null,
; "state": "TX",
; "street": "312 Constitution Place\nAustin, TX 78767\nUSA"
; },
; "ShippingStreet": "312 Constitution Place\nAustin, TX 78767\nUSA",
; "ShippingCity": null,
; "ShippingState": null,
; "ShippingPostalCode": null,
; "ShippingCountry": null,
; "ShippingLatitude": null,
; "ShippingLongitude": null,
; "ShippingGeocodeAccuracy": null,
; "ShippingAddress": {
; "city": null,
; "country": null,
; "geocodeAccuracy": null,
; "latitude": null,
; "longitude": null,
; "postalCode": null,
; "state": null,
; "street": "312 Constitution Place\nAustin, TX 78767\nUSA"
; },
; "Phone": "(512) 757-6000",
; "Fax": "(512) 757-9000",
; "AccountNumber": "CD451796",
; "Website": "http://edgecomm.com",
; "PhotoUrl": "/services/images/photo/001B000000UnQ2vIAF",
; "Sic": "6576",
; "Industry": "Electronics",
; "AnnualRevenue": 139000000,
; "NumberOfEmployees": 1000,
; "Ownership": "Public",
; "TickerSymbol": "EDGE",
; "Description": "Edge, founded in 1998, is a start-up based in Austin, TX. The company designs and manufactures a device to convert music from one digital format to another. Edge sells its product through retailers and its own website.",
; "Rating": "Hot",
; "Site": null,
; "OwnerId": "005B0000003TOI6IAO",
; "CreatedDate": "2017-08-18T14:46:22.000+0000",
; "CreatedById": "005B0000003TOI6IAO",
; "LastModifiedDate": "2017-08-18T14:46:22.000+0000",
; "LastModifiedById": "005B0000003TOI6IAO",
; "SystemModstamp": "2017-08-18T14:46:22.000+0000",
; "LastActivityDate": null,
; "LastViewedDate": null,
; "LastReferencedDate": null,
; "IsPartner": false,
; "IsCustomerPortal": false,
; "ChannelProgramName": null,
; "ChannelProgramLevelName": null,
; "Jigsaw": null,
; "JigsawCompanyId": null,
; "CleanStatus": "Pending",
; "AccountSource": null,
; "DunsNumber": null,
; "Tradestyle": null,
; "NaicsCode": null,
; "NaicsDesc": null,
; "YearStarted": null,
; "SicDesc": null,
; "DandbCompanyId": null,
; "CustomerPriority__c": "Medium",
; "SLA__c": "Silver",
; "Active__c": "Yes",
; "NumberofLocations__c": 2,
; "UpsellOpportunity__c": "Maybe",
; "SLASerialNumber__c": "2657",
; "SLAExpirationDate__c": "2016-09-12"
; },
; {
; "attributes": {
; "type": "Account",
; "url": "/services/data/v58.0/sobjects/Account/001B000000UnQ31IAF"
; },
; "Id": "001B000000UnQ31IAF",
; "IsDeleted": false,
; "MasterRecordId": null,
; "Name": "Express Logistics and Transport",
; "Type": "Customer - Channel",
; "ParentId": null,
; "BillingStreet": "620 SW 5th Avenue Suite 400\nPortland, Oregon 97204\nUnited States",
; "BillingCity": "Portland",
; "BillingState": "OR",
; "BillingPostalCode": null,
; "BillingCountry": null,
; "BillingLatitude": null,
; "BillingLongitude": null,
; "BillingGeocodeAccuracy": null,
; "BillingAddress": {
; "city": "Portland",
; "country": null,
; "geocodeAccuracy": null,
; "latitude": null,
; "longitude": null,
; "postalCode": null,
; "state": "OR",
; "street": "620 SW 5th Avenue Suite 400\nPortland, Oregon 97204\nUnited States"
; },
; "ShippingStreet": "620 SW 5th Avenue Suite 400\nPortland, Oregon 97204\nUnited States",
; "ShippingCity": null,
; "ShippingState": null,
; "ShippingPostalCode": null,
; "ShippingCountry": null,
; "ShippingLatitude": null,
; "ShippingLongitude": null,
; "ShippingGeocodeAccuracy": null,
; "ShippingAddress": {
; "city": null,
; "country": null,
; "geocodeAccuracy": null,
; "latitude": null,
; "longitude": null,
; "postalCode": null,
; "state": null,
; "street": "620 SW 5th Avenue Suite 400\nPortland, Oregon 97204\nUnited States"
; },
; "Phone": "(503) 421-7800",
; "Fax": "(503) 421-7801",
; "AccountNumber": "CC947211",
; "Website": "www.expressl&t.net",
; "PhotoUrl": "/services/images/photo/001B000000UnQ31IAF",
; "Sic": "8742",
; "Industry": "Transportation",
; "AnnualRevenue": 950000000,
; "NumberOfEmployees": 12300,
; "Ownership": "Public",
; "TickerSymbol": "EXLT",
; "Description": "Commerical logistics and transportation company.",
; "Rating": "Cold",
; "Site": null,
; "OwnerId": "005B0000003TOI6IAO",
; "CreatedDate": "2017-08-18T14:46:22.000+0000",
; "CreatedById": "005B0000003TOI6IAO",
; "LastModifiedDate": "2017-08-18T14:46:22.000+0000",
; "LastModifiedById": "005B0000003TOI6IAO",
; "SystemModstamp": "2017-08-18T14:46:22.000+0000",
; "LastActivityDate": null,
; "LastViewedDate": null,
; "LastReferencedDate": null,
; "IsPartner": false,
; "IsCustomerPortal": false,
; "ChannelProgramName": null,
; "ChannelProgramLevelName": null,
; "Jigsaw": null,
; "JigsawCompanyId": null,
; "CleanStatus": "Pending",
; "AccountSource": null,
; "DunsNumber": null,
; "Tradestyle": null,
; "NaicsCode": null,
; "NaicsDesc": null,
; "YearStarted": null,
; "SicDesc": null,
; "DandbCompanyId": null,
; "CustomerPriority__c": "Medium",
; "SLA__c": "Platinum",
; "Active__c": "Yes",
; "NumberofLocations__c": 150,
; "UpsellOpportunity__c": "Maybe",
; "SLASerialNumber__c": "4724",
; "SLAExpirationDate__c": "2017-03-15"
; },
; {
; "attributes": {
; "type": "Account",
; "url": "/services/data/v58.0/sobjects/Account/001B000000UnQ35IAF"
; },
; "Id": "001B000000UnQ35IAF",
; "IsDeleted": false,
; "MasterRecordId": null,
; "Name": "GenePoint",
; "Type": "Customer - Channel",
; "ParentId": null,
; "BillingStreet": "345 Shoreline Park\nMountain View, CA 94043\nUSA",
; "BillingCity": "Mountain View",
; "BillingState": "CA",
; "BillingPostalCode": null,
; "BillingCountry": null,
; "BillingLatitude": null,
; "BillingLongitude": null,
; "BillingGeocodeAccuracy": null,
; "BillingAddress": {
; "city": "Mountain View",
; "country": null,
; "geocodeAccuracy": null,
; "latitude": null,
; "longitude": null,
; "postalCode": null,
; "state": "CA",
; "street": "345 Shoreline Park\nMountain View, CA 94043\nUSA"
; },
; "ShippingStreet": "345 Shoreline Park\nMountain View, CA 94043\nUSA",
; "ShippingCity": null,
; "ShippingState": null,
; "ShippingPostalCode": null,
; "ShippingCountry": null,
; "ShippingLatitude": null,
; "ShippingLongitude": null,
; "ShippingGeocodeAccuracy": null,
; "ShippingAddress": {
; "city": null,
; "country": null,
; "geocodeAccuracy": null,
; "latitude": null,
; "longitude": null,
; "postalCode": null,
; "state": null,
; "street": "345 Shoreline Park\nMountain View, CA 94043\nUSA"
; },
; "Phone": "(650) 867-3450",
; "Fax": "(650) 867-9895",
; "AccountNumber": "CC978213",
; "Website": "www.genepoint.com",
; "PhotoUrl": "/services/images/photo/001B000000UnQ35IAF",
; "Sic": "3712",
; "Industry": "Biotechnology",
; "AnnualRevenue": 30000000,
; "NumberOfEmployees": 265,
; "Ownership": "Private",
; "TickerSymbol": null,
; "Description": "Genomics company engaged in mapping and sequencing of the human genome and developing gene-based drugs",
; "Rating": "Cold",
; "Site": null,
; "OwnerId": "005B0000003TOI6IAO",
; "CreatedDate": "2017-08-18T14:46:22.000+0000",
; "CreatedById": "005B0000003TOI6IAO",
; "LastModifiedDate": "2017-08-18T14:46:22.000+0000",
; "LastModifiedById": "005B0000003TOI6IAO",
; "SystemModstamp": "2017-08-18T14:46:22.000+0000",
; "LastActivityDate": null,
; "LastViewedDate": null,
; "LastReferencedDate": null,
; "IsPartner": false,
; "IsCustomerPortal": false,
; "ChannelProgramName": null,
; "ChannelProgramLevelName": null,
; "Jigsaw": null,
; "JigsawCompanyId": null,
; "CleanStatus": "Pending",
; "AccountSource": null,
; "DunsNumber": null,
; "Tradestyle": null,
; "NaicsCode": null,
; "NaicsDesc": null,
; "YearStarted": null,
; "SicDesc": null,
; "DandbCompanyId": null,
; "CustomerPriority__c": "Low",
; "SLA__c": "Bronze",
; "Active__c": "Yes",
; "NumberofLocations__c": 1,
; "UpsellOpportunity__c": "Yes",
; "SLASerialNumber__c": "7324",
; "SLAExpirationDate__c": "2017-03-15"
; }
; ]
; }
; Sample code for parsing the JSON response...
; Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
v_Type.s
v_Url.s
Id.s
IsDeleted.i
MasterRecordId.s
Name.s
ParentId.s
BillingStreet.s
BillingCity.s
BillingState.s
BillingPostalCode.s
BillingCountry.s
BillingLatitude.s
BillingLongitude.s
BillingGeocodeAccuracy.s
City.s
Country.s
GeocodeAccuracy.s
Latitude.s
Longitude.s
PostalCode.s
State.s
Street.s
ShippingStreet.s
ShippingCity.s
ShippingState.s
ShippingPostalCode.s
ShippingCountry.s
ShippingLatitude.s
ShippingLongitude.s
ShippingGeocodeAccuracy.s
ShippingAddress.s
Phone.s
Fax.s
AccountNumber.s
Website.s
PhotoUrl.s
Sic.s
Industry.s
AnnualRevenue.i
NumberOfEmployees.i
Ownership.s
TickerSymbol.s
Description.s
Rating.s
Site.s
OwnerId.s
CreatedDate.s
CreatedById.s
LastModifiedDate.s
LastModifiedById.s
SystemModstamp.s
LastActivityDate.s
LastViewedDate.s
LastReferencedDate.s
IsPartner.i
IsCustomerPortal.i
ChannelProgramName.s
ChannelProgramLevelName.s
Jigsaw.s
JigsawCompanyId.s
CleanStatus.s
AccountSource.s
DunsNumber.s
Tradestyle.s
NaicsCode.s
NaicsDesc.s
YearStarted.s
SicDesc.s
DandbCompanyId.s
CustomerPriority__c.s
SLA__c.s
Active__c.s
NumberofLocations__c.i
UpsellOpportunity__c.s
SLASerialNumber__c.s
SLAExpirationDate__c.s
ShippingAddressCity.s
ShippingAddressCountry.s
ShippingAddressGeocodeAccuracy.s
ShippingAddressLatitude.s
ShippingAddressLongitude.s
ShippingAddressPostalCode.s
ShippingAddressState.s
ShippingAddressStreet.s
totalSize.i = CkJsonObject::ckIntOf(jResp,"totalSize")
done.i = CkJsonObject::ckBoolOf(jResp,"done")
i.i = 0
count_i.i = CkJsonObject::ckSizeOfArray(jResp,"records")
While i < count_i
CkJsonObject::setCkI(jResp, i)
v_Type = CkJsonObject::ckStringOf(jResp,"records[i].attributes.type")
v_Url = CkJsonObject::ckStringOf(jResp,"records[i].attributes.url")
Id = CkJsonObject::ckStringOf(jResp,"records[i].Id")
IsDeleted = CkJsonObject::ckBoolOf(jResp,"records[i].IsDeleted")
MasterRecordId = CkJsonObject::ckStringOf(jResp,"records[i].MasterRecordId")
Name = CkJsonObject::ckStringOf(jResp,"records[i].Name")
v_Type = CkJsonObject::ckStringOf(jResp,"records[i].Type")
ParentId = CkJsonObject::ckStringOf(jResp,"records[i].ParentId")
BillingStreet = CkJsonObject::ckStringOf(jResp,"records[i].BillingStreet")
BillingCity = CkJsonObject::ckStringOf(jResp,"records[i].BillingCity")
BillingState = CkJsonObject::ckStringOf(jResp,"records[i].BillingState")
BillingPostalCode = CkJsonObject::ckStringOf(jResp,"records[i].BillingPostalCode")
BillingCountry = CkJsonObject::ckStringOf(jResp,"records[i].BillingCountry")
BillingLatitude = CkJsonObject::ckStringOf(jResp,"records[i].BillingLatitude")
BillingLongitude = CkJsonObject::ckStringOf(jResp,"records[i].BillingLongitude")
BillingGeocodeAccuracy = CkJsonObject::ckStringOf(jResp,"records[i].BillingGeocodeAccuracy")
City = CkJsonObject::ckStringOf(jResp,"records[i].BillingAddress.city")
Country = CkJsonObject::ckStringOf(jResp,"records[i].BillingAddress.country")
GeocodeAccuracy = CkJsonObject::ckStringOf(jResp,"records[i].BillingAddress.geocodeAccuracy")
Latitude = CkJsonObject::ckStringOf(jResp,"records[i].BillingAddress.latitude")
Longitude = CkJsonObject::ckStringOf(jResp,"records[i].BillingAddress.longitude")
PostalCode = CkJsonObject::ckStringOf(jResp,"records[i].BillingAddress.postalCode")
State = CkJsonObject::ckStringOf(jResp,"records[i].BillingAddress.state")
Street = CkJsonObject::ckStringOf(jResp,"records[i].BillingAddress.street")
ShippingStreet = CkJsonObject::ckStringOf(jResp,"records[i].ShippingStreet")
ShippingCity = CkJsonObject::ckStringOf(jResp,"records[i].ShippingCity")
ShippingState = CkJsonObject::ckStringOf(jResp,"records[i].ShippingState")
ShippingPostalCode = CkJsonObject::ckStringOf(jResp,"records[i].ShippingPostalCode")
ShippingCountry = CkJsonObject::ckStringOf(jResp,"records[i].ShippingCountry")
ShippingLatitude = CkJsonObject::ckStringOf(jResp,"records[i].ShippingLatitude")
ShippingLongitude = CkJsonObject::ckStringOf(jResp,"records[i].ShippingLongitude")
ShippingGeocodeAccuracy = CkJsonObject::ckStringOf(jResp,"records[i].ShippingGeocodeAccuracy")
ShippingAddress = CkJsonObject::ckStringOf(jResp,"records[i].ShippingAddress")
Phone = CkJsonObject::ckStringOf(jResp,"records[i].Phone")
Fax = CkJsonObject::ckStringOf(jResp,"records[i].Fax")
AccountNumber = CkJsonObject::ckStringOf(jResp,"records[i].AccountNumber")
Website = CkJsonObject::ckStringOf(jResp,"records[i].Website")
PhotoUrl = CkJsonObject::ckStringOf(jResp,"records[i].PhotoUrl")
Sic = CkJsonObject::ckStringOf(jResp,"records[i].Sic")
Industry = CkJsonObject::ckStringOf(jResp,"records[i].Industry")
AnnualRevenue = CkJsonObject::ckIntOf(jResp,"records[i].AnnualRevenue")
NumberOfEmployees = CkJsonObject::ckIntOf(jResp,"records[i].NumberOfEmployees")
Ownership = CkJsonObject::ckStringOf(jResp,"records[i].Ownership")
TickerSymbol = CkJsonObject::ckStringOf(jResp,"records[i].TickerSymbol")
Description = CkJsonObject::ckStringOf(jResp,"records[i].Description")
Rating = CkJsonObject::ckStringOf(jResp,"records[i].Rating")
Site = CkJsonObject::ckStringOf(jResp,"records[i].Site")
OwnerId = CkJsonObject::ckStringOf(jResp,"records[i].OwnerId")
CreatedDate = CkJsonObject::ckStringOf(jResp,"records[i].CreatedDate")
CreatedById = CkJsonObject::ckStringOf(jResp,"records[i].CreatedById")
LastModifiedDate = CkJsonObject::ckStringOf(jResp,"records[i].LastModifiedDate")
LastModifiedById = CkJsonObject::ckStringOf(jResp,"records[i].LastModifiedById")
SystemModstamp = CkJsonObject::ckStringOf(jResp,"records[i].SystemModstamp")
LastActivityDate = CkJsonObject::ckStringOf(jResp,"records[i].LastActivityDate")
LastViewedDate = CkJsonObject::ckStringOf(jResp,"records[i].LastViewedDate")
LastReferencedDate = CkJsonObject::ckStringOf(jResp,"records[i].LastReferencedDate")
IsPartner = CkJsonObject::ckBoolOf(jResp,"records[i].IsPartner")
IsCustomerPortal = CkJsonObject::ckBoolOf(jResp,"records[i].IsCustomerPortal")
ChannelProgramName = CkJsonObject::ckStringOf(jResp,"records[i].ChannelProgramName")
ChannelProgramLevelName = CkJsonObject::ckStringOf(jResp,"records[i].ChannelProgramLevelName")
Jigsaw = CkJsonObject::ckStringOf(jResp,"records[i].Jigsaw")
JigsawCompanyId = CkJsonObject::ckStringOf(jResp,"records[i].JigsawCompanyId")
CleanStatus = CkJsonObject::ckStringOf(jResp,"records[i].CleanStatus")
AccountSource = CkJsonObject::ckStringOf(jResp,"records[i].AccountSource")
DunsNumber = CkJsonObject::ckStringOf(jResp,"records[i].DunsNumber")
Tradestyle = CkJsonObject::ckStringOf(jResp,"records[i].Tradestyle")
NaicsCode = CkJsonObject::ckStringOf(jResp,"records[i].NaicsCode")
NaicsDesc = CkJsonObject::ckStringOf(jResp,"records[i].NaicsDesc")
YearStarted = CkJsonObject::ckStringOf(jResp,"records[i].YearStarted")
SicDesc = CkJsonObject::ckStringOf(jResp,"records[i].SicDesc")
DandbCompanyId = CkJsonObject::ckStringOf(jResp,"records[i].DandbCompanyId")
CustomerPriority__c = CkJsonObject::ckStringOf(jResp,"records[i].CustomerPriority__c")
SLA__c = CkJsonObject::ckStringOf(jResp,"records[i].SLA__c")
Active__c = CkJsonObject::ckStringOf(jResp,"records[i].Active__c")
NumberofLocations__c = CkJsonObject::ckIntOf(jResp,"records[i].NumberofLocations__c")
UpsellOpportunity__c = CkJsonObject::ckStringOf(jResp,"records[i].UpsellOpportunity__c")
SLASerialNumber__c = CkJsonObject::ckStringOf(jResp,"records[i].SLASerialNumber__c")
SLAExpirationDate__c = CkJsonObject::ckStringOf(jResp,"records[i].SLAExpirationDate__c")
ShippingAddressCity = CkJsonObject::ckStringOf(jResp,"records[i].ShippingAddress.city")
ShippingAddressCountry = CkJsonObject::ckStringOf(jResp,"records[i].ShippingAddress.country")
ShippingAddressGeocodeAccuracy = CkJsonObject::ckStringOf(jResp,"records[i].ShippingAddress.geocodeAccuracy")
ShippingAddressLatitude = CkJsonObject::ckStringOf(jResp,"records[i].ShippingAddress.latitude")
ShippingAddressLongitude = CkJsonObject::ckStringOf(jResp,"records[i].ShippingAddress.longitude")
ShippingAddressPostalCode = CkJsonObject::ckStringOf(jResp,"records[i].ShippingAddress.postalCode")
ShippingAddressState = CkJsonObject::ckStringOf(jResp,"records[i].ShippingAddress.state")
ShippingAddressStreet = CkJsonObject::ckStringOf(jResp,"records[i].ShippingAddress.street")
i = i + 1
Wend
CkHttp::ckDispose(http)
CkJsonObject::ckDispose(queryParams)
CkStringBuilder::ckDispose(sbResponseBody)
CkJsonObject::ckDispose(jResp)
ProcedureReturn
EndProcedure
Curl Command
curl -G -d "q=SELECT%20FIELDS%28All%29%20FROM%20ACCOUNT%20ORDER%20BY%20Name%20LIMIT%205"
-H "Authorization: Bearer <access_token>"
-H "Content-Type: application/json"
https://domain.com/services/data/v{{version}}/query/
Postman Collection Item JSON
{
"name": "Query",
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/query/?q=SELECT FIELDS(All) FROM ACCOUNT ORDER BY Name LIMIT 5",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"query",
""
],
"query": [
{
"key": "q",
"value": "SELECT FIELDS(All) FROM ACCOUNT ORDER BY Name LIMIT 5",
"description": "A SOQL query. Note that you will need to replace spaces with “+” characters in your query string to create a valid URI. An example query parameter string might look like: “SELECT+Name+FROM+MyObject”. If the SOQL query string is invalid, a MALFORMED_QUERY response is returned."
}
]
},
"description": "Executes the specified SOQL query.\n\nIf the query results are too large, the response contains the first batch of results and a query identifier in the nextRecordsUrl field of the response. The identifier can be used in an additional request to retrieve the next batch.\nhttps://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/resources_query.htm"
},
"response": [
{
"name": "Query",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/query/?q=SELECT FIELDS(All) FROM ACCOUNT ORDER BY Name LIMIT 5",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"query",
""
],
"query": [
{
"key": "q",
"value": "SELECT FIELDS(All) FROM ACCOUNT ORDER BY Name LIMIT 5",
"description": "A SOQL query. Note that you will need to replace spaces with “+” characters in your query string to create a valid URI. An example query parameter string might look like: “SELECT+Name+FROM+MyObject”. If the SOQL query string is invalid, a MALFORMED_QUERY response is returned."
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Date",
"value": "Wed, 27 Sep 2023 15:27:00 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": "Sforce-Limit-Info",
"value": "api-usage=1/15000"
},
{
"key": "Content-Type",
"value": "application/json;charset=UTF-8"
},
{
"key": "Vary",
"value": "Accept-Encoding"
},
{
"key": "Content-Encoding",
"value": "gzip"
},
{
"key": "Transfer-Encoding",
"value": "chunked"
}
],
"cookie": [
],
"body": "{\n \"totalSize\": 5,\n \"done\": true,\n \"records\": [\n {\n \"attributes\": {\n \"type\": \"Account\",\n \"url\": \"/services/data/v58.0/sobjects/Account/001B000000UnQ2wIAF\"\n },\n \"Id\": \"001B000000UnQ2wIAF\",\n \"IsDeleted\": false,\n \"MasterRecordId\": null,\n \"Name\": \"Burlington Textiles Corp of America\",\n \"Type\": \"Customer - Direct\",\n \"ParentId\": null,\n \"BillingStreet\": \"525 S. Lexington Ave\",\n \"BillingCity\": \"Burlington\",\n \"BillingState\": \"NC\",\n \"BillingPostalCode\": \"27215\",\n \"BillingCountry\": \"USA\",\n \"BillingLatitude\": null,\n \"BillingLongitude\": null,\n \"BillingGeocodeAccuracy\": null,\n \"BillingAddress\": {\n \"city\": \"Burlington\",\n \"country\": \"USA\",\n \"geocodeAccuracy\": null,\n \"latitude\": null,\n \"longitude\": null,\n \"postalCode\": \"27215\",\n \"state\": \"NC\",\n \"street\": \"525 S. Lexington Ave\"\n },\n \"ShippingStreet\": null,\n \"ShippingCity\": null,\n \"ShippingState\": null,\n \"ShippingPostalCode\": null,\n \"ShippingCountry\": null,\n \"ShippingLatitude\": null,\n \"ShippingLongitude\": null,\n \"ShippingGeocodeAccuracy\": null,\n \"ShippingAddress\": null,\n \"Phone\": \"(336) 222-7000\",\n \"Fax\": \"(336) 222-8000\",\n \"AccountNumber\": \"CD656092\",\n \"Website\": \"www.burlington.com\",\n \"PhotoUrl\": \"/services/images/photo/001B000000UnQ2wIAF\",\n \"Sic\": \"546732\",\n \"Industry\": \"Apparel\",\n \"AnnualRevenue\": 350000000,\n \"NumberOfEmployees\": 9000,\n \"Ownership\": \"Public\",\n \"TickerSymbol\": \"BTXT\",\n \"Description\": null,\n \"Rating\": \"Warm\",\n \"Site\": null,\n \"OwnerId\": \"005B0000003TOI6IAO\",\n \"CreatedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"CreatedById\": \"005B0000003TOI6IAO\",\n \"LastModifiedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"LastModifiedById\": \"005B0000003TOI6IAO\",\n \"SystemModstamp\": \"2017-08-18T14:46:22.000+0000\",\n \"LastActivityDate\": null,\n \"LastViewedDate\": null,\n \"LastReferencedDate\": null,\n \"IsPartner\": false,\n \"IsCustomerPortal\": false,\n \"ChannelProgramName\": null,\n \"ChannelProgramLevelName\": null,\n \"Jigsaw\": null,\n \"JigsawCompanyId\": null,\n \"CleanStatus\": \"Pending\",\n \"AccountSource\": null,\n \"DunsNumber\": null,\n \"Tradestyle\": null,\n \"NaicsCode\": null,\n \"NaicsDesc\": null,\n \"YearStarted\": null,\n \"SicDesc\": null,\n \"DandbCompanyId\": null,\n \"CustomerPriority__c\": null,\n \"SLA__c\": \"Silver\",\n \"Active__c\": null,\n \"NumberofLocations__c\": 6,\n \"UpsellOpportunity__c\": \"Maybe\",\n \"SLASerialNumber__c\": \"5367\",\n \"SLAExpirationDate__c\": \"2016-09-12\"\n },\n {\n \"attributes\": {\n \"type\": \"Account\",\n \"url\": \"/services/data/v58.0/sobjects/Account/001B000000UnQ2yIAF\"\n },\n \"Id\": \"001B000000UnQ2yIAF\",\n \"IsDeleted\": false,\n \"MasterRecordId\": null,\n \"Name\": \"Dickenson plc\",\n \"Type\": \"Customer - Channel\",\n \"ParentId\": null,\n \"BillingStreet\": \"1301 Hoch Drive\",\n \"BillingCity\": \"Lawrence\",\n \"BillingState\": \"KS\",\n \"BillingPostalCode\": \"66045\",\n \"BillingCountry\": \"USA\",\n \"BillingLatitude\": null,\n \"BillingLongitude\": null,\n \"BillingGeocodeAccuracy\": null,\n \"BillingAddress\": {\n \"city\": \"Lawrence\",\n \"country\": \"USA\",\n \"geocodeAccuracy\": null,\n \"latitude\": null,\n \"longitude\": null,\n \"postalCode\": \"66045\",\n \"state\": \"KS\",\n \"street\": \"1301 Hoch Drive\"\n },\n \"ShippingStreet\": \"1301 Hoch Drive\",\n \"ShippingCity\": \"Lawrence\",\n \"ShippingState\": \"KS\",\n \"ShippingPostalCode\": \"66045\",\n \"ShippingCountry\": \"USA\",\n \"ShippingLatitude\": null,\n \"ShippingLongitude\": null,\n \"ShippingGeocodeAccuracy\": null,\n \"ShippingAddress\": {\n \"city\": \"Lawrence\",\n \"country\": \"USA\",\n \"geocodeAccuracy\": null,\n \"latitude\": null,\n \"longitude\": null,\n \"postalCode\": \"66045\",\n \"state\": \"KS\",\n \"street\": \"1301 Hoch Drive\"\n },\n \"Phone\": \"(785) 241-6200\",\n \"Fax\": \"(785) 241-6201\",\n \"AccountNumber\": \"CC634267\",\n \"Website\": \"dickenson-consulting.com\",\n \"PhotoUrl\": \"/services/images/photo/001B000000UnQ2yIAF\",\n \"Sic\": \"6752\",\n \"Industry\": \"Consulting\",\n \"AnnualRevenue\": 50000000,\n \"NumberOfEmployees\": 120,\n \"Ownership\": \"Private\",\n \"TickerSymbol\": null,\n \"Description\": null,\n \"Rating\": null,\n \"Site\": null,\n \"OwnerId\": \"005B0000003TOI6IAO\",\n \"CreatedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"CreatedById\": \"005B0000003TOI6IAO\",\n \"LastModifiedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"LastModifiedById\": \"005B0000003TOI6IAO\",\n \"SystemModstamp\": \"2017-08-18T14:46:22.000+0000\",\n \"LastActivityDate\": null,\n \"LastViewedDate\": null,\n \"LastReferencedDate\": null,\n \"IsPartner\": false,\n \"IsCustomerPortal\": false,\n \"ChannelProgramName\": null,\n \"ChannelProgramLevelName\": null,\n \"Jigsaw\": null,\n \"JigsawCompanyId\": null,\n \"CleanStatus\": \"Pending\",\n \"AccountSource\": null,\n \"DunsNumber\": null,\n \"Tradestyle\": null,\n \"NaicsCode\": null,\n \"NaicsDesc\": null,\n \"YearStarted\": null,\n \"SicDesc\": null,\n \"DandbCompanyId\": null,\n \"CustomerPriority__c\": \"Low\",\n \"SLA__c\": \"Bronze\",\n \"Active__c\": \"Yes\",\n \"NumberofLocations__c\": 2,\n \"UpsellOpportunity__c\": \"No\",\n \"SLASerialNumber__c\": \"7425\",\n \"SLAExpirationDate__c\": \"2017-03-15\"\n },\n {\n \"attributes\": {\n \"type\": \"Account\",\n \"url\": \"/services/data/v58.0/sobjects/Account/001B000000UnQ2vIAF\"\n },\n \"Id\": \"001B000000UnQ2vIAF\",\n \"IsDeleted\": false,\n \"MasterRecordId\": null,\n \"Name\": \"Edge Communications\",\n \"Type\": \"Customer - Direct\",\n \"ParentId\": null,\n \"BillingStreet\": \"312 Constitution Place\\nAustin, TX 78767\\nUSA\",\n \"BillingCity\": \"Austin\",\n \"BillingState\": \"TX\",\n \"BillingPostalCode\": null,\n \"BillingCountry\": null,\n \"BillingLatitude\": null,\n \"BillingLongitude\": null,\n \"BillingGeocodeAccuracy\": null,\n \"BillingAddress\": {\n \"city\": \"Austin\",\n \"country\": null,\n \"geocodeAccuracy\": null,\n \"latitude\": null,\n \"longitude\": null,\n \"postalCode\": null,\n \"state\": \"TX\",\n \"street\": \"312 Constitution Place\\nAustin, TX 78767\\nUSA\"\n },\n \"ShippingStreet\": \"312 Constitution Place\\nAustin, TX 78767\\nUSA\",\n \"ShippingCity\": null,\n \"ShippingState\": null,\n \"ShippingPostalCode\": null,\n \"ShippingCountry\": null,\n \"ShippingLatitude\": null,\n \"ShippingLongitude\": null,\n \"ShippingGeocodeAccuracy\": null,\n \"ShippingAddress\": {\n \"city\": null,\n \"country\": null,\n \"geocodeAccuracy\": null,\n \"latitude\": null,\n \"longitude\": null,\n \"postalCode\": null,\n \"state\": null,\n \"street\": \"312 Constitution Place\\nAustin, TX 78767\\nUSA\"\n },\n \"Phone\": \"(512) 757-6000\",\n \"Fax\": \"(512) 757-9000\",\n \"AccountNumber\": \"CD451796\",\n \"Website\": \"http://edgecomm.com\",\n \"PhotoUrl\": \"/services/images/photo/001B000000UnQ2vIAF\",\n \"Sic\": \"6576\",\n \"Industry\": \"Electronics\",\n \"AnnualRevenue\": 139000000,\n \"NumberOfEmployees\": 1000,\n \"Ownership\": \"Public\",\n \"TickerSymbol\": \"EDGE\",\n \"Description\": \"Edge, founded in 1998, is a start-up based in Austin, TX. The company designs and manufactures a device to convert music from one digital format to another. Edge sells its product through retailers and its own website.\",\n \"Rating\": \"Hot\",\n \"Site\": null,\n \"OwnerId\": \"005B0000003TOI6IAO\",\n \"CreatedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"CreatedById\": \"005B0000003TOI6IAO\",\n \"LastModifiedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"LastModifiedById\": \"005B0000003TOI6IAO\",\n \"SystemModstamp\": \"2017-08-18T14:46:22.000+0000\",\n \"LastActivityDate\": null,\n \"LastViewedDate\": null,\n \"LastReferencedDate\": null,\n \"IsPartner\": false,\n \"IsCustomerPortal\": false,\n \"ChannelProgramName\": null,\n \"ChannelProgramLevelName\": null,\n \"Jigsaw\": null,\n \"JigsawCompanyId\": null,\n \"CleanStatus\": \"Pending\",\n \"AccountSource\": null,\n \"DunsNumber\": null,\n \"Tradestyle\": null,\n \"NaicsCode\": null,\n \"NaicsDesc\": null,\n \"YearStarted\": null,\n \"SicDesc\": null,\n \"DandbCompanyId\": null,\n \"CustomerPriority__c\": \"Medium\",\n \"SLA__c\": \"Silver\",\n \"Active__c\": \"Yes\",\n \"NumberofLocations__c\": 2,\n \"UpsellOpportunity__c\": \"Maybe\",\n \"SLASerialNumber__c\": \"2657\",\n \"SLAExpirationDate__c\": \"2016-09-12\"\n },\n {\n \"attributes\": {\n \"type\": \"Account\",\n \"url\": \"/services/data/v58.0/sobjects/Account/001B000000UnQ31IAF\"\n },\n \"Id\": \"001B000000UnQ31IAF\",\n \"IsDeleted\": false,\n \"MasterRecordId\": null,\n \"Name\": \"Express Logistics and Transport\",\n \"Type\": \"Customer - Channel\",\n \"ParentId\": null,\n \"BillingStreet\": \"620 SW 5th Avenue Suite 400\\nPortland, Oregon 97204\\nUnited States\",\n \"BillingCity\": \"Portland\",\n \"BillingState\": \"OR\",\n \"BillingPostalCode\": null,\n \"BillingCountry\": null,\n \"BillingLatitude\": null,\n \"BillingLongitude\": null,\n \"BillingGeocodeAccuracy\": null,\n \"BillingAddress\": {\n \"city\": \"Portland\",\n \"country\": null,\n \"geocodeAccuracy\": null,\n \"latitude\": null,\n \"longitude\": null,\n \"postalCode\": null,\n \"state\": \"OR\",\n \"street\": \"620 SW 5th Avenue Suite 400\\nPortland, Oregon 97204\\nUnited States\"\n },\n \"ShippingStreet\": \"620 SW 5th Avenue Suite 400\\nPortland, Oregon 97204\\nUnited States\",\n \"ShippingCity\": null,\n \"ShippingState\": null,\n \"ShippingPostalCode\": null,\n \"ShippingCountry\": null,\n \"ShippingLatitude\": null,\n \"ShippingLongitude\": null,\n \"ShippingGeocodeAccuracy\": null,\n \"ShippingAddress\": {\n \"city\": null,\n \"country\": null,\n \"geocodeAccuracy\": null,\n \"latitude\": null,\n \"longitude\": null,\n \"postalCode\": null,\n \"state\": null,\n \"street\": \"620 SW 5th Avenue Suite 400\\nPortland, Oregon 97204\\nUnited States\"\n },\n \"Phone\": \"(503) 421-7800\",\n \"Fax\": \"(503) 421-7801\",\n \"AccountNumber\": \"CC947211\",\n \"Website\": \"www.expressl&t.net\",\n \"PhotoUrl\": \"/services/images/photo/001B000000UnQ31IAF\",\n \"Sic\": \"8742\",\n \"Industry\": \"Transportation\",\n \"AnnualRevenue\": 950000000,\n \"NumberOfEmployees\": 12300,\n \"Ownership\": \"Public\",\n \"TickerSymbol\": \"EXLT\",\n \"Description\": \"Commerical logistics and transportation company.\",\n \"Rating\": \"Cold\",\n \"Site\": null,\n \"OwnerId\": \"005B0000003TOI6IAO\",\n \"CreatedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"CreatedById\": \"005B0000003TOI6IAO\",\n \"LastModifiedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"LastModifiedById\": \"005B0000003TOI6IAO\",\n \"SystemModstamp\": \"2017-08-18T14:46:22.000+0000\",\n \"LastActivityDate\": null,\n \"LastViewedDate\": null,\n \"LastReferencedDate\": null,\n \"IsPartner\": false,\n \"IsCustomerPortal\": false,\n \"ChannelProgramName\": null,\n \"ChannelProgramLevelName\": null,\n \"Jigsaw\": null,\n \"JigsawCompanyId\": null,\n \"CleanStatus\": \"Pending\",\n \"AccountSource\": null,\n \"DunsNumber\": null,\n \"Tradestyle\": null,\n \"NaicsCode\": null,\n \"NaicsDesc\": null,\n \"YearStarted\": null,\n \"SicDesc\": null,\n \"DandbCompanyId\": null,\n \"CustomerPriority__c\": \"Medium\",\n \"SLA__c\": \"Platinum\",\n \"Active__c\": \"Yes\",\n \"NumberofLocations__c\": 150,\n \"UpsellOpportunity__c\": \"Maybe\",\n \"SLASerialNumber__c\": \"4724\",\n \"SLAExpirationDate__c\": \"2017-03-15\"\n },\n {\n \"attributes\": {\n \"type\": \"Account\",\n \"url\": \"/services/data/v58.0/sobjects/Account/001B000000UnQ35IAF\"\n },\n \"Id\": \"001B000000UnQ35IAF\",\n \"IsDeleted\": false,\n \"MasterRecordId\": null,\n \"Name\": \"GenePoint\",\n \"Type\": \"Customer - Channel\",\n \"ParentId\": null,\n \"BillingStreet\": \"345 Shoreline Park\\nMountain View, CA 94043\\nUSA\",\n \"BillingCity\": \"Mountain View\",\n \"BillingState\": \"CA\",\n \"BillingPostalCode\": null,\n \"BillingCountry\": null,\n \"BillingLatitude\": null,\n \"BillingLongitude\": null,\n \"BillingGeocodeAccuracy\": null,\n \"BillingAddress\": {\n \"city\": \"Mountain View\",\n \"country\": null,\n \"geocodeAccuracy\": null,\n \"latitude\": null,\n \"longitude\": null,\n \"postalCode\": null,\n \"state\": \"CA\",\n \"street\": \"345 Shoreline Park\\nMountain View, CA 94043\\nUSA\"\n },\n \"ShippingStreet\": \"345 Shoreline Park\\nMountain View, CA 94043\\nUSA\",\n \"ShippingCity\": null,\n \"ShippingState\": null,\n \"ShippingPostalCode\": null,\n \"ShippingCountry\": null,\n \"ShippingLatitude\": null,\n \"ShippingLongitude\": null,\n \"ShippingGeocodeAccuracy\": null,\n \"ShippingAddress\": {\n \"city\": null,\n \"country\": null,\n \"geocodeAccuracy\": null,\n \"latitude\": null,\n \"longitude\": null,\n \"postalCode\": null,\n \"state\": null,\n \"street\": \"345 Shoreline Park\\nMountain View, CA 94043\\nUSA\"\n },\n \"Phone\": \"(650) 867-3450\",\n \"Fax\": \"(650) 867-9895\",\n \"AccountNumber\": \"CC978213\",\n \"Website\": \"www.genepoint.com\",\n \"PhotoUrl\": \"/services/images/photo/001B000000UnQ35IAF\",\n \"Sic\": \"3712\",\n \"Industry\": \"Biotechnology\",\n \"AnnualRevenue\": 30000000,\n \"NumberOfEmployees\": 265,\n \"Ownership\": \"Private\",\n \"TickerSymbol\": null,\n \"Description\": \"Genomics company engaged in mapping and sequencing of the human genome and developing gene-based drugs\",\n \"Rating\": \"Cold\",\n \"Site\": null,\n \"OwnerId\": \"005B0000003TOI6IAO\",\n \"CreatedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"CreatedById\": \"005B0000003TOI6IAO\",\n \"LastModifiedDate\": \"2017-08-18T14:46:22.000+0000\",\n \"LastModifiedById\": \"005B0000003TOI6IAO\",\n \"SystemModstamp\": \"2017-08-18T14:46:22.000+0000\",\n \"LastActivityDate\": null,\n \"LastViewedDate\": null,\n \"LastReferencedDate\": null,\n \"IsPartner\": false,\n \"IsCustomerPortal\": false,\n \"ChannelProgramName\": null,\n \"ChannelProgramLevelName\": null,\n \"Jigsaw\": null,\n \"JigsawCompanyId\": null,\n \"CleanStatus\": \"Pending\",\n \"AccountSource\": null,\n \"DunsNumber\": null,\n \"Tradestyle\": null,\n \"NaicsCode\": null,\n \"NaicsDesc\": null,\n \"YearStarted\": null,\n \"SicDesc\": null,\n \"DandbCompanyId\": null,\n \"CustomerPriority__c\": \"Low\",\n \"SLA__c\": \"Bronze\",\n \"Active__c\": \"Yes\",\n \"NumberofLocations__c\": 1,\n \"UpsellOpportunity__c\": \"Yes\",\n \"SLASerialNumber__c\": \"7324\",\n \"SLAExpirationDate__c\": \"2017-03-15\"\n }\n ]\n}"
}
]
}
