Forum Discussion

Nidhi_Sonar_123's avatar
Nidhi_Sonar_123
Regular Visitor
3 years ago

Need Help in calling and getting data from rest post api which returns excel file in response

Hello Everyone,    I have a post api which takes the payload as below : {"DateFrom":"2022-12-26T18:30:00.000Z","DateTo":"2022-12-29T18:29:59.000Z","TimeZone":"India Standard Time"}   process th...
Need Help
Nidhi_Sonar_123's avatar
Nidhi_Sonar_123
Regular Visitor
3 years ago

Hi Ibendlin,

 

Thanks for your solution.

Could you please provide some example where we have the similar scenario and we have handled, or any link which describes the solution.

 

Thanks in advance

lbendlin's avatar
lbendlin
Super User
3 years ago
let
    Source = Excel.Workbook(Web.Contents("http://192.168.3.26/historydownload.xlsm"), null, true),
    #"Field Changes_Sheet" = Source{[Item="Field Changes",Kind="Sheet"]}[Data]
in
    #"Field Changes_Sheet"