Call an api with a filter

Hi  ,
Thanks for reaching out to the Microsoft fabric community forum.

Try to modify the M query into this 

let
    api = url_getEventPending & apiEvent & "/search",
    token = getTokenData(),
    idValue = "667995612c15a237078c605e",
    fullUrl = api & "?id=" & idValue,
    
    apiResponse = Web.Contents(
        fullUrl,
        [
            Headers = [
                Authorization = token,
                #"Content-Type" = "application/json"
            ]
        ]
    ),
    
    FormatAsJsonQuery = Json.Document(apiResponse)
in
    FormatAsJsonQuery

and check if you are able to bypass the error.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

The error message is telling you that your Content field value needs to be of type binary, but you are instead supplying an M record. Most likely, you can fix this by wrapping your record in Json.FromValue

You can see it in action in example 2 in the MS doc:

https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-2