add json parameters in advance query editor Json.Document(Web.Contents(url)) encodeURIComponent()

[Pumayk26]

I want to pass json object as a parameter in advance query editor Json.Document(Web.Contents(url))

object is as below,

parameters = {

 prop : { name:"John",age;25 },

 prop : { name:"Doe",age;24 }

}

"http://localhost:8088/search?parameters="+encodeURIComponent(json.stringify(parameters ))

is it possible..?

[v-yiruan-msft · Accepted solution]

Hi @Pumayk26 ,

You can refer the following documentations to update the codes in Advanced Editor:

Web.Contents

Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code

Dynamic Web.Contents() and Power BI Refresh Error

Best Regards

Rena

[amitchandak]

@Pumayk26 , refer, if this can help https://docs.microsoft.com/en-us/power-bi/service-url-filters