How To Extract Data from Microsoft Publisher (.PUB) Files in Appian?

Since Appian doesn't natively understand .PUB files, you can:

1. Upload .PUB file to Appian.
2. Send it to a custom API (Java, .NET, Python).
3. API extracts text/content.
4. Return JSON to Appian.

Example response:

{
  "customerName": "John Smith",
  "invoiceNumber": "INV-1234",
  "amount": "$500"
}

Appian then processes the JSON.

OR try  structured text rather than OCR:

PUB → DOCX → Extract Text → Appian

or

PUB → HTML → Parse Content → Appian

This can preserve more structure than a PDF in some cases.

Since Appian doesn't natively understand .PUB files, you can:

1. Upload .PUB file to Appian.
2. Send it to a custom API (Java, .NET, Python).
3. API extracts text/content.
4. Return JSON to Appian.

Example response:

{
  "customerName": "John Smith",
  "invoiceNumber": "INV-1234",
  "amount": "$500"
}

Appian then processes the JSON.

OR try  structured text rather than OCR:

PUB → DOCX → Extract Text → Appian

or

PUB → HTML → Parse Content → Appian

This can preserve more structure than a PDF in some cases.

Thanks for the suggestions.

We explored the Python-based approach and were able to extract the data; however, it requires hosting, so we are evaluating alternatives.

We are currently exploring Appian-based options (such as plugins) to handle the extraction as much as possible within the platform.