Using the search API

 

Endpoint

/api/search

/api/facet_search (Same as /api/search but includes facets (refinements); all fields selected as refinements in CloudLSI will included as facets)

 

Parameters

Parameter Name

Type

Required

Description

Possible Values

Default

locationId

String

Yes

The catalog id being searched.

 Get this from Console UI

 N/A

wt

String

No

Format of response data. 

json

xml

csv

json

connector

String

No

If set, will map field names to names in the connector as configured in CloudLSI.

ec2ndPhaseWeb

cloudlsi

 

 None

omitHeader

Boolean

No

If false or not set, the response header will be returned containing meta data for product attributes.

true

false

true

includeOnlyDynamicFields

Boolean

No

/facet_search only:

If set to true, will only include dynamic fields in the header, as long as omitHeader is false.

true

false

false

disableSmart

Boolean

No

If set to true, will only include smartfields in the header for the corresponding fields found in the products.

true

false

false

dynamicFacets

Boolean

No

/facet_search only:

When using dynamic fields, set to true to limit the number of facets to only those related to the first 50 products found in the search.

true

false

false

q

String

No

Search values consisting of general search terms or specific field searches (see Search Configuration below).

*

fqsearch String No

Search values consisting of general search terms or specific field searches (see Search Configuration below).  Use this instead

of &fq when want to perform the search respecting the search type of the field specified.

    

fq

String

No

Search values consisting of general search terms or specific field searches (see Search Configuration below).  This will do an

exact match of the field specified.

 

 

fl

String

No

List of fields to include for each document.  If not set, the results will contain all displayable fields as defined in CloudLSI.

Comma delimited list of field names

Fields set to Displayable n Console UI

sort

String

No

Field(s) the results are to be sorted by.  If parameter is not set, the results will be sorted based on best match.

Comma delimited list of field names followed by ASC or DESC

score DESC

start

Integer

No

This is used to paginate the results.  It indicates the offset of the first product in the query.

0

rows

Integer

No

Number of products to be included in the response.

  

 
searchProfileId Integer No Id of searchProfile being used for refinement and boost configuration.  If no id is supplied, the default is used.    
intelligentSearch Boolean No Turn on intelligent searching.  See Intelligent Search document in sub-directory.

true

false

false
fuzzySimilarity Double No To be used with Intelligent Search. See Intelligent Search document in sub-directory. 0.0 - 1.0 0.6

groupNames

 

 

Filter product fields by groups.

 

 

inconnector

 

 

Only apply connector values for field names when searching.  Original field names are returned in the results.

 

none

outconnector

    Only apply connector values for field names on search result.   none

addPrice

 

 

Will retrieve pricing and availability information from external datasource (like ERP).

 Needs custom Integration. Please contact Secondphase before using this setting

 
includedisabled Boolean No Will include products that have been marked as disabled in PIM.

true

false

 false
action String No When set to export, will limit the fields returned to exactly what is passed in the "fl" parameter.  Otherwise, connector fields are added to the "fl" list. export  
logsearch Boolean No If set to true, will log full search to CloudLSI log.

true

false

 false

 

Search Configuration :

General Search

When a search field is not present, all fields marked as searchable will be searched.  Examples of general search:

  • q=lamps
  • q=weatherproof AND box
    • To return results containing both words, must put an AND between them
  • q=”weatherproof box”
    • Search terms surrounded in quotes will return results containing both words in that order

 

Field Specific Search 

If a search field is present, only that field will be searched.  Examples of field specific search:

  • q=ITEM_COLOR:black
  • q=Keywords:WEBREADY
    • Keywords is a field in the cloudlsi connector, if the cloudlsi connector is a parameter (connector=cloudlsi), the mapped field will be searched
  • q=Keywords:WEBREADY AND ITEM_COLOR:black
  • q=(weatherproof AND box) AND ITEM_COLOR:black
    • Searches can be a simple combination of general and specific search terms using parenthesis to contain multiple search terms

Example API Calls

API calls must be URL Encoded.

