Forum Discussion

TP-101's avatar
TP-101
Helper I
2 years ago

M Query Post REST API, return format not JSON with Expression.Error

I'm attempting a POST to a REST API which should return data in JSON.  The POST appears to succeed however, receiving an Expression.Error trying to convert the response to binary.  Can this query be ...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago
GetJsonQuery = Json.Document(Web.Contents("https://" & Tenant & GetMetric, [Headers=[Authorization=AccessTokenHeader, Accept="application/json"]]))
TP-101's avatar
TP-101
Helper I
2 years ago

That one is showing a 405 error.  I think that might be due to it trying to GET vs. POST without the Content piece.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    yes, didn't notice you had removed that.

     

     GetJsonQuery = Json.Document(Web.Contents("https://" & Tenant & GetMetric, [Headers=[Authorization="AccessTokenHeader", Accept="application/json"], Content=Text.FromBinary(Json.FromValue(data))]))
  • TP-101's avatar
    TP-101
    Helper I
    2 years ago

    That one put's us back to square 1.  Is there something in that line that is trying to convert the returned JSON to binary?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Sorry, typo again. Tiny screen. Try this one

     

     

    WebResult = Web.Contents("https://" & Tenant & GetMetric, [Headers=[Authorization=AccessTokenHeader, Accept="application/json"], Content=Text.FromBinary(Json.FromValue(data))]),
GetJsonQuery = Json.Document(Text.Replace(Text.Replace(WebResult,"\u000a",""),"\""",""""))

     

  • TP-101's avatar
    TP-101
    Helper I
    2 years ago

    Ya, still getting the Expression.Error as before.