API Request

[jymjams75]

Hi everybody,

I need your help !

I would use PowerBI to get data from sevrals apps : website metrics, twitter etc.

It was simple because i just had to change parameters in the URL. Example : myservice.fr/request/data/getData?param=%7B%22columns%22:";"%5B%22click%22,%22event_name%22,%22p1.m_visits%22,%22 etc.
I could get date that way, it was easy.

Now, I have a new service and it seems to me that it's kinda different.

I have the URL : https://myservice.com/report/batch/query.json
And i have a body : 

{
"reports": [
{
"kind": "rt#pagetree",
"path": "mcWEBSITE[1234].mcGLOBALPAGETREE.mcPAGETREE",
"dateRanges": [

{ "dateFrom" : "2024/01/01", "dateTo": "2024/03/07", "dateFormat" : "YYYY/DD/MM" }
],
 etc.

I don't understand how I can use that in PowerBi...where do I have to put the body ?

Best regards

[lbendlin]

There's a Content attribute for that.

Web.Contents - PowerQuery M | Microsoft Learn

Example 2