It really depends on how the GPS data is stored on the server and what your options are to get to that data. If it is in plain text and the data is accessible on the server where you are able to execute the ETL through for example a cifs share you could load the data by doing a something like:
BULK INSERT dbo.GPSApi_Table
FROM 'some_location/gpsdata'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR =' \n'
);
The table has to reflect the data you extract. Otherwise you need to do some transformations before you load the data in to sql server. Some validations would be welcome as well of course.
My suggestion would be to take a look at SSIS to help you build the ETL. After you build and tested it you can then schedule it in SQL Server to run periodically in production.
Hope this helps you
Harold