Overview of data field mapping between JobProgress and One Click Contractor
The following is a detailed listing of the data fields and how they map between JobProgress and One Click.
| OCC Object | OCC Field | SF Field |
| User Object Linking | ||
| User | crm_id | User.id |
| User | User.email | |
| Job Object | ||
| Job | customer_name | job.customer.first_name job.customer.last_name |
| Job | name | job.name OR customer_name if blank |
| Job | job.customer.email | |
| Job | lead_source | NOT PROVIDED |
| Job | metadata.jobprogress_job_id | job.id |
| Job | metadata.jobprogress_customer_id | job.customer.id |
| Job Address | ||
| Job Address | line_1 | job.address.address |
| Job Address | line_2 | job.address.address_line_1 |
| Job Address | city | job.address.city |
| Job Address | state | job.address.state.name |
| Job Address | postal_code | job.address.zip |
| Job Phone (Multiple records are created if available) | ||
| Job Phone | name | Customer.Phones.label |
| Job Phone | number | Customer.Phones.number |
| Job Appointments (Can be Multiple) | ||
| Appointment | summary | Appointment.title |
| Appointment | notes | Appointment.description |
| Appointment | start_time | Appointment.start_date_time |
| Appointment | end_time | Appointment.end_date_time |
| Appointment | metadata.jobprogress_customer_id | Appointment.customer_id |
| Appointment | metadata.jobprogress_user_id | Appointment.user_id |
| Appointment | metadata.jobprogress_job_id | Appointment.jobs.data[0].id |