Unanswered

SharePoint Search REST API JSON to CSV

(0) Share

Report

Posted on by Matt01

I am using the SharePoint REST API to return information an all SharePoint sites in a site collection including subsites.

Using "Send HTTP Request to SharePoint" connector I do a GET request for

_api/search/query?querytext='(Contentclass:STS_WEb)'&trimduplicates=false&rowlimit=5000&Selectproperties='title,url'

Next I use the "Parse JSON" connector autogenerating the schema from the output of the HTTP request.

Finally I use the "Create CSV Table" connector. Which results in the error "The 'from' property value in the 'table' action inputs is type 'Null'. The value must be of type 'Array'.

My guess is the issue is the JSON is not being parsed correctly. The input and the output essentially look the same not formatted at all.

Any help would be appreciated!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,194 Most Valuable Professional on at

Like (1)

Report
Hi @Matt01,

The returned json of this method is pretty complex and has a couple of nested arrays. I have tested with it before and as far as I know fields like title and url are store in the property key. So, you would have to transpose this type of data.

I would start with the first array (the results) and work you way down from there:

body('Send_an_HTTP_request_to_SharePoint')['d']['query']['PrimaryQueryResult']['RelevantResults']['Table']['Rows']['results']

Was this reply helpful? Yes No
Matt01 10 on at

Like (0)

Report

@Expiscornovus Thank you for the response! This is a big step closer!

The data does not need to be transposed if you ignore column headers.

With the result from what you suggested the next step would be to extract the "Value" output and place each one in a sperate column.

Any suggestions on how to only select value?

Was this reply helpful? Yes No