Prerequisite
Create your Excel Connector in the Meridix Dstny Analytics Platform, under saved reports. Read guidelines here: Connectors. Copy the Connector link.
How to add the Connector to Excel
Select the Data tab in Excel and click the “From Web” data source.
Enter the Connector link into the Url and click Ok.
The data should appear in the Navigator and you can now select the tables you like to import into Excel.
How to
load a Connector withuse an access token
?with the Connector
When loading Web data click the advanced option. Add , add the URL as normal and then add under “URL parts”.
Under “HTTP request header parameters, manually enter the header “access_-token” with followed by the actual access token value under the headers section.
Meridix Systems AB
Phone: +46 (0)21 38 30 32
Support: support@meridix.se
Web – Swedish: www.meridix.se
Web – English: www.meridix.eu