Retrieve attributes of multiple sharepoint sites using Send an HTTP request to SharePoint connector

[tomka50501]

Hello,

i am trying to gather information on all SharePoint sites from out tenant.

First, i am invoking an HTTP Request using Graph API which provides some attributes but is missing for example the creator of the site and the space assigned to the site.

I have used the Send an HTTP request to SharePoint command with the following Uri:

/_api/Web?$select=Author/Title&$expand=Author

and it provides the name of the creator.

My issue is that i can not loop through all SharePoint site URLs that i have received by using the Graph API.

You can find my flow attached.

Many thanks for your support ahead!

[v-yueyun-msft]

Hi , @tomka50501 

This is the SharePoint Api return, do you mean you want to extract this url in your loop?

If this , this is my test flow:

(1)We can create "Initialize variable" before your Apply to each :

(2)Append to array variable:

outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['Author']?['__metadata']?['uri']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[tomka50501]

Hi,

many thanks for your answer!

I would like to iterate through and find the author of all SharePoint sites that i have fetched using the Graph API.

webUrl is the key that contains the site URLs in JSON.

I hope this clarifies the situation and thanks for your support in advance!

[v-yueyun-msft]

Hi, @tomka50501 

Do you mean you want to get this field value?

If this ,you can use this code in the "Append to array variable":

outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['Author']?['Title']

If I misunderstand what you mean, can you share your sharepoint http api return and which field you want to loop to extract in your side??

Best Regards,

Yueyun Zhang

[tomka50501]

Hi,

here is the snippet of the api return:

