Recommended way to extract supplier, supplier site, contact and bank details via OIC or other.

Summary:

For a third-party integration we need to supply a combination of data from supplier, supplier site, contacts and bank details in one table/Json file (max 6000 records).
The only way they can receive data is by an API, we can write data/files to an external storage.

I am looking for advise on the best way to do this.

1. Do it via all different API calls and extract the data from Fusion combine then in in OIC to one big table
2. Create an OTBI report with all required data, call the report in OIC and push the data out