Tutiorial on OData to Excel?
- Last Post 4 weeks ago
Here are the links to the tutorials:
https://skyvia.com/resources/docs/index.html?how_to_link_external_data_to_s_2.htm (Salesforce Lighting)
https://skyvia.com/resources/docs/index.html?how_to_link_external_data_to_s.htm (Salesforce Classic)
In order to access Odata endpoint directly in Excel you can perform these steps:
Click on the Data tab in Excel, then Get Data > From Other Sources > From OData Feed. If you don't see the Get Data button, then click New Query > From Other Sources > From OData Feed. Specify URL and user/password if necessary.