Forum Discussion

vilmarci's avatar
vilmarci
Frequent Visitor
7 years ago

Use another query result as text parameter

I need to pass a json document as body to another Graph API query. The source where I want to get the parameter data is: rooms = Json.Document(Web.Contents("https://graph.microsoft.com/beta/me/find...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi vilmarci , if you want the output to be the text representation of a JSON document; have you tried to use the Text.FromBinary function? Try to edit the query to the following:

jsaddress = Json.FromValue(#"roomaddress"),
tx = Text.FromBinary(
           Json.FromValue(jsaddress)
     )

 Example of Text.FromBinary in use on JSON formatted data in the docs