Forum Discussion

cleon169's avatar
cleon169
Frequent Visitor
7 years ago

POST request strange behavior - request is sent twice with EXPECT header added

I've created the code below in Power Query to send a POST request to an API server that contains report parameters in the body. The authentication protocol is OAuth 1.0 single-legged (i.e. tokens are...
Need Help
blopez11's avatar
blopez11
Super User
7 years ago

I am seeing the same thing.  Did you ever by chance able to resolve this?

Thanks,

cleon169's avatar
cleon169
Frequent Visitor
7 years ago

I never found a good answer on this. However I was able to get it to work for me.

 

I replaced the line 

Result = Csv.Document(Source)

with

 

    #"Imported Text" = Table.FromColumns({Lines.FromBinary(Source,null,null,1252)}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Imported Text", "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5", "Column1.6", "Column1.7", "Column1.8", "Column1.9", "Column1.10", "Column1.11", "Column1.12", "Column1.13"}),

 Change the #"Split Column by Delimiter" variables to match the number of delimited columns in your data.

 

PQ still sends multiple requests for the same item, however it appears to revaluate the variables and the API server throw an error.

 

Hope this helps! Let me know if it does.

  • blopez11's avatar
    blopez11
    Super User
    7 years ago

    Thanks for the reply

    Mine is slightly different, where I am reading XML from the response

    But the thing is the web service we are using, apparently doesn't like the two back to back POSTcalls, and for the second, just replies back with an empty content body

    So my report ends up with nothing:)

     

    There doesn't appear to be a solution to this