/api/search

api/search?locationId=ts-plumbing-demo&wt=xml&omitHeader=false&connector=cloudlsi&q=weatherproof%20AND%20coating&start=0&rows=12

/api/facet_search

/api/facet_search?locationId=ts-plumbing-demo&wt=xml&omitHeader=false&connector=cloudlsi&includeOnlyDynamicFields=true&dynamicFacets=true&q=weatherproof%20AND%20coating&start=0&rows=12

 

FAQs:

  1. How do I get the field meta data needed to answer questions 2 thru 6?
           By setting “omitHeader=false” (or not including it as a parameter), the response header will contain the meta data for each field in the “LSIFields” tag.  This data can then be used to determine how the field is to be used in your application.
  2. How do I determine which fields I should display in my application?
           The “displayable” flag is set to true in the metadata.
  3. How do I know which fields have been setup as Refinements?
           The “facetable” flag is set to true in the metadata.
  4. How do I determine what field name to display in my application?
           The “display_name” field in the metadata contains the value needed.
  5. How do I determine the sort order of the fields?
           The “priority” field contains the sort order.
  6. When I setup the grouping option in CloudLSI, how do I determine which fields are part of that group?
           The “group” field contains a comma delimited list of group names that the field belongs to.
  7. Where do I get the information to setup my refinements?
           When the /api/facet_search is performed, refinement (facet) information is included in the response.  For each field added to the Refinement’s list in CloudLSI, an entry will be included in the “facet_fields” section, if the documents found by the search contain that field.  Each entry in the “facet_fields” section contains the field name of the refinement, then a unique list of values for the field and the count of how many documents contain that value.  Note that the count is for all possible responses, not just the number of documents found in the response (the number of documents in the response is determined by the “&rows” parameter).
  8. How do I determine the number of documents found by my search?
           The “result” tag of the response contains the field “numFound” which contains the overall count.  Note that the number of actual documents returned is determined by the “&rows” parameter.
  9. When the user selects a refinement, how do I narrow down my search by the selected refinement?
           You perform the same search call that you used to create the results and add another parameter: “&fq” which contains the field name of the refinement and the refinement value. Note that the “!tag” is used when selecting multiple facets.  See the next question.
                Example: api/facet_search?locationId=ts-plumbing-demo&wt=xml&omitHeader=false&connector=cloudlsi&includeOnlyDynamicFields=true&dynamicFacets=true&q=weatherproof AND coating&start=0&rows=12 &fq={!tag=f0}COLOR_ATT:”Bronze”
  10. Can more than one refinement be used to filter a search?
           Yes, this requires ‘OR’ing together the multiple fields that belong to the same refinement using the same tag.  If using multiple refinements, each refinement needs to have its own unique tag.
                 Single refinement; multiple values: &fq={!tag=f0}COLOR_ATT:”Bronze” OR COLOR_ATT:”Gray
                 Multiple refinement; multiple values:  &fq={!tag=f0}MATERIAL_ATT:”Die\-Cast Aluminum”&fq={!tag=Df1}COLOR_ATT:”Bronze” OR COLOR_ATT:”Gray” OR COLOR_ATT:”Silver”
  11. I noticed in answer #10 there is a backslash before the dash in “Die-Cast”, why is that?  Do I need to escape special characters?
            Yes, the following characters need to be escaped using a backslash when they are found in query values since these characters are part of the syntax:
                 + - && || ! ( ) { } [ ] ^ " ~ * ? :
  12. I would like to be able to filter my searches by fields other than refinements, is this possible?
             Yes, you will use the “&fq” parameter as used with refinements but you do not need the complication of the tags.
                  &q=weatherproof AND coating&fq=MANUFACTURER_NAME:”Oatey (Hercules)”
  13. Is there a way to use filters to exclude data?
             Yes, you will use the “&fq” parameter as shown in #12, but you place a dash (minus sign) in front of the field name.
                  &q=weatherproof AND coating&fq=-MANUFACTURER_NAME:”Oatey (Hercules)”
  14.      How do I retrieve products from a Merchandising Group?
              To retrieve products for a merchandising group, you need to search the_lsi_collections_  field using the merch group id.
                  &q=_lsi_collections_:19

