External REST data presented in a form of SP List or external column

Question

I have a REST API that sends me json array with simple structure as follows:
[
{
"id":15422,
"disciplineNameUkraninan":"Логістика",
"disciplineNameEnglish":"Logistics"
},

My goal is to integrate it into SP list, so it's columns can be later referenced in other lists, and in best case scenario - structure of generated list itself could be modified (for example some additional columns could be added).

I've tried looking into creating data source from REST API and successfully managed to do it, but now I don't really know how to use it's data in lists as column or create list from it.

Other thing I've tried to do is to created External Data Type, but the only options there are WCF, .NET assembly and SQL Server - neither of them works for me in my situation.

Answer 1

Hi @Потапенко Едвард Сергійович ,

You could try to import BDC Model in bcs to create external content types: https://learn.microsoft.com/en-us/sharepoint/manage-business-connectivity-service-applications

And here is a third party tool BCS Meta man to build BDC Model file, hope it's helpfu to you.

Third-party information disclaimer:
The third-party product that this article discusses is manufactured by a company that is independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of third-party products referenced in this article.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.