Filing Office Lookup

Also known as Search by Filing Number

Product Code(s)

Not Applicable

Option(s)

None

Monitoring Available

No

Interface

SOAP

WSDL

download

Format(s)

XML

Service

Company

Operation

SearchByFilingNumber

{version}

5.0

5.0 Released On

July 10, 2015

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.

Global Availability

This data layer is only available for businesses domiciled in the United States.

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

Sample Request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:com="http://services.dnb.com/CompanyServiceV2.0">
   <soapenv:Header>
      <wsse:Security soapenv:mustUnderstand="0" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
         <wsse:UsernameToken wsu:Id="UsernameToken-11">
            <wsse:Username>MyUserName</wsse:Username>
            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">MyPassword</wsse:Password>
         </wsse:UsernameToken>
      </wsse:Security>
   </soapenv:Header>
   <soapenv:Body>
      <com:SearchByFilingNameRequest ServiceVersionNumber="4.0">         
         <SearchByFilingNumberRequestDetail>
            <InquiryDetail>
               <FilingTypeCode>419</FilingTypeCode>
               <FilingNumber>60652958</FilingNumber>
               <FilingLocation>
                  <TerritoryName>CA</TerritoryName>
                  <CountryISOAlpha2Code>US</CountryISOAlpha2Code>
               </FilingLocation>
            </InquiryDetail>
         </SearchByFilingNumberRequestDetail>
      </com:SearchByFilingNameRequest>
   </soapenv:Body>
</soapenv:Envelope>

Name	Characteristics
SearchByFilingNumberRequest	Element
SearchByFilingNumberRequest@ServiceVersionNumber	Element
SearchByFilingNumberRequest. TransactionDetail	RequestTransactionDetail, Optional Records information necessary to process a particular request. Examples of a request is the ordering of a product.
SearchByFilingNumberRequest. TransactionDetail. ApplicationTransactionID	string up to 64 chars., Optional Unique Transaction ID of the request generated by the service
SearchByFilingNumberRequest. TransactionDetail. 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.
SearchByFilingNumberRequest. TransactionDetail. 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.
END: SearchByFilingNumberRequest. TransactionDetail	Element
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail	SearchByFilingNumberRequestDetail, Required
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryDetail	SearchByFilingNumberInquiryDetail, Required
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryDetail. FilingTypeCode	integer up to 7 digits., Required Possible values: 14824 (Business Registration); 419 (UCC); 8037 (suit); 8036 (Lein); 1625 (Judgement); 1626 (Bankruptcy)
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryDetail. FilingNumber	string up to 32 chars., Required
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryDetail. FilingLocation	SearchByFilingNumberFilingLocation, Required
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryDetail. FilingLocation. TerritoryName	string up to 64 chars., Required
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryDetail. FilingLocation. CountryISOAlpha2Code	string at least 2 chars. up to 2 chars., Required
END: SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryDetail. FilingLocation	Element
END: SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryDetail	Element
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryReferenceDetail	InquiryReferenceDetail, Optional
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryReferenceDetail. CustomerReferenceText	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.
SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryReferenceDetail. 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.
END: SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail. InquiryReferenceDetail	Element
END: SearchByFilingNumberRequest. SearchByFilingNumberRequestDetail	Element
END: SearchByFilingNumberRequest	Element

Endpoint

Use the following endpoint with the downloadable WSDL to request this feature.

Endpoint (Company)
https://direct.dnb.com/Company/V{version}

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

Specification

The following is a list of the possible data fields returned by this operation in the XML 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.

Sample Response

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Body>
      <com:SearchByFilingNumberResponse ServiceVersionNumber="2" xmlns:com="http://services.dnb.com/CompanyServiceV2.0">
         <TransactionDetail>
            <ServiceTransactionID>Id-a5cfe8b4515e6e6201ab742e-1</ServiceTransactionID>
            <TransactionTimestamp>2013-04-05T02:25:39</TransactionTimestamp>
         </TransactionDetail>
         <TransactionResult>
            <SeverityText>Information</SeverityText>
            <ResultID>CM000</ResultID>
            <ResultText>Success</ResultText>
         </TransactionResult>
         <SearchByFilingNumberResponseDetail>
            <InquiryDetail>
               <FilingTypeCode>419</FilingTypeCode>
               <FilingNumber>60652958</FilingNumber>
               <FilingLocation>
                  <TerritoryName>DE</TerritoryName>
                  <CountryISOAlpha2Code>US</CountryISOAlpha2Code>
               </FilingLocation>
            </InquiryDetail>
            <CandidateMatchedQuantity>1</CandidateMatchedQuantity>
            <PublicFilingCandidate>
               <FilingNumber>60652958</FilingNumber>
               <FilingOfficeDUNSNumber>361538168</FilingOfficeDUNSNumber>
               <FilingOfficeName>SECRETARY OF STATE/UCC DIVISION</FilingOfficeName>
               <FilingTerritoryName>DE</FilingTerritoryName>
               <PublicFilingSummary>
                  <FilingTypeText DNBCodeValue="0" DNBCodeTableNumber="0">UCC</FilingTypeText>
                  <TotalFilingsCount>0000001</TotalFilingsCount>
               </PublicFilingSummary>
            </PublicFilingCandidate>
         </SearchByFilingNumberResponseDetail>
      </com:SearchByFilingNumberResponse>
   </soapenv:Body>
