Travel rate 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
AccountNumber
Cost
Charge
Unit
ContractOnly

JSON file format¶

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

[
    {
        "Name": "Indigo BB",
        "Active": true,
        "Notes": "Eligendi ipsum totam odit omnis eius et at.",
        "Wiki": null,
        "Tags": [
            "brown",
            "green",
            "orange",
            "zone7",
            "zone9"
        ],
        "AccountNumber": "68876012",
        "Cost": 8.470000000000000000,
        "Charge": 16.940000000000000000,
        "Unit": "km",
        "ContractOnly": false
    },
    {
        "Name": "Cyan TT",
        "Active": true,
        "Notes": "Enim quis adipisci eum ea molestias aut porro.",
        "Wiki": null,
        "Tags": [
            "indigo",
            "yellow"
        ],
        "AccountNumber": "80516729",
        "Cost": 9.390000000000000000,
        "Charge": 18.780000000000000000,
        "Unit": "hours",
        "ContractOnly": false
    },
    {
        "Name": "Teal AW",
        "Active": true,
        "Notes": "Rem aperiam non qui illum doloremque iusto eos enim inventore.",
        "Wiki": null,
        "Tags": [
            "white",
            "yellow",
            "zebra"
        ],
        "AccountNumber": "83302044",
        "Cost": 3.170000000000000000,
        "Charge": 6.340000000000000000,
        "Unit": "miles",
        "ContractOnly": false
    }
]

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,AccountNumber,Cost,Charge,Unit,ContractOnly
Indigo BB,true,Eligendi ipsum totam odit omnis eius et at.,,"brown,green,orange,zone7,zone9",68876012,8.47,16.94,km,false
Cyan TT,true,Enim quis adipisci eum ea molestias aut porro.,,"indigo,yellow",80516729,9.39,18.78,hours,false
Teal AW,true,Rem aperiam non qui illum doloremque iusto eos enim inventore.,,"white,yellow,zebra",83302044,3.17,6.34,miles,false