Forum Discussion

TP-101's avatar
TP-101
Icon for Helper I rankHelper 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
TP-101's avatar
TP-101
Icon for Helper I rankHelper I
2 years ago

Thank you lbendlin .  I changed line 31 to include a content-type however, still seeing the Expression.Error.  I'm not sure what is tring to convert to binary since the response should be json.  Any idea?

 

GetJsonQuery = Json.Document(Web.Contents("https://" & #"Tenant" & #"GetMetric", [Headers=[Authorization=AccessTokenHeader, #"Content-Type"="application/json"], Content=Text.FromBinary(Json.FromValue(data))]))
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Try adding an accept directive.

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

    Added the accept and still observing the same Expression.Error.

     GetJsonQuery = Json.Document(Web.Contents("https://" & #"Tenant" & #"GetMetric", [Headers=[Authorization=AccessTokenHeader, #"accept"="application/json"], Content=Text.FromBinary(Json.FromValue(data))]))
    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Try this.  

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

       

      You will also need to read up on RelativePath and Query.

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

        Changing it to that shows a Bad Request (400) error instead.