Get Jobs And Worksheets CSV

This method will return a CSV file containing the details of a job and the answers given in the worksheet questions for the jobs. Because different jobs can have different worksheet answers the number of columns returned will vary between jobs and calls to this service.

Query String Parameters

Name	Type	Description	Required
Action	String	JobsAndWorksheetsCSV	Required
Start	Datetime	Date you want jobs data from. Format: yyyy-MM-dd HH:mm:ss.	Required
End	Datetime	Date you want jobs data to. Format: yyyy-MM-dd HH:mm:ss.	Required
JobId	Int		Optional
JobGroup	String	Job group reference.	Optional
JobTypeId	Int		Optional
ResourceId	Int	Job resource Id.	Optional
ResourceGroupId	String		Optional
ContactId	Int		Optional

Response Codes

Code	Message	Information
0	No result
0	dataTable
2	error
2	Missing or invalid parameter - Start
2	Missing or invalid parameter - End

Example

Request

Request URL

https://webservice.bigchange.com/v01/services.ashx?action=jobsandworksheetscsv

Response

Response Data

{
  "Code": 0,
  "Result": [
    {
      "ContactNoteId": "12345"
    }
  ]
}