interface QuickBaseNodeParameters {
binaryPropertyName?: string;
columns?: string;
fieldId?: string;
limit?: number;
mergeFieldId?: string;
operation?:
| "create"
| "get"
| "getAll"
| "update"
| "delete"
| "upsert"
| "download"
| "run";
options?: | { includeFieldPerms?: boolean }
| { fields?: unknown[]; useFieldIDs?: boolean }
| {
select?: unknown[];
sortByUi?: {
sortByValues: {
fieldId?: string;
order?: "ASC" | "DESC";
}[];
};
where?: string;
};
recordId?: string;
reportId?: string;
resource?: "record"
| "file"
| "report"
| "field";
returnAll?: boolean;
simple?: boolean;
tableId?: string;
updateKey?: string;
versionNumber?: number;
where?: string;
}
Properties§
Source§readonly columns?: string
readonly columns?: string
Comma-separated list of the properties which should used as columns for the new rows
Source§readonly limit?: number
readonly limit?: number
Max number of results to return Default: 50 Type options: {"minValue":1,"maxValue":100}
Source§readonly merge Field Id?: string
readonly merge Field Id?: string
You're updating records in a Quick Base table with data from an external file. In order for a merge like this to work, Quick Base needs a way to match records in the source data with corresponding records in the destination table.
You make this possible by choosing the field in the app table that holds unique matching values. This is called a merge field.
. Choose from the list, or specify an ID using an expression. Type options: {"loadOptionsMethod":"getUniqueTableFields"}Source§readonly operation?:
| "create"
| "get"
| "getAll"
| "update"
| "delete"
| "upsert"
| "download"
| "run"
readonly operation?:
| "create"
| "get"
| "getAll"
| "update"
| "delete"
| "upsert"
| "download"
| "run"
Default: "getAll"
Source§readonly options?:
| { includeFieldPerms?: boolean }
| { fields?: unknown[]; useFieldIDs?: boolean }
| {
select?: unknown[];
sortByUi?: {
sortByValues: {
fieldId?: string;
order?: "ASC" | "DESC";
}[];
};
where?: string;
}
readonly options?:
| { includeFieldPerms?: boolean }
| { fields?: unknown[]; useFieldIDs?: boolean }
| {
select?: unknown[];
sortByUi?: {
sortByValues: {
fieldId?: string;
order?: "ASC" | "DESC";
}[];
};
where?: string;
}
Default: {}
Source§readonly simple?: boolean
readonly simple?: boolean
Whether to return a simplified version of the response instead of the raw data Default: true
Default: "data"