Is it possible to get data from external sources into SharePoint online sites? I suppose rest API's is an option, but how can that be done? Any suggestions would be much appreciated.


It is not SharePoint that limits what you can import.

You need to connect to the API of your 3rd party vendor.
If they don't "let you in", you can't get the data

So start by investigating if the vendor has APIs, then follow their code examples.

To import content into SharePoint learn to use the SharePoint REST endpoints, or use the Microsoft PnP tools: https://github.com/SharePoint/PnP

  • Yes they are providing with API's. But to import content what REST API's will i use? Any tutorial, walkthrough ? – mohd tahir Dec 9 '16 at 13:57
  • 1
    People don't like your answers that tell people how to find answers themselves. It's kinda sad. I downvoted this question as it's something that really should've been solved by Google. – wjervis Dec 13 '16 at 15:37
  • I know, and I won't stop my sometimes blunt comments.. I am good at memorizing names; so if people don't learn I will never answer any question they ask again. Before asking a question on SO one should have at least searched for 15 minutes. If it where up to me questions should include at least 3 urls with information that kinda helped but didn't answer the question. – Danny '365CSI' Engelman Dec 13 '16 at 15:48
  • After all this @Danny'365CSI'Engelman I just have to say your answer helped me a lot. And I have started getting idea of how to import external data into SharePoint. Please do not interpret me. Thank you! – mohd tahir Dec 15 '16 at 6:17

In SharePoint Online we can setup BCS - Business Connectivity Service and get external data in SharePoint Online List.

What is your external data source?

  • a third party tool like Connectwise. – mohd tahir Dec 9 '16 at 12:36
  • What if we wish to copy data from an external excel sheet to a SharePoint List? – mohd tahir Dec 9 '16 at 12:37
  • You can create SharePoint List from excel. So all data will be imported in SharePoint Online. – Trimantra Software Solution Dec 9 '16 at 12:59
  • BCS cannot connect to Connectwise tool. If you have any web service then BCS can connect. – Trimantra Software Solution Dec 9 '16 at 12:59
  • Well Connectwise will be providing us with set of API's to access data from their system. In that case? – mohd tahir Dec 9 '16 at 13:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.