util-response-rejection

This plugin handles response rejections returned from an external source.


plugin-autocast

A plugin for automatically casting values in Flatfile.

plugin-automap

A plugin to provide automapping imported files for headless workflows.

plugin-constraints

A plugin for extending blueprint with external constraints

plugin-convert-currency

A Flatfile plugin for currency conversion using Open Exchange Rates API

plugin-convert-json-schema

A plugin for converting JSON Schema to Flatfile Blueprint and configuring a...

plugin-convert-openapi-schema

A plugin for converting OpenAPI schema to Flatfile Blueprint.

plugin-convert-sql-ddl

A plugin for converting SQL DDL into Flatfile Blueprint.

plugin-convert-translate

A Flatfile Listener plugin for field translation using the Google Translate...

plugin-convert-what3words

A Flatfile plugin for converting What3Words addresses to standard addresses...

plugin-convert-yaml-schema

A plugin for converting YAML Schema definitions to Flatfile Blueprint.

plugin-dedupe

Dedupe records in a sheet via a sheet level custom action.

plugin-delimiter-extractor

A plugin for parsing .delimiter files in Flatfile.

plugin-dxp-configure

A plugin for using DXP class-based configurations.

plugin-enrich-geocode

A Flatfile plugin for geocoding addresses using the Google Maps Geocoding A...

plugin-enrich-gpx

A Flatfile plugin for parsing GPX files and extracting relevant data

plugin-enrich-sentiment

A Flatfile plugin for sentiment analysis of text fields in records

plugin-enrich-summarize

A Flatfile plugin for text summarization and key phrase extraction

plugin-export-delimited-zip

A Flatfile plugin for exporting Workbooks to delimited files and zipping th...

plugin-export-pivot-table

A Flatfile plugin for generating pivot tables from sheet data and saving as...

plugin-export-workbook

A plugin for exporting data in Flatfile to Workbooks.

plugin-extract-html-table

A Flatfile plugin for extracting table data from HTML files

plugin-extract-markdown

A plugin for parsing markdown files in Flatfile.

plugin-import-faker

A Flatfile plugin that generates example records using Faker

plugin-import-llm-records

A Flatfile plugin that generates example records using AI

plugin-import-rss

A Flatfile plugin for importing RSS feed data

plugin-job-handler

A plugin for handling Flatfile Jobs.

plugin-json-extractor

A plugin for parsing json files in Flatfile.

plugin-markdown-extractor

A plugin for parsing markdown files in Flatfile.

plugin-pdf-extractor

A plugin for parsing PDF files in Flatfile.

plugin-record-hook

A plugin for running custom logic on individual data records in Flatfile.

plugin-rollout

A plugin for automatically rolling out new changes to workbooks in flatfile...

plugin-space-configure

A plugin for configuring a Flatfile Space.

plugin-space-configure-from-template

A plugin for configuring a Flatfile Space from a Space Template.

plugin-stored-constraints

A plugin for running stored constraints

plugin-validate-boolean

A Flatfile plugin for boolean validation with multi-language support

plugin-validate-date

A Flatfile plugin for normalizing date formats

plugin-validate-email

A Flatfile Listener plugin for email validation

plugin-validate-isbn

A Flatfile Listener plugin for ISBN validation with configurable options. V...

plugin-validate-number

A Flatfile Listener plugin for number validation

plugin-validate-phone

A validator plugin for phone number formatting on individual data records i...

plugin-validate-string

A Flatfile plugin for string configuration and validation

plugin-view-mapped

A plugin for making the view post mapping show only mapped columns.

plugin-webhook-egress

A plugin for egressing data from a Flatfile Workbook to a webhook.

plugin-xlsx-extractor

A plugin for parsing xlsx files in Flatfile.

plugin-xml-extractor

A plugin for parsing .xml files in Flatfile.

plugin-zip-extractor

A plugin for unzipping zip files and uploading content back in Flatfile.

util-extractor

A library containing common utilities and helpers for extractors.

util-file-buffer

A utility for extracting data from any file and making it available as a bu...

util-response-rejection

This plugin handles response rejections returned from an external source.

Installation


Installnpm i @flatfile/util-response-rejection
Source: View source
Package:@flatfile/util-response-rejection 1k installs

The @flatfile/util-response-rejection utility is built to handle response rejections from an external source. It is designed to be used as a rejection response handler in an egress listener.

Response Rejection

Usage

The purpose of @flatfile/util-response-rejection utility is to handle cases where some Records were rejected during an egress process. The responseRejectionHandler function is designed to consume a set of sheets containing rejected Records, and then process the rejected Records by marking the offending Record fields with the returned rejection message indicating why they were rejected. If the response value of deleteSubmitted is true, the successfully submitted values will be deleted from the Sheet. If deleteSubmitted is false or not provided, a Submission Status field is added to the Sheet and each Record is set to either "Submitted" or "Rejected". In the end, it returns a total count of all rejected Records across all sheets that can be used in a Job completion message.

npm i @flatfile/util-response-rejection
import {
  responseRejectionHandler,
  RejectionResponse,
} from "@flatfile/util-response-rejection";

Response Rejection Handler Function

  • The responseRejectionHandler function is the main entry point of the utility. It takes one parameter:
    • responseRejection: An object containing the rejection data. This object's structure is defined by the RejectionResponse interface.
  • The responseRejectionHandler function returns a Promise that resolves to a number representing the total number of rejected Records across all sheets.
listener.on(
  "job:ready",
  { job: "workbook:submitActionFg" },
  async ({ context: { jobId } }) => {
    // ...
    const response = await axios.post("https://webhook.site/...", data, {
      headers: {
        "Content-Type": "application/json",
      },
    });

    const rejections: RejectionResponse = response.data.rejections;
    if (rejections) {
      return await responseRejectionHandler(rejections);
    }
    // ...
  }
);

RejectionResponse Interface

The RejectionResponse interface defines the structure of the responseRejection parameter object that is passed into the responseRejectionHandler function. This RejectionResponse's structure is as follows:

{ // RejectionResponse interface
  id: string; // The Workbook ID
  message: "Success! All records are valid.", // Optional
  deleteSubmitted: true, // Optional
  sheets: [
    { // SheetRejections interface
      sheetId: string; // The Sheet ID
      rejectedRecords: [
        { // RecordRejections interface
          id: string; // The Record ID
          values: [
            {
              field: string; // The field key
              message: string;
            }
          ];
        }
        // other rejected records...
      ];
    }
    // other sheets...
  ];
}

The message property is optional. If provided, this message will be displayed to the user. This message should be set for either a successful submission or a rejection submission. The deleteSubmitted property is optional. If true, the successfully submitted values will be deleted from the Sheet. If false or not provided, a Submission Status field is added to the Sheet and each Record is set to either "Submitted" or "Rejected".

Helper Functions

  • The code includes a helper functions to assist in the Flatfile Sheet update process:
    • updateSheet: Updates a Flatfile Sheet by adding the returned rejection messages as error messages on the Records.

Type Definitions

  • The code defines three interfaces: RejectionResponse, SheetRejections and RecordRejections. These interfaces represent the structure expected by the responseRejectionHandler().