topic Re: Get data from REST API in Developer

Get data from REST API

Anonymous — Wed, 10 Jul 2024 03:51:32 GMT

Hi everyone, hope you're doing great

I need some help to resolve an issue:

I'm getting data from a REST API, I have researched on internet and followed to an instruction, but after I inputted mandatory parameter then click OK, it just loading...forerver... 😃 I inputted these parameter on postman and it work properly.

Re: Get data from REST API

lbendlin — Wed, 10 Jul 2024 14:42:16 GMT

Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1

Re: Get data from REST API

Anonymous — Thu, 11 Jul 2024 01:31:51 GMT

Thank you for your answer. Could you please guide more detailed? I'm a little confused.

Re: Get data from REST API

lbendlin — Thu, 11 Jul 2024 10:39:19 GMT

What part of the documentation is confusing?

Re: Get data from REST API

Anonymous — Thu, 11 Jul 2024 10:45:55 GMT

I dont know where to input bearer token to M query below:

let
searchText = "Power Query"
in
Web.Contents(
"https://www.bing.com",
[
RelativePath = "search",
Query = [q = searchText]
]
)

Could you guide me?

Re: Get data from REST API

lbendlin — Thu, 11 Jul 2024 11:04:41 GMT

That goes in the Headers section as Authentication.

Re: Get data from REST API

Anonymous — Mon, 22 Jul 2024 08:05:44 GMT

Hi @Anonymous ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Get data from REST API

Anonymous — Mon, 22 Jul 2024 08:12:34 GMT

This suggestion doesn't help to solve at all, it's just a high level guidance. But I appreciate his suggestion so I accept it as solution to close the topic.

Re: Get data from REST API

lbendlin — Mon, 22 Jul 2024 18:15:59 GMT

Where are you currently stuck?

Re: Get data from REST API

Anonymous — Tue, 23 Jul 2024 09:37:41 GMT

I have copied code from postman and used ChatGPT to convert it to M language, it worked. Thank you @lbendlin for your help. Have a good day 😃