Processing different file types in Celigo

Integrator.io
, , ,
1

Hi Team,

I am interested in being able to use Celigo as the connector between NetSuite, 3PLs, and external warehouses where Celigo should be be able to support processing .xlsx files with multiple tabs or reading PDF files.

Flow: Data from 3PLs/External Warehouses → NetSuite

I have a few questions regarding Celigo’s file processing capabilities:

  • Can Celigo process .xlsx files that contain multiple tabs?

  • Is it able to read data from PDF files?

  • If FTP is not supported in a given integration, what alternatives does Celigo offer for file transfer?

Thank you in advance for the help!

Regards,

Swapnil Shah

2

If you're pulling the xlsx file from one of our file provider connectors (Google Drive, NetSuite, FTP, S3, etc.), then you do not have the option to choose which tab gets processed. If there are multiple tabs, the only one that gets processed is the first one. If you need a way to read from many tabs, I'd suggest you store the xlsx file in SharePoint or OneDrive, then use the Microsoft Graph APIs to read data from the multiple tabs since their APIs let you specify where you want to read from.

For reading PDF files, we're able to connect to many OCR or IDP providers such as Textract with AWS, Azure AI Document, etc. Additionally, you could use just about any LLM like OpenAI, Gemini, etc.

FTP is an available connection in any flow or integration.