Forum Discussion

wdrain's avatar
wdrain
Helper I
1 year ago

How do you pass and escape chars from GraphQL Query into web.contents for a REST api connections?

Query: query endpointsBitLockerDetails { endpoints(after: null, first: 200) { edges { node { id computerID isEncrypted sensorReadings(sensors: [{name: "BitLocker Details"}, {name: "Enforce...
Need Help
wdrain's avatar
wdrain
Helper I
1 year ago

Hi Gao,

Thanks for replying back.
But unfortunely the double Quotes did not work.
In my finding variable names with out and dash work by escaping with a backslash \ and a double Qoute ". i.e.  \"
i.e.
\"BitLocker Details\" -> this works
\"Enforce -TPM Status\"  or \#"Enforce - TPM Status\" -> will not work because of the dash

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi wdrain ,

 

Is it possible to show the full code (masking the private information)? Please try again something like this:

 

let
    Source = Web.Contents(
	"https://apiurl",
	[
		Headers=[
			#"Method"="POST",
			#"Content-Type"="application/json",
			#"Authorization"="Bearer <your_token_here>"
		],
		Content=Text.ToBinary("{""query"": ""endpointsBitLockerDetails{endpoints(after: null, first: 200) {edges {node {idcomputerIDisEncryptedsensorReadings(sensors: [{name: \""BitLocker Details\""}, {name: \""Enforce - TPM Status\""}]) {columns {sensor {name}namevalues}}}}pageInfo {startCursorendCursorhasNextPage}totalRecords}}""}")
	]
    ),
    #"JSON" = Json.Document(Source)
in
    #"JSON"

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum