/** * Microsoft Excel 365 Node - Version 2 * Discriminator: resource=table, operation=getRows */ interface Credentials { microsoftExcelOAuth2Api: CredentialReference; } /** Represents an Excel table */ export type MicrosoftExcelV2TableGetRowsParams = { resource: 'table'; operation: 'getRows'; /** * Workbook * @default {"mode":"list","value":""} */ workbook?: { __rl: true; mode: 'list' | 'id'; value: string; cachedResultName?: string }; /** * Sheet * @default {"mode":"list","value":""} */ worksheet?: { __rl: true; mode: 'list' | 'id'; value: string; cachedResultName?: string }; /** * Table * @default {"mode":"list","value":""} */ table?: { __rl: true; mode: 'list' | 'id'; value: string; cachedResultName?: string }; /** * Whether to return all results or only up to a given limit * @default false */ returnAll?: boolean | Expression; /** * Max number of results to return * @displayOptions.show { returnAll: [false] } * @default 100 */ limit?: number | Expression; /** * Whether the data should be returned RAW instead of parsed into keys according to their header * @default false */ rawData?: boolean | Expression; /** * The name of the property into which to write the RAW data * @displayOptions.show { rawData: [true] } * @default data */ dataProperty?: string | Expression | PlaceholderValue; /** * Filters * @default {} */ filters?: { /** A comma-separated list of the fields to include in the response * @displayOptions.show { /rawData: [true] } */ fields?: string | Expression | PlaceholderValue; /** Choose from the list, or specify an ID using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. Choose from the list, or specify IDs using an <a href="https://docs.n8n.io/code/expressions/">expression</a>. * @displayOptions.show { /rawData: [false] } * @default [] */ column?: string[]; }; }; export type MicrosoftExcelV2TableGetRowsNode = { type: 'n8n-nodes-base.microsoftExcel'; version: 2; credentials?: Credentials; config: NodeConfig; };