How to load data via API from another site on cms drupal 7 into a temporary table for further work with them?

Question

API

There is a ready-made site on Drupal 7 and you need to upload information via API from another site to a temporary table about the requested products so that the user can send a request for their design, something like dropshipping.
Interested in the cost of the work, if someone has already done this, we will place an order, or tell me where to dig and where to start to do it yourself, if there are ready-made examples, that would be great!