Skip to main content
Sprout API
SLINKY avatar
Written by SLINKY
Updated over 4 months ago

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

Did this answer your question?