Api: Airtable Integration

[daleighan]

Goals:

• Make it so that lb.waivecar.com shows info from airtable. The info fetched may be stored as text on - the car object or some other way of storing the information may be used. Later, when this is confirmed to work, the info will be saved to the cars model and will not be editable on lb
• Add the ability to add airtable tickets on lb.waivecar.com
• Separate cars from telematics by using a new telematics table. This should allow switching of telematics units: id | car_id | telem_id | first_seen | last_seen
• Change where cars are added. Where cars are currently added, add new telem to the telematics table instead
• Cars should now be added in cars-sync loop, but only once their telematics id is added to airtable. This is so that cars can be added to airtable before they have a telematics unit installed.
• Make sure the telematics can be reassigned from airtable
• Add a route showing unassigned telems (doesn’t really need to have a front end, can just return json)

(Airtable API docs here: https://airtable.com/appPTFWqjSvOrKcfu/api/docs#curl/table:screens:fields)

[daleighan]

create table telematics (
  id int(11) not null auto_increment,
  telem_id  varchar(28) not null,
  car_id varchar(28) default null,
  created_at datetime not null,
  updated_at datetime not null,
  deleted_at datetime default null,
  last_seen_at datetime default null,
  PRIMARY KEY(`id`)
);
alter table cars add column airtable_data text default null after comments;

[daleighan]

There is now a route for listing unassigned telematics: api.waivecar.com/unassignedTelematics