BadgerFish (REST)

BadgerFish is a convention for translating an XML document into a JSON object. D&B Direct JSON responses follow this convention with a few minor variations. Exception: The responses supplied by the Data Exchange Service follow the convention used by the respective business partner.

Examples

# Scenario XML Instance JSON Instance
1 Element having no attribute <DUNSNumber>804735132 </DUNSNumber> "DUNSNumber": "804735132"
2 Element having Attribute <FamilyTreeMemberRoleText DNBCodeValue="12773">Parent </FamilyTreeMemberRoleText> "FamilyTreeMemberRoleText": { "@DNBCodeValue": 12773, "$": "Parent" }
3 Aggregate having attribute <OrganizationIdentificationNumberDetail TypeText="Federal Taxpayer Identification Number (US)" DNBCodeValue="6863"> <OrganizationIdentificationNumber>12345 </OrganizationIdentificationNumber> </OrganizationIdentificationNumberDetail> "OrganizationIdentificationNumberDetail": { "@TypeText": "Federal Taxpayer Identification Number (US)", "@DNBCodeValue": 6863, "OrganizationIdentificationNumber": "12345" }
4 Element having Attribute as per definition, however attribute is not returned for a specific JSON instance <OrganizationName>Gorman Manufacturing Company, Inc. </OrganizationName> "OrganizationName": { "$": "Gorman Manufacturing Company, Inc." }
5 Aggregate having Attribute as per definition, however attribute is not returned for a specific JSON instance <OrganizationIdentificationNumberDetail > <OrganizationIdentificationNumber>12345 </OrganizationIdentificationNumber> </OrganizationIdentificationNumberDetail> "OrganizationIdentificationNumberDetail": { "OrganizationIdentificationNumber": "12345" }
6 Non-Repeating Element <DUNSNumber>804735132 </DUNSNumber> "DUNSNumber": "804735132"
7 Repeating Element <SalesRevenueAmount CurrencyISOAlpha3Code="USD”>1000000 </SalesRevenueAmount> <SalesRevenueAmount CurrencyISOAlpha3Code="CAD”>1040000 </SalesRevenueAmount> "SalesRevenueAmount": [ { "@CurrencyISOAlpha3Code": "USD", "$": 1000000 }, { "@CurrencyISOAlpha3Code": "CAD", "$": 1040000 } ]
8 Repeating Aggregate <FamilyTreeMemberRole> <FamilyTreeMemberRoleText DNBCodeValue="12773">Parent </FamilyTreeMemberRoleText> </FamilyTreeMemberRole> <FamilyTreeMemberRole> <FamilyTreeMemberRoleText DNBCodeValue="12775">Global Ultimate </FamilyTreeMemberRoleText> </FamilyTreeMemberRole> <FamilyTreeMemberRole> <FamilyTreeMemberRoleText DNBCodeValue="12774">Domestic Ultimate </FamilyTreeMemberRoleText> </FamilyTreeMemberRole> "FamilyTreeMemberRole": [ {"FamilyTreeMemberRoleText": { "@DNBCodeValue": 12773, "$": "Parent" }}, {"FamilyTreeMemberRoleText": { "@DNBCodeValue": 12775, "$": "Global Ultimate" }}, {"FamilyTreeMemberRoleText": { "@DNBCodeValue": 12774, "$": "Domestic Ultimate" }} ]
9 Element is repeatable as per the definition. However it is not repeating in a specific JSON instance. <SalesRevenueAmount CurrencyISOAlpha3Code="USD”>1000000 </SalesRevenueAmount> "SalesRevenueAmount": [ { "@CurrencyISOAlpha3Code": "USD", "$": 1000000 }]
10 Aggregate is repeatable as per the definition. However it is not repeating in a specific JSON instance. <FamilyTreeMemberRole> <FamilyTreeMemberRoleText DNBCodeValue="12773">Parent </FamilyTreeMemberRoleText> </FamilyTreeMemberRole> "FamilyTreeMemberRole": [ {"FamilyTreeMemberRoleText": { "@DNBCodeValue": 12773, "$": "Parent" }} ]
11 Date Field <TransactionTimestamp>2013-07-11T11:08:48.067-04:00 </TransactionTimestamp> "TransactionTimestamp": "2013-07-11T11:10:39.110-04:00"
12 Boolean Field <StandaloneOrganizationIndicator>false </StandaloneOrganizationIndicator> "StandaloneOrganizationIndicator": false
13 Numeric Field <RawScore>352</RawScore> "RawScore": 352
14 String Field <LineText>492 Koller Street</LineText> "LineText": "492 Koller Street"
Back to Top