A Flatfile plugin that performs data analysis and summarization by generating pivot tables from workbook data and uploading them as Markdown documents.
aggregateColumn
.groupByColumn
.pivotColumn
, aggregateColumn
, and aggregationMethod
to be defined. If groupByColumn
is not provided, the plugin will aggregate data across all records for each unique pivotColumn
value and present the result in a single “Total” column. The debug
mode is disabled by default, meaning errors are only reported back to the Flatfile job status without being logged to the console.
groupByColumn
and debug
options.
debug
flag.
debug: true
configuration option enabled and check your server-side logs for a more detailed error stack trace.
aggregateColumn
contains numeric data. Non-numeric values will be treated as 0.
job: 'workbook:generatePivotTable'
. This job must be initiated from the Flatfile UI or via an API callsheets.data[0]
). It does not currently support selecting a specific sheet by name or IDaggregateColumn
are expected to be numbers. Non-numeric values will be treated as 0try...catch
block to manage errors during its execution:
api.jobs.ack
api.jobs.complete
and a success messageapi.jobs.fail
and an error messagedebug: true
option is set, the caught error object is also logged to the console