MacroPoint Integration Guide

Automatically track load locations with real-time updates from MacroPoint, no manual entry required.

Overview

MacroPoint is a leading freight visibility platform that lets brokers, carriers, and shippers track truck locations in real time. Through this integration, Salesforce automatically pulls location data from MacroPoint and attaches it to your load records, helping you eliminate check calls and improve transparency.

What This Integration Does

• Fetches latitude and longitude data from MacroPoint’s server
• Creates related location records in FTM
• Automatically associates each location update with the correct load record
• Ensures only valid GPS data is saved (records without coordinates are ignored)

Setup Instructions

Before using the integration, make sure the following setup steps are complete:

1. Get Access Credentials

You’ll need to collect the following from your MacroPoint account representative:

• MPID
• FTPS/SFTP Username
• FTPS/SFTP Password

These credentials grant FTM access to your location data on the MacroPoint Lite server.

2. Sandbox Setup (Optional for Testing)

To test before deploying live:

1. Go to Setup → Sandboxes
2. Create a new Developer sandbox (no Apex class needed)
3. After it’s ready (can take up to 24 hrs), log into test.salesforce.com
4. In Production: go to Setup → Deployment Settings and check “Allow Inbound Changes”
5. Share sandbox login credentials with your FTM implementation team

How the Integration Works

1. FTM connects to your MacroPoint Lite server via SFTP
2. It pulls .txt files containing real-time GPS data for all tracked loads
3. Each valid entry is parsed and stored as a FreightTM__Location_Site__c record
4. Each location record includes a lookup to the related FreightTM__Load__c

• Location records are only created if both latitude and longitude values are present, ensuring clean, reliable data.

Field Mapping in FTM

MacroPoint Field	FTM Field	Notes
UID	Load ID (Salesforce ID)	Used to match location to a load
Latitude/Longitude	Coordinates on Location record	Ignored if missing
Timestamp	Created Date on Location	Reflects time of tracking ping

File Access

MacroPoint data is typically stored at:
ftp.macropoint-lite.com/{MPID}
All data is placed in the root directory and accessed as .txt files.

FAQs

1. What happens if data is missing?
   The system only creates location records when both latitude and longitude are present.
2. Can I manually add locations?
   Yes, but they’ll be flagged differently than auto-synced records.
3. Do I need to change my load creation process?
   No. As long as your loads are correctly created in FTM, the system will handle location syncing automatically.

Need Help?

For assistance with setup, sandbox access, or SFTP validation, contact your FTM.cloud implementation team or email [email protected]

📄 MacroPoint API Docs