--- title: "Rand McNally" slug: "rand-mcnally" tags: ["Rand McNally", "Admin"] updated: 2026-10-14T17:05:53Z published: 2026-10-14T17:05:53Z canonical: "documents.revenova.com/rand-mcnally" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.revenova.com/llms.txt > Use this file to discover all available pages before exploring further. # Rand McNally Rand McNally is an API partner that provides data related to route mileage between Stops in a Load. The Rand McNally API integration works in the background with [Trimble Maps](/v1/docs/trimble-maps) to retrieve precise distance information (expressed in miles and kilometers) depending on TMS configuration. View the total distance between Stops on the Trimble Map under the Load Tracking Log. ## Setup Use the TMS Admin to configure the Rand McNally API to pull real-time route mileage data via MileMaker. ### **Enter Credentials** Enable the Rand McNally integration by completing the following steps: 1. Navigate to **TMS Admin**. 2. Select **Credentials**. 3. Select the **Global Services** tab. 4. Search or locate *Rand McNally* in the list and open the card. 5. Check the **Enabled** box. 6. Enter the **User ID** and **Password1** into the text field. 7. Click the **Save** button when finished. Valid credentials are required from a Rand McNally subscription. See examples in the table below. | User ID | Password 1 | Password 2 | Customer Number | | --- | --- | --- | --- | | - A required value provided via Rand McNally Portal Example: 123456 | - A required value provided via Rand McNally Portal Example: iKndyjn8&%vjod | | | > [!CAUTION] > **Warning**: The User ID and Password 1 values **must** match the values provided by Rand McNally. Any removed or inaccurate characters causes an error to appear in the Load Lightning Record Page (LRP) when retrieving or refreshing route data. ### **Remote Site Settings** Configure the Remote Site Settings for the Rand McNally integration URL and ensure these settings are updated. 1. Click the Setup Gear icon in the top right corner. 2. From the drop-down, click **Setup**. 3. In the Quick Find Toolbar, type *Remote Site Settings* and click the link. 4. From the list of remote sites, find *Rand McNally* and click the **Edit** link. 5. Confirm the Remote Site URL matches the *Service URL.* 6. When testing in a sandbox, confirm the Remote Site URL matches the *Test Service URL.* **Service URL**: ```xml https://milemaker.randmcnally.com/Api/MileMakerService/MileMaker.svc ``` **Test Service URL**: ```xml https://milemaker.randmcnally.com/Api/MileMakerService/MileMaker.svc ``` ## **Transportation Profile** Configure the mileage version and routing preferences on the [Customer Transportation Profile](/v1/docs/customer-transportation-profile#automatic-carrier-tracking-fields). The below field is only field that triggers a request to Rand McNally: - **Mileage API**: Set the Mileage API for each customer. - Options include *Rand McNally*, [*PC Miler*](/v1/docs/pc-miler), or *None*. Note the following fields under the Customer Mileage & Routing section in the Customer Transportation Profile are: - Mileage API Routing - Mileage API Toll Roads***** - Mileage API Borders - Mileage API Version - Mileage API Highway Only - Mileage API Override Restrictions Although these fields can be edited, they **are not** read or parsed by Rand McNally. Edit the page by clicking the pencil icon on the right side of the Customer Transportation Profile to hide these fields in the UI. > [!WARNING] > ***Note**: If there is a toll road route option between Stops, Rand McNally provides this information in the API response. This field is not stored in the TMS and does not impact routing. ## **Load Map** The Rand McNally integration does not support the **Route Options** feature on the [Load Map](/v1/docs/load-map) component. However, Rand McNally supports two other Load Map options that can be enabled or disabled: - Refresh map - Hide Weather ![""](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/refresh_map_hide_weather_buttons.png) ### Refresh Route > [!WARNING] > **Note**: The map displayed in the component is provided via the Trimble Map integration. Refreshing the Trimble Map **is not** the same as refreshing the route. Refreshing the Trimble Map *only* updates the map; whereas, refreshing the route updates the Stops *and* the map. Select the **Refresh Route** button ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/image(35).png) in the [Load Detail](/v1/docs/load-detail#stop-information) LWC to update the mileage information and the Load Map using the Rand McNally integration. ## Integration Calls The Rand McNally API integration makes two different requests via the MileMaker endpoint: - [Validate Mileage Operation](/v1/docs/rand-mcnally#validate-mileage-operation1) - [Get Mileage Operation](/v1/docs/rand-mcnally#get-mileage-operation1) Although both API requests respond differently, the Validate Mileage Operation and Get Mileage Operation work in tandem and cannot be requested separately. In the TMS, users trigger both requests simultaneously by: - **Creating or updating a Stop**. Creating Stops via the Load Configuration LWC or editing Stops/clicking the Refresh Route button in the Load Detail. - **Requesting Carrier Status update**. Clicking the Request Carrier Status button in the Load Lightning Record Page (LRP). ### Validate Operation The Validate Operation is the first step in ensuring the Stop location/address data from MileMaker is accurate. The Validate Operation confirms a location match and any adjacent locations that may also match. The TMS sends location information as URL parameters to determine if location data is valid. Locations accepted by Rand McNally include the following. - City, State - City, Count Qualifier, State - Latitude/Longitude - ZIP Code - 3-digit ZIP code > [!NOTE] > Rand McNally recognizes two-part city names and Canadian zip codes normally regardless of space between entered values. | Request Operation | Rand McNally/MileMaker Endpoint | Request Type | Response | | --- | --- | --- | --- | | - Creating/updating a Stop - Requesting Carrier Status Update | Receives locations that match or closely match location data provided. | GET | 200: SUCCESS | > [!CAUTION] > **Note**: The Validate Operation produces a FAILURE code for two reasons: > > - The User ID and Password 1 fields do not match the correct Rand McNally credentials. > - The Account associated with the Customer Transportation Profile does not have a complete address (for example, no city or zip code values). Base URL for the **GET Validate** request. ```xml https://milemaker.randmcnally.com/Api/MileMakerService/MileMaker.svc/Validate?location=Lebanon,OH&zipflag=0 ``` No TMS fields are included in the GET Validate request. Sample **GET Validate** response payload. No TMS fields are updated from the **GET Validate** response payload. ```json {  "ValidateResult": {    "Response": {      "Status": "SUCCESS",      "ValidatedRecord": [        {          "f1_City": "LEBANON",          "f2_County": "MO",          "f3_State": "OH",          "f4_Latitude": "39.616245",          "f5_Longitude": "-81.27402",          "f6_FullCounty": "MONROE",          "f8_Country": "US"        },        {          "f1_City": "LEBANON",          "f2_County": "WA",          "f3_State": "OH",          "f4_Latitude": "39.433376",          "f5_Longitude": "-84.20846",          "f6_FullCounty": "WARREN",          "f8_Country": "US"        },        {          "f1_City": "LEBANON JCT",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.77",          "f5_Longitude": "-84.18",          "f6_FullCounty": "MONTGOMERY",          "f8_Country": "US"        },        {          "f1_City": "LENOX",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.68354",          "f5_Longitude": "-80.78114",          "f6_FullCounty": "ASHTABULA",          "f8_Country": "US"        },        {          "f1_City": "LERADO",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.17473",          "f5_Longitude": "-84.0083",          "f6_FullCounty": "CLERMONT",          "f8_Country": "US"        },        {          "f1_City": "LEO",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.14805",          "f5_Longitude": "-82.6692",          "f6_FullCounty": "JACKSON",          "f8_Country": "US"        },        {          "f1_City": "LEVANNA",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "38.766567",          "f5_Longitude": "-83.88373",          "f6_FullCounty": "BROWN",          "f8_Country": "US"        },        {          "f1_City": "LEROY",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.025997",          "f5_Longitude": "-81.9332",          "f6_FullCounty": "MEDINA",          "f8_Country": "US"        },        {          "f1_City": "LENA",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.14029",          "f5_Longitude": "-84.027245",          "f6_FullCounty": "MIAMI",          "f8_Country": "US"        },        {          "f1_City": "LEON",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.653606",          "f5_Longitude": "-80.6161",          "f6_FullCounty": "ASHTABULA",          "f8_Country": "US"        },        {          "f1_City": "LEAPER",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "38.68223",          "f5_Longitude": "-82.2703",          "f6_FullCounty": "GALLIA",          "f8_Country": "US"        },        {          "f1_City": "LEAVITTSVILLE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.513607",          "f5_Longitude": "-81.1964",          "f6_FullCounty": "CARROLL",          "f8_Country": "US"        },        {          "f1_City": "LAWCO",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "38.63944",          "f5_Longitude": "-82.7022",          "f6_FullCounty": "LAWRENCE",          "f8_Country": "US"        },        {          "f1_City": "LECTA",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "38.674973",          "f5_Longitude": "-82.37665",          "f6_FullCounty": "LAWRENCE",          "f8_Country": "US"        },        {          "f1_City": "LETART FLS",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "38.893105",          "f5_Longitude": "-81.92433",          "f6_FullCounty": "MEIGS",          "f8_Country": "US"        },        {          "f1_City": "LE SOURDSVILLE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.441128",          "f5_Longitude": "-84.429985",          "f6_FullCounty": "BUTLER",          "f8_Country": "US"        },        {          "f1_City": "LEETONIA",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.87539",          "f5_Longitude": "-80.75591",          "f6_FullCounty": "COLUMBIANA",          "f8_Country": "US"        },        {          "f1_City": "LATHROP",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.44",          "f5_Longitude": "-81.91",          "f6_FullCounty": "ATHENS",          "f8_Country": "US"        },        {          "f1_City": "LEESBURG",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.345127",          "f5_Longitude": "-83.55476",          "f6_FullCounty": "HIGHLAND",          "f8_Country": "US"        },        {          "f1_City": "LAUGHLIN",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.62",          "f5_Longitude": "-80.58",          "f6_FullCounty": "COLUMBIANA",          "f8_Country": "US"        },        {          "f1_City": "LAYMAN",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.403255",          "f5_Longitude": "-81.72451",          "f6_FullCounty": "WASHINGTON",          "f8_Country": "US"        },        {          "f1_City": "LE MOYNE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.5",          "f5_Longitude": "-83.47",          "f6_FullCounty": "WOOD",          "f8_Country": "US"        },        {          "f1_City": "LEMOYNE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.495422",          "f5_Longitude": "-83.47328",          "f6_FullCounty": "WOOD",          "f8_Country": "US"        },        {          "f1_City": "LAYLAND",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.43568",          "f5_Longitude": "-81.96707",          "f6_FullCounty": "COSHOCTON",          "f8_Country": "US"        },        {          "f1_City": "LEAVITTSBURG",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.24031",          "f5_Longitude": "-80.8885",          "f6_FullCounty": "TRUMBULL",          "f8_Country": "US"        },        {          "f1_City": "LEES CRK",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.42028",          "f5_Longitude": "-83.649376",          "f6_FullCounty": "CLINTON",          "f8_Country": "US"        },        {          "f1_City": "LEESVILLE",          "f2_County": "CA",          "f3_State": "OH",          "f4_Latitude": "40.45172",          "f5_Longitude": "-81.21225",          "f6_FullCounty": "CARROLL",          "f8_Country": "US"        },        {          "f1_City": "LEESVILLE",          "f2_County": "CR",          "f3_State": "OH",          "f4_Latitude": "40.8",          "f5_Longitude": "-82.79",          "f6_FullCounty": "CRAWFORD",          "f8_Country": "US"        },        {          "f1_City": "LEESVILLE XRD",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.795483",          "f5_Longitude": "-82.78844",          "f6_FullCounty": "CRAWFORD",          "f8_Country": "US"        },        {          "f1_City": "LEIPSIC",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.09843",          "f5_Longitude": "-83.98438",          "f6_FullCounty": "PUTNAM",          "f8_Country": "US"        },        {          "f1_City": "LEIPSIC JCT",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.11",          "f5_Longitude": "-83.98",          "f6_FullCounty": "PUTNAM",          "f8_Country": "US"        },        {          "f1_City": "LEISTVILLE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.53252",          "f5_Longitude": "-82.84084",          "f6_FullCounty": "PICKAWAY",          "f8_Country": "US"        },        {          "f1_City": "LEITH",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.46",          "f5_Longitude": "-81.15",          "f6_FullCounty": "WASHINGTON",          "f8_Country": "US"        },        {          "f1_City": "LEMERT",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.89416",          "f5_Longitude": "-83.0936",          "f6_FullCounty": "CRAWFORD",          "f8_Country": "US"        },        {          "f1_City": "LEONARDSBURG",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.357086",          "f5_Longitude": "-82.98916",          "f6_FullCounty": "DELAWARE",          "f8_Country": "US"        },        {          "f1_City": "LESTER",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.180748",          "f5_Longitude": "-81.93781",          "f6_FullCounty": "MEDINA",          "f8_Country": "US"        },        {          "f1_City": "LATHAM",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.098877",          "f5_Longitude": "-83.24651",          "f6_FullCounty": "PIKE",          "f8_Country": "US"        },        {          "f1_City": "LATTY",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.091633",          "f5_Longitude": "-84.573425",          "f6_FullCounty": "PAULDING",          "f8_Country": "US"        },        {          "f1_City": "LAUB FOOD MRT 3",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.50502",          "f5_Longitude": "-84.3064",          "f6_FullCounty": "FULTON",          "f8_Country": "US"        },        {          "f1_City": "LAURA",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.99668",          "f5_Longitude": "-84.40865",          "f6_FullCounty": "MIAMI",          "f8_Country": "US"        },        {          "f1_City": "LAYHIGH",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.362545",          "f5_Longitude": "-84.69624",          "f6_FullCounty": "BUTLER",          "f8_Country": "US"        },        {          "f1_City": "LAWRENCE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "38.645",          "f5_Longitude": "-82.6736",          "f6_FullCounty": "LAWRENCE",          "f8_Country": "US"        },        {          "f1_City": "LAWRENCEVILLE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.98554",          "f5_Longitude": "-83.879486",          "f6_FullCounty": "CLARK",          "f8_Country": "US"        },        {          "f1_City": "LATTASVILLE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.35",          "f5_Longitude": "-83.21",          "f6_FullCounty": "ROSS",          "f8_Country": "US"        },        {          "f1_City": "LAWNDALE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.79",          "f5_Longitude": "-81.54",          "f6_FullCounty": "STARK",          "f8_Country": "US"        },        {          "f1_City": "LAWSHE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "38.94055",          "f5_Longitude": "-83.469696",          "f6_FullCounty": "ADAMS",          "f8_Country": "US"        },        {          "f1_City": "LATIMER",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "41.35667",          "f5_Longitude": "-80.618095",          "f6_FullCounty": "TRUMBULL",          "f8_Country": "US"        },        {          "f1_City": "LAUREL",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "38.91556",          "f5_Longitude": "-84.19109",          "f6_FullCounty": "CLERMONT",          "f8_Country": "US"        },        {          "f1_City": "LATTASBURG",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "40.87899",          "f5_Longitude": "-82.108315",          "f6_FullCounty": "WAYNE",          "f8_Country": "US"        },        {          "f1_City": "LAURELVILLE",          "f2_County": "",          "f3_State": "OH",          "f4_Latitude": "39.47288",          "f5_Longitude": "-82.73919",          "f6_FullCounty": "HOCKING",          "f8_Country": "US"        }      ]    }  } } ``` ### Get Mileage Operation The Get Mileage Operation is the final step in retrieving the routing distance data from MileMaker. The TMS sends location information as URL parameters to determine the distance between points. Locations accepted by Rand McNally include the following. - City, State - Address, City, State - City, Count Qualifier, State - Latitude/Longitude - ZIP Code - 3-digit ZIP code | TMS Operation | Rand McNally Endpoint | Request Type | Response | | --- | --- | --- | --- | | - Creating/updating a Stop - Requesting Carrier Status Update | Receives updated route mileage data from MileMaker. | GET | 200: SUCCESS 400: FAILURE | Sample base URL for the **GET Mileage** request. ```xml https://milemaker.randmcnally.com/Api/MileMakerService/MileMaker.svc/Mileage?routetype=P&location1=Brookfield,OH&Location2=Bannockburn,IL&Location3=Houston,TX&Location4=Boston,MA&trucklength=53&hazmat=0&kmflag=0&avoidtolls=0 ``` Sample **GET Mileage** response payload with a 200: SUCCESS. ```json {  "MileageResult": {    "Response": {      "Status": "SUCCESS",      "MileageRecord": [        {          "f1_Location": "Total",          "f2_Miles": "3401",          "f3_TollCostUSA": "383.27",          "f4_TollCostCN": "0.00",          "f5_Time": "57:17",          "f6_County": ""        },        {          "f1_Location": "BROOKFIELD,OH",          "f2_Miles": "",          "f3_TollCostUSA": "",          "f4_TollCostCN": "",          "f5_Time": "",          "f6_County": "TRUMBULL"        },        {          "f1_Location": "BANNOCKBURN,IL",          "f2_Miles": "432",          "f3_TollCostUSA": "176.85",          "f4_TollCostCN": "0.00",          "f5_Time": "8:11",          "f6_County": "LAKE"        },        {          "f1_Location": "HOUSTON,TX",          "f2_Miles": "1122",          "f3_TollCostUSA": "40.45",          "f4_TollCostCN": "0.00",          "f5_Time": "19:06",          "f6_County": "HARRIS"        },        {          "f1_Location": "BOSTON,MA",          "f2_Miles": "1847",          "f3_TollCostUSA": "165.97",          "f4_TollCostCN": "0.00",          "f5_Time": "30:00",          "f6_County": "SUFFOLK"        }      ]    }  } } ``` There is one (1) field stored in the TMS after triggering the Get Mileage request: | TMS Object | TMS Field | Type | Rand McNally Field | | --- | --- | --- | --- | | Stop | Miles Away | Number | f2_Miles | Sample **GET Mileage** response payload with a 400: FAILURE. ```json {  "errors": {    "location": [      "The location field is required."    ]  },  "type": "https://tools.ietf.org/html/rfc9110#section-15.5.1",  "title": "One or more validation errors occurred.",  "status": 400,  "traceId": "00-f208d3741a0d6cc86fdc44c82daf5f8a-4eab5fefb1778bbf-01" } ``` ## API Field Reference | TMS Object | TMS Field | Type | Rand McNally Field | | --- | --- | --- | --- | | Stop | Miles Away | Number | f2_Miles | ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Glossary/Setup%20Gear%202.gif)