Unit model import / update specifications¶

Names of fields listed here are the exact case and spelling required to be recognized by AyaNova for importing / updating.

Any field in the import file that is not listed on this page will be removed before sending to the server for import.

Required fields¶

Name

Key field used to match to existing records¶

Name

Fields directly importable / updateable¶

Name (import only)
Active
Notes
Wiki
Tags
UPC
LifeTimeWarranty
IntroducedDate
Discontinued
DiscontinuedDate
WarrantyLength
WarrantyTerms"

Linked object fields¶

The following linked objects are supported for import / update:

Unit model Vendor via "VendorViz" field which must contain the name of an existing Vendor

JSON file format¶

The .json file must contain an array of one or more objects.

[
    {
        "Name": "Silverado Kids - 394697",
        "Active": true,
        "Notes": "Quia neque dolorem quis cum sit dolores omnis dolores ex.",
        "Wiki": null,
        "Tags": [
            "quince",
            "silver",
            "violet",
            "yellow",
            "zone9"
        ],
        "VendorViz": "Ruecker - Jakubowski",
        "UPC": "2626181040130",
        "LifeTimeWarranty": false,
        "IntroducedDate": "2017-10-26T17:06:35.479433Z",
        "Discontinued": false,
        "DiscontinuedDate": null,
        "WarrantyLength": 36,
        "WarrantyTerms": "Service only"
    },
    {
        "Name": "Sentra Electronics - 598797",
        "Active": true,
        "Notes": "Incidunt officiis minus vero distinctio quasi.",
        "Wiki": null,
        "Tags": [
            "brown",
            "mauve",
            "white",
            "zone2",
            "zone7"
        ],
        "VendorViz": "Senger, Schinner and Zieme",
        "UPC": "3036454614095",
        "LifeTimeWarranty": false,
        "IntroducedDate": "2018-12-28T21:40:59.003417Z",
        "Discontinued": false,
        "DiscontinuedDate": null,
        "WarrantyLength": 24,
        "WarrantyTerms": "Service only"
    },
    {
        "Name": "Ranchero Garden - 625229",
        "Active": true,
        "Notes": "Ipsum ea nam exercitationem ea perspiciatis.",
        "Wiki": null,
        "Tags": [
            "brown",
            "gold",
            "mauve",
            "purple",
            "zone8"
        ],
        "VendorViz": "Pfeffer - Dicki",
        "UPC": "0805820409756",
        "LifeTimeWarranty": false,
        "IntroducedDate": "2018-06-01T17:29:48.427245Z",
        "Discontinued": false,
        "DiscontinuedDate": null,
        "WarrantyLength": 1,
        "WarrantyTerms": "Parts only"
    }
]

CSV file format¶

The first row of the .csv file must contain column headers that match the field names listed above.

Name,Active,Notes,Wiki,Tags,VendorViz,UPC,LifeTimeWarranty,IntroducedDate,Discontinued,DiscontinuedDate,WarrantyLength,WarrantyTerms
Silverado Kids - 394697,true,Quia neque dolorem quis cum sit dolores omnis dolores ex.,,"quince,silver,violet,yellow,zone9",Ruecker - Jakubowski,2626181040130,false,2017-10-26T17:06:35.479433Z,false,,36,Service only
Sentra Electronics - 598797,true,Incidunt officiis minus vero distinctio quasi.,,"brown,mauve,white,zone2,zone7","Senger, Schinner and Zieme",3036454614095,false,2018-12-28T21:40:59.003417Z,false,,24,Service only
Ranchero Garden - 625229,true,Ipsum ea nam exercitationem ea perspiciatis.,,"brown,gold,mauve,purple,zone8",Pfeffer - Dicki,0805820409756,false,2018-06-01T17:29:48.427245Z,false,,1,Parts only