</soapenv:Envelope>

Name	Characteristics
SearchByFilingNumberResponse	Aggregate
SearchByFilingNumberResponse@ServiceVersionNumber	Attribute
SearchByFilingNumberResponse. TransactionDetail	Aggregate, Required Records information necessary to process a particular request. Examples of a request is the ordering of a product.
SearchByFilingNumberResponse. TransactionDetail. ApplicationTransactionID	string up to 64 chars., Optional Unique Transaction ID of the request generated by the service
SearchByFilingNumberResponse. TransactionDetail. ServiceTransactionID	string up to 64 chars., Required A number assigned by the D&B service to uniquely identify this transaction.
SearchByFilingNumberResponse. TransactionDetail. TransactionTimestamp	dateTime, Required 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.
END: SearchByFilingNumberResponse. TransactionDetail	Aggregate
SearchByFilingNumberResponse. TransactionResult	Aggregate, Required An aggregate that can repeat multiple times to record the different outcomes of the transaction.
SearchByFilingNumberResponse. TransactionResult. SeverityText	string, Required Text that records the criticality of the outcome, e.g., Information, Warning, Error, Fatal.
SearchByFilingNumberResponse. TransactionResult. ResultID	string up to 32 chars., Required An alphanumeric string that uniquely identifies the outcome of the transaction.
SearchByFilingNumberResponse. TransactionResult. ResultText	string up to 512 chars., Optional Text that explains the outcome of the transaction.
SearchByFilingNumberResponse. TransactionResult. ResultMessage	Aggregate, Optional (Infinite) An aggregate that can repeat multiple times to record textual data that expands on the ResultID and ResultText to provide additional information to the user regarding the status of the transaction. If the status implies that there is a problem this may also provide guidance to the user on how to address it.
SearchByFilingNumberResponse. TransactionResult. ResultMessage. ResultDescription	string up to 512 chars., Required Text that describes the additional information regarding the outcome of the transaction.
END: SearchByFilingNumberResponse. TransactionResult. ResultMessage	Aggregate
END: SearchByFilingNumberResponse. TransactionResult	Aggregate
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail	Aggregate, Optional
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryDetail	Aggregate, Required
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryDetail. FilingTypeCode	integer up to 7 digits., Required
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryDetail. FilingNumber	string up to 32 chars., Required
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryDetail. FilingLocation	Aggregate, Required
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryDetail. FilingLocation. TerritoryName	string up to 64 chars., Required
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryDetail. FilingLocation. CountryISOAlpha2Code	string at least 2 chars. up to 2 chars., Required
END: SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryDetail. FilingLocation	Aggregate
END: SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryDetail	Aggregate
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. CandidateMatchedQuantity	int up to 4 digits., Required
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate	Aggregate, Required (Infinite)
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate. FilingNumber	string up to 32 chars., Optional
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate. FilingOfficeDUNSNumber	*string up to 15 chars. Pattern: {([0-9a-zA-Z])}.*, Optional*
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate. FilingOfficeName	string up to 256 chars., Required
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate. FilingTerritoryName	string up to 64 chars., Optional
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate. PublicFilingSummary	Aggregate, Optional
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate. PublicFilingSummary. FilingTypeText	string up to 256 chars., Optional Possible values: 14824 (Business Registration); 419 (UCC); 8037 (suit); 8036 (Lein); 1625 (Judgement); 1626 (Bankruptcy)
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate. PublicFilingSummary. FilingTypeText@DNBCodeValue	Attribute Possible values: 14824 (Business Registration); 419 (UCC); 8037 (suit); 8036 (Lein); 1625 (Judgement); 1626 (Bankruptcy)
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate. PublicFilingSummary. TotalFilingsCount	int up to 7 digits., Optional
END: SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate. PublicFilingSummary	Aggregate
END: SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. PublicFilingCandidate	Aggregate
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryReferenceDetail	Aggregate, Optional
SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryReferenceDetail. CustomerReferenceText	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.
END: SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail. InquiryReferenceDetail	Aggregate
END: SearchByFilingNumberResponse. SearchByFilingNumberResponseDetail	Aggregate
END: SearchByFilingNumberResponse	Aggregate

NOTE: There may be additional request and/or response elements specified in the WSDL that are not applicable for D&B Direct customers. Data elements that are not listed on this page are currently unused by this operation.

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.

Loading

Filing Office Lookup

Feature Request

Overview

Global Availability

Data Layer Entitlement

Specification

Endpoint

Testing

Feature Response

Specification

Response Codes & Error Handling

Feature Notes