Forum Discussion
LarryBroward
Helper I
Helper IPut API with Body
Hi, I need to pass the following in the body, <?xml version="1.0" encoding="utf-8" standalone="yes"?> <ns2:invocationContext xmlns:ns2="http://collectionspace.org/services/common/invocable"> <...
Hi LarryBroward ,
I'm not used to work with xml files.
Have you triedXml.Document(Web.Contents(url, [Headers=headers, Content = postData ] ) )or
Excel.Workbook(Web.Contents(url, [Headers=headers, Content = postData ] ) )instead?
ImkeF
Community Champion
Community ChampionHi LarryBroward ,
that's correct. To use Basic Authentication, you would have to build a custom connector.
Handling authentication for Power Query connectors - Power Query | Microsoft Learn
LarryBrowardI was looking at this post Accessing REST APIs with Basic Auth and API Key in Power Query | John Dalesandro
It is suggesting that you can get it to work without using a customer connector, by builiding one URL. Is this a viable option, I played with it a little bit and can see the key is coming back, but I wasn't able to get it to work.
Thanks