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
