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
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.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        please show the current code.