Search API sample response

<?xml version="1.0"?>
<response>
    <lst name="responseHeader">
        <lst name="LSIFields">
            <lst name="Keywords">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">Keywords</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="Description">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">Description</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="PACKAGE_WIDTH__inch">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">PACKAGE_WIDTH__inch</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="CATEGORYHIERARCHYDESC">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Categoryhierarchydesc</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="UPC">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">UPC</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="FEATURESBENEFITS">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">FEATURESBENEFITS</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="CONTAINER_TYPE_ATT">
                <str name="displayable">true</str>
                <str name="facetable">true</str>
                <str name="display_name">Container type</str>
                <str name="priority">0</str>
                <str name="group">tab1</str>
            </lst>
            <lst name="IMAGE__Standard">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">IMAGE__Standard</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="PACKAGE_HEIGHT__inch">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">PACKAGE_HEIGHT__inch</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="MANUFACTURER_NAME">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">MANUFACTURER_NAME</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="TS_SCHEMA_LEAF_CLASS_NAME">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Ts schema leaf class name</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="DRILLCODE_LEVEL_1">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Drillcode level 1</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="MANUFACTURER_PART_NUMBER">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">MANUFACTURER_PART_NUMBER</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="CUSTOMER_ITEM_ID">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Customer item id</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="APPLICABLE_STANDARD_ATT">
                <str name="displayable">true</str>
                <str name="facetable">true</str>
                <str name="display_name">Applicable standard</str>
                <str name="priority">0</str>
                <str name="group">tab1</str>
            </lst>
            <lst name="CUSTOMER_MANUFACTURER_NAME">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Customer manufacturer name</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="CONTAINER_CAPACITY_ATT">
                <str name="displayable">true</str>
                <str name="facetable">true</str>
                <str name="display_name">Container capacity</str>
                <str name="priority">0</str>
                <str name="group">tab1</str>
            </lst>
            <lst name="CUSTOMER_MANUFACTURER_PART_NUMBER">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Customer manufacturer part number</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="APPLICATION_ATT">
                <str name="displayable">true</str>
                <str name="facetable">true</str>
                <str name="display_name">Application</str>
                <str name="priority">0</str>
                <str name="group">tab1</str>
            </lst>
            <lst name="COMMODITY_CODE_DESCRIPTION_LEVEL_3">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Commodity code description level 3</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="PACKAGE_WEIGHT__pounds">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">PACKAGE_WEIGHT__pounds</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="COMMODITY_CODE_LEVEL_3">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Commodity code level 3</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="TS_SCHEMA_PARENT_CLASS_NAME">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Ts schema parent class name</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="COMMODITY_CODE_LEVEL_1">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Commodity code level 1</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="CATEGORYHIERARCHYCODE">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Categoryhierarchycode</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="ProductID">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">ProductID</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="Families">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">Families</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="PRODUCT_NAME">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">PRODUCT_NAME</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="DRILLCODE_LEVEL_3">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Drillcode level 3</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="PACKAGE_LENGTH__inch">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">PACKAGE_LENGTH__inch</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="CUSTOMER_OTHER">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Customer other</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="SHORT_DESCRIPTION">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Short description</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="TS_STATUS">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Ts status</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="UNSPSC_CODE">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">UNSPSC_CODE</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="Price">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">Price</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="AltDesc">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">AltDesc</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="PACKAGE_VOLUME__cubic_inch">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">PACKAGE_VOLUME__cubic_inch</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="COLOR_ATT">
                <str name="displayable">true</str>
                <str name="facetable">true</str>
                <str name="display_name">Color</str>
                <str name="priority">0</str>
                <str name="group">tab1</str>
            </lst>
            <lst name="CUSTOMER_UPC">
                <str name="displayable">true</str>
                <str name="facetable">false</str>
                <str name="display_name">Customer upc</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
            <lst name="BRANDSERIES_NAME">
                <str name="displayable">false</str>
                <str name="facetable">false</str>
                <str name="display_name">BRANDSERIES_NAME</str>
                <str name="priority">0</str>
                <str name="group"/>
            </lst>
        </lst>
        <str name="LSIAPITime">1</str>
        <int name="status">0</int>
        <int name="QTime">29</int>
    </lst>
    <lst name="facet_counts">
        <lst name="facet_queries"/>
        <lst name="facet_fields">
            <lst name="APPLICATION_ATT">
                <int name="Roof, Flashing, Cooling Towers, Skylights, Downspouts, Gutters, Vents, Chimney, Concrete, Metal, Tile, Wood">2</int>
            </lst>
            <lst name="CONTAINER_TYPE_ATT">
                <int name="Can">2</int>
            </lst>
            <lst name="APPLICABLE_STANDARD_ATT">
                <int name="SS-C-153">2</int>
            </lst>
            <lst name="COLOR_ATT">
                <int name="Black">2</int>
            </lst>
            <lst name="CONTAINER_CAPACITY_ATT">
                <int name="1 Quart">1</int>
                <int name="5 Gallon">1</int>
            </lst>
            <lst name="MANUFACTURER_NAME">
                <int name="Oatey (Hercules)">2</int>
            </lst>
            <lst name="BRANDSERIES_NAME">
                <int name="Plastic Seal">2</int>
            </lst>
        </lst>
        <lst name="facet_dates"/>
        <lst name="facet_ranges"/>
        <lst name="facet_intervals"/>
        <lst name="facet_heatmaps"/>
    </lst>
    <result name="response" numFound="2" start="0" maxScore="0.1327543">
        <doc>
            <str name="UPC">032628254053</str>
            <str name="FEATURESBENEFITS">Special Bituminous Composition Provides Superior Adhesive Properties Even in Severe Weather Conditions, can be Applied in all Types of Weather and Becomes Effective Immediately, Even on Cold or Wet Surfaces; Withstands Stress of Dissimilar Rates of ExpANSIon Providing Years of Problem Free Life; Forms Durable, Flexible, Weatherproof Coating; Can be Easily Applied with Trowel or Putty Knife; Waterproof Entire Floors and Seepage-Proof Linings for Sump Pits; Time Saving Formula is Ready-To-Use Directly from the Container, No Heating, No Mixing or Remixing is Required; Excellent Shelf Life</str>
            <str name="PACKAGE_WEIGHT__POUNDS">2.50</str>
            <str name="CONTAINER_TYPE_ATT">Can</str>
            <str name="MANUFACTURER_NAME">Oatey (Hercules)</str>
            <str name="CATALOG__PAGESS">http://images.tradeservice.com/ATTACHMENTS/DIR100129/DBRBRSE00237_57.pdf</str>
            <str name="ADDITIONAL_INFORMATION">Physical State Paste; Relative Density 1.1; Flash Point 100 Deg F; VOC 300 Grams per Liter; Boiling Point 315 Deg F; Vapor Density 3.9; Packaging Quantity 12 per Carton; Weight 2.4 Lb</str>
            <str name="CUSTOMER_DESCRIPTION">25405 1QT ROOF/FLASHING SEALANT</str>
            <str name="MANUFACTURER_PART_NUMBER">25405</str>
            <str name="APPLICABLE_STANDARD_ATT">SS-C-153</str>
            <str name="TS_ID">21909</str>
            <str name="CONTAINER_CAPACITY_ATT">1 Quart</str>
            <str name="SPECIFICATION_SHEET">http://images.tradeservice.com/ATTACHMENTS/DIR100044/HERCHEE00066_1_2.pdf</str>
            <str name="APPLICATION_ATT">Roof, Flashing, Cooling Towers, Skylights, Downspouts, Gutters, Vents, Chimney, Concrete, Metal, Tile, Wood</str>
            <str name="IMAGE__STANDARD">http://images.tradeservice.com/ProductImages/2PhaseRSZ/25405.jpg</str>
            <str name="COMMODITY_CODE_DESCRIPTION_LEVEL_1">CHEMICALS, COMPOUNDS, REPAIR SPECIALTIES</str>
            <str name="PACKAGE_VOLUME__CUBIC_INCH">0.70</str>
            <str name="MATERIAL_SAFETY_DATA_SHEET_MSDS">http://images.tradeservice.com/MSDS/DIR100000/HERCHEMSDS00164.pdf</str>
            <str name="PRODUCT_NAME">Roof and Flashing Sealant</str>
            <str name="COL3_PRICING">18.01</str>
            <str name="UNSPSC_CODE">31201700</str>
            <str name="LONG_DESCRIPTION">Roof and Flashing Sealant; Applicable Standard SS-C-153; Container Type Can; Container Capacity 1 Quart; Color Black; Application Roof, Flashing, Cooling Towers, Skylights, Downspouts, Gutters, Vents, Chimney, Concrete, Metal, Tile, Wood; Physical State Paste; Relative Density 1.1; Flash Point 100 Deg F; VOC 300 Grams per Liter; Boiling Point 315 Deg F; Vapor Density 3.9; Packaging Quantity 12 per Carton; Weight 2.4 Lb</str>
            <str name="COLOR_ATT">Black</str>
            <str name="BRANDSERIES_NAME">Plastic Seal</str>
            <str name="AltDesc">Physical State Paste; Relative Density 1.1; Flash Point 100 Deg F; VOC 300 Grams per Liter; Boiling Point 315 Deg F; Vapor Density 3.9; Packaging Quantity 12 per Carton; Weight 2.4 Lb</str>
            <str name="Price">18.01</str>
            <str name="PACKAGE_WEIGHT__pounds">2.50</str>
            <str name="Families">CHEMICALS, COMPOUNDS, REPAIR SPECIALTIES</str>
            <str name="Keywords">Roof and Flashing Sealant; Applicable Standard SS-C-153; Container Type Can; Container Capacity 1 Quart; Color Black; Application Roof, Flashing, Cooling Towers, Skylights, Downspouts, Gutters, Vents, Chimney, Concrete, Metal, Tile, Wood; Physical State Paste; Relative Density 1.1; Flash Point 100 Deg F; VOC 300 Grams per Liter; Boiling Point 315 Deg F; Vapor Density 3.9; Packaging Quantity 12 per Carton; Weight 2.4 Lb</str>
            <str name="ProductID">21909</str>
            <str name="Description">25405 1QT ROOF/FLASHING SEALANT</str>
            <str name="PACKAGE_VOLUME__cubic_inch">0.70</str>
            <str name="IMAGE__Standard">http://images.tradeservice.com/ProductImages/2PhaseRSZ/25405.jpg</str>
        </doc>
        <doc>
            <str name="UPC">032628254107</str>
            <str name="FEATURESBENEFITS">Special Bituminous Composition Provides Superior Adhesive Properties Even in Severe Weather Conditions, can be Applied in all Types of Weather and Becomes Effective Immediately, Even on Cold or Wet Surfaces; Withstands Stress of Dissimilar Rates of ExpANSIon Providing Years of Problem Free Life; Forms Durable, Flexible, Weatherproof Coating; Can be Easily Applied with Trowel or Putty Knife; Waterproof Entire Floors and Seepage-Proof Linings for Sump Pits; Time Saving Formula is Ready-To-Use Directly from the Container, No Heating, No Mixing or Remixing is Required; Excellent Shelf Life</str>
            <str name="PACKAGE_WEIGHT__POUNDS">9.58</str>
            <str name="CONTAINER_TYPE_ATT">Can</str>
            <str name="MANUFACTURER_NAME">Oatey (Hercules)</str>
            <str name="CATALOG__PAGESS">http://images.tradeservice.com/ATTACHMENTS/DIR100129/DBRBRSE00237_57.pdf</str>
            <str name="ADDITIONAL_INFORMATION">Physical State Paste; Relative Density 1.1; Flash Point 100 Deg F; VOC 300 Grams per Liter; Boiling Point 315 Deg F; Vapor Density 3.9; Packaging Quantity 6 per Carton; Weight 8.77 Lb</str>
            <str name="CUSTOMER_DESCRIPTION">25410 1GAL ROOF/FLASHING SEALANT</str>
            <str name="MANUFACTURER_PART_NUMBER">25410</str>
            <str name="APPLICABLE_STANDARD_ATT">SS-C-153</str>
            <str name="TS_ID">21910</str>
            <str name="CONTAINER_CAPACITY_ATT">5 Gallon</str>
            <str name="SPECIFICATION_SHEET">http://images.tradeservice.com/ATTACHMENTS/DIR100044/HERCHEE00066_1_2.pdf</str>
            <str name="APPLICATION_ATT">Roof, Flashing, Cooling Towers, Skylights, Downspouts, Gutters, Vents, Chimney, Concrete, Metal, Tile, Wood</str>
            <str name="IMAGE__STANDARD">http://images.tradeservice.com/ProductImages/2PhaseRSZ/25410.jpg</str>
            <str name="COMMODITY_CODE_DESCRIPTION_LEVEL_1">CHEMICALS, COMPOUNDS, REPAIR SPECIALTIES</str>
            <str name="PACKAGE_VOLUME__CUBIC_INCH">1.41</str>
            <str name="MATERIAL_SAFETY_DATA_SHEET_MSDS">http://images.tradeservice.com/MSDS/DIR100000/HERCHEMSDS00164.pdf</str>
            <str name="PRODUCT_NAME">Roof and Flashing Sealant</str>
            <str name="COL3_PRICING">40.96</str>
            <str name="UNSPSC_CODE">31201700</str>
            <str name="LONG_DESCRIPTION">Roof and Flashing Sealant; Applicable Standard SS-C-153; Container Type Can; Container Capacity 5 Gallon; Color Black; Application Roof, Flashing, Cooling Towers, Skylights, Downspouts, Gutters, Vents, Chimney, Concrete, Metal, Tile, Wood; Physical State Paste; Relative Density 1.1; Flash Point 100 Deg F; VOC 300 Grams per Liter; Boiling Point 315 Deg F; Vapor Density 3.9; Packaging Quantity 6 per Carton; Weight 8.77 Lb</str>
            <str name="COLOR_ATT">Black</str>
            <str name="BRANDSERIES_NAME">Plastic Seal</str>
            <str name="AltDesc">Physical State Paste; Relative Density 1.1; Flash Point 100 Deg F; VOC 300 Grams per Liter; Boiling Point 315 Deg F; Vapor Density 3.9; Packaging Quantity 6 per Carton; Weight 8.77 Lb</str>
            <str name="Price">40.96</str>
            <str name="PACKAGE_WEIGHT__pounds">9.58</str>
            <str name="Families">CHEMICALS, COMPOUNDS, REPAIR SPECIALTIES</str>
            <str name="Keywords">Roof and Flashing Sealant; Applicable Standard SS-C-153; Container Type Can; Container Capacity 5 Gallon; Color Black; Application Roof, Flashing, Cooling Towers, Skylights, Downspouts, Gutters, Vents, Chimney, Concrete, Metal, Tile, Wood; Physical State Paste; Relative Density 1.1; Flash Point 100 Deg F; VOC 300 Grams per Liter; Boiling Point 315 Deg F; Vapor Density 3.9; Packaging Quantity 6 per Carton; Weight 8.77 Lb</str>
            <str name="ProductID">21910</str>
            <str name="Description">25410 1GAL ROOF/FLASHING SEALANT</str>
            <str name="PACKAGE_VOLUME__cubic_inch">1.41</str>
            <str name="IMAGE__Standard">http://images.tradeservice.com/ProductImages/2PhaseRSZ/25410.jpg</str>
        </doc>
    </result>
</response>

&nbsp;