Hello,

We have a client with a new Laserfiche Cloud account where we want to setup a data pipeline for employee data going from their cloud hr system into a lookup table in laserfiche so that data can be used in future processes. Their previous system had an sftp server and they'd configure an extract to land on that server on a nightly basis. I was trying to think of the easiest method to replicate this functionality assuming we can't get direct access to their hr system's api to query it directly from Laserfiche as a web request.

Options I've considered:

1. Installing import agent on a local machine on their network and have their IT configure the extract (csv) to land in a monitored folder on a daily basis. We'd then have that csv land in a folder in Laserfiche to kick off a workflow to replace the lookup table.

2. Provide their IT with a simple script to upload using the api and replace the lookup table data.

Does anybody have any other ideas or have experience setting something like this up before?

Thank you!