I'm sure I'm missing something probably easy, but I can't seem to figure this out. I have a Powershell script that polls Active Directory every hour and exports all users to a CSV on my PC. I've created an External Data Source in Laserfiche and pointed it at this CSV, then created a Query Rule to Select the data from the Users table. Next, I created a lookup table and populated it with the same CSV to use in a lookup table rule of my form.
What I'm trying to do, and can't seem to figure out, is create a workflow that will run regularly and update the Lookup Table with the information read from the External Data Source.
I created a simple workflow of "Run Rule (Query the Users table in Data Source) -> Replace Lookup Table Data (Source Data is "Activity -> Read Rule Results File").
When running the workflow, Run Rule runs fine but Replace Lookup Table errors with "Bad Request Status: 400 Response: "DM81303: Could not parse file as CSV file"". I'm not sure where to look to fix this and in Cloud I don't have any CSV options in workflow.
Any help would be appreciated. If there is a better way of accomplishing what I'm trying to do, I'm open to any suggestions.