Data can be extracted from Dispatch Science using the Open Data Protocol (OData). OData is a data access protocol built on core protocols like HTTP and other accepted methodologies like REST for the web. Diverse tools use OData to extract the needed information to easily create reports like Microsoft Excel.


This article will guide you on how to use MS Excel version 2016 or 365 and MS Power Query with OData to extract Dispatch Science information.


Here are the different sets of data you can extract:


Instruction to connect - Microsoft Excel

1) Open new Excel Book

2)From Data menu, click on Get Data, From Other sources, From OData Feed

3) Select BASIC, the following will open

4) Type in your URL:

For instance, if you are trying to get to your Test site:

https://DSsite-Odata-Test.dsapp.io/OData

If you are trying to get to your Production site:

https://DSsite-Odata.dsapp.io/OData


For example if my site URL is: https://company.dsapp.io

For Production site, Odata URL would be:

https://company-odata.dsapp.io/odata

For test the URL would be: https://company-test.dsapp.io

https://company-odata-test.dsapp.io/odata

5) Click OK

6) Select Basic access

7) In this window, enter your Dispatch Science login and Password and select the URL ending in OData:

8) Click Connect

9) In the list, select the data you wish to use. If you need more than one table, click on the Select multiple items checkbox to see checkboxes beside your tables.

You now have the following tables available:

10) Click on Load to load the information or click on Transform Data to enter queries to link tables together and/or filter the information before loading into an Excel sheet.


Instructions to Connect - Google Sheets

  1. Install ⁠Google AppSheet. You will need to give it permissions on your Google account.
  2. Go to Account Settings
  3. Click "Sources"
  4. Click "New Data Source"
  5. Create New Connection of type OData
    1. OData Version: 4.0
    2. URL: https://tenantname-odata.dsapp.io/OData Replace "tenantname" with yours.
    3. Username: Yours
    4. Password: Yours
    5. SAP Gateway: Is not SAP Gateway
    6. CSRD: Not required
  6. Click Test, then Authorize Access