interface ItemListsV2NodeParameters {
aggregate?:
| "aggregateIndividualFields"
| "aggregateAllItemData";
code?: string;
compare?: | "allFields"
| "allFieldsExcept"
| "selectedFields";
destinationFieldName?: string;
fieldsToAggregate?: {
fieldToAggregate: {
fieldToAggregate?: string;
outputFieldName?: string;
renameField?: boolean;
}[];
};
fieldsToCompare?: { fields: { fieldName?: string }[] };
fieldsToExclude?: { fields: { fieldName?: string }[] };
fieldsToInclude?: { fields: { fieldName?: string }[] };
fieldsToSplitBy?: string;
fieldsToSummarize?: {
values: {
aggregation?:
| "append"
| "max"
| "average"
| "concatenate"
| "count"
| "countUnique"
| "min"
| "sum";
customSeparator?: string;
field?: string;
includeEmpty?: boolean;
separateBy?: ""
| "other"
| ","
| ", "
| "\n"
| " ";
}[];
};
fieldToSplitOut?: string;
include?: | "allFields"
| "specifiedFields"
| "allFieldsExcept"
| "noOtherFields"
| "allOtherFields"
| "selectedOtherFields";
keep?: "firstItems"
| "lastItems";
maxItems?: number;
operation?:
| "aggregateItems"
| "limit"
| "removeDuplicates"
| "sort"
| "splitOutItems"
| "summarize";
options?: | {
disableDotNotation?: boolean;
removeOtherFields?: boolean;
}
| { disableDotNotation?: boolean }
| {
destinationFieldName?: string;
disableDotNotation?: boolean;
keepMissing?: boolean;
mergeLists?: boolean;
}
| {
disableDotNotation?: boolean;
outputFormat?: "separateItems"
| "singleItem";
skipEmptySplitFields?: boolean;
};
sortFieldsUi?: {
sortField: {
fieldName: string;
order?: "ascending"
| "descending";
}[];
};
type?: "simple"
| "random"
| "code";
}
Properties§
Source§readonly code?: string
readonly code?: string
Javascript code to determine the order of any two items Default: "// The two items to compare are in the variables a and b\n// Access the fields in a.json and b.json\n// Return -1 if a should go before b\n// Return 1 if b should go before a\n// Return 0 if there's no difference\n\nfieldName = 'myField';\n\nif (a.json[fieldName] < b.json[fieldName]) {\n\t\treturn -1;\n}\nif (a.json[fieldName] > b.json[fieldName]) {\n\t\treturn 1;\n}\nreturn 0;" Type options: {"alwaysOpenEditWindow":true,"editor":"jsEditor","rows":10}
Source§readonly compare?: "allFields" | "allFieldsExcept" | "selectedFields"
readonly compare?: "allFields" | "allFieldsExcept" | "selectedFields"
The fields of the input items to compare to see if they are the same Default: "allFields"
Source§readonly destination Field Name?: string
readonly destination Field Name?: string
The name of the output field to put the data in Default: "data"
Source§readonly fields To Aggregate?: {
fieldToAggregate: {
fieldToAggregate?: string;
outputFieldName?: string;
renameField?: boolean;
}[];
}
readonly fields To Aggregate?: {
fieldToAggregate: {
fieldToAggregate?: string;
outputFieldName?: string;
renameField?: boolean;
}[];
}
Default: {"fieldToAggregate":[{"fieldToAggregate":"","renameField":false}]} Type options: {"multipleValues":true}
Source§readonly fields To Compare?: { fields: { fieldName?: string }[] }
readonly fields To Compare?: { fields: { fieldName?: string }[] }
Default: {} Type options: {"multipleValues":true}
Source§readonly fields To Exclude?: { fields: { fieldName?: string }[] }
readonly fields To Exclude?: { fields: { fieldName?: string }[] }
Default: {} Type options: {"multipleValues":true}
Source§readonly fields To Include?: { fields: { fieldName?: string }[] }
readonly fields To Include?: { fields: { fieldName?: string }[] }
Default: {} Type options: {"multipleValues":true}
Source§readonly fields To Split By?: string
readonly fields To Split By?: string
The name of the input fields that you want to split the summary by
Source§readonly fields To Summarize?: {
values: {
aggregation?:
| "append"
| "max"
| "average"
| "concatenate"
| "count"
| "countUnique"
| "min"
| "sum";
customSeparator?: string;
field?: string;
includeEmpty?: boolean;
separateBy?: ""
| "other"
| ","
| ", "
| "\n"
| " ";
}[];
}
readonly fields To Summarize?: {
values: {
aggregation?:
| "append"
| "max"
| "average"
| "concatenate"
| "count"
| "countUnique"
| "min"
| "sum";
customSeparator?: string;
field?: string;
includeEmpty?: boolean;
separateBy?: ""
| "other"
| ","
| ", "
| "\n"
| " ";
}[];
}
Default: {"values":[{"aggregation":"count","field":""}]} Type options: {"multipleValues":true}
Source§readonly field To Split Out?: string
readonly field To Split Out?: string
The name of the input fields to break out into separate items
Source§readonly include?:
| "allFields"
| "specifiedFields"
| "allFieldsExcept"
| "noOtherFields"
| "allOtherFields"
| "selectedOtherFields"
readonly include?:
| "allFields"
| "specifiedFields"
| "allFieldsExcept"
| "noOtherFields"
| "allOtherFields"
| "selectedOtherFields"
Whether to copy any other fields into the new items Default: "noOtherFields"
Source§readonly keep?: "firstItems" | "lastItems"
readonly keep?: "firstItems" | "lastItems"
When removing items, whether to keep the ones at the start or the ending Default: "firstItems"
Source§readonly max Items?: number
readonly max Items?: number
If there are more items than this number, some are removed Default: 1 Type options: {"minValue":1}
Source§readonly operation?:
| "aggregateItems"
| "limit"
| "removeDuplicates"
| "sort"
| "splitOutItems"
| "summarize"
readonly operation?:
| "aggregateItems"
| "limit"
| "removeDuplicates"
| "sort"
| "splitOutItems"
| "summarize"
Default: "splitOutItems"
Source§readonly options?:
| {
disableDotNotation?: boolean;
removeOtherFields?: boolean;
}
| { disableDotNotation?: boolean }
| {
destinationFieldName?: string;
disableDotNotation?: boolean;
keepMissing?: boolean;
mergeLists?: boolean;
}
| {
disableDotNotation?: boolean;
outputFormat?: "separateItems"
| "singleItem";
skipEmptySplitFields?: boolean;
}
readonly options?:
| {
disableDotNotation?: boolean;
removeOtherFields?: boolean;
}
| { disableDotNotation?: boolean }
| {
destinationFieldName?: string;
disableDotNotation?: boolean;
keepMissing?: boolean;
mergeLists?: boolean;
}
| {
disableDotNotation?: boolean;
outputFormat?: "separateItems"
| "singleItem";
skipEmptySplitFields?: boolean;
}
Default: {}
Default: "aggregateIndividualFields"