Documentation.

Asset Import.

Importing an asset will include the asset and optionally, image(s) & attachment(s) data.

Embedded HTML is not allowed in any field.

Each FieldName must have a corresponding XML entity.

    Example:
    <?xml version='1.0' encoding='UTF-8'?>
    <Assets>
       <Row>
          <field_1>data</field_1>
          <field_2>data</field_2>
          <field_3>data</field_3>
       </Row>
    </Assets>

 

Asset Location - New Feature Available July 26, 2023 Release

Asset API has added a new process where a location ID does not have to be entered. The system will then try to match the address submitted to an existing location in the system or create a new location.

  1. If there is a locationid entered and the fields of address1, address2, city, state, postalcode and country are also entered, the system will try to match the locationid. The other address fields will be ignored.
    • If the locationid is valid, the asset will be created using the locationid.
    • If the locationid is not valid, an error will be returned.
  2. If the locationid is left blank and the fields of address1, address2, city, state, postalcode and country are entered, the system will try to match these fields to an existing address.
    • If these fields match an existing locationid, the asset will be created with that locationid.
    • If these fields do not match an existing locationid, a new asset location will be added to the system and the asset will be created with this new location.
  3. The Country must exist in our database or an error will be returned.
  4. The State must exist in our database or an error will be returned.

Required Values

 Order   Name   Value Type 
1 asset_qty_unit string (Required EA|LT)
(2 character max)
2 asset_short_desc string (Required)
(120 character max)
3 asset_long_desc string (Required)
(3900 character max)
4 asset_condition_cd string (Required - (N|S|SD))
(2 character max)
5 asset_status_cd string (Required - (HFR|RFA|RFR))
(3 character max)
6 asset_category string (Required)
(3 character max) (See Categories)
7 locationid integer (Required - (Location ID))
(Location ID)
8 willship bit (Required)
0 = false, 1 = true
9 asset_poc bit (Required)
0=Default (Client POC) or AssetPOC ID which must be valid entry for that client.

Optional Values

 Order   Name   Value Type 
