I was given a task (im Noob):
We have a dashboard that preset data, The dashboard grids retrieve the data via sending a query over Azure plugin datasource.
Create new button that will collect the same data presented on the grids, save it as dataset and send to Salesforce API. on Salesforce API someone will fetch the data, and we’ll be able to load if offline.
First I thought, If possible to save a snapshot of entire dashboard along with the data, as an object, send that object as HTTP body and reload that object on the other end, I saw this is impossible.
So my guess is that I need to create a button, button OnClick will query the Azure datasource plugin, fetch the information (Same query as we did on grid) and instead of sending data to grid → Wrap it in HTTP request and send to salesforce API
Is there a convenient way to do it?
I probably need to save the tokens/session identifier etc for security.
Does anyone knows of a guide with samples how to achieve this?
Or throw some components that are best suited for my scenario? design suggestion?