Submit a Delete REST Command through PowerQuery

Anonymous — Tue, 01 Oct 2019 08:11:59 GMT

I have the following code that Posts to a REST API (that requires BASIC authentication). This then retrieves a session key and does a GET to obtain the JSON information (passing the session key as a parameter). I would like to delete the session key using a DELETE HTTP method after I have the data (as there is a limit on the number of sessions we can have open simulataneously). Any tips on how I do this?

let
    
    Source = (Web.Contents(APIURL, [Headers=[Accept="application/json", #"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content=Text.ToBinary("UserID=USERID&CompanyID=COMP&Password=PASS&ProjectNo=PROJ&Application=APPNAME"), RelativePath="/session"])),
    SessionKey = Json.Document(Source),
    SessionKeyHeader = "Basic " & SessionKey,
    Source1= Json.Document(Web.Contents(APIURL, [Headers=[Authorization= SessionKeyHeader],RelativePath="Report/"&REPORTNUM]))
 
in
    Source1

topic Submit a Delete REST Command through PowerQuery in Developer

Submit a Delete REST Command through PowerQuery