Downloading a csv after clicking on button in sail form.

Question

Can someone guide me in how to download a csv(containing records) after the click of a button in sail form ? . 
 Steps what i have taken now is . 
 Expression Rule - Contains the queryEntity which fetches the data from database. 
 Web Api - Uses the csv template which calls the Expression rule . 
 Integration Object - calls the web api 
 
 I am trying to call this integration object into the saveInto of the button which will in turn call the integration object which will fetch the excel . Is this the correct approach ?

Thanks, 
 Rohit Ouhal

aloks0189 · Answer

Hi rohitr303 may I know the method type of API. Is that a GET or POST call? 
 
Yes, the procedure which you are trying is correct. Can you try calling this API directly, what response you are getting? 
 
Also there is an alternate approach if this, we have a shared component (Download DataSubset) which provides you an option to download an excel file by clicking over a link but it has a limitation that, it's not cloud approved one.

naveenp878 · Answer

Hi Rohit, The procedure is correct. As far as i know, we don't need the integration object and i think we can directly use a!safeLink() to download the content into csv. Have to tried hitting the webapi url directly in the browser? If you are able to download then it will definitley works through a!safeLink(). 
 
Thanks