I'd like to create a program in ECC, that creates queries for specific vendors via a batch over night. As a part of this batch, is it possible to upload the query extract to a cFolder specified for that vendor as a part of the batch? The code would have to be dynamic in that there is a variable amount of vendors that would be maintained in a Z table. Steps would be as follows:
Batch process initiation
- Get Vendor from Z table
- Run query for Vendor
- Extract query to Excel file (or flat file)
- Upload to cFolder
Loop to next Vendor
Any thoughts?