Snapshot API: JobChanges
The Snapshot API endpoint for job changes (actual/target stage dates, job field data and deadlines) is regenerated overnight. The date range included depends on the endpoint called:
- /snapshot/jobchanges - returns the job changes data for the preceding day.
- /snapshot/dailyjobevents - returns all job changes data in the Glide system.
- /snapshot/dailyjobevents/{date} - returns job changes data for the specific date specified in the URL (yyyy-mm-dd).
A typical implementation pattern would be to have a process that retrieves /dailyjobevents; this would allow a database to be populated with all data held in Glide. Thereafter, to reduce the size of data being retrieved, have a recurring daily process that retrieves /jobchanges and supplements your existing local database with the new data generated on the preceding day.
All of the above snapshots contain the following information:
| Field name | Field type | Meaning |
| GlideID | Integer | The Glide ID/Unique identifier for this data point. (Unique) |
| JobID | Integer | The Glide ID/Unique identifier for the job. |
| SubJobID | Integer | The Glide ID/Unique identifier for the sub-job. |
| StageID | Integer | The Glide ID/Unique identifier for the stage/field/deadline to which the data point relates. |
| Stage | VARCHAR(250) | The name of the stage/field/deadline to which the data point relates. |
| LogType | Options | ActualDate, TargetDate, JobFields, Deadline, JobFieldTarget. |
| DateValue | Date | The date for actual dates, target dates, deadlines or job field data (where the job field type is appropriate). |
| IntegerValue | Integer | The job field data for job fields of the appropriate type. |
| StringValue | VARCHAR(20) | The job field data for job fields of the appropriate type. |
| DateCreated | Date | The date the log was created. |
| CreatedBy | Glide user ID (Integer) | The unique GlideID for the user that crated the log. The value 'Automated' is returned where system generated. |
| StepID | Glide step ID (Integer) | The unique identifier for the step that created the log. This is relevant to actual date log types. |
| Step | VARCHAR(40) | The name of the step that created the log. This is relevant to actual date log types. |
| LogStatus | Integer | 0 = Active, 1 = Deleted. |