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


Result of creating REST data source

I have a REST API that sends me json array with simple structure as follows:

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.

Microsoft Technologies based on the .NET software framework.
3,143 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,120 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MichaelHan-MSFT 17,996 Reputation points

    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.