Forum Discussion
Call an api with a filter
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
Hi ,
Thanks for reaching out to the Microsoft fabric community forum.
Try to modify the M query into thislet 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 youThe 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
8 Replies
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 youHi 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.
Hi ,
Thanks for reaching out to the Microsoft fabric community forum.
Try to modify the M query into thislet 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
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.
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.
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.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
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