1 makebrand string (Optional - Client)
(50 character max)
2 model string (Optional - Client)
(50 character max)
3 vinserial string (Optional - Client)
(40 character max)
4 special_instructions string (Optional)
(3900 character max)
5 inventoryid string (Optional - Client)
(50 character max)
6 department integer (Optional but default to value of zero - (Department ID))
(Department ID)
7 model_year string (Optional - Client)
(4 digit year)
8 title_restriction string (Optional - (Y|N|A|B|C))
(1 character max)
9 meter string (Optional - Client - (Hours|Miles|Kilometers))
(18 character max)
10 metercount numeric (Optional - Client)
(18 character max)
11 meteraccurate string (Optional - Client - (Yes|No|Unknown))
(10 character max)
12 inspectioninstructions string (Optional)
(3900 character max)
13 paymentinstructions string (Optional)
(3900 character max)
14 removalinstructions string (Optional)
(3900 character max)
15 secondary_inventoryid string (Optional - Client)
(500 character max)
16 NSN string (20 character max).
17 ASIN string (15 character max).
18 EAN string (15 character max).
19 SKU string (32 character max).
20 tier string (Default is GNP) - Account must belong to a Tier.
21 Weight integer (Optional)
22 WeightType string (Optional)- Use Abbreviation (g, kg, mt, oz, lb, t)
23 isDOWarehouse bit (Optional)
0 = false, 1 = true
24 address1 string (100 character max).
25 address2 string (100 character max).
26 city string (40 character max).
27 state string (6 character state) (ie. AL).
28 postalcode string (10 character max).
28 country string (3 character max) (ie. USA).
*Note: Canadian clients will have the value of this field computed for them based on their province.
Example XML
Additional rows can be included - RowCount in <Assets> must be correct
images and attachments are optional. Multiple images and attachments may be included with any asset.
** Note ** img, image and imagefile are not included in the fieldnames parameter.

    Single Asset, Single image, Single attachment:
    <?xml version="1.0" encoding="UTF-8"?>
    <Assets>
    <Row>
      <asset_qty_unit> </asset_qty_unit>
      <asset_short_desc> </asset_short_desc>
      <asset_long_desc> </asset_long_desc>
      <makebrand> </makebrand>
      <model> </model>
      <vinserial> </vinserial>
      <asset_condition_cd> </asset_condition_cd>
      <asset_status_cd> </asset_status_cd>
      <asset_category> </asset_category>
      <special_instructions> </special_instructions>
      <inventoryid> </inventoryid>
      <department> </department>
      <model_year> </model_year>
      <title_restriction> </title_restriction>
      <meter> </meter>
      <metercount> </metercount>
      <meteraccurate> </meteraccurate>
      <locationid> </locationid>
      <inspectioninstructions> </inspectioninstructions>
      <paymentinstructions> </paymentinstructions>
      <removalinstructions> </removalinstructions>
      <willship> </willship>
      <asset_poc> </asset_poc>
      <secondary_inventoryid> </secondary_inventoryid>
      <media>
        <image>Base64 Encoded image Data</image>
      </media>
      <attachments>
        <document fileName="file.txt">Base64 Encoded text Data</document>
      </attachments>
      <NSN> </NSN>
      <ASIN> </ASIN>
      <EAN> </EAN>
      <SKU> </SKU>
      <Weight> </Weight>
      <WeightType> </WeightType>
      <isDOWarehouse> </isDOWarehouse>
      <address1> </address1>
      <address2> </address2>
      <city> </city>
      <state> </state>
      <postalcode> </postalcode>
      <country> </country>
    </Row>
    </Assets>

    Single Asset, Multiple images, Multiple attachments:
    <?xml version="1.0" encoding="UTF-8"?>
    <Assets>
    <Row>
      <asset_qty_unit> </asset_qty_unit>
      <asset_short_desc> </asset_short_desc>
      <asset_long_desc> </asset_long_desc>
      <makebrand> </makebrand>
      <model> </model>
      <vinserial> </vinserial>
      <asset_condition_cd> </asset_condition_cd>
      <asset_status_cd> </asset_status_cd>
      <asset_category> </asset_category>
      <special_instructions> </special_instructions>
      <inventoryid> </inventoryid>
      <department> </department>
      <model_year> </model_year>
      <title_restriction> </title_restriction>
      <meter> </meter>
      <metercount> </metercount>
      <meteraccurate> </meteraccurate>
      <locationid> </locationid>
      <inspectioninstructions> </inspectioninstructions>
      <paymentinstructions> </paymentinstructions>
      <removalinstructions> </removalinstructions>
      <willship> </willship>
      <asset_poc> </asset_poc>
      <secondary_inventoryid> </secondary_inventoryid>
      <media>
         <image>Base64 Encoded image Data</image>
         <image>Base64 Encoded image Data</image>
         <image>Base64 Encoded image Data</image>
      </media>
      <attachments>
        <document fileName="file.txt">Base64 Encoded text Data</document>
        <document fileName="file2.pdf">Base64 Encoded pdf Data</document>
        <document fileName="file3.docx">Base64 Encoded word Data</document>
        <document fileName="file4.doc">Base64 Encoded word Data</document>
        <document fileName="file5.xlsx">Base64 Encoded excel Data</document>
        <document fileName="file6.xls">Base64 Encoded excel Data</document>
      </attachments>
      <NSN> </NSN>
      <ASIN> </ASIN>
      <EAN> </EAN>
      <SKU> </SKU>
      <Weight> </Weight>
      <WeightType> </WeightType>
      <isDOWarehouse> </isDOWarehouse>
      <address1> </address1>
      <address2> </address2>
      <city> </city>
      <state> </state>
      <postalcode> </postalcode>
      <country> </country>
    </Row>
    </Assets>