SOLVED

integration with ERP(SQL)

%3CLINGO-SUB%20id%3D%22lingo-sub-1621934%22%20slang%3D%22en-US%22%3Eintegration%20with%20ERP(SQL)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621934%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3ECan%20i%20use%20graph%20API%2C%20or%20is%20there%20a%20Microsoft%20connector%20that%20can%20be%20used%20to%20get%20the%20caller%2Fclient%20name%20from%20an%20ERP%20hosted%20on%20SQL%3F%20%2Cso%20when%20a%20user%20receive%20a%20call%20on%20Ms%20Teams%20%2C%20he%20can%20see%20the%20name%20of%20customer%20calling%20(data%20comming%20from%20ERP)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1621934%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EActivity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECalling%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623921%22%20slang%3D%22en-US%22%3ERe%3A%20integration%20with%20ERP(SQL)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623921%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7960%22%20target%3D%22_blank%22%3E%40Tom%20Morgan%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5458%22%20target%3D%22_blank%22%3E%40Vesa%20Nopanen%3C%2FA%3E%20%2C%20maybe%20you%20can%20answer%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623927%22%20slang%3D%22en-US%22%3ERe%3A%20integration%20with%20ERP(SQL)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623927%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20the%20calls%20will%20be%20initiated%20by%20the%20client%2C%20could%20be%20tricky.%20In%20an%20ideal%20world%20the%20Client%20info%20would%20populate%20some%20sort%20of%20Address%20book%20that%20Teams%20would%20make%20use%20of%2C%20correlate%20and%20then%20give%20the%20designated%20name.%20However%20such%20a%20thing%20does%20not%20exist%20beyond%20a%20per%20user%20at%20present.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20sure%20you%20have%20looked%20at%20this%20but%20just%20in%20case%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fcommunications-api-overview%3Fview%3Dgraph-rest-1.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fcommunications-api-overview%3Fview%3Dgraph-rest-1.0%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3E%3CBR%20%2F%3EHenry%3C%2FLINGO-BODY%3E
Microsoft

Hello,

Can i use graph API, or is there a Microsoft connector that can be used to get the caller/client name from an ERP hosted on SQL? ,so when a user receive a call on Ms Teams , he can see the name of customer calling (data comming from ERP)

3 Replies
@Tom Morgan @Vesa Nopanen , maybe you can answer this?

Adam
best response confirmed by Karim Hossam (Microsoft)
Solution
Hi,

So the calls will be initiated by the client, could be tricky. In an ideal world the Client info would populate some sort of Address book that Teams would make use of, correlate and then give the designated name. However such a thing does not exist beyond a per user at present.

I am sure you have looked at this but just in case: https://docs.microsoft.com/en-us/graph/api/resources/communications-api-overview?view=graph-rest-1.0

Thanks

Henry
Hey Adam!

In order to identify incoming caller, you need to sync your SQL contacts with your Microsoft Exchange/Outlook/Teams contacts. You can do that using sync.blue: https://info.sync.blue/sync/microsoft-sql-server/microsoft-teams.