Forum Discussion

DevinL's avatar
DevinL
Helper I
2 years ago

Trouble with Request Body in Copy Data data flow

  I'm connecting to a REST API through a POST request and trying to pass some parameters (filters) in the request body:     { "size": 100, "page": 1, "search": { "date_limits": [ { ...
data engineering
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DevinL,

Have you try to put these processing in M queries with web connector and optional parameter and 'relative path'?

let
    //API endpoint
    url = "",
    // request headers
    headers = [#"Content-Type" = "application/json", #"Authorization" = "Bearer your_api_key"],
    //Relative path
    path = "credits/debits/accounts/xxxx",
    // query
    query = "{
    	'size': 100,
        'page': 1,
        'search': {
        'date_limits': [
                    {
                        'field': 'datetime',
                        'from': '2024-06-25 00:00:00',
                        'to': '2024-07-01 00:00:00'
                    }
                ]
        	}
    }",
    // Get the data from the API
    rawData = Web.Contents(url, [
        Headers = headers,
        RelativePath = path,
        Content = Text.ToBinary(query)
    ]),
    // Convert the JSON response into a table
    json = Json.Document(rawData),
    #"Converted to Table" = Record.ToTable(json)
in
    #"Converted to Table"

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

Xiaoxin Sheng