private static string resolveWorksheetId(JToken queryData, JObject queryResponse)
        {
            string worksheetId = null;

            if (queryData["id"] == null)
            {
                var worksheetName = queryData.Value <string>("name");
                var allWorksheets = BlpTerminal.GetAllWorksheets();
                foreach (BlpWorksheet sheet in allWorksheets)
                {
                    if (sheet.Name.Equals(worksheetName))
                    {
                        worksheetId = sheet.Id;
                        break;
                    }
                }
                if (worksheetId == null)
                {
                    queryResponse.Add("status", false);
                    queryResponse.Add("message", "Worksheet '" + worksheetName + "' not found");
                }
            }
            else
            {
                worksheetId = queryData.Value <string>("id");
            }
            return(worksheetId);
        }
        private static void GetAllWorksheets(JObject queryResponse)
        {
            var    allWorksheets = BlpTerminal.GetAllWorksheets();
            JArray worksheets    = new JArray();

            foreach (BlpWorksheet sheet in allWorksheets)
            {
                worksheets.Add(renderWorksheet(sheet, false));
            }
            queryResponse.Add("status", true);
            queryResponse.Add("worksheets", worksheets);
        }