Ok here's a question...maybe I'm going about it the wrong way but this is my issue...
ISSUE
We want to integrate Expensify with NetSuite. Easy enough. Proof of concept is working. However, we sometimes add Campaigns to expense lines. Expensify does not support the Campaigns table (probably a Netsuite API issue), but do support customer records/lists.
Workaround
I am going to create a custom record called Expensify Campaigns. but need to copy the records from the native Campaigns table (where the End Date is not in the past) to the expensify Campaigns table. Is this something I can do via scheduled workflow?