SharePoint Framework get data from on premise web api

Question

SharePoint Framework get data from on premise web api

Nilesh Kodulkar 1

Hello All,

I know we can make calls to external/anonymous api from SPFX however I want to know what is the secure way of calling web api which is hosted in SP 2019 farm from SPFX webpart?

Regards,
NK

0 comments

1 answer

Your answer

Answer 1

RaytheonXie_MSFT 40,496 Microsoft External Staff

Hi @Nilesh Kodulkar ,
When building SharePoint Framework solutions, you might need to connect to an API secured by using Azure Active Directory (Azure AD). SharePoint Framework allows you to specify which Azure AD applications and permissions your solution requires, and a global or SharePoint administrator can grant the necessary permissions if they haven't yet been granted. By using the AadHttpClient, you can easily connect to APIs secured by using Azure AD without having to implement the OAuth flow yourself.
Please refer to the following document to connect to Azure AD-secured APIs in SharePoint Framework solutions.

https://learn.microsoft.com/en-us/sharepoint/dev/spfx/use-aadhttpclient

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Nilesh Kodulkar 1 Reputation point

2022-02-21T15:02:39.48+00:00

Hi @RaytheonXie_MSFT ,

I have used AadHttpClient in SharePoint Online SPFx solution with no issues. The question above is about using SPFx in SharePoint 2019 on premises and securely consuming web api's hosted on SharePoint 2019 farm.
RaytheonXie_MSFT 40,496 Reputation points Microsoft External Staff

2022-02-22T01:58:42.44+00:00

Hi @Nilesh Kodulkar ,
On-prem SharePoint uses SPFx 1.4.1, so you cannot use AadTokenProvider, meaning you need to use ADAL JS, see instructions here.

webApiPermissionRequests refers to AadTokenProvider which in turn requires SPFx 1.6.0+, thus is not currently supported on-prem SP.
RaytheonXie_MSFT 40,496 Reputation points Microsoft External Staff

2022-02-28T09:27:26.833+00:00

Hi @Nilesh Kodulkar ,
Would you tell me whether your issue has been resolved or have any update?
I am looking forward to your reply.

Have a nice day!

Thanks,
Raytheon Xie
Nilesh Kodulkar 1 Reputation point

2022-03-30T10:10:04.143+00:00

Hello @RaytheonXie_MSFT , I want to access data from custom database(SQL) to present it on SPFx form in SP2019. What would be available options to achieve this?

Share via

SharePoint Framework get data from on premise web api

1 answer

Your answer