/** * Microsoft Excel 365 Node - Version 2.2 * Discriminator: resource=table, operation=getColumns */ interface Credentials { microsoftExcelOAuth2Api: CredentialReference; } /** Represents an Excel table */ export type MicrosoftExcelV22TableGetColumnsParams = { resource: 'table'; operation: 'getColumns'; /** * 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 * @displayOptions.show { rawData: [true] } * @default {} */ filters?: { /** A comma-separated list of the fields to include in the response */ fields?: string | Expression | PlaceholderValue; }; }; export type MicrosoftExcelV22TableGetColumnsNode = { type: 'n8n-nodes-base.microsoftExcel'; version: 2.2; credentials?: Credentials; config: NodeConfig; };