Get a List of Worksheets And Questions

This service lists all questions and their associated worksheets, useful when building a spreadsheet to filter by worksheet if csv format is returned.

Query String Parameters

Name	Type	Description	Required
Action	String	WorksheetsAndQuestions	Required
Format	String	JSON, XML or CSV - default format is JSON.	Optional

Response Codes

Code	Message	Information
0	Response Object	See 'Response' example tab

Example

Request

Request URL

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

Response

Response Data

{
  "Code": 0,
  "Result": [
    {
      "WorksheetName": "A0024 Catering Engineers Electrical Report",
      "WorksheetQuestionId": 81326,
      "WorksheetQuestionWorksheetId": 6489,
      "WorksheetQuestionText": "(2) Earth Continuity",
      "WorksheetQuestionType": 0,
      "WorksheetQuestionExtra": "",
      "WorksheetQuestionMandatory": false,
      "WorksheetQuestionOrder": 28,
      "WorksheetQuestionOwnerId": 2381,
      "WorksheetQuestionOnJobCard": true,
      "WorksheetQuestionCustomerId": 298,
      "WorksheetQuestionAnswerRequirePhoto": false
    },
    {
      "WorksheetName": "A0024 Catering Engineers Electrical Report",
      "WorksheetQuestionId": 81328,
      "WorksheetQuestionWorksheetId": 6489,
      "WorksheetQuestionText": "(2) Serviced as per HCS schedule",
      "WorksheetQuestionType": 0,
      "WorksheetQuestionExtra": "",
      "WorksheetQuestionMandatory": false,
      "WorksheetQuestionOrder": 30,
      "WorksheetQuestionOwnerId": 2381,
      "WorksheetQuestionOnJobCard": true,
      "WorksheetQuestionCustomerId": 298,
      "WorksheetQuestionAnswerRequirePhoto": false
    },
    {
      "WorksheetName": "A0024 Catering Engineers Electrical Report",
      "WorksheetQuestionId": 81329,
      "WorksheetQuestionWorksheetId": 6489,
      "WorksheetQuestionText": "(2) Appliance safe to use?",
      "WorksheetQuestionType": 0,
      "WorksheetQuestionExtra": "",
      "WorksheetQuestionMandatory": false,
      "WorksheetQuestionOrder": 31,
      "WorksheetQuestionOwnerId": 2381,
      "WorksheetQuestionOnJobCard": true,
      "WorksheetQuestionCustomerId": 298,
      "WorksheetQuestionAnswerRequirePhoto": false
    },
    {
      "WorksheetName": "A0025 Catering Equip Sales, Services, Installation",
      "WorksheetQuestionId": 81448,
      "WorksheetQuestionWorksheetId": 6490,
      "WorksheetQuestionText": "Order No.",
      "WorksheetQuestionType": 3,
      "WorksheetQuestionExtra": "",
      "WorksheetQuestionMandatory": false,
      "WorksheetQuestionOrder": 0,
      "WorksheetQuestionOwnerId": 2381,
      "WorksheetQuestionOnJobCard": true,
      "WorksheetQuestionCustomerId": 298,
      "WorksheetQuestionAnswerRequirePhoto": false
    },
    {
      "WorksheetName": "A0025 Catering Equip Sales, Services, Installation",
      "WorksheetQuestionId": 81449,
      "WorksheetQuestionWorksheetId": 6490,
      "WorksheetQuestionText": "Warranty",
      "WorksheetQuestionType": 3,
      "WorksheetQuestionExtra": "",
      "WorksheetQuestionMandatory": false,
      "WorksheetQuestionOrder": 1,
      "WorksheetQuestionOwnerId": 2381,
      "WorksheetQuestionOnJobCard": true,
      "WorksheetQuestionCustomerId": 298,
      "WorksheetQuestionAnswerRequirePhoto": false
    },
    {
      "WorksheetName": "A0025 Catering Equip Sales, Services, Installation",
      "WorksheetQuestionId": 81450,
      "WorksheetQuestionWorksheetId": 6490,
      "WorksheetQuestionText": "Engineers Initials",
      "WorksheetQuestionType": 3,
      "WorksheetQuestionExtra": "",
      "WorksheetQuestionMandatory": false,
      "WorksheetQuestionOrder": 2,
      "WorksheetQuestionOwnerId": 2381,
      "WorksheetQuestionOnJobCard": true,
      "WorksheetQuestionCustomerId": 298,
      "WorksheetQuestionAnswerRequirePhoto": false
    }
  ]
}