Web.contents auto adding Expect header

Question

I am trying to connect to a graphql API using the follwing:let&nbsp; &nbsp; &nbsp; &nbsp; query = Web.Contents(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "http:****************",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Headers=[&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; #"Content-Type"="application/json",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; #"x-token-id"="1************",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; #"x-token-value"="W*************"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Content = Text.ToBinary(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"{""query"": ""query GetEvents { events( filter: { time: { between: [""2024-09-11T00:00:00Z"", ""2024-09-12T00:00:00Z""] } }, first: 1 ) { edges { node { id } } }}""}"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Timeout = #duration(0,0,5,0), // Set timeout to 5 minutes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ManualStatusHandling = {500} &nbsp;// Handle 500 errors manually&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; // Handle the response&nbsp; &nbsp; &nbsp; &nbsp; StatusCode = Value.Metadata(query)[Response.Status], // Extract status code from metadata&nbsp; &nbsp; &nbsp; &nbsp; RawResponse = Text.FromBinary(query), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;// Convert raw binary response to text&nbsp; &nbsp; &nbsp; &nbsp; ParsedResult = try Json.Document(query) otherwise RawResponse, // Try parsing the result or return raw if it fails&nbsp; &nbsp; &nbsp; &nbsp; // Build a structured output for debugging&nbsp; &nbsp; &nbsp; &nbsp; Result = if StatusCode = 500 then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Return an error with detailed information&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Error.Record("ServerError", "500 Internal Server Error", [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RawResponse = RawResponse,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; StatusCode = StatusCode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ParsedResult&nbsp; &nbsp; in&nbsp; &nbsp; &nbsp; &nbsp; // Return the detailed result with status and raw response for debugging&nbsp; &nbsp; &nbsp; &nbsp; [StatusCode = StatusCode, RawResponse = RawResponse, Result = Result];I am getting this error:statusCode\":500,\"code\":\"FST_REPLY_FROM_INTERNAL_SERVER_ERROR\",\"error\":\"Internal Server Error\",\"message\":\"expect header not supported\"}Is there anyway to prevent web.Contents from attaching the expect header?I was able to force the query to work by creating running nginx x server using the follwoing config so I know it is coming from web.contents:http {server {listen 80;location /graphql {proxy_set_header Expect "";proxy_pass https://d*********************;}}}Thank you for your help

lbendlin · Answer

Do you see what is specified in the expect header?&nbsp; application/json ?

jake_rage · Answer

Hey yes the Expect header is being set to "100-continue" by web.Contents I dont have the abillity to change the how the api handles headers otherwise I would do that so was hoping there was a way to prevent web.contents from adding it.&nbsp;

lbendlin · Answer

I would call that a bug.
&nbsp;
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbiOtherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Forum Discussion

Web.contents auto adding Expect header

3 Replies

Related content

Expression.SyntaxError: Token ',' expected.

Adding Timeout to a Web.Contents Dataflow query

Expression.SyntaxError: Token Eof expected. and Token Comma expected

Adding columns

Folder.Files + Web.Contents