Call an api with a filter

[alops1]

Hello all colleagues,

I need your help. I am trying to call an api with a filter through power query, but I receive this error.

I attach the code:

What am I doing wrong?

thank you so much

[v-nmadadi-msft · Accepted solution]

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

[MarkLaf · Accepted solution]

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

[v-nmadadi-msft]

Hi @alops1 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @alops1 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @alops1 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-nmadadi-msft]

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

There may be an extra closing bracket ] in the code that's affecting the syntax and causing the error. Please review the structure carefully, and let us know if the issue persists after correcting it.

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

[alops194]

Hi @v-nmadadi-msft ,

thanks a lot for the answer but unfortunately that square bracket closes headers and if I remove it the code goes into error.

[alops194]

Hi @v-nmadadi-msft ,

thanks a lot for the answer but unfortunately that square bracket closes headers and if I remove it the code goes into error.

[v-nmadadi-msft · Accepted solution]

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