excel.interfaces.querydata.yml

### YamlMime:TSType
name: Excel.Interfaces.QueryData
uid: 'excel!Excel.Interfaces.QueryData:interface'
package: excel!
fullName: Excel.Interfaces.QueryData
summary: An interface describing the data returned by calling `query.toJSON()`<!-- -->.
remarks: ''
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: error
    uid: 'excel!Excel.Interfaces.QueryData#error:member'
    package: excel!
    fullName: error
    summary: Gets the query error message from when the query was last refreshed.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: >-
        error?: Excel.QueryError | "Unknown" | "None" | "FailedLoadToWorksheet" | "FailedLoadToDataModel" |
        "FailedDownload" | "FailedToCompleteDownload";
      return:
        type: >-
          <xref uid="excel!Excel.QueryError:enum" /> | "Unknown" | "None" | "FailedLoadToWorksheet" |
          "FailedLoadToDataModel" | "FailedDownload" | "FailedToCompleteDownload"
  - name: loadedTo
    uid: 'excel!Excel.Interfaces.QueryData#loadedTo:member'
    package: excel!
    fullName: loadedTo
    summary: Gets the query loaded to object type.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'loadedTo?: Excel.LoadToType | "ConnectionOnly" | "Table" | "PivotTable" | "PivotChart";'
      return:
        type: '<xref uid="excel!Excel.LoadToType:enum" /> | "ConnectionOnly" | "Table" | "PivotTable" | "PivotChart"'
  - name: loadedToDataModel
    uid: 'excel!Excel.Interfaces.QueryData#loadedToDataModel:member'
    package: excel!
    fullName: loadedToDataModel
    summary: Specifies if the query loaded to the data model.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'loadedToDataModel?: boolean;'
      return:
        type: boolean
  - name: name
    uid: 'excel!Excel.Interfaces.QueryData#name:member'
    package: excel!
    fullName: name
    summary: Gets the name of the query. Query names cannot contain periods or quotation marks.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'name?: string;'
      return:
        type: string
  - name: refreshDate
    uid: 'excel!Excel.Interfaces.QueryData#refreshDate:member'
    package: excel!
    fullName: refreshDate
    summary: Gets the date and time when the query was last refreshed.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'refreshDate?: Date;'
      return:
        type: Date
  - name: rowsLoadedCount
    uid: 'excel!Excel.Interfaces.QueryData#rowsLoadedCount:member'
    package: excel!
    fullName: rowsLoadedCount
    summary: >-
      Gets the number of rows that were loaded when the query was last refreshed. If last refresh has errors the value
      will be -1.
    remarks: '\[ [API set: ExcelApi 1.14](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'rowsLoadedCount?: number;'
      return:
        type: number