Forum Discussion

LarryBroward's avatar
LarryBroward
Helper I
2 years ago
Solved

Put 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"> <...
Need Help
  • ImkeF's avatar
    ImkeF
    2 years ago

    Hi LarryBroward ,
    I'm not used to work with xml files.
    Have you tried

    Xml.Document(Web.Contents(url, [Headers=headers, Content = postData ] ) )

    or 

    Excel.Workbook(Web.Contents(url, [Headers=headers, Content = postData ] ) )

    instead?

ImkeF's avatar
ImkeF
Community Champion
2 years ago

Hi LarryBroward ,
Power Query can only do GET and POST calls.

 

LarryBroward's avatar
LarryBroward
Helper I
2 years ago

I meant Post. I just realized the code sample I put in from another post which would have been clear was removed by the content screeners on submit.