We need to pull Accounts Payable (open transactions only) - what is the best way to do this? ideally if this can be a batch job, it will be great as well.
Also, I wonder what would be the best way to do this in Dynamics 365 Operations? Thank you
If you want to export data from AX, use the Data Import Export Framework (DIXF). In Operations, it's based on an important new concept: data entities.
Automation is a bit more complicated in cloud - please refer to Recurring integrations.