DatacloudDandBCompany SOQL Request and Response
Use a SOQL request to search the Data.com database for companies with D&B data.
There is a 24-hour rolling quota on the number of API calls that you can make. Your organization gets 1,000 daily calls for every Data.com Prospector license purchased. For example, an organization with 10 prospector licenses has a daily limit of 10,000 Search API calls (1,000 x 10 = 10,000). Call quotas are implemented at the Salesforce organization level.
When no LIMIT
is specified, queryMore()
returns the entire response in 25-record chunks. You can scroll through the full set of results 25 records at a time.
A LIMIT
that’s set from 1 and 100 returns the actual number of records or the number of records equal to the LIMIT
value, whichever is fewer. This query returns only the first 75 records from a response that contains more than 1,000 records. A next page is not returned.
Specify a LIMIT
greater than or equal to the number of records in the response to scroll through large responses in 100-record chunks. For example, in a response with 1,900 records and a LIMIT
that’s set to 2,000, you can scroll through the complete response in chunks of 100 records. You can only scroll through as many records as are specified in the LIMIT
. If your LIMIT
is less than the number of records in the response, queryMore()
processes only the number of records that’s specified in the LIMIT
value.
You can also scroll through query results by using LIMIT
and OFFSET
in your SOQL statement.
LIMIT
: Specifies the number of results that are displayed per page. ALIMIT
of 100 displays 100 records for each page of the results.OFFSET
: Specifies at which record the results start to display. An offset of 100 would start displaying results from the one hundred and first (101) record.
Use a LIMIT
clause in combination with OFFSET
if you need to retrieve subsequent subsets of the same result set. For example, retrieve the first 100 rows of a query using the following:
You could then retrieve the next 100 rows, 101 through 200, using the following query:
Keep incrementing the OFFSET
to scroll through all the results.
OFFSET
has a limit of 2000. Your query fails with an OFFSET
of 2001 or greater.
The maximum LIMIT
is 100. A query with a LIMIT
greater than 100 defaults to 100
Here is a list of the logical operators that are supported in SOQL queries with the DatacloudDandBCompany object.
This table lists the fields that you can use with specific logical operators to construct your SOQL query.
Field | = | != | < | <= | > | >= | LIKE | IN | NOT IN | ORDER BY |
---|---|---|---|---|---|---|---|---|---|---|
CompanyId | √ | √ | ||||||||
DunsNumber | √ | √ | ||||||||
GlobalUltimateDunsNumber | √ | |||||||||
LocationStatus | √ | √ | ||||||||
Name | √ | √ | √ | |||||||
ParentOrHqDunsNumber | √ |
Here are some tips on how logical operators work with which fields in DatacloudDandBCompany queries.
The Datacloud objects directly query the Data.com database cache. The queries are passed directly to Data.com. Some of the fields and logical operators execute queries differently than standard Salesforce objects do. Query results can differ from expected. The following table provides details about those differences.
-
=
An exact search on the value entered. It must be enclosed in single quotation marks.
-
IN
Searches for a nine-digit number assigned by Dun & Bradstreet (D&B) to identify unique business establishments.
-
=
An exact search on the value entered. It must be enclosed in single quotation marks.
-
LIKE
Does a fuzzy search on the string that was entered. Also searches the Tradestyle1 and URL fields.