API Questions

Hello,

I have 5 sales environments and would like to setup an API to bring all my sales data into a sharepoint list.

  1. Which API would you recommend?

  2. Can the API be setup to push data from all 5 sales environments? Or do I need 5 APIs?

Thanks,

Mark