Travel type endpoint

[priyasree.bhowmik]

Hi Dan,

Is there an endpoint to access Travel type data using TRAMS API.

Thanks and regards,

Priyasree

[Dan Palley]

Hi Priyasree,

Do you mean a way to just look up travel type definitions, or do you want to modify?

{

"apiVersion": "4.07",

"result":{

"resultcode": 0,

"resulttext": "",

"dataset":{

"name": "TravelType",

"flags":["update"],

"metaData":{"TravelType":{"TravelTypeNo":{"type": "integer", "flags":["PKField"…},

"data":{

"TravelType":[

{"TravelTypeNo": 1, "TravelCategory_LinkNo": 1, "TravelType": "Dom. Air", "PrintInd": "Y",…},

{"TravelTypeNo": 2, "TravelCategory_LinkNo": 2, "TravelType": "Hotel", "PrintInd": "Y",…},

{"TravelTypeNo": 3, "TravelCategory_LinkNo": 3, "TravelType": "Car", "PrintInd": "Y",…},

{"TravelTypeNo": 4, "TravelCategory_LinkNo": 4, "TravelType": "Ship-Dpst", "PrintInd": "Y",…},

{"TravelTypeNo": 5, "TravelCategory_LinkNo": 4, "TravelType": "Ship-Finl", "PrintInd": "Y",…},

{"TravelTypeNo": 6, "TravelCategory_LinkNo": 6, "TravelType": "Rail", "PrintInd": "N",…},

{"TravelTypeNo": 7, "TravelCategory_LinkNo": 8, "TravelType": "Insurance", "PrintInd": "Y",…},

{"TravelTypeNo": 8, "TravelCategory_LinkNo": 1, "TravelType": "Intl Air", "PrintInd": "N",…},

{"TravelTypeNo": 9, "TravelCategory_LinkNo": 5, "TravelType": "Tour-Dpst", "PrintInd": "N",…},

{"TravelTypeNo": 10, "TravelCategory_LinkNo": 5, "TravelType": "Tour-Finl", "PrintInd": "N",…},

{"TravelTypeNo": 11, "TravelCategory_LinkNo": 9, "TravelType": "Misc.", "PrintInd": "Y",…},

{"TravelTypeNo": 12, "TravelCategory_LinkNo": 10, "TravelType": "Finance Charges2", "PrintInd": "N",…},

{"TravelTypeNo": 13, "TravelCategory_LinkNo": 10, "TravelType": "Don't Use", "PrintInd": "N",…},

{"TravelTypeNo": 14, "TravelCategory_LinkNo": 10, "TravelType": "Don't Use", "PrintInd": "N",…},

{"TravelTypeNo": 15, "TravelCategory_LinkNo": 10, "TravelType": "Don't Use", "PrintInd": "N",…},

{"TravelTypeNo": 16, "TravelCategory_LinkNo": 10, "TravelType": "Don't Use", "PrintInd": "N",…},

{"TravelTypeNo": 17, "TravelCategory_LinkNo": 1, "TravelType": "Conj", "PrintInd": "N",…},

{"TravelTypeNo": 18, "TravelCategory_LinkNo": 6, "TravelType": "Query Test", "PrintInd": "N",…},

{"TravelTypeNo": 19, "TravelCategory_LinkNo": 10, "TravelType": "UserDef19", "PrintInd": "N",…},

{"TravelTypeNo": 20, "TravelCategory_LinkNo": 10, "TravelType": "UserDef20", "PrintInd": "N",…},

{"TravelTypeNo": 21, "TravelCategory_LinkNo": 10, "TravelType": "UserDef21", "PrintInd": "N",…},

{"TravelTypeNo": 22, "TravelCategory_LinkNo": 10, "TravelType": "UserDef22", "PrintInd": "N",…},

{"TravelTypeNo": 23, "TravelCategory_LinkNo": 10, "TravelType": "UserDef23", "PrintInd": "N",…},

{"TravelTypeNo": 24, "TravelCategory_LinkNo": 10, "TravelType": "UserDef24", "PrintInd": "N",…},

{"TravelTypeNo": 25, "TravelCategory_LinkNo": 10, "TravelType": "UserDef25", "PrintInd": "N",…},

{"TravelTypeNo": 26, "TravelCategory_LinkNo": 1, "TravelType": "UserDef26", "PrintInd": "N",…},

{"TravelTypeNo": 27, "TravelCategory_LinkNo": 1, "TravelType": "UserDef27", "PrintInd": "N",…},

{"TravelTypeNo": 28, "TravelCategory_LinkNo": 1, "TravelType": "UserDef28", "PrintInd": "N",…},

{"TravelTypeNo": 29, "TravelCategory_LinkNo": 1, "TravelType": "UserDef29", "PrintInd": "N",…},

{"TravelTypeNo": 30, "TravelCategory_LinkNo": 1, "TravelType": "UserDef30", "PrintInd": "N",…},

{"TravelTypeNo": 31, "TravelCategory_LinkNo": 1, "TravelType": "UserDef31", "PrintInd": "N",…},

{"TravelTypeNo": 32, "TravelCategory_LinkNo": 1, "TravelType": "UserDef32", "PrintInd": "N",…},

{"TravelTypeNo": 33, "TravelCategory_LinkNo": 1, "TravelType": "UserDef33", "PrintInd": "N",…},

{"TravelTypeNo": 34, "TravelCategory_LinkNo": 1, "TravelType": "UserDef34", "PrintInd": "N",…},

{"TravelTypeNo": 35, "TravelCategory_LinkNo": 1, "TravelType": "UserDef35", "PrintInd": "N",…},

{"TravelTypeNo": 36, "TravelCategory_LinkNo": 1, "TravelType": "UserDef36", "PrintInd": "N",…},

{"TravelTypeNo": 37, "TravelCategory_LinkNo": 1, "TravelType": "UserDef37", "PrintInd": "N",…},

{"TravelTypeNo": 38, "TravelCategory_LinkNo": 1, "TravelType": "UserDef38", "PrintInd": "N",…},

{"TravelTypeNo": 39, "TravelCategory_LinkNo": 1, "TravelType": "UserDef39", "PrintInd": "N",…},

{"TravelTypeNo": 40, "TravelCategory_LinkNo": 1, "TravelType": "UserDef40", "PrintInd": "N",…},

{"TravelTypeNo": 41, "TravelCategory_LinkNo": 1, "TravelType": "UserDef41", "PrintInd": "N",…},

{"TravelTypeNo": 42, "TravelCategory_LinkNo": 1, "TravelType": "UserDef42", "PrintInd": "N",…},

{"TravelTypeNo": 43, "TravelCategory_LinkNo": 1, "TravelType": "UserDef43", "PrintInd": "N",…},

{"TravelTypeNo": 44, "TravelCategory_LinkNo": 1, "TravelType": "UserDef44", "PrintInd": "N",…},

{"TravelTypeNo": 45, "TravelCategory_LinkNo": 1, "TravelType": "UserDef45", "PrintInd": "N",…},

{"TravelTypeNo": 46, "TravelCategory_LinkNo": 1, "TravelType": "UserDef46", "PrintInd": "N",…},

{"TravelTypeNo": 47, "TravelCategory_LinkNo": 1, "TravelType": "UserDef47", "PrintInd": "N",…},

{"TravelTypeNo": 48, "TravelCategory_LinkNo": 1, "TravelType": "UserDef48", "PrintInd": "N",…},

{"TravelTypeNo": 49, "TravelCategory_LinkNo": 1, "TravelType": "UserDef49", "PrintInd": "N",…},

{"TravelTypeNo": 50, "TravelCategory_LinkNo": 1, "TravelType": "UserDef50", "PrintInd": "N",…}

]

}

}

}

}

Dan

[priyasree.bhowmik]

Hi Dan,

We just need an endpoint to lookup. Is that available in version 4.07?

Thanks and regards,

Priyasree

[Dan Palley]

Yes, it's in 4.6.  Forgot to include the request URL:

http://localhost:8085/traveltype/runquery

Dan

[Mahesh Gajera]

Thanks a lot Dan. :)

[eric...@ciswired.com]

Hi Dan,

I came across this thread when I was looking for a way that we could determine the travel types and categories directly from the API.  Having this travel type endpoint is great.  I see that it includes the TravelCategory_LinkNo, but I wanted to see if there might be a way to retrieve the category name (Air, Hotel, Car, Cruise, Tour, etc.).  Do you know if there is a way for us to pull the travel category name via the API?

Thanks, Eli