How to create Web API project to retrieve Sharepoint Online list and result in JSON format

Question

How to create Web API project to retrieve Sharepoint Online list and result in JSON format

THM THM 1

Hi I am new to API project with Sharepoint Online (MFA) to retrieve list items and result in JSON format. I want to ensure i am on the right track by using either WebAPI or Webservices in Visual Studio. or any other suggestions?

Is there an project example with a step by step reference ?

Thank you.

Jaliya Udagedara 2,836 Reputation points MVP Volunteer Moderator

2020-12-13T08:55:10.927+00:00

Can you clarify your question/requirement please. Do you want to retrieve SharePoint Online list and expose the result through a REST endpoint?
THM THM 1 Reputation point

2020-12-13T17:25:14.81+00:00

I would like to come up a API call (URL) for a vendor to get the items in JSON format. e.g. https://mysite.sharepoint.com/api/Employee/GetAllEmployee -> JSON format
prashant sharma 21 Reputation points

2022-12-01T10:01:51.673+00:00

custom web api crud operations in sharepoint online in c# code i need this or even any idea you can have it

1 answer

Your answer

Jaliya Udagedara 2,836 Reputation points MVP Volunteer Moderator

2020-12-13T08:55:10.927+00:00

Can you clarify your question/requirement please. Do you want to retrieve SharePoint Online list and expose the result through a REST endpoint?
THM THM 1 Reputation point

2020-12-13T17:25:14.81+00:00

I would like to come up a API call (URL) for a vendor to get the items in JSON format. e.g. https://mysite.sharepoint.com/api/Employee/GetAllEmployee -> JSON format
prashant sharma 21 Reputation points

2022-12-01T10:01:51.673+00:00

custom web api crud operations in sharepoint online in c# code i need this or even any idea you can have it

Answer 1

ZhengyuGuo 10,586 Moderator

Hi @THM THM ,

For SharePoint Online MFA enabled Tenant, it's suggested to use App-Only authentication with CSOM code to connect with SharePoint Online list:

Connect To SharePoint Online Site With App Only Authentication

For building the custom web API to connecting with SharePoint Online, here is a complete example for start:

Building a Custom Web API for use with SharePoint Online

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.

ZhengyuGuo 10,586 Reputation points Moderator

2020-12-17T09:11:13.4+00:00

Hi @THM THM ,

Is there any update ? If the suggestion is helpful to the question, I suggest you could accept as answer so that it could also help others in the forum.

Thanks
Best Regards

Share via

How to create Web API project to retrieve Sharepoint Online list and result in JSON format

1 answer

Your answer