Back to Collection Items
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim http As New Chilkat.Http
Dim success As Boolean
Dim queryParams As New Chilkat.JsonObject
queryParams.UpdateString("q","SELECT FIELDS(All) FROM ACCOUNT ORDER BY Name LIMIT 5")
' Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken = "<access_token>"
http.SetRequestHeader("Content-Type","application/json")
Dim resp As Chilkat.HttpResponse = http.QuickRequestParams("GET","https://domain.com/services/data/v{{version}}/query/",queryParams)
If (http.LastMethodSuccess = False) Then
Debug.WriteLine(http.LastErrorText)
Exit Sub
End If
Dim sbResponseBody As New Chilkat.StringBuilder
resp.GetBodySb(sbResponseBody)
Dim jResp As New Chilkat.JsonObject
jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False
Debug.WriteLine("Response Body:")
Debug.WriteLine(jResp.Emit())
Dim respStatusCode As Integer = resp.StatusCode
Debug.WriteLine("Response Status Code = " & respStatusCode)
If (respStatusCode >= 400) Then
Debug.WriteLine("Response Header:")
Debug.WriteLine(resp.Header)
Debug.WriteLine("Failed.")
Exit Sub
End If
' 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
Dim v_Type As String
Dim v_Url As String
Dim Id As String
Dim IsDeleted As Boolean
Dim MasterRecordId As String
Dim Name As String
Dim ParentId As String
Dim BillingStreet As String
Dim BillingCity As String
Dim BillingState As String
Dim BillingPostalCode As String
Dim BillingCountry As String
Dim BillingLatitude As String
Dim BillingLongitude As String
Dim BillingGeocodeAccuracy As String
Dim City As String
Dim Country As String
Dim GeocodeAccuracy As String
Dim Latitude As String
Dim Longitude As String
Dim PostalCode As String
Dim State As String
Dim Street As String
Dim ShippingStreet As String
Dim ShippingCity As String
Dim ShippingState As String
Dim ShippingPostalCode As String
Dim ShippingCountry As String
Dim ShippingLatitude As String
Dim ShippingLongitude As String
Dim ShippingGeocodeAccuracy As String
Dim ShippingAddress As String
Dim Phone As String
Dim Fax As String
Dim AccountNumber As String
Dim Website As String
Dim PhotoUrl As String
Dim Sic As String
Dim Industry As String
Dim AnnualRevenue As Integer
Dim NumberOfEmployees As Integer
Dim Ownership As String
Dim TickerSymbol As String
Dim Description As String
Dim Rating As String
Dim Site As String
Dim OwnerId As String
Dim CreatedDate As String
Dim CreatedById As String
Dim LastModifiedDate As String
Dim LastModifiedById As String
Dim SystemModstamp As String
Dim LastActivityDate As String
Dim LastViewedDate As String
Dim LastReferencedDate As String
Dim IsPartner As Boolean
Dim IsCustomerPortal As Boolean
Dim ChannelProgramName As String
Dim ChannelProgramLevelName As String
Dim Jigsaw As String
Dim JigsawCompanyId As String
Dim CleanStatus As String
Dim AccountSource As String
Dim DunsNumber As String
Dim Tradestyle As String
Dim NaicsCode As String
Dim NaicsDesc As String
Dim YearStarted As String
Dim SicDesc As String
Dim DandbCompanyId As String
Dim CustomerPriority__c As String
Dim SLA__c As String
Dim Active__c As String
Dim NumberofLocations__c As Integer
Dim UpsellOpportunity__c As String
Dim SLASerialNumber__c As String
Dim SLAExpirationDate__c As String
Dim ShippingAddressCity As String
Dim ShippingAddressCountry As String
Dim ShippingAddressGeocodeAccuracy As String
Dim ShippingAddressLatitude As String
Dim ShippingAddressLongitude As String
Dim ShippingAddressPostalCode As String
Dim ShippingAddressState As String
Dim ShippingAddressStreet As String
Dim totalSize As Integer = jResp.IntOf("totalSize")
Dim done As Boolean = jResp.BoolOf("done")
Dim i As Integer = 0
Dim count_i As Integer = jResp.SizeOfArray("records")
While i < count_i
jResp.I = i
v_Type = jResp.StringOf("records[i].attributes.type")
v_Url = jResp.StringOf("records[i].attributes.url")
Id = jResp.StringOf("records[i].Id")
IsDeleted = jResp.BoolOf("records[i].IsDeleted")
MasterRecordId = jResp.StringOf("records[i].MasterRecordId")
Name = jResp.StringOf("records[i].Name")
v_Type = jResp.StringOf("records[i].Type")
ParentId = jResp.StringOf("records[i].ParentId")
BillingStreet = jResp.StringOf("records[i].BillingStreet")
BillingCity = jResp.StringOf("records[i].BillingCity")
BillingState = jResp.StringOf("records[i].BillingState")
BillingPostalCode = jResp.StringOf("records[i].BillingPostalCode")
BillingCountry = jResp.StringOf("records[i].BillingCountry")
BillingLatitude = jResp.StringOf("records[i].BillingLatitude")
BillingLongitude = jResp.StringOf("records[i].BillingLongitude")
BillingGeocodeAccuracy = jResp.StringOf("records[i].BillingGeocodeAccuracy")
City = jResp.StringOf("records[i].BillingAddress.city")
Country = jResp.StringOf("records[i].BillingAddress.country")
GeocodeAccuracy = jResp.StringOf("records[i].BillingAddress.geocodeAccuracy")
Latitude = jResp.StringOf("records[i].BillingAddress.latitude")
Longitude = jResp.StringOf("records[i].BillingAddress.longitude")
PostalCode = jResp.StringOf("records[i].BillingAddress.postalCode")
State = jResp.StringOf("records[i].BillingAddress.state")
Street = jResp.StringOf("records[i].BillingAddress.street")
ShippingStreet = jResp.StringOf("records[i].ShippingStreet")
ShippingCity = jResp.StringOf("records[i].ShippingCity")
ShippingState = jResp.StringOf("records[i].ShippingState")
ShippingPostalCode = jResp.StringOf("records[i].ShippingPostalCode")
ShippingCountry = jResp.StringOf("records[i].ShippingCountry")
ShippingLatitude = jResp.StringOf("records[i].ShippingLatitude")
ShippingLongitude = jResp.StringOf("records[i].ShippingLongitude")
ShippingGeocodeAccuracy = jResp.StringOf("records[i].ShippingGeocodeAccuracy")
ShippingAddress = jResp.StringOf("records[i].ShippingAddress")
Phone = jResp.StringOf("records[i].Phone")
Fax = jResp.StringOf("records[i].Fax")
AccountNumber = jResp.StringOf("records[i].AccountNumber")
Website = jResp.StringOf("records[i].Website")
PhotoUrl = jResp.StringOf("records[i].PhotoUrl")
Sic = jResp.StringOf("records[i].Sic")
Industry = jResp.StringOf("records[i].Industry")
AnnualRevenue = jResp.IntOf("records[i].AnnualRevenue")
NumberOfEmployees = jResp.IntOf("records[i].NumberOfEmployees")
Ownership = jResp.StringOf("records[i].Ownership")
TickerSymbol = jResp.StringOf("records[i].TickerSymbol")
Description = jResp.StringOf("records[i].Description")
Rating = jResp.StringOf("records[i].Rating")
Site = jResp.StringOf("records[i].Site")
OwnerId = jResp.StringOf("records[i].OwnerId")
CreatedDate = jResp.StringOf("records[i].CreatedDate")
CreatedById = jResp.StringOf("records[i].CreatedById")
LastModifiedDate = jResp.StringOf("records[i].LastModifiedDate")
LastModifiedById = jResp.StringOf("records[i].LastModifiedById")
SystemModstamp = jResp.StringOf("records[i].SystemModstamp")
LastActivityDate = jResp.StringOf("records[i].LastActivityDate")
LastViewedDate = jResp.StringOf("records[i].LastViewedDate")
LastReferencedDate = jResp.StringOf("records[i].LastReferencedDate")
IsPartner = jResp.BoolOf("records[i].IsPartner")
IsCustomerPortal = jResp.BoolOf("records[i].IsCustomerPortal")
ChannelProgramName = jResp.StringOf("records[i].ChannelProgramName")
ChannelProgramLevelName = jResp.StringOf("records[i].ChannelProgramLevelName")
Jigsaw = jResp.StringOf("records[i].Jigsaw")
JigsawCompanyId = jResp.StringOf("records[i].JigsawCompanyId")
CleanStatus = jResp.StringOf("records[i].CleanStatus")
AccountSource = jResp.StringOf("records[i].AccountSource")
DunsNumber = jResp.StringOf("records[i].DunsNumber")
Tradestyle = jResp.StringOf("records[i].Tradestyle")
NaicsCode = jResp.StringOf("records[i].NaicsCode")
NaicsDesc = jResp.StringOf("records[i].NaicsDesc")
YearStarted = jResp.StringOf("records[i].YearStarted")
SicDesc = jResp.StringOf("records[i].SicDesc")
DandbCompanyId = jResp.StringOf("records[i].DandbCompanyId")
CustomerPriority__c = jResp.StringOf("records[i].CustomerPriority__c")
SLA__c = jResp.StringOf("records[i].SLA__c")
Active__c = jResp.StringOf("records[i].Active__c")
NumberofLocations__c = jResp.IntOf("records[i].NumberofLocations__c")
UpsellOpportunity__c = jResp.StringOf("records[i].UpsellOpportunity__c")
SLASerialNumber__c = jResp.StringOf("records[i].SLASerialNumber__c")
SLAExpirationDate__c = jResp.StringOf("records[i].SLAExpirationDate__c")
ShippingAddressCity = jResp.StringOf("records[i].ShippingAddress.city")
ShippingAddressCountry = jResp.StringOf("records[i].ShippingAddress.country")
ShippingAddressGeocodeAccuracy = jResp.StringOf("records[i].ShippingAddress.geocodeAccuracy")
ShippingAddressLatitude = jResp.StringOf("records[i].ShippingAddress.latitude")
ShippingAddressLongitude = jResp.StringOf("records[i].ShippingAddress.longitude")
ShippingAddressPostalCode = jResp.StringOf("records[i].ShippingAddress.postalCode")
ShippingAddressState = jResp.StringOf("records[i].ShippingAddress.state")
ShippingAddressStreet = jResp.StringOf("records[i].ShippingAddress.street")
i = i + 1
End While
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}"
}
]
}
