The Hubspot API syncs deal and contact information into Airtable. Currently only available for STAFFLINK and Airtable.
Once implemented, please do not change the names of any tables used by the API. Consequently, please also do not change any of the fields that the API feeds data into for each record. If you change data in any of the fields, the API will overwrite it on the next run.
Not all data is available from Sprout, only selected data that is provided by the Sprout API.
The following jobs run to syncronise data.
Employees Job
The Employees job syncronises Employees data into Airtable and runs every 10 minutes, updating all records modified since the last run time.
Fields For OS Staff Table
Hubspot Data | Field Name | Field Type |
First name of employee | First_Name | Text |
Last name of employee | Last_Name | Text |
Employee gender | Gender | Text |
Employe DOB | Date_Of_Birth | Date |
Internal Sprout record Id | Record_Id | Text |
Employee phone number | Phone_Number | Text |
Employees's Stafflink Email | SL_Email | Text |
The department of the employee | Department | Text |
The employees location | Location | Single Select |
Status of the employee | Employment_Status | Single Select |
The date they were hired | Hire_Date | Date |
The date they were let go | Separation_Date | Date |
Who the employee reports to | Reports_To | Text |
The salary for the employee | Basic_Salary | Currency |