Back to Collection Items
LOCAL loHttp
LOCAL lnSuccess
LOCAL loQueryParams
LOCAL loResp
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcV_Type
LOCAL lcV_Url
LOCAL lcId
LOCAL lnIsDeleted
LOCAL lcMasterRecordId
LOCAL lcName
LOCAL lcParentId
LOCAL lcBillingStreet
LOCAL lcBillingCity
LOCAL lcBillingState
LOCAL lcBillingPostalCode
LOCAL lcBillingCountry
LOCAL lcBillingLatitude
LOCAL lcBillingLongitude
LOCAL lcBillingGeocodeAccuracy
LOCAL lcCity
LOCAL lcCountry
LOCAL lcGeocodeAccuracy
LOCAL lcLatitude
LOCAL lcLongitude
LOCAL lcPostalCode
LOCAL lcState
LOCAL lcStreet
LOCAL lcShippingStreet
LOCAL lcShippingCity
LOCAL lcShippingState
LOCAL lcShippingPostalCode
LOCAL lcShippingCountry
LOCAL lcShippingLatitude
LOCAL lcShippingLongitude
LOCAL lcShippingGeocodeAccuracy
LOCAL lcShippingAddress
LOCAL lcPhone
LOCAL lcFax
LOCAL lcAccountNumber
LOCAL lcWebsite
LOCAL lcPhotoUrl
LOCAL lcSic
LOCAL lcIndustry
LOCAL lnAnnualRevenue
LOCAL lnNumberOfEmployees
LOCAL lcOwnership
LOCAL lcTickerSymbol
LOCAL lcDescription
LOCAL lcRating
LOCAL lcSite
LOCAL lcOwnerId
LOCAL lcCreatedDate
LOCAL lcCreatedById
LOCAL lcLastModifiedDate
LOCAL lcLastModifiedById
LOCAL lcSystemModstamp
LOCAL lcLastActivityDate
LOCAL lcLastViewedDate
LOCAL lcLastReferencedDate
LOCAL lnIsPartner
LOCAL lnIsCustomerPortal
LOCAL lcChannelProgramName
LOCAL lcChannelProgramLevelName
LOCAL lcJigsaw
LOCAL lcJigsawCompanyId
LOCAL lcCleanStatus
LOCAL lcAccountSource
LOCAL lcDunsNumber
LOCAL lcTradestyle
LOCAL lcNaicsCode
LOCAL lcNaicsDesc
LOCAL lcYearStarted
LOCAL lcSicDesc
LOCAL lcDandbCompanyId
LOCAL lcCustomerPriority__c
LOCAL lcSLA__c
LOCAL lcActive__c
LOCAL lnNumberofLocations__c
LOCAL lcUpsellOpportunity__c
LOCAL lcSLASerialNumber__c
LOCAL lcSLAExpirationDate__c
LOCAL lcShippingAddressCity
LOCAL lcShippingAddressCountry
LOCAL lcShippingAddressGeocodeAccuracy
LOCAL lcShippingAddressLatitude
LOCAL lcShippingAddressLongitude
LOCAL lcShippingAddressPostalCode
LOCAL lcShippingAddressState
LOCAL lcShippingAddressStreet
LOCAL lnTotalSize
LOCAL lnDone
LOCAL i
LOCAL lnCount_i
* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loQueryParams = CreateObject('Chilkat.JsonObject')
loQueryParams.UpdateString("q","SELECT FIELDS(All) FROM ACCOUNT ORDER BY Name LIMIT 5")
* Adds the "Authorization: Bearer <access_token>" header.
loHttp.AuthToken = "<access_token>"
loHttp.SetRequestHeader("Content-Type","application/json")
loResp = loHttp.QuickRequestParams("GET","https://domain.com/services/data/v{{version}}/query/",loQueryParams)
IF (loHttp.LastMethodSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loQueryParams
CANCEL
ENDIF
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbResponseBody = CreateObject('Chilkat.StringBuilder')
loResp.GetBodySb(loSbResponseBody)
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJResp = CreateObject('Chilkat.JsonObject')
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = 0
? "Response Body:"
? loJResp.Emit()
lnRespStatusCode = loResp.StatusCode
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
? "Response Header:"
? loResp.Header
? "Failed."
RELEASE loResp
RELEASE loHttp
RELEASE loQueryParams
RELEASE loSbResponseBody
RELEASE loJResp
CANCEL
ENDIF
RELEASE loResp
* 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
lnTotalSize = loJResp.IntOf("totalSize")
lnDone = loJResp.BoolOf("done")
i = 0
lnCount_i = loJResp.SizeOfArray("records")
DO WHILE i < lnCount_i
loJResp.I = i
lcV_Type = loJResp.StringOf("records[i].attributes.type")
lcV_Url = loJResp.StringOf("records[i].attributes.url")
lcId = loJResp.StringOf("records[i].Id")
lnIsDeleted = loJResp.BoolOf("records[i].IsDeleted")
lcMasterRecordId = loJResp.StringOf("records[i].MasterRecordId")
lcName = loJResp.StringOf("records[i].Name")
lcV_Type = loJResp.StringOf("records[i].Type")
lcParentId = loJResp.StringOf("records[i].ParentId")
lcBillingStreet = loJResp.StringOf("records[i].BillingStreet")
lcBillingCity = loJResp.StringOf("records[i].BillingCity")
lcBillingState = loJResp.StringOf("records[i].BillingState")
lcBillingPostalCode = loJResp.StringOf("records[i].BillingPostalCode")
lcBillingCountry = loJResp.StringOf("records[i].BillingCountry")
lcBillingLatitude = loJResp.StringOf("records[i].BillingLatitude")
lcBillingLongitude = loJResp.StringOf("records[i].BillingLongitude")
lcBillingGeocodeAccuracy = loJResp.StringOf("records[i].BillingGeocodeAccuracy")
lcCity = loJResp.StringOf("records[i].BillingAddress.city")
lcCountry = loJResp.StringOf("records[i].BillingAddress.country")
lcGeocodeAccuracy = loJResp.StringOf("records[i].BillingAddress.geocodeAccuracy")
lcLatitude = loJResp.StringOf("records[i].BillingAddress.latitude")
lcLongitude = loJResp.StringOf("records[i].BillingAddress.longitude")
lcPostalCode = loJResp.StringOf("records[i].BillingAddress.postalCode")
lcState = loJResp.StringOf("records[i].BillingAddress.state")
lcStreet = loJResp.StringOf("records[i].BillingAddress.street")
lcShippingStreet = loJResp.StringOf("records[i].ShippingStreet")
lcShippingCity = loJResp.StringOf("records[i].ShippingCity")
lcShippingState = loJResp.StringOf("records[i].ShippingState")
lcShippingPostalCode = loJResp.StringOf("records[i].ShippingPostalCode")
lcShippingCountry = loJResp.StringOf("records[i].ShippingCountry")
lcShippingLatitude = loJResp.StringOf("records[i].ShippingLatitude")
lcShippingLongitude = loJResp.StringOf("records[i].ShippingLongitude")
lcShippingGeocodeAccuracy = loJResp.StringOf("records[i].ShippingGeocodeAccuracy")
lcShippingAddress = loJResp.StringOf("records[i].ShippingAddress")
lcPhone = loJResp.StringOf("records[i].Phone")
lcFax = loJResp.StringOf("records[i].Fax")
lcAccountNumber = loJResp.StringOf("records[i].AccountNumber")
lcWebsite = loJResp.StringOf("records[i].Website")
lcPhotoUrl = loJResp.StringOf("records[i].PhotoUrl")
lcSic = loJResp.StringOf("records[i].Sic")
lcIndustry = loJResp.StringOf("records[i].Industry")
lnAnnualRevenue = loJResp.IntOf("records[i].AnnualRevenue")
lnNumberOfEmployees = loJResp.IntOf("records[i].NumberOfEmployees")
lcOwnership = loJResp.StringOf("records[i].Ownership")
lcTickerSymbol = loJResp.StringOf("records[i].TickerSymbol")
lcDescription = loJResp.StringOf("records[i].Description")
lcRating = loJResp.StringOf("records[i].Rating")
lcSite = loJResp.StringOf("records[i].Site")
lcOwnerId = loJResp.StringOf("records[i].OwnerId")
lcCreatedDate = loJResp.StringOf("records[i].CreatedDate")
lcCreatedById = loJResp.StringOf("records[i].CreatedById")
lcLastModifiedDate = loJResp.StringOf("records[i].LastModifiedDate")
lcLastModifiedById = loJResp.StringOf("records[i].LastModifiedById")
lcSystemModstamp = loJResp.StringOf("records[i].SystemModstamp")
lcLastActivityDate = loJResp.StringOf("records[i].LastActivityDate")
lcLastViewedDate = loJResp.StringOf("records[i].LastViewedDate")
lcLastReferencedDate = loJResp.StringOf("records[i].LastReferencedDate")
lnIsPartner = loJResp.BoolOf("records[i].IsPartner")
lnIsCustomerPortal = loJResp.BoolOf("records[i].IsCustomerPortal")
lcChannelProgramName = loJResp.StringOf("records[i].ChannelProgramName")
lcChannelProgramLevelName = loJResp.StringOf("records[i].ChannelProgramLevelName")
lcJigsaw = loJResp.StringOf("records[i].Jigsaw")
lcJigsawCompanyId = loJResp.StringOf("records[i].JigsawCompanyId")
lcCleanStatus = loJResp.StringOf("records[i].CleanStatus")
lcAccountSource = loJResp.StringOf("records[i].AccountSource")
lcDunsNumber = loJResp.StringOf("records[i].DunsNumber")
lcTradestyle = loJResp.StringOf("records[i].Tradestyle")
lcNaicsCode = loJResp.StringOf("records[i].NaicsCode")
lcNaicsDesc = loJResp.StringOf("records[i].NaicsDesc")
lcYearStarted = loJResp.StringOf("records[i].YearStarted")
lcSicDesc = loJResp.StringOf("records[i].SicDesc")
lcDandbCompanyId = loJResp.StringOf("records[i].DandbCompanyId")
lcCustomerPriority__c = loJResp.StringOf("records[i].CustomerPriority__c")
lcSLA__c = loJResp.StringOf("records[i].SLA__c")
lcActive__c = loJResp.StringOf("records[i].Active__c")
lnNumberofLocations__c = loJResp.IntOf("records[i].NumberofLocations__c")
lcUpsellOpportunity__c = loJResp.StringOf("records[i].UpsellOpportunity__c")
lcSLASerialNumber__c = loJResp.StringOf("records[i].SLASerialNumber__c")
lcSLAExpirationDate__c = loJResp.StringOf("records[i].SLAExpirationDate__c")
lcShippingAddressCity = loJResp.StringOf("records[i].ShippingAddress.city")
lcShippingAddressCountry = loJResp.StringOf("records[i].ShippingAddress.country")
lcShippingAddressGeocodeAccuracy = loJResp.StringOf("records[i].ShippingAddress.geocodeAccuracy")
lcShippingAddressLatitude = loJResp.StringOf("records[i].ShippingAddress.latitude")
lcShippingAddressLongitude = loJResp.StringOf("records[i].ShippingAddress.longitude")
lcShippingAddressPostalCode = loJResp.StringOf("records[i].ShippingAddress.postalCode")
lcShippingAddressState = loJResp.StringOf("records[i].ShippingAddress.state")
lcShippingAddressStreet = loJResp.StringOf("records[i].ShippingAddress.street")
i = i + 1
ENDDO
RELEASE loHttp
RELEASE loQueryParams
RELEASE loSbResponseBody
RELEASE loJResp
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}"
}
]
}
