MYOB Endpoint: JobsTable
Overview
The MYOB JobsTable endpoint allows you to access the list of jobs located within MYOB.
Note this endpoint is an alternate format of the Jobs endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.
Fields
The following fields are available for the JobsTable endpoint.
- DataFileID
- A guid field that provides the id of the data file as setup in OdataLink.
- DataFileName
- A text field provides the name of the data file as setup in OdataLink.
- DataFileCode
- A text field provides the code of the data file as setup in OdataLink.
- UID
- A GUID field representing the internal id of a job. This field can be used to link to other endpoints.
- Number
- A text field used as the job number.
- IsHeader
- A true/false value that indicates if the job is a header or detail job.
- Name
- A text field used as the job name.
- Description
- A text field used as the job description.
- ParentJobUID
- A GUID field that provides the internal id of a job assigned to this line. This field can be used to link to other endpoints.
- ParentJobNumber
- A text field that provides the job number assigned to this line.
- ParentJobName
- A text field that provides the job name assigned to this line.
- LinkedCustomerUID
- A GUID field that provides the internal id of the customer. This field can be used to link to other endpoints.
- LinkedCustomerName
- A text field that provides the full name of the customer.
- LinkedCustomerDisplayID
- A text field that provides the Card ID of the customer.
- PercentComplete
- A decimal field that gives access to the percentage completed as entered in the job screen.
- StartDate
- A date field that gives access to the start date as entered in the job screen.
- EndDate
- A date field that gives access to the end date as entered in the job screen.
- Contact
- A text field that gives access to the contact name as entered in the job screen.
- Manager
- A text field that gives access to the manager name as entered in the job screen.
- IsActive
- A true/false value that indicates if the job is active and useable within MYOB.
- TrackReimbursables
- A true/false value that indicates if the job is used to track reimbursables within MYOB.
- RowVersion
- A row version field.
MYOB API
For a detailed run through of the endpoint, you can see the MYOB API.
Related Endpoints