Unable to iterate through SharePoint REST API Search Result with Parse JSON output

(0) Share

Report

Posted on by jaiswati2017

Hi All,

need to find specific documents in specific doc lib,

for that reason , we have used "send request to sharepoint activity" (with SharePoint Search Rest API)

though we get the output as below, need to iterate through the results. output of ParseJson always returns 1 record (even though there are 7 records)

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi @jaiswati2017,

Which dynamic content have you specified for the field Select an output from previous steps of Apply to each?

Please make sure the dynamic content you are using will return multiple values but not only one.

Hope the following blog could be a reference for you:

http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

Best regards,

Mabel

Was this reply helpful? Yes No
jaiswati2017 2 on at

Like (0)

Report

Hi,

the above issue is resolved..
but need to access "Path" value from following json output
[
{
"results": [
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "Rank",
"Value": "26.5133228302002",
"ValueType": "Edm.Double"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "DocId",
"Value": "17597065018987",
"ValueType": "Edm.Int64"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "Path",
"Value": "https://cg.sharepoint.com/sites/sw/nb/abc.docx",
"ValueType": "Edm.String"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "Url",
"Value": "https://cg.sharepoint.com/sites/sc/nb/abc.docx",
"ValueType": "Edm.String"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "OriginalPath",
"Value": "https://cg.sharepoint.com/sites/sw/nb/abc.docx",
"ValueType": "Edm.String"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "Title",
"Value": "Curriculum Vitae",
"ValueType": "Edm.String"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "Author",
"Value": "sbuster;abc,abc",
"ValueType": "Edm.String"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "PartitionId",
"Value": "2c414026-d1c1-41e3-9d39-8c8955061366",
"ValueType": "Edm.Guid"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "UrlZone",
"Value": "0",
"ValueType": "Edm.Int32"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "Culture",
"Value": "en-US",
"ValueType": "Edm.String"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "ResultTypeId",
"Value": "0",
"ValueType": "Edm.Int32"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "RenderTemplateId",
"Value": "~sitecollection/_catalogs/masterpage/Display Templates/Search/Item_Default.js",
"ValueType": "Edm.String"
}
]
}
]

Was this reply helpful? Yes No