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

I never heard of any such use case. If you can turn the files into PDF first, you can do the extraction with OOTB functions.

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.