API question

Firstly, I want to say thankyou to Qrew for a great webinar on using API. I always thought it would be much more difficult.
I have a question-wondering if the following is possible.

We use Appsheet for out procurement system. I have 10 Apps, all of similar structure, one for each project. I use the same Suppliers across all Apps. I need to analyse Supplier performance across all Apps.

Currently, I have a Reports spreadsheet with pivot tables and charts. I manually pull the Orders details from each App into the Reports spreadsheet as the combined source for the charts.

If I create a Reports App and pull the Reports spreadsheet into a table can I use API to update this table from the Orders tab in each if the 10 Apps?
@stefan_qrew

1 2 137
2 REPLIES 2