{

    "statusCode": 200,

    "headers": {

        "Cache-Control": "no-store, no-cache",

        "Transfer-Encoding": "chunked",

        "Vary": "Accept-Encoding",

        "Strict-Transport-Security": "max-age=31536000",

        "request-id": "8f0e3f7d-54c9-4ed1-b23f-8fc654827eee",

        "client-request-id": "8f0e3f7d-54c9-4ed1-b23f-8fc654827eee",

        "x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"West Europe\",\"Slice\":\"E\",\"Ring\":\"5\",\"ScaleUnit\":\"006\",\"RoleInstance\":\"AM1PEPF00027CA2\"}}",

        "X-SearchPlatform": "Substrate",

        "OData-Version": "4.0",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "true",

        "x-ms-apihub-obo": "false",

        "Date": "Wed, 06 Mar 2024 09:11:56 GMT",

        "Content-Type": "application/json; odata.metadata=minimal; odata.streaming=true; IEEE754Compatible=false; charset=utf-8"

    },

    "body": {

        "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites",

        "value": [

            {

                "createdDateTime": "2015-07-20T06:21:25Z",

                "id": "companyname.sharepoint.com,9ee570d8-e7cc-4b97-bac2-dda1eef2e207,fec43029-946f-49b1-8487-794d1234350f",

                "lastModifiedDateTime": "2015-08-06T13:49:23Z",

                "name": "companyname.sharepoint.com",

                "webUrl": "https://companyname.sharepoint.com",

                "displayName": "Companyname Bt. Team Site",

                "root": {},

                "siteCollection": {

                    "hostname": "companyname.sharepoint.com"

                }

            },

            {

                "createdDateTime": "2023-04-26T13:51:04Z",

                "description": "Itt található az összes ügyfelünk összes dokumentációja",

                "id": "companyname.sharepoint.com,0f7ca8ed-8c17-4e0e-a1f1-3af226eb2c22,d895270e-8651-4b02-b0ce-0393594a9ba8",

                "lastModifiedDateTime": "2023-09-01T14:31:57Z",

                "name": "gyfelek",

                "webUrl": "https://companyname.sharepoint.com/sites/gyfelek",

                "displayName": "Ügyfelek",

                "root": {},

                "siteCollection": {

                    "hostname": "companyname.sharepoint.com"

                }

            },

 i wou

{

    "statusCode": 200,

    "headers": {

        "Cache-Control": "no-store, no-cache",

        "Transfer-Encoding": "chunked",

        "Vary": "Accept-Encoding",

        "Strict-Transport-Security": "max-age=31536000",

        "request-id": "8f0e3f7d-54c9-4ed1-b23f-8fc654827eee",

        "client-request-id": "8f0e3f7d-54c9-4ed1-b23f-8fc654827eee",

        "x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"West Europe\",\"Slice\":\"E\",\"Ring\":\"5\",\"ScaleUnit\":\"006\",\"RoleInstance\":\"AM1PEPF00027CA2\"}}",

        "X-SearchPlatform": "Substrate",

        "OData-Version": "4.0",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "true",

        "x-ms-apihub-obo": "false",

        "Date": "Wed, 06 Mar 2024 09:11:56 GMT",

        "Content-Type": "application/json; odata.metadata=minimal; odata.streaming=true; IEEE754Compatible=false; charset=utf-8"

    },

    "body": {

        "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites",

        "value": [

            {

                "createdDateTime": "2015-07-20T06:21:25Z",

                "id": "irodaszoftver.sharepoint.com,9ee570d8-e7cc-4b97-bac2-dda1eef2e207,fec43029-946f-49b1-8487-794d1234350f",

                "lastModifiedDateTime": "2015-08-06T13:49:23Z",

                "name": "irodaszoftver.sharepoint.com",

                "webUrl": "https://irodaszoftver.sharepoint.com",

                "displayName": "Irodaszoftver Bt. Team Site",

                "root": {},

                "siteCollection": {

                    "hostname": "irodaszoftver.sharepoint.com"

                }

            },

            {

                "createdDateTime": "2023-04-26T13:51:04Z",

                "description": "Itt található az összes ügyfelünk összes dokumentációja",

                "id": "irodaszoftver.sharepoint.com,0f7ca8ed-8c17-4e0e-a1f1-3af226eb2c22,d895270e-8651-4b02-b0ce-0393594a9ba8",

                "lastModifiedDateTime": "2023-09-01T14:31:57Z",

                "name": "gyfelek",

                "webUrl": "https://irodaszoftver.sharepoint.com/sites/gyfelek",

                "displayName": "Ügyfelek",

                "root": {},

                "siteCollection": {

                    "hostname": "companyname.sharepoint.com"

                }

            },

i would like to find the author and other parameters of all sharepoint sites listed in the output.

Best Regards,

Tamás

[v-yueyun-msft]

Hi , @tomka50501 

Thanks for your quick response and your Api output! As what is your author and other parameters you need from your Api output?

Best Regards,

Yueyun Zhang

[tomka50501]

Parameters:

Name of the author

Storage space assigned to the site

Storage space used

Best Regards,

Tamás

[v-yueyun-msft]

HI , @tomka50501 

Thanks for your reply, in your returned json, it seems that the corresponding value you said was not found.
Sorry, I don't particularly know about the Sharepoint API.
You have to make sure that calling your Sharepoint API can return the value you need in Output.

Best Regards,

Yueyun Zhang

[tomka50501]

i will figure out the SharePoint API call.

My current issue is that i can not pass the webUrl values to the Send an HTTP request to SharePoint action in the Apply to each 4 control.

By selecting the webUrl key from the Parse JSON action, for some reason it does not passes the values.

Kind Regards,

Tamás

Kind Regards,

Tamás

[v-yueyun-msft]

Hi , @tomka50501 

Do you mean you want to extract the "wenurl" from your return in your Apply to each 4 action?
If this , you can refer to my test flow:

The Compose is used to create the test data, like this:

{
  "statusCode": 200,
  "headers": {
    "Cache-Control": "no-store, no-cache",
    "Transfer-Encoding": "chunked",
    "Vary": "Accept-Encoding",
    "Strict-Transport-Security": "max-age=31536000",
    "request-id": "8f0e3f7d-54c9-4ed1-b23f-8fc654827eee",
    "client-request-id": "8f0e3f7d-54c9-4ed1-b23f-8fc654827eee",
    "x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"West Europe\",\"Slice\":\"E\",\"Ring\":\"5\",\"ScaleUnit\":\"006\",\"RoleInstance\":\"AM1PEPF00027CA2\"}}",
    "X-SearchPlatform": "Substrate",
    "OData-Version": "4.0",
    "Timing-Allow-Origin": "*",
    "x-ms-apihub-cached-response": "true",
    "x-ms-apihub-obo": "false",
    "Date": "Wed, 06 Mar 2024 09:11:56 GMT",
    "Content-Type": "application/json; odata.metadata=minimal; odata.streaming=true; IEEE754Compatible=false; charset=utf-8"
  },
  "body": {
    "value": [
      {
        "createdDateTime": "2015-07-20T06:21:25Z",
        "id": "companyname.sharepoint.com,9ee570d8-e7cc-4b97-bac2-dda1eef2e207,fec43029-946f-49b1-8487-794d1234350f",
        "lastModifiedDateTime": "2015-08-06T13:49:23Z",
        "name": "companyname.sharepoint.com",
        "webUrl": "https://companyname.sharepoint.com",
        "displayName": "Companyname Bt. Team Site",
        "root": {},
        "siteCollection": {
          "hostname": "companyname.sharepoint.com"
        }
      },
      {
        "createdDateTime": "2023-04-26T13:51:04Z",
        "description": "Itt található az összes ügyfelünk összes dokumentációja",
        "id": "companyname.sharepoint.com,0f7ca8ed-8c17-4e0e-a1f1-3af226eb2c22,d895270e-8651-4b02-b0ce-0393594a9ba8",
        "lastModifiedDateTime": "2023-09-01T14:31:57Z",
        "name": "gyfelek",
        "webUrl": "https://companyname.sharepoint.com/sites/gyfelek",
        "displayName": "Ügyfelek",
        "root": {},
        "siteCollection": {
          "hostname": "companyname.sharepoint.com"
        }
      }
    ]
  }
}

The Apply to each action:

Best Regards,

Yueyun Zhang

[Tomka5050]

Thank you!

my issue occurs when using the Send an HTTP Request to Sharepoint action. 

i can not figure out how can i send the same API call to multiple SharePoint sites by adding a custom value to the Site address parameter. 

kind regards,

Tamás

[v-yueyun-msft]

Hi , @Tomka5050 

As in my above reply, you can use the weburl to set the custom value :

If i misunderstand your need , can you give a example you need to get in your Apply to each 4 loop??

Best Regards,

Yueyun Zhang