Setting up an external list column that fetches from an ERP

%3CLINGO-SUB%20id%3D%22lingo-sub-1827618%22%20slang%3D%22en-US%22%3ESetting%20up%20an%20external%20list%20column%20that%20fetches%20from%20an%20ERP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1827618%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20searching%20for%20clear%20documentation%20on%20how%20to%20do%20this%20but%20apparently%20am%20not%20looking%20in%20the%20right%20pace%20or%20phrasing%20it%20incorrectly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20to%20do%20is%20avoid%20having%20to%20maintain%20multiple%20Choice%20columns%20that%20all%20derive%20their%20content%20from%20the%20ERP%20system%2C%20which%20ought%20to%20be%20the%20master%20for%20things%20like%20product%20codes%2C%20open%20orders%2C%20etc.%20So%20instead%20of%20risking%20the%20chance%20of%20some%20lists%20in%20SPO%20not%20being%20a%20match%20for%20what%20the%20ERP%20says%2C%20I%20want%20to%20set%20up%20an%20External%20Content%20Type%20that%20fetches%20the%20data%20straight%20out%20of%20the%20ERP.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20ERP%20isn't%20Dynamics%20or%20SAP%2C%20but%20it%20does%20support%20REST%20API%2C%20and%20does%20send%20data%20in%20JSON%2C%20and%20I%20have%20extracted%20data%20using%20Power%20Automate.%20What%20I%20don't%20see%20is%20a%20way%20in%20SPO%20to%20do%20this%20in%20a%20straightforward%20way.%20I%20have%20found%20vague%20references%20to%20setting%20up%20something%20in%20BCS%2C%20or%20using%20SharePoint%20Designer%202013%2C%20but%20nothing%20that%20I%20found%20very%20clear.%20The%20ERP%20company%20had%20a%20webpart%20for%20SP%202010%20that%20is%20useless%20to%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20point%20me%20in%20the%20right%20direction%3F%20Has%20anyone%20actually%20done%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1827618%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebcs%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExternal%20Data%20Source%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I've been searching for clear documentation on how to do this but apparently am not looking in the right pace or phrasing it incorrectly.

 

What I want to do is avoid having to maintain multiple Choice columns that all derive their content from the ERP system, which ought to be the master for things like product codes, open orders, etc. So instead of risking the chance of some lists in SPO not being a match for what the ERP says, I want to set up an External Content Type that fetches the data straight out of the ERP.

 

Our ERP isn't Dynamics or SAP, but it does support REST API, and does send data in JSON, and I have extracted data using Power Automate. What I don't see is a way in SPO to do this in a straightforward way. I have found vague references to setting up something in BCS, or using SharePoint Designer 2013, but nothing that I found very clear. The ERP company had a webpart for SP 2010 that is useless to me.

 

Can someone point me in the right direction? Has anyone actually done this?

1 Reply
The way to do the integration you are lookig for was BCS...the problem with BCS is that Microsoft has not done any investment on the service for the last 7 years, so I would avoid to use it...