Filing Office Lookup
Also known as Search by Filing Number
| Product Code(s) | Not Applicable |
| Option(s) | None |
| Monitoring Available | No |
| Interface | REST |
| Method | GET |
| Format(s) | JSON |
| Service | Company |
| {version} | 4.0 |
| 4.0 Released On | October 3, 2013 |
Update History
No modifications have been made to this data layer since the initial release.
Feature Request
IMPORTANT: Please see the new Online Services Security Enhancement Release, effective November 09, 2020.
Overview
When utilizing this D&B Direct feature, a filing number, encoded filing type, case-sensitive filing location state abbreviation and country code of "US" will be required.
This feature provides information for the following filing types: Suit, Lien, Judgment, UCC, Business Registration, and Bankruptcy.
Data Layer Entitlement
For customers in U.S. and Canadian markets, the API is provisioned for specific collections of products, reports, and/or features (collectively referred to as data layers) for production and trial usage. Entitlement is not required for testing in the sandbox environment.
- This product is entitled as "Search - Suits, Liens, Judgments & Bankruptcies" for D&B Direct 2.0 customers.
For customers in the UK, Ireland, Belgium, Netherlands and Luxembourg markets, the API is provisioned as a specific set of data layers for production, trial, and sandbox usage.
- This particular data layer is NOT included in the D&B Direct Onboard suite.
Specification
GET https://direct.dnb.com/V4.0/organizations/publicrecords?TerritoryName=CA&searchbyfilingnumber=true&CountryISOAlpha2Code=US&FilingTypeCode=419&FilingNumber=60652958
| Name | Characteristics |
|---|---|
| {version} | Element |
| ApplicationTransactionID | string up to 64 chars., Optional Unique Transaction ID of the request generated by the service |
| TransactionTimestamp | dateTime, Optional The date and time when this request was created. When the request is from an intermediary, such as a workflow manager or service bus, this is the date and time when the message was sent to the D&B function, i.e., the date and time when the xml document was created by the requesting intermediary. |
| SubmittingOfficeID | string up to 64 chars., Optional A number that identifies the system or the software application from where this request originated. / A number used to uniquely identfy the D&B business segment or delivery channel from where this request originated. |
| FilingTypeCode | integer up to 7 digits., Required Possible values: 14824 (Business Registration); 419 (UCC); 8037 (suit); 8036 (Lein); 1625 (Judgement); 1626 (Bankruptcy) |
| FilingNumber | string up to 32 chars., Required |
| TerritoryName | string up to 64 chars., Required |
| CountryISOAlpha2Code | string at least 2 chars. up to 2 chars., Required |
| CustomerReferenceText-n | string at least 1 chars. up to 240 chars., Optional (Up to 5x) A freeform reference string provided by the customer to be linked to the product in order to support subsequent order reconciliation. |
| CustomerBillingEndorsementText | string at least 1 chars. up to 240 chars., Optional Text that is filled in by customer and commonly contains requesting individual or department name, or customer's own account/reference number and/or name for the case on which the product was provided.This text is a reference used during the billing process. |
Endpoint
Use the following endpoint for requesting this feature. The {version} is dependent on the underlying service delivering the response.
| Endpoint (Company) |
|---|
| GET https://direct.dnb.com/V{version}/organizations/publicrecords?searchbyfilingnumber |
Testing
This operation will return a static set of results in the D&B Direct test environment (sandbox), regardless of the request parameters.
Feature Response
NOTE: The D&B Direct REST implementation uses the BadgerFish approach for JSON with some minor variations.
Specification
The following is a list of the possible data fields returned by this operation in the JSON response. Samples are provided for testing successful and failed retrieval, and to demonstrate the basic layout of a response. The data returned in samples may not represent actual values that this feature will deliver.
NOTE: The D-U-N-S Number returned in the response will be a nine-digit zero-padded, numeric value.
{"SearchByFilingNumberResponse": {
"TransactionDetail": {
"ServiceTransactionID": "Id-c2cadf5e519f56da05eb742e-1",
"TransactionTimestamp": "2013-05-24T08:02:36"
},
"TransactionResult": {
"SeverityText": "Information",
"ResultID": "CM000",
"ResultText": "Success"
},
"SearchByFilingNumberResponseDetail": {
"InquiryDetail": {
"FilingTypeCode": 419,
"FilingNumber": "60652958",
"FilingLocation": {
"TerritoryName": "DE",
"CountryISOAlpha2Code": "US"
}
},
"CandidateMatchedQuantity": 1,
"PublicFilingCandidate": [ {
"FilingNumber": "60652958",
"FilingOfficeDUNSNumber": "361538168",
"FilingOfficeName": "SECRETARY OF STATE/UCC DIVISION",
"FilingTerritoryName": "DE",
"PublicFilingSummary": {
"FilingTypeText": {
"@DNBCodeValue": 0,
"@DNBCodeTableNumber": 0,
"$": "UCC"
},
"TotalFilingsCount": 1
}
}],
"InquiryReferenceDetail": {"CustomerReferenceText": ["PRName"]}
}
}}
Response Codes & Error Handling
Successful service requests will return a CM000 response code in the TransactionResult ResultID field. Otherwise, one of the D&B Direct standard response codes will be returned.
This operation may return the following response codes: CM002, CM004, CM005, CM007, CP001, CP002, and SC001-SC009.
Feature Notes
This feature returns the filing office name and D-U-N-S Number. Information about the parties involved in the filing is not returned.
- © Dun & Bradstreet, Inc. 2019 – 2024. All rights reserved.