GET Request and Token authentication to download file as JSON

Query parameters and header information can be part of the Web.Contents call.  The last URL shows the examples.

https://docs.microsoft.com/en-us/powerquery-m/web-contents

https://docs.microsoft.com/en-us/power-query/web.contents

https://kohera.be/blog/power-bi/the-hidden-gems-of-the-function-web-contents/

Hi Anonymous,

You can try to use the following code if it meets your requirement:

let
	GetJson = Web.Contents(
		"https://xxxxxxxx/api", 
		[
			RelativePath="/v1.0/data/search", 
			Query=
			[
				query="xxxxxxx", 
				limit=1000
			]
		]
	),
	FormatAsJson = Json.Document(GetJson)
in
	FormatAsJson

Reference links:

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

Get Data from Twitter API with Power Query 

Regards,

Xiaoxin Sheng