Custom connector for Sharepoint REST API

(1) Share

Report

Posted on by Shibu

As mentioned in the azure document for app registration, I was able to create connector for sharepoint rest api.

I tested the custom connector in powerapps for the rest api URL /sites/{sitename}/_api/web/getuserbyid({userid})/groups and I got all the sharepoint groups associated with the user and the response in JSON format.

When I tried to use the connector in powerapps and after passing all the required parameter.(sitename and userid). The output that is returned is always in xml and powerapps is not able to parse xml.

I did mention in the swagger file to produce and consume json. In the network console I could see they are using proxy url as shown below and response always shows xml

Network consoleSwagger description

https://msmanaged-na.azure-apim.net/apim/spapi.5f79410ce145b.5f7edfa0cdba0c396b/399ed19282a847568e504a8e8ca0/sites/SharepointSandbox/_api/web/getuserbyid%2813%29/groups

How do I get the JSON format as a response ? This solution would help me to maintain user roles in sharepoint site

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Could you please share the documentation for how to register App for SharePoint REST API?

Are you using Azure functions?

Regards,

Michael
Shibu 28 on at

Like
a
(1)

Report
Copy link

Link copied!

I used the below blog article link for registering application for sharepoint rest api. Please refer the below link

https://powerapps.microsoft.com/en-us/blog/implementing-role-based-permission/
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Did you try adding and Accept header?
Accept: application/json
Suggested answer

rohitsbots 280 on at

Like
a
(1)

Report
Copy link

Link copied!

Can you call this custom connector using Power Automate? You can add an action on power automate to convert the XML result to JSON response by using this formula json(xml(body('HTTP'))). Then you can parse JSON in Powerapp.

In my case I'm using HTTP action that returns xml response and then you convert the xml to json.