How do I pull data from the bentley projectwise cloud?

I need to pull data on Transmittals from ProjectWise Database in order to generate a report. The report will pull data on how the document is flowing thru the various steps of the workflow.  We are cloud subscribers, so the data needs to be pulled from the cloud.

I envision pulling the data from the bentley cloud and storing it locally in a SQL database and then querying the local database to produce the report on demand.

How would I go about accomplishing this?

No. Submittal No. Discipline  DOC TYPE DOC NO Document Title  Latest Rev  Status Update Internal Document Received on  Date of Final Submission
Submitted by Supplier  Latest Rev  Code Received Date  Response send  Delayed by days    Submitted to Detail Designer  Latest Rev  Code Submitted Date  Response Received  Delayed by days