Changes

SmartSimple OData Feed to Excel

252 bytes added, 13:52, 3 July 2018

no edit summary

=Overview=

There are different ways to import OData Feed into Excel: Excel Data Tab, Power Pivot or Power Query.

Example below shows how to pull OData feed via the Excel Data Tab.

[[Image:OData-Excel5.PNG|400px]]

 

=Troubleshooting=

<!--see ticket 69942 - OData with https gives error-->

1. TLS1.2 security protocol should be enabled on their local machines before they can import OData with HTTPS link. By default, MS Office do not accept this protocol by default.

=See Also=

• ← Older edit
• Newer edit →

Lalaine Songalia

Smartstaff

1,